C# Housekeeping Phoenix

class MySQLConnection
    {
        public static MySqlConnection CONNECTION;
        public static MySqlCommand COMMAND;
        private static MySqlConnectionStringBuilder BUILDER;
        private static DataTable dTable;


        public static bool OPEN_MYSQL_CONNECTION(string HOST, string USER, string PASS, string DATABASE)
        {
            try
            {
                BUILDER = new MySqlConnectionStringBuilder();
                BUILDER.Server = HOST;
                BUILDER.UserID = USER;
                BUILDER.Password = PASS;
                BUILDER.Database = DATABASE;


                CONNECTION = new MySqlConnection(BUILDER.ToString());
                CONNECTION.Open();


                if (CONNECTION.State == ConnectionState.Open)
                    return true;
                else
                    return false;
            }
            catch
            {
                return false;
            }
        }


        public static void CLOSE_MYSQL_CONNECTION(MySqlConnection CON)
        {
            if (CON.State == ConnectionState.Open)
                CON.Close();
        }


        public static void EXECUTE_MYSQL_QUERY(string QUERY)
        {
            COMMAND = new MySqlCommand(QUERY, CONNECTION);
            COMMAND.ExecuteNonQuery();
            COMMAND.CommandText = null;
        }


        public static DataTable RETURN_DATATABLE(string QUERY)
        {
            dTable = new DataTable();
            COMMAND = new MySqlCommand(QUERY, CONNECTION);


            using (MySqlDataAdapter Adapter = new MySqlDataAdapter(COMMAND))
            {
                Adapter.Fill(dTable);
            }


            COMMAND.CommandText = null;
            return dTable;
        }


        public static DataRow RETURN_DATAROW(string QUERY)
        {
            dTable = new DataTable();
            dTable = RETURN_DATATABLE(QUERY);
            return dTable.Rows.Count > 0 ? dTable.Rows[0] : null;
        }


        public static Int32 RETURN_INT32(string QUERY)
        {
            int i = 0;
            try
            {
                COMMAND = new MySqlCommand(QUERY, CONNECTION);
                try
                {
                    bool succes = int.TryParse(COMMAND.ExecuteScalar().ToString(), out i);
                }
                catch { }
            }
            catch
            {

            }


            return i;
        }
    }

private void button1_Click(object sender, EventArgs e)
        {
            DateTime A = new DateTime(1970, 1, 1, 0, 0, 0, 0).AddHours(2);
            DateTime B = DateTime.Now;
            TimeSpan C = B - A;
            double TIMESTAMP = C.TotalSeconds;


            switch (comboBox1.SelectedItem.ToString()) // kA ob ToLower die Zahl beeinträchtigt, deshalb lassen wir es so :) (ps: kb zu testen :D)
            {
                case "1 Tag":
                    TIMESTAMP += 86400;
                    break;

                case "1 Woche":
                    TIMESTAMP += 604800;
                    break;


                case "1 Monat":
                    TIMESTAMP += 2592000;
                    break;


                case "1 Jahr":
                    TIMESTAMP += 31104000;
                    break;


                case "25 Jahre":
                    TIMESTAMP += 777600000;
                    break;
            }


            string BAN_TYPE = "user";


            switch (comboBox2.SelectedItem.ToString().ToLower())
            {
                case "ip":
                    BAN_TYPE = "ip";
                    break;


                case "user":
                    BAN_TYPE = "user";
                    break;
            }


            if (!textBox1.Text.Equals(null) && !textBox2.Text.Equals(null))
            {
                HOUSEKEEPING.MySQL.MySQLConnection.EXECUTE_MYSQL_QUERY("INSERT INTO bans (bantype, value, reason, expire, added_by, added_date, appeal_state) VALUES ('" + BAN_TYPE + "', '" + textBox1.Text + "', '" + textBox2.Text + "', '" + TIMESTAMP + "', 'JNike', '" + C.TotalSeconds + "', '0')");
                MessageBox.Show("Mitglied wurde erfolgreich verbannt!", "User verbannt!", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }


            // return sQLOL.TotalSeconds;


            // 1 TAG = 86400 Sekunden
            // 1 Woche = 604800 Sekunden
            // 1 Monat = 2592000 Sekunden
            // 1 Jahr = 31104000 Sekunden
            // 25 Jahre = 777600000 Sekunden
            /*
             * 1 Tag
             1 Woche
             1 Monat
             1 Jahr
             25 Jahre
             * */
        }