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();
}
}
}