private void button1_Click(object sender, EventArgs e)
        {
            DAL.UserDAL user = new DAL.UserDAL();
            UserDTO     data = new UserDTO();

            data.Login    = textBox1.Text;
            data.Password = textBox2.Text;

            int userId = user.checkUserLogin(data);

            if (userId == -1)
            {
                MessageBox.Show("Empty Fields");
            }
            else if (userId == 0)
            {
                MessageBox.Show("Invalid Username or password");
            }
            else
            {
                this.Hide();
                Form7 home = new Form7(userId);
                home.Show();
            }
        }
        public Form2(int id, int admin)
        {
            userId  = id;
            adminId = admin;
            InitializeComponent();
            user     = new DAL.UserDAL();
            userData = user.getUser(userId);
            if (adminId == 0)
            {
                if (userData.UserID != -1)
                {
                    textBox1.Text = userData.Name;
                    textBox7.Text = userData.Login;
                    textBox6.Text = userData.Password;

                    String applicationBasePath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);
                    String filePath            = applicationBasePath + @"\images\" + userData.ImageName;
                    pictureBox1.Image = Image.FromFile(filePath);
                }
            }
            else
            {
                if (userData.UserID != -1)
                {
                    textBox1.Text = userData.Name;
                    textBox7.Text = userData.Login;
                    textBox6.Text = userData.Password;
                    textBox5.Text = userData.Email;
                    char gender = userData.Gender;
                    if (gender == '1')
                    {
                        comboBox1.Text = "Male";
                    }
                    else if (gender == '2')
                    {
                        comboBox1.Text = "Female";
                    }
                    else
                    {
                        comboBox1.Text = "Others";
                    }
                    address.Text          = userData.Address;
                    numericUpDown1.Value  = userData.Age;
                    textBox2.Text         = userData.NIC;
                    dateTimePicker1.Value = userData.DOB.Date;
                    checkBox1.Checked     = Convert.ToBoolean(userData.IsCricket);
                    checkBox3.Checked     = Convert.ToBoolean(userData.Hockey);
                    checkBox2.Checked     = Convert.ToBoolean(userData.Chess);

                    String applicationBasePath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);
                    String filePath            = applicationBasePath + @"\images\" + userData.ImageName;
                    pictureBox1.Image = Image.FromFile(filePath);
                }
            }
        }
        public Form7(int id)
        {
            InitializeComponent();
            userID   = id;
            user     = new DAL.UserDAL();
            userData = user.getUser(userID);
            if (userData.UserID != -1)
            {
                label2.Text = userData.Name;
                String applicationBasePath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);

                String filePath = applicationBasePath + @"\images\" + userData.ImageName;
                pictureBox1.Image = Image.FromFile(filePath);
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            string name        = textBox1.Text;
            string login       = textBox7.Text;
            string password    = textBox6.Text;
            string email       = textBox5.Text;
            string homeAddress = address.Text.Trim();

            string   nic       = textBox2.Text.Trim();
            DateTime dob       = dateTimePicker1.Value;
            string   isCricket = (checkBox1.Checked == true ? "1" : "0");
            string   isHockey  = (checkBox3.Checked == true ? "1" : "0");
            string   isChess   = (checkBox2.Checked == true ? "1" : "0");
            string   gen       = comboBox1.Text;
            char     gender    = ' ';

            if (gen == "Male")
            {
                gender = '1';
            }
            else if (gen == "Female")
            {
                gender = '2';
            }
            else
            {
                gender = '3';
            }
            int    age        = Convert.ToInt32(numericUpDown1.Value);
            string uniqueName = "";

            if (pictureBox1 != null)
            {
                string applicationBasePath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);
                string pathToSaveImage     = applicationBasePath + @"\images\";

                uniqueName = Guid.NewGuid().ToString() + ".jpg";
                string imgPath = pathToSaveImage + uniqueName;
                pictureBox1.Image.Save(imgPath);
            }

            DAL.UserDAL user = new DAL.UserDAL();
            UserDTO     data = new UserDTO();

            data.Name      = name;
            data.Login     = login;
            data.Password  = password;
            data.Email     = email;
            data.Gender    = gender;
            data.Address   = homeAddress;
            data.Age       = age;
            data.NIC       = nic;
            data.DOB       = dob;
            data.IsCricket = isCricket;
            data.Hockey    = isHockey;
            data.Chess     = isChess;
            data.ImageName = uniqueName;
            data.CreatedOn = DateTime.Now;

            if (userId > 0)
            {
                int result = user.updateUser(userId, data);
                if (result == 0)
                {
                    MessageBox.Show("No result Found");
                }
                else
                {
                    if (adminId == 0)
                    {
                        MessageBox.Show("User Updated Successfully");
                        this.Hide();
                        Form7 home = new Form7(userId);
                        home.Show();
                    }
                    else
                    {
                        MessageBox.Show("User Updated Successfully");
                        this.Hide();
                        Form8 adminHome = new Form8();
                        adminHome.Show();
                    }
                }
            }
            else
            {
                userId = user.insertNewUser(data);
                if (userId == -1)
                {
                    MessageBox.Show("Empty or invalid fields");
                }
                else if (userId == -2)
                {
                    MessageBox.Show("User with same login or email already exists");
                }
                else if (userId > 0)
                {
                    MessageBox.Show("User successfully added");
                    this.Hide();
                    Form7 home = new Form7(userId);
                    home.Show();
                }
                else
                {
                    MessageBox.Show("Error in inserting the data");
                }
            }
        }