private void BackBt_Click(object sender, EventArgs e)
{
this.Hide();
Admin_form a = new Admin_form();
a.Show();
}
private void SignIn_bt_Click(object sender, EventArgs e)
{
if (usernametxt.Text == "" || passwordtxt.Text == "")
{
MessageBox.Show("Please enter all information", "Sign in error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (customerRadiobox.Checked == false && driverRadiobox.Checked == false && cookRadiobox.Checked == false && checkerRadiobox.Checked == false && adminRadiobox.Checked == false)
{
MessageBox.Show("Please enter all information", "Sign in error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
username = usernametxt.Text;
user.con.Open();
if (user.con.State == System.Data.ConnectionState.Open) //to avoid database connection errors
{
string query = null;
if (sqlTable == "Admin")
{
query = "select top 1 * from " + sqlTable + " where Name = '" + usernametxt.Text + "' and Password = '******'";
}
else
{
query = "select top 1 * from " + sqlTable + " where Username = '******' and Password = '******'";
}
SqlCommand cmd = new SqlCommand(query, user.con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("sign in successful", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
ParentForm.Hide();
if (sqlTable == "Customer")
{
customerForm cf = new customerForm();
cf.Show();
customerUsername = usernametxt.Text;
//the customer's options goes here
}
else if (sqlTable == "Driver")
{
DriverUsername = usernametxt.Text;
driverForm df = new driverForm();
df.Show();
//the driver's options goes here
}
else if (sqlTable == "Cooks")
{
CookForm cf = new CookForm();
cf.Show();
}
else if (sqlTable == "Checker")
{
//Checker's options goes here
checker_username = usernametxt.Text;
checker_form ch = new checker_form();
ch.Show();
}
else if (sqlTable == "Admin")
{
//admin's options goes here
Admin_form af = new Admin_form();
af.Show();
}
}
else
{
MessageBox.Show("please enter username and password again", "username or password incorrect", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Can not open connection to database", "Database connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
MessageBox.Show(err.ToString(), "Data connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
user.con.Close();
}
}
}