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

namespace Test
{
    class DBConnect
    {
        public static  MySqlConnection connection;
        public static  string server;
        public static  string database;
        public static  string uid;
        public static  string password;

        public DBConnect()
        {
            Initialize();
        }


        public static void Initialize()
        {
            server = "localhost";
            database = "co2";
            uid = "root";
            password = "123";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" +
            database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

            connection = new MySqlConnection(connectionString);
        }

        public static bool OpenConnection()
        {
            try
            {
                connection.Open();
                Console.WriteLine("Connection Had Been Open !");
                return true;
            }
            catch (MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        Console.WriteLine("Cannot connect to server");
                        break;

                    case 1045:
                        Console.WriteLine("Invalid username/password, please try again");
                        break;
                }
                return false;
            }
        }

        public static bool CloseConnection()
        {
            try
            {
                connection.Close();
                Console.WriteLine("connection Has been close !");
                return true;
            }
            catch (MySqlException ex)
            {
                Console.WriteLine(ex.Message);
                return false;
            }
        }


        public  void Insert()
        {
         int npc_id;
         int npc_type = 2;
         string npc_n;
        int npc_face;
         int npc_city;
         int npc_x;
        int npc_y;
            string query = "INSERT INTO `npcs` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`) VALUES (' " + npc_id +  "' , 'testnew', '2', '6666', '5000', '50', '50')";
            if (DBConnect.OpenConnection() == true)
            {
                MySqlCommand cmd = new MySqlCommand(query, connection);

                cmd.ExecuteNonQuery();

                DBConnect.CloseConnection();
            }
        }

        public  void Update()
        {
            string query = "";
            if (DBConnect.OpenConnection() == true)
            {

                MySqlCommand cmd = new MySqlCommand();

                cmd.CommandText = query;

                cmd.Connection = connection;


                cmd.ExecuteNonQuery();


                DBConnect.CloseConnection();
            }
        }


        public void Delete()
        {
            string query ="";

            if (DBConnect.OpenConnection() == true)
            {
                MySqlCommand cmd = new MySqlCommand(query, connection);
                cmd.ExecuteNonQuery();
                DBConnect.CloseConnection();
            }
        }

         #region Select & Count statement
        //public static List<string>[] Select()
        //{
        //}

        //public static int Count()
        //{
        //}
#endregion

        #region Backup & Restore statement

        public static void Backup()
        {
        }

        public static void Restore()
        {
        }
        #endregion
    }
}