private void btnLogin_Click(object sender, EventArgs e) { String userName = txtUn.Text; String password = txtPw.Text; String pass = null; String q = "select password from Users where userName = '******'"; using (DBConect db = new DBConect()) { MySqlCommand cmd = new MySqlCommand(q, db.con); MySqlDataReader r = cmd.ExecuteReader(); if (r.HasRows) { while (r.Read()) { pass = r["password"].ToString(); } if (pass.Equals(password)) { frmMain m = new frmMain(); this.Hide(); m.Show(); } else { MessageBox.Show("Invalid Password"); } } else { MessageBox.Show("Invalid user name"); } } }
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"); } } }