private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text == textBox3.Text)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into Users values (:us , :ps , :st) ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("us", textBox1.Text);
cmd.Parameters.Add("ps", textBox2.Text);
cmd.Parameters.Add("st", "u");
int r = cmd.ExecuteNonQuery();
if (r != -1)
{
this.Hide();
ViewFlight v = new ViewFlight(textBox1.Text);
v.ShowDialog();
}
}
else
{
MessageBox.Show("invalid password ");
textBox2.Clear();
textBox3.Clear();
}
}
private void button1_Click(object sender, EventArgs e)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select status from Users where UserName =:us and Pword = :ps ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("us", textBox1.Text);
cmd.Parameters.Add("ps", textBox2.Text);
OracleDataReader dr = cmd.ExecuteReader();
int counter = 0;
while (dr.Read())
{
counter++;
stat = dr[0].ToString();
}
dr.Close();
if (counter == 1 && stat == "u")
{
this.Hide();
ViewFlight v = new ViewFlight(textBox1.Text);
v.ShowDialog();
}
else if (counter == 1 && stat == "a")
{
this.Hide();
Admin a = new Admin();
a.ShowDialog();
}
else if (counter == 0)
{
MessageBox.Show("wrong username or password");
textBox1.Clear();
textBox2.Clear();
}
}
