private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=DESKTOP-7KB122K\\WASSIMSQL; initial catalog=airport; integrated security=true");
if (checkBox1.Checked)
{
SqlCommand li = new SqlCommand("select * from Admin where admin_name = @name and admin_password = @pass", con);
con.Open();
SqlParameter pass = new SqlParameter("@pass", textBox1.Text);
SqlParameter name = new SqlParameter("@name", E_mail.Text);
li.Parameters.Add(name);
li.Parameters.Add(pass);
SqlDataReader myreader = li.ExecuteReader();
if (myreader.Read())
{
this.Hide();
admin admin = new admin(E_mail.Text);
admin.Show();
con.Close();
}
else
{
MessageBox.Show("the username or the password is invalid");
E_mail.Clear();
textBox1.Clear();
E_mail.Focus();
con.Close();
}
}
else
{
SqlCommand li2 = new SqlCommand("select * from Passenger where Passenger_username = @name and Passenger_password = @pass", con);
con.Open();
SqlParameter pass = new SqlParameter("@pass", textBox1.Text);
SqlParameter name = new SqlParameter("@name", E_mail.Text);
li2.Parameters.Add(name);
li2.Parameters.Add(pass);
SqlDataReader myreader = li2.ExecuteReader();
if (myreader.Read())
{
this.Hide();
user user = new user(E_mail.Text);
user.Show();
con.Close();
}
else
{
MessageBox.Show("the username or the password is invalid");
E_mail.Clear();
textBox1.Clear();
E_mail.Focus();
myreader.Close();
con.Close();
}
}
con.Close();
}
private void pictureBox2_Click(object sender, EventArgs e)
{
user a2 = new user();
a2.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
user c1 = new user();
c1.Show();
this.Hide();
}
private void button5_Click(object sender, EventArgs e)
{
this.Hide();
user a = new user();
a.UserForm = this;
a.Show();
}
private void button5_Click(object sender, EventArgs e)
{
this.Hide();
user a = new user();
a.UserForm = this;
a.Show();
}
private void 用户名密码管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!config.account)
{
user u = new user();
u.Show();
config.account = true;
}
}
