private void pictureBox6_Click(object sender, EventArgs e)
        {
            PML_Home home = new PML_Home();

            home.Show();
            this.Hide();
        }
        public void btn_login_Click(object sender, EventArgs e)
        {
            chkType = null;
            chkName = null;

            if (rb_siteMan.Checked == false & rb_supervisor.Checked == false & rb_acnt.Checked == false & rb_other.Checked == false & rb_admin.Checked == false & rb_manager.Checked == false)
            {
                MessageBox.Show("You must select a user type", "ERROR");
            }
            else if (String.IsNullOrEmpty(txt_userName.Text))
            {
                MessageBox.Show("Please enter the User Name", "ERROR");
                txt_userName.Focus();
            }
            else if (String.IsNullOrEmpty(txt_password.Text))
            {
                MessageBox.Show("Please enter the Password", "ERROR");
                txt_password.Focus();
            }

            else
            {
                if (rb_siteMan.Checked)
                {
                    userType = rb_siteMan.Text;
                }
                if (rb_supervisor.Checked)
                {
                    userType = rb_supervisor.Text;
                }
                if (rb_acnt.Checked)
                {
                    userType = rb_acnt.Text;
                }
                if (rb_other.Checked)
                {
                    userType = rb_other.Text;
                }
                if (rb_manager.Checked)
                {
                    userType = rb_manager.Text;
                }
                if (rb_admin.Checked)
                {
                    userType = rb_admin.Text;
                }

                using (MySqlConnection mysqlCon = new MySqlConnection(connectionString))
                {
                    mysqlCon.Open();
                    String          sql  = "SELECT UserID, UserType, UserName FROM pml_user WHERE UserType='" + userType + "' AND UserName='******' AND Password='******'";
                    MySqlCommand    mySc = new MySqlCommand(sql, mysqlCon);
                    MySqlDataReader myDr = mySc.ExecuteReader();

                    while (myDr.Read())
                    {
                        chkID   = myDr.GetValue(0).ToString();
                        chkType = myDr.GetValue(1).ToString();
                        chkName = myDr.GetValue(2).ToString();
                    }
                }

                if (chkName == null)
                {
                    MessageBox.Show("Login Failed. Please check the User Type and Credentials Again !!", "ERROR");
                }
                else
                {
                    chkName = txt_userName.Text;
                    chkType = userType;

                    PML_Home openSiteHome = new PML_Home();
                    openSiteHome.Show();
                    this.Hide();
                }
            }
        }