using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;

namespace dbs_project
{
    class User
    {
        string firstname { get; set; }
        string lastname { get; set; }
        string occupation { get; set; }
        string userId { get; set; }
        string middlename { get; set; }
        string username { get; set; }
        string password { get; set; }
        string passwordencrypted { get; set; }
        string dob { get; set; }
        string gender { get; set; }
        string occupationid { get; set; }
        string userstatusid { get; set; }
        string usertypeid { get; set; }
        public User()
        {

        }
        public void LoginCreds(MySqlConnection conn, string username, string password)
        {

            string stm = "Select userId, firstname, lastname, middlename, username, password, passwordEncrypted, dob, gender, occupationId, userStatusId, userTypeId From users Where username = @username AND passwordEncrypted  = md5(@password)";


            MySqlCommand cmd = new MySqlCommand(stm, conn);

            //bind sql variables
            cmd.Parameters.AddWithValue("@username", username);
            cmd.Parameters.AddWithValue("@password", password);
            //Executor
            MySqlDataReader rdr = cmd.ExecuteReader();

            if (rdr.HasRows)
            {
                rdr.Read();
                userId = rdr["userId"].ToString();
                firstname = rdr["firstname"].ToString();
                lastname = rdr["lastname"].ToString();
                middlename = rdr["middlename"].ToString();
                username = rdr["username"].ToString();
                password = rdr["password"].ToString();
                passwordencrypted = rdr["passwordEncrypted"].ToString();
                DateTime bday;
                DateTime.TryParse(rdr["dob"].ToString(), out bday);
                dob = bday.ToString("MMMM dd, yyyy");
                gender = rdr["gender"].ToString();
                occupationid = rdr["occupationId"].ToString();
                userstatusid = rdr["userStatusId"].ToString();
                usertypeid = rdr["userTypeId"].ToString();

                rdr.Close();
                Console.WriteLine("Login is successful!");


            }
        }
        public void display()
        {
            Console.WriteLine($"{userId} " +
                $"{firstname} " +
                $"{lastname} " +
                $"{middlename} " +
                $"{username} " +
                $"{password} " +
                $"{passwordencrypted} " +
                $"{dob} " +
                $"{gender} " +
                $"{occupationid} " +
                $"{userstatusid} " +
                $"{usertypeid}");
        }
        public void Info(MySqlConnection conn)
        {
            string stm = "Select concat(firstname, ' ', lastname) as fullname, occupation from users Join occupation On users.occupationId = occupation.OccupationId Where userId = @uId";
            MySqlCommand cmd = new MySqlCommand(stm, conn);

            cmd.Parameters.AddWithValue("@uId",userId);
            MySqlDataReader rdr = cmd.ExecuteReader();

            if (rdr.HasRows)
            {
                rdr.Read();
                string fullname = rdr["fullname"].ToString();
                string occupation = rdr["occupation"].ToString();
                rdr.Close();
                Console.WriteLine($"{fullname}  {occupation}");
            }

        }
    }
}