private void button1_Click(object sender, EventArgs e) { this.Hide(); StaffForm SF = new StaffForm(); SF.Show(); }
private void button1_Click(object sender, EventArgs e) { this.Close(); StaffForm sf = new StaffForm(); sf.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); } }