private void btnLogin_Click(object sender, EventArgs e)
{
String userName = txtUn.Text;
String password = txtPw.Text;
String pass = null;
String jobRole = null;
String q = "select password,jobRole from employee where employeeID = '" + userName + "'";
using (DBConnect db = new DBConnect())
{
MySqlCommand cmd = new MySqlCommand(q, db.con);
MySqlDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
while (r.Read())
{
pass = r["password"].ToString();
jobRole = r["jobRole"].ToString();
}
if (pass.Equals(password))
{
if (jobRole.Equals("Receptionist"))
{
frmMain m = new frmMain(txtUn.Text);
this.Hide();
m.Show();
}
else if (jobRole.Equals("Manager"))
{
frmHome home = new frmHome(txtUn.Text);
this.Hide();
home.Show();
}
else if (jobRole.Equals("StockManager"))
{
InventoryMain inv = new InventoryMain(txtUn.Text);
this.Hide();
inv.Show();
}
else if (jobRole.Equals("FinanceManager"))
{
FormFinance fiance = new FormFinance(txtUn.Text);
fiance.Show();
this.Hide();
}
else if (jobRole.Equals("RestaurantManager"))
{
Rest_Managment.RestManagment res = new Rest_Managment.RestManagment(txtUn.Text);
res.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid Password");
}
}
else
{
MessageBox.Show("Invalid user name");
}
}
}
