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(); }