private void button1_Click(object sender, EventArgs e)
{
if (!verifySGBDConnection())
{
return;
}
string email = textBox1.Text;
string password = textBox2.Text;
if (email == "" && password == "")
{
MessageBox.Show("Inputs cannot be left in blank", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (email == "")
{
MessageBox.Show("Please enter e-mail", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (password == "")
{
MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
SqlCommand cmd = new SqlCommand("TravelAgency.VerifyAgent", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter aEmail = new SqlParameter("@Email", SqlDbType.VarChar);
SqlParameter aPassword = new SqlParameter("@AccountPwd", SqlDbType.VarChar);
SqlParameter aResult = new SqlParameter("@Result", SqlDbType.Int);
cmd.Parameters.Add(aEmail);
cmd.Parameters.Add(aPassword);
cmd.Parameters.Add(aResult);
cmd.Parameters["@Email"].Value = email;
cmd.Parameters["@AccountPwd"].Value = password;
cmd.Parameters["@Result"].Direction = ParameterDirection.Output;
cmd.Connection = cn;
cmd.ExecuteNonQuery();
if ((int)cmd.Parameters["@Result"].Value == 1)
{
MessageBox.Show("You have logged in successfully\n" + email);
this.Hide();
Form2 menu = new Form2(email);
menu.ShowDialog();
}
else
{
MessageBox.Show("Login failed, try again", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
cn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
Form2 form2 = new Form2();
form2.ShowDialog();
}
private void newToolStripMenuItem_Click(object sender, EventArgs e)
{
Form2 obj = new Form2();
obj.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
f.ShowDialog();
}
