using MySql.Data.MySqlClient;

namespace Namespace_SQL
{
    class Class_SQL
    {
        private MySqlConnection con;
        private MySqlCommand cmd;

        public Class_SQL()
        {
            con = new MySqlConnection(GetConnectionString());
            cmd = con.CreateCommand();
        }

        public void CreatePlayer(string playername)
        {
            string query = string.Format("INSERT INTO `player` (`Name`) VALUES('{0}');", playername);
            ExecuteNonQuery(query);
        }

        public object DeletePlayer(int playerid)
        {
            string query = string.Format("DELETE FROM `player` WHERE ID = {0};", playerid);
            object scalar = ExecuteScalar(query);
            return scalar;
        }

        private string GetConnectionString()
        {
            return "SERVER=localhost;Port=3307;DATABASE=gtasql;UID=root;PASSWORD=1337;";
        }

        private void Connect()
        {
            con.Open();
        }

        private void Disconnect()
        {
            con.Close();
        }

        private void ExecuteNonQuery(string query)
        {
            Connect();
            cmd.CommandText = query;
            cmd.ExecuteNonQuery();
            Disconnect();
        }

        private object ExecuteScalar(string query)
        {
            Connect();
            cmd.CommandText = query;
            object scalar = cmd.ExecuteScalar();
            Disconnect();
            return scalar;
        }

    }
}