using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using MySql.Data;
using System.Security.Cryptography.X509Certificates;

namespace Izukova
{
    class DataBase
    {
        public static DataBase instance = null;
        MySqlConnection connection = new MySqlConnection("server=cfif31.ru; port=3306; username=ISPr25-22; " +
            "password=ISPr25-22; database=ISPr-25-22_Izukova32");
        public DataBase() { }
        public static DataBase getInstance()
        {
            if (instance != null) return instance;
            else
            {
                instance = new DataBase();
                instance.openConnection ();
                return instance;
            }
        }
        public void openConnection()
        {
            if (connection.State == System.Data.ConnectionState.Closed)
                connection.Open();
        }
        public void CloseConnection()
        {
            if (connection.State != System.Data.ConnectionState.Open)
                connection.Close();
        }
        public int CreateCommand(string query)
        {
            MySqlCommand command = connection.CreateCommand ();
            command.CommandText = query;
            try
            {
                int rows = command.ExecuteNonQuery();
                return rows;
            }
            catch
            {
                connection = new MySqlConnection("server=cfif31.ru; port=3306; username=ISPr25-22; " +
                    "password=ISPr25-22; database=ISPr-25-22_Izukova32");
                connection.Open ();
                command = connection.CreateCommand ();
                command.CommandText = query;
                int rows = command.ExecuteNonQuery ();
                return rows;
            }
            
            
        }
        public MySqlConnection GetConnection()
        {
            return connection;
        }
    }
}