Wpf desktop app authenticate product key to an online database

99.214.49.191 or http://www.mywebsite.com
myapp_KeyCodes
myapp_user1
Password12345

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.IO;
using MySql.Data.MySqlClient;

namespace myApp
{
    partial class DBConnect
    {
        private MySqlConnection connection;
        private string server;
        private string database;
        private string uid;
        private string password;


        #region Load Config file information
        //Constructor
        public DBConnect()
        { 
            // Change the path to your location in the next line
            var filestream = new FileStream(@"c:\Configfolder\dbConfig.txt",
                            FileMode.Open,
                            FileAccess.Read,
                            FileShare.ReadWrite);
            var file = new StreamReader(filestream, Encoding.UTF8, true, 128);
            string lineOfText;
            int x = 1;
            while((lineOfText = file.ReadLine()) != null)
            {
                if (x == 1) { server = lineOfText; }
                if (x == 2) { database = lineOfText; }
                if (x == 3) { uid = lineOfText; }
                if (x == 4) { password = lineOfText; }
                x++;
            }
            Initialize();
        }
        #endregion

        #region Initialize
        //Initialize values
        private void Initialize()
        {
            // If hard coding database information, put it here and do NOT run DBConnect above.
            //server = "http://www.mywebsite.com";
            //database = "myApp_keycodes";
            //uid = "myapp_user1";
            //password = "Password12345";
            string connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
            connection = new MySqlConnection(connectionString);
        }
        #endregion

        #region Encypt/Decrypt
        //encrypt
        public string Base64Encode(string plainText)
        {
            var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(plainText);
            return System.Convert.ToBase64String(plainTextBytes);
        }

        //decrypt
        public string Base64Decode(string base64EncodedData)
        {
            var base64EncodedBytes = System.Convert.FromBase64String(base64EncodedData);
            return System.Text.Encoding.UTF8.GetString(base64EncodedBytes);
        }
        #endregion

        #region Open Database Connection
        //open connection to database
        public bool OpenConnection()
        {
            try
            {
                connection.Open();
                return true;
            }
            catch (MySqlException ex)
            {
                //When handling errors, you can use your application's response based on the error number.
                //The two most common error numbers when connecting are as follows:
                //0: Cannot connect to server.
                //1045: Invalid user name and/or password.
                switch (ex.Number)
                {
                    case 0:
                        MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;

                    case 1045:
                        MessageBox.Show("Invalid username/password, please try again");
                        break;

                    case 1042:
                        MessageBox.Show("Unable to connect to any of the specified MySQL hosts., please try again");
                        break;
                }
                return false;
            }
        }
        #endregion

        #region Close Database Connection
        //Close connection
        public bool CloseConnection()
        {
            try
            {
                connection.Close();
                return true;
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
        #endregion

        #region Get Key Code information
        //Gets KeyCode Information from Database on web server.
        public boolean getKeyCode(string kcode)
        {
            string query = "SELECT * FROM myapp_KeyCodes where KeyCode = '" + kcode + "'";

            //Open connection
            if (this.OpenConnection() == true)
            {
                try
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data return by the database
                    while (dataReader.Read())
                    {
                        string kc = dataReader["KeyCode"].ToSting();
                        int usage = dataReader["Usage"];
                        //or bool usage = dataReader["Usage"];
                        string uName = dataReader["User"].ToString();
                        string date = dataReader["Date"].ToString();
                    }
                    //close Data Reader
                    dataReader.Close();
                    if(kcode == kc)
                    {
                        if(usage == 0)  // If Bool, then use: If(usage == false)
                        {
                            return true;
                        }
                        else
                        {
                            return false;
                        }
                    }
                    else
                    {
                        return false;
                    }
                }
                catch
                {
                    // Error retrieving database information, or no information was found.
                    return false;
                }
            }
            else
            {
                return false;
            }
        }

        #region Update Keycode Information.
        //Update KeyCode Info
        public void UpdateKeyCode(string kCode, string nUser, string IDate, Int nUsage)
        {
            string query = "UPDATE myapp_KeyCodes SET User='" + nUser + "', Date='" + IDate + "', Usage='" + nUsage + "' WHERE KeyCode =" + kCode;
            //Open connection
            if (this.OpenConnection() == true)
            {
                //create mysql command
                MySqlCommand cmd = new MySqlCommand();
                //Assign the query using CommandText
                cmd.CommandText = query;
                //Assign the connection using Connection
                cmd.Connection = connection;
                //Execute query
                cmd.ExecuteNonQuery();
                //close connection
                this.CloseConnection();
            }
        }
        #endregion
    }
}

private void Button_Click(object sender, RoutedEventArgs e)
     {
         DBConnect myDBConnect = new DBConnect();
         bool checkCode = getKeyCode(txt_KeyCode.text); //Get key code from text box
         if(checkCode == True)
         {
             // KeyCode already Used
             // Display Warning...
             // Allow retry or Exit application.
             return;
         }
         else
         {
             // Ask user for Email address to register the Key Code
             // Allow Installation to complete.....

             // then Update Web Server Database with new usage
             UpdateKeyCode(txt_KeyCode.text, txt.UserEmail.Text, DateTime.Now.ToString(), 1)

         }