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();
}
}
