using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace BTGAdmin
{
    class Program
    {

       static string btgConnect = "SERVER=50.63.244.26;" + "DATABASE=btgusers;" + "UID=btgusers;" + "PASSWORD= ;";
       static MySqlConnection btgXConnect = new MySqlConnection(btgConnect);
       static string sadduser = "INSERT INTO `btgusers`.`Members` (`USERID`, `PASSWORD`, `PIN`) VALUES (@USERID, @PASSWORD, @PIN)";
       static string slistuser = "SELECT * FROM `btgusers`.`Members`";
       static string sDelUser = "DELETE FROM `btgusers`.`Members` WHERE CONVERT(`Members`.`USERID` USING utf8) = (@USERID) LIMIT 1";
       static Dictionary<int, string> sUser = new Dictionary<int, string>();

        static void Main(string[] args)
        {
            bool exit = false;
            while (!exit)
            {
                Console.WriteLine("Welcome To BeatTheGa.ME, Choose an Option");
                Console.WriteLine(" 1. Add User\r\n 2. Delete User\r\n 3. Exit");
                switch (Convert.ToInt32(Console.ReadLine()))
                {
                    case 1:
                        Console.WriteLine("Enter Username:");
                        string userid = Console.ReadLine();
                        Console.WriteLine("Enter Password:");
                        string password = Console.ReadLine();
                        Console.WriteLine("Enter Pin:");
                        string pin = Console.ReadLine();
                        Console.WriteLine("Adding User: " + userid);
                        adduser(userid, password, pin);
                        Console.WriteLine("User Added.");

                        break;
                    case 2:
                        Console.WriteLine("User List:\r\n");
                        Console.WriteLine("KEY|USER|PASS|PIN");
                        listuser();
                        Console.WriteLine("Select User to Delete");
                        string userchoice = Console.ReadLine();
                        deluser(userchoice);
                        break;
                    case 3:
                        Console.WriteLine("Goodbye.");
                        exit = true;
                        break;
                    default:
                        Console.WriteLine("Default");
                        break;
                }
            }
        }
        static void deluser(string choice)
        {
            btgXConnect.Open();
            MySqlCommand cmdDeluser = new MySqlCommand(sDelUser, btgXConnect);
            cmdDeluser.Parameters.Add("@USERID", choice);
            cmdDeluser.ExecuteNonQuery();
            btgXConnect.Close();
        }
        static void listuser()
        {
            btgXConnect.Open();
            MySqlCommand cmdListuser = new MySqlCommand(slistuser, btgXConnect);
            MySqlDataReader Reader;
            int key = 1;
            Reader = cmdListuser.ExecuteReader();
            while (Reader.Read())
            {
                int FieldCount = Reader.FieldCount ;
                string row = "";
                for (int i = 0; i < FieldCount; i++)
                {
                    row += Reader.GetValue(i).ToString().ToUpper() + ":";
                }
                sUser.Add(key, Reader.GetValue(0).ToString());
                key++;
            }
            btgXConnect.Close();

            foreach (var pair in sUser)
            {
                Console.WriteLine("{0}: {1}", pair.Key, pair.Value);
            }

        }
        static void adduser(string userid, string password, string pin)
        {
            btgXConnect.Open();
            MySqlCommand cmdAdduser = new MySqlCommand(sadduser, btgXConnect);
            cmdAdduser.Parameters.Add("@USERID", userid);
            cmdAdduser.Parameters.Add("@PASSWORD", password);
            cmdAdduser.Parameters.Add("@PIN", pin);
            cmdAdduser.ExecuteNonQuery();
            btgXConnect.Close();
        }
    }
}