protected void Button1_Click(object sender, EventArgs e)
{
int ak;
int p = Convert.ToInt32(noofperson.Text);
if (p < availseats)
{
trainscmd.CommandText = "insert into Ticket_book(USERNAME,FULLNAME,TRAIN_NO,TRAIN_NAME,SOURCE_STN,DESTINATION_STN,ARRIVAL_DAY,ARRIVAL_TIME,DEPARTURE_DAY,DEPARTURE_TIME,JOURNEY_DATE,CLASSTYPE,NO_OF_PERSONS,TOTAL) values('" + Session["username"] + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox7.Text + "','" + TextBox9.Text + "','" + TextBox5.Text + "','" + TextBox10.Text + "','" + TextBox6.Text + "','" + TextBox8.Text + "','" + noofperson.SelectedIndex + "'," + ClassDrop.SelectedIndex + "," + txttotal.Text + ") ";
trainscmd.Connection = con;
trainscmd.ExecuteNonQuery();
trainscmd.CommandText = "select TICKET_NO from Ticket_book order by TICKET_NO desc";
trainsda.SelectCommand = trainscmd;
DataTable ticketdt = new DataTable();
trainsda = new SqlDataAdapter(trainscmd);
trainsda.Fill(ticketdt);
string pnrtxt = "1800" + ticketdt.Rows[0]["TICKET_NO"];
int bb = Convert.ToInt32(pnrtxt);
trainscmd.CommandText = "update Ticket_book set pnr_no = '" + bb + "' where TICKET_NO = " + ticketdt.Rows[0]["TICKET_NO"];
trainscmd.Connection = con;
trainscmd.ExecuteNonQuery();
int noofpersons = Convert.ToInt32(noofperson.Text);
trainscmd.CommandText = "update Train set avail_seat = avail_seat - " + noofpersons;
trainscmd.ExecuteNonQuery();
// Literal1.Text = "Ticket No " + ticketdt.Rows[0]["TICKET_NO"] + " PNR NO :- " + pnrtxt;
object o = ticketdt.Rows[0]["TICKET_NO"];
ak = Convert.ToInt32(o);
Session["trainno"] = ak;
}
else
{
Literal1.Text = "Seats Are Not Available";
}
Response.Redirect("~/Payment.aspx");
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox8.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
noofperson.ClearSelection();
ClassDrop.ClearSelection();
TextBox9.Text = "";
TextBox10.Text = "";
txttotal.Text = "";
}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox8.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
noofperson.ClearSelection();
ClassDrop.ClearSelection();
TextBox9.Text = "";
TextBox10.Text = "";
txttotal.Text = "";
}
