using FitnessApp.SQLdatabase;
using System.Data.SqlClient;

namespace FitnessApp.Models
{
    class UserModel
    {
        // Sql connection
        SqlConnection Connection = new SqlConnection("data source=MICHA\\SQLEXPRESS; database=FITNESSAPP; integrated security=SSPI");

        // object from SQLqueries class
        SQLqueries SqlQueriesObject = new SQLqueries();

        //private string image;
        private int _id;
        private string _firstName;
        private string _lastName;
        private string _username;
        private string _email;
        private string _password;
        private string _gender;
        private string _birthDate;
        private double _weight;
        private double _height;
        private double _targetWeight;
        private double _kilosToLose;
        private double _workoutsPerWeek;
        private double _workoutHoursPerDay;

        public UserModel()
        {
            FillTheClass();
        }

        // function that fill the class
        public void FillTheClass()
        {
            _id = SqlQueriesObject.accountID;

            //  Info from user table
            string query = "select * from [User] where ID = @accountID ;";
            Connection.Open();
            SqlCommand cmd = new SqlCommand(query,Connection);
            cmd.Parameters.AddWithValue("@accountID", _id);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                if (dr.HasRows == true)
                {
                    _firstName             = (string)dr["FirstName"];
                    _lastName              = (string)dr["LastName"];
                    _username              = (string)dr["Username"];
                    _gender                = (string)dr["Gender"];
                    _birthDate             = (string)dr["BirthDate"];
                    _height                = (double)dr["Height"];
                    _targetWeight          = (double)dr["TargetWeight"];
                    _kilosToLose           = (double)dr["KilosToLosePerWeek"];
                    _workoutsPerWeek       = (double)dr["WorkoutsDaysPerWeek"];
                    _workoutHoursPerDay    = (double)dr["WorkoutsHoursPerDay"];

                }
            }
            Connection.Close();

            // Info from weight Table
            string query2 = "select Weight From [UserWeight] where UserId=@accountID ;";
            Connection.Open();
            SqlCommand cmd2 = new SqlCommand(query2, Connection);
            cmd2.Parameters.AddWithValue("@accountID", _id);
            SqlDataReader dr2 = cmd2.ExecuteReader();
            while (dr2.Read())
            {
                if (dr2.HasRows == true)
                {
                    _weight = (double)dr2["Weight"];
                }
            }
            Connection.Close();

            // Info from admin and user table
            string query3 = " select Email,Password From AdminAndUserAccount where ID=@accountID ;";
            Connection.Open();
            SqlCommand cmd3= new SqlCommand(query3, Connection);
            cmd3.Parameters.AddWithValue("@accountID", _id);
            SqlDataReader dr3 = cmd3.ExecuteReader();
            while (dr3.Read())
            {
                if (dr3.HasRows == true)
                {
                    _email      = (string)dr3[" Email"];
                    _password   = (string)dr3["Password"];
                }
            }
            Connection.Close();

        }
        public int ID
        {
            get { return _id; }
            set { _id = value; }
        }

        public string FirstName
        {
            get { return _firstName; }
            set { _firstName = value; }
        }

        public string LastName
        {
            get { return _lastName; }
            set { _lastName = value; }
        }

        public string Username
        {
            get { return _username; }
            set { _username = value; }
        }

        public string Email
        {
            get { return _email; }
            set { _email = value; }
        }

        public string Password
        {
            get { return _password; }
            set { _password = value; }
        }

        public string Gender
        {
            get { return _gender; }
            set { _gender = value; }
        }

        public string BirthDate
        {
            get { return _birthDate; }
            set { _birthDate = value; }
        }

        public double Weight
        {
            get { return _weight; }
            set { _weight = value; }
        }

        public double Height
        {
            get { return _height; }
            set { _height = value; }
        }

        public double TargetWeight
        {
            get { return _targetWeight; }
            set { _targetWeight = value; }
        }

        public double KilosToLose
        {
            get { return _kilosToLose; }
            set { _kilosToLose = value; }
        }

        public double WorkoutsPerWeek
        {
            get { return _workoutsPerWeek; }
            set { _workoutsPerWeek = value; }
        }

        public double WorkoutHoursPerDay
        {
            get { return _workoutHoursPerDay; }
            set { _workoutHoursPerDay = value; }
        }

    }
}