private void BackButton_Click(object sender, EventArgs e) { this.Hide(); AdminHomePage adminHomePage = new AdminHomePage(); adminHomePage.Show(); }
private void login() { string username = usernameTextBox.Text; string password = passwordTextBox.Text; if (username == "" || password == "") { MessageBox.Show("Please enter the username and password", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); usernameTextBox.Focus(); } else { try { // checking whether the username password is correct with the database SqlCommand cmd = new SqlCommand("SELECT * FROM users where username=@username and password=@password", con); cmd.Parameters.AddWithValue("username", username); cmd.Parameters.AddWithValue("password", password); con.Open(); SqlDataAdapter adpt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adpt.Fill(ds); con.Close(); int count = ds.Tables[0].Rows.Count; if (count == 1) { // Message box with the username if the credentials are correct MessageBox.Show("Have a Nice Day!! ", "Welcome: " + username); this.Hide(); string role = ds.Tables[0].Rows[0]["user_type"].ToString(); passingText = username; switch (role) { case "USER": // normal users UserHomePage userHomePage = new UserHomePage(); userHomePage.Show(); break; case "ADMIN": // admin user AdminHomePage adminHomePage = new AdminHomePage(); adminHomePage.Show(); break; } } else { //error message if the credentials are incorrect MessageBox.Show("The username or password is incorrect. Please try again!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); usernameTextBox.Clear(); passwordTextBox.Clear(); usernameTextBox.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }