using MySql.Data.MySqlClient;
using System;
using Game.Achievements;
using System.Collections.Generic;
namespace Syko.ORM
{
    class AchievementsManager // a refaire avec Stump.ORM
    {
        public static System.Collections.Generic.List<Achievements> Cache = new System.Collections.Generic.List<Achievements>();
        public  void CatchAll()
        {
            string host = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.Host;
            string name = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.DbName;
            string user = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.User;
            string pass = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.Password;

            string connectionString = "SERVER="+host+";" + "DATABASE="+name+";" + "UID="+user+";" + "PASSWORD="+pass+";";
            MySqlConnection Conn = new MySqlConnection(connectionString);
            Conn.Open();
            Cache.Clear();
            string cmdText = "SELECT * FROM achievements";
            MySqlCommand mySqlCommand = new MySqlCommand(cmdText, Conn);
            MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
            while (mySqlDataReader.Read())
            {

                Achievements achievement = new Achievements();
                achievement.id = short.Parse(mySqlDataReader["SuccesID"].ToString());
                achievement.mapid = int.Parse(mySqlDataReader["MapDiscoveredID"].ToString());
                achievement.wonkamas = int.Parse(mySqlDataReader["wonKamasRatio"].ToString());
                achievement.wonxp = int.Parse(mySqlDataReader["wonXPRatio"].ToString());


                Cache.Add(achievement);
            }
          //  Console.WriteLine(Cache.Count + " Loaded"); ---> Count
            mySqlDataReader.Close();
        }


        public static void CreateTable(MySqlConnection Conn)
        {
            try
            {
                string cmdText = "CREATE TABLE if not exists achievements (ID int(32) unsigned NOT NULL auto_increment PRIMARY KEY,Ndc varchar(400) NOT NULL,Mdp varchar(400) NOT NULL,Role int(32) unsigned NOT NULL,Email varchar(400) NOT NULL)";// update this
                MySqlCommand mySqlCommand = new MySqlCommand(cmdText, Conn);
                mySqlCommand.ExecuteNonQuery();
            }
            catch
            {

                Console.ReadKey();
                Environment.Exit(0);
            }
        }

    }
}