using COServer.Database;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MangSystem
{
    public class Accounts
    {

        public enum AccountState : byte
        {
            NotActivated = 100,
            Chef = 6,
            Food = 7,
            drinks = 8,
            ProjectManager = 4,
            Cashier = 5,
            Water = 3,
            User = 2,
            Banned = 1,
            DoesntExist = 0

        }
        public string Username = "", Password = "", Mobile = "", Email = "", Full_Name = "";
        public DateTime LastCheck;
        public AccountState State;
        public uint UID;
        public void DB_Where(string user)
        {
            if (user == null) return;
            this.Username = "";
            this.Password = "";
            this.Mobile = "";
            this.Email = "";
            this.Full_Name = "";
            this.LastCheck = DateTime.Now;
            this.State = AccountState.DoesntExist;
            this.UID = 0;
            MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(Program.connection("db_sql", ""));
            conn.Open();
            string sql = "SELECT * FROM accounts WHERE Username = '" + user + "'";
            MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, conn);
            MySql.Data.MySqlClient.MySqlDataReader rdr = cmd.ExecuteReader();
            while (rdr.Read())
            {
                this.UID = rdr.GetUInt32(0);
                this.Username = rdr.GetString(1);
                this.Password = rdr.GetString(2);
                this.Mobile = rdr.GetString(3);
                this.Email = rdr.GetString(4);
                this.LastCheck = rdr.GetDateTime("LastCheck");
                this.State = (AccountState)rdr.GetUInt32(6);
                this.Full_Name = rdr.GetString(7);
            }
            rdr.Close();
            conn.Close();
        }
        public void UpdatePssword(string NewPass, string user)
        {
            using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
                cmd.Update("accounts").Set("Password", NewPass).Where("Username", user).Execute();
        }
    }
}