protected void AddTrip_Click(object sender, EventArgs e)
{
CommonGateWay gateWay = new CommonGateWay();
getDestinationId();
string date = departon.SelectedItem.Text;
string Time = j_Time.SelectedItem.Text;
string Bus = BusNumber.SelectedItem.Text;
string query = "Insert Into Status (Date,Time,Station,BusNumber) Values ('" + date + "','" + Time + "','" + destinationId + "','" + Bus + "')";
gateWay.Command = new SqlCommand(query, gateWay.Connection);
gateWay.Connection.Open();
int result = gateWay.Command.ExecuteNonQuery();
gateWay.Connection.Close();
if (result < 0)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Unsuccessful')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Successful')", true);
}
}
protected void CheckTicketButton_Click(object sender, EventArgs e)
{
string quary = "select TicketNo as 'Ticket Number',ticket.Name,Phone,SeatNo as 'Seat No',JourneyDate as 'Journey Date',JourneyTime as 'Journey Time',JourneyFrom as 'Source',FromTo.Name as Destination,BusNumber as 'Bus Number' from ticket full join FromTo On ticket.JourneyTo = FromTo.Id where TicketNo = '" + TicketNumberTextBox.Text + "' ";
CommonGateWay gateWay = new CommonGateWay();
SqlDataAdapter dataAdapter = new SqlDataAdapter(quary, gateWay.Connection);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
ticketGridView.DataSource = dataSet.Tables[0];
ticketGridView.DataBind();
}
