private void button4_Click(object sender, EventArgs e) { AdminHomePage ahp = new AdminHomePage(); this.Hide(); ahp.Show(); }
private void button2_Click(object sender, EventArgs e) { int flag = -1; try { SqlCommand cmd = new SqlCommand("sp_Admin_Login", con); cmd.CommandType = CommandType.StoredProcedure; //adding input parameters cmd.Parameters.Add("@A_ID", SqlDbType.Int, 50).Value = textBox1.Text.Trim(); cmd.Parameters.Add("@A_Pass", SqlDbType.NVarChar, 50).Value = textBox2.Text.Trim(); //adding output parameter cmd.Parameters.Add(new SqlParameter("@flag", SqlDbType.Int)); cmd.Parameters["@flag"].Direction = ParameterDirection.Output; //calling sp con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); rdr.Close(); //converting output to int try { flag = (int)cmd.Parameters["@flag"].Value; } catch (Exception E) { MessageBox.Show(E.Message); } //saving value in flag flag = (int)cmd.Parameters["@flag"].Value; cmd.ExecuteNonQuery(); con.Close(); if (flag == 1) { AdminHomePage AHS = new AdminHomePage(); this.Hide(); AHS.Show(); } else { MessageBox.Show("Invalid Info, Please Check Again!"); } textBox1.Clear(); textBox2.Clear(); } catch (Exception Exp) { MessageBox.Show("Admin cannot login due following error: " + Exp.Message); con.Close(); textBox1.Clear(); textBox2.Clear(); } }