using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace wypozyczalnia
{
    class MySQL_Connector
    {
        private MySqlConnection connection;
        private string          db_host;
        private string          db_name;
        private string          db_user;
        private string          db_pass;

        public MySQL_Connector()
        {
            db_host = "localhost";
            db_name = "wypozyczalnia";
            db_user = "root";
            db_pass = "";

            string connStr = "SERVER=" + db_host + ";DATABASE=" + db_name + ";UID=" + db_user + ";PASSWORD=" + db_pass + ";";
            connection = new MySqlConnection(connStr);

            Connect();
        }

        ~MySQL_Connector()
        {
            Disconnect();
        }

        private bool Connect()
        {
            try
            {
                connection.Open();
                return true;
            }
            catch(MySqlException ex)
            {
                switch(ex.Number)
                {
                    case 0:
                        MessageBox.Show("Nie można połączyć się z serwerem.");
                        break;
                    case 1045:
                        MessageBox.Show("Złe hasło.");
                        break;
                }
                return false;
            }
        }

        private void Disconnect()
        {
            try
            {
                connection.Close();
                return;
            }
            catch
            {
                return;
            }
        }
    }
}