private void button2_Click(object sender, EventArgs e)
{
//con.Open();
if (textBox11.Text != "" && textBox12.Text != "")
{
if (textBox11.Text != null && textBox12.Text != null)
{
if (con.State == ConnectionState.Open)
{
String str = "insert into Booking(CustomerId,DateofJourney,FlightId,Seatno) values('" + Convert.ToInt32(textBox3.Text) + "', '" + Convert.ToString(dateTimePicker1.Text) + "','" + Convert.ToInt32(textBox11.Text) + "','" + Convert.ToInt32(textBox12.Text) + "' )";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
String st = "update Flight_Details set Seats= Seats-@x where Id='" + Convert.ToInt32(textBox11.Text) + "') ";
SqlCommand cm = new SqlCommand(str, con);
cm.ExecuteNonQuery();
MessageBox.Show("Your seat is booked");
this.Hide();
Ticket_Reservation lgn = new Ticket_Reservation();
lgn.Show();
//Ticket_Reservation_Load(sender,e);
}
}
else
{
MessageBox.Show("Enter all required DATA !!!");
}
}
else
{
label11.Visible = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-PRPMMA8\HASANDB;Initial Catalog=Flight_booking;Integrated Security=True");
SqlDataAdapter sda = new SqlDataAdapter("Select Count(*)From customer_detail where name='" + textBox1.Text + "' and password='******'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
//x = dt.Rows[0][0].ToString();
// MessageBox.Show(x);
con.Open();
String s = "Select id From customer_detail where name='" + textBox1.Text + "' and password='******'";
SqlCommand cmd = new SqlCommand(s, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
x = (dr["id"].ToString());
MessageBox.Show(x);
}
else
{
MessageBox.Show("error in inner");
}
this.Hide();
Ticket_Reservation lgn = new Ticket_Reservation(x);
lgn.Show();
}
else if (textBox1.Text == "Admin" && textBox2.Text == "Admin")
{
MessageBox.Show("You are login as Admin");
this.Hide();
Admin lgn = new Admin();
lgn.Show();
}
else
{
MessageBox.Show("Please check Your Username and password");
}
}