using Discord;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;

namespace Rambot
{
    public class Database
    {
        private string table { get; set; }
        private const string server = "localhost";
        private const string database = "rambot";
        private const string username = "root";
        private const string password = "Alan4455";
        private MySqlConnection dbConnection;

        public Database(string table)
        {
            this.table = table;
            MySqlConnectionStringBuilder stringBuilder = new MySqlConnectionStringBuilder();
            stringBuilder.Server = server;
            stringBuilder.UserID = username;
            stringBuilder.Password = password;
            stringBuilder.Database = database;
            stringBuilder.SslMode = MySqlSslMode.None;

            var connectionString = stringBuilder.ToString();

            dbConnection = new MySqlConnection(connectionString);

            dbConnection.Open();
        }
        public MySqlDataReader FireCommand(string query)
        {
            if (dbConnection == null)
            {
                return null;
            }

            MySqlCommand command = new MySqlCommand(query, dbConnection);

            var mySqlReader = command.ExecuteReader();

            return mySqlReader;
        }
        public void CloseConnection()
        {
            if (dbConnection != null)
            {
                dbConnection.Close();
            }
        }
        public static List<String> CheckExistingUser(IUser user)
        {
            var result = new List<String>();
            var database = new Database("rambot");
            var str = string.Format("SELECT * FROM ramtable WHERE user_id = '{0}'", user.Id);
            var tableName = database.FireCommand(str);
            while (tableName.Read())
            {
                var userId = (string)tableName["user_id"];

                result.Add(userId);
            }

            return result;
        }
        public static string EnterUser(IUser user)
        {
            var database = new Database("rambot");
            var str = string.Format("INSERT INTO ramtable (user_id, username, tokens ) VALUES ('{0}', '{1}', '100')", user.Id, user.Username);
            var table = database.FireCommand(str);

            database.CloseConnection();

            return null;
        }

    }
}