private void bunifuTileButton3_Click(object sender, EventArgs e)
{
conn.Close();
this.Hide();
ReserveRoom a = new ReserveRoom();
a.ShowDialog();
this.Close();
}
private void bunifuPictureBox2_Click(object sender, EventArgs e)
{
FeedBackConnection.Close();
this.Hide();
ReserveRoom a = new ReserveRoom();
a.ShowDialog();
this.Close();
}
private void bunifuFlatButton2_Click(object sender, EventArgs e)
{
if (check() == true)
{
return;
}
if (validate() == true)
{
return;
}
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into users( id,email, gender, date_of_birth, first_name, last_name, mobile, password, is_admin) values(:id,:email,:gender,:dateofbirth, :firstname, :lastname, :mobile, :password,'f') ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("id", getuserID());
cmd.Parameters.Add("email", email.Text);
if (f.Checked)
{
cmd.Parameters.Add("gender", 'f');
}
else
{
cmd.Parameters.Add("gender", 'm');
}
cmd.Parameters.Add("dateofbirth", dateofbirth.Value);
cmd.Parameters.Add("firstname", first.Text);
cmd.Parameters.Add("lastname", last.Text);
cmd.Parameters.Add("mobile", mobile.Text);
cmd.Parameters.Add("password", password.Text);
int r = cmd.ExecuteNonQuery();
if (r > 0)
{
MessageBox.Show("Registeration Completed!");
}
conn.Close();
this.Hide();
ReserveRoom a = new ReserveRoom();
a.ShowDialog();
this.Close();
}
private void LoginBtn_Click(object sender, EventArgs e)
{
string cmdst = "select * from Users where EMAIL=:email AND PASSWORD=:password ";
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = cmdst;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("email", EmailTxtBox.Text);
cmd.Parameters.Add("password", PasswordTxtBox.Text);
OracleDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
MessageBox.Show(" You Have Logged In Successfully");
userID = rd["id"].ToString();
if (rd["is_admin"].ToString() == "t")
{
conn.Close();
Admin temp = new Admin();
this.Hide();
temp.ShowDialog();
this.Close();
}
else
{
conn.Close();
ReserveRoom temp = new ReserveRoom();
this.Hide();
temp.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("Wrong email or password");
}
}
