private void button1_Click(object sender, EventArgs e)
{
this.Hide();
StockIncharge SI = new StockIncharge();
SI.Show();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-24KK9O8\SQLEXPRESS;Initial Catalog=PharmacyDatabase;Persist Security Info=True;User ID=sa;Password=iluvumerijan");
conn.Open();
String query = "select Role from UserTable where UserID =( select UserId from LoginTable where UserName='******'and Password='******')";
SqlCommand command = new SqlCommand(query, conn);
SqlDataReader reader = command.ExecuteReader();
//sda.Fill(dt);
if (reader.HasRows == true)
{
reader.Read();
if (int.Parse(reader["Role"].ToString()) == 1)
{
this.Hide();
StaffForm fm = new StaffForm();
MessageBox.Show("Staff");
fm.Show();
conn.Close();
}
else if (int.Parse(reader["Role"].ToString()) == 2)
{
this.Hide();
AdminForm fm = new AdminForm();
MessageBox.Show("Admin");
fm.Show();
conn.Close();
}
else if (int.Parse(reader["Role"].ToString()) == 3)
{
this.Hide();
StockIncharge SI = new StockIncharge();
MessageBox.Show("Stock");
SI.Show();
conn.Close();
}
else
{
MessageBox.Show("Check ur username and password");
}
}
else
{
MessageBox.Show("Invalid username and password", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}