private void submitBookTicketBtn_Click(object sender, EventArgs e)
{
Bookticket bt = new Bookticket();
bt.BookTicketId = textBox21.Text;
bt.PassengerId = textBox22.Text;
bt.PassengerUsername = textBox23.Text;
bt.Airplane = airplaneLabel.Text;
bt.Source = fromComboBox.Text;
bt.Destination = toComboBox.Text;
bt.Departure = dateTimePicker1.Text;
bt.Arrival = dateTimePicker2.Text;
bt.Cost = Convert.ToInt32(costLabel.Text);
bt.Seats = seatLabel.Text;
BookTicketRepository btRepo = new BookTicketRepository();
if (btRepo.Insert(bt))
{
MessageBox.Show("Ticket Booked");
}
else
{
MessageBox.Show("Error adding ticket");
}
}
private void loadBookedFilghts_Click(object sender, EventArgs e)
{
Bookticket bt = new Bookticket();
BookTicketRepository btRepo = new BookTicketRepository();
string text = passengerSearchTextBox.Text;
if (text == "")
{
List <Bookticket> btList = btRepo.GetAllTickets();
dataGridView2.DataSource = btList;
}
else
{
Bookticket b2 = btRepo.GetTicket(text);
List <Bookticket> btList = new List <Bookticket>();
btList.Add(b2);
dataGridView2.DataSource = btList;
}
}
private void passengerSearchBtn_Click(object sender, EventArgs e)
{
if (passengerComboBox.SelectedItem.ToString() == "Flight")
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM Flight WHERE FlightID = '" + text + "' OR AirlineName LIKE '%" + text + "%' " + " OR Source LIKE '%" + text + "%' " + " OR Destination LIKE '%" + text + "%' " + " OR Cost LIKE '%" + text + "%' ";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
Flight f;
List <Flight> fList = new List <Flight>();
if (sdr.Read())
{
f = new Flight();
f.FlightId = sdr["FlightID"].ToString();
f.AirlineName = sdr["AirlineName"].ToString();
f.Source = sdr["Source"].ToString();
f.Destination = sdr["Destination"].ToString();
f.Arrival = Convert.ToString(sdr["Arrival"]);
f.Departure = Convert.ToString(sdr["Departure"]);
f.Cost = Convert.ToInt32(sdr["Cost"]);
fList.Add(f);
}
this.dataGridView2.DataSource = fList;
}
else if (passengerComboBox.SelectedItem.ToString() == "Airplanes")
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM Airplane WHERE AirplaneId = '" + text + "' OR AirplaneName LIKE '%" + text + "%' ";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
Airplane air;
List <Airplane> airList = new List <Airplane>();
if (sdr.Read())
{
air = new Airplane();
air.AirplaneId = sdr["AirplaneId"].ToString();
air.AirplaneName = sdr["AirplaneName"].ToString();
air.Capacity = Convert.ToInt32(sdr["Capacity"]);
airList.Add(air);
}
this.dataGridView2.DataSource = airList;
}
else if (passengerComboBox.SelectedItem.ToString() == "Airport")
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM Airport WHERE AirportId = '" + text + "' OR AirportName LIKE '%" + text + "%' ";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
Airport air1;
List <Airport> air1List = new List <Airport>();
if (sdr.Read())
{
air1 = new Airport();
air1.AirportId = sdr["AirportID"].ToString();
air1.AirportName = sdr["AirportName"].ToString();
air1.City = sdr["City"].ToString();
air1.Airportcode = sdr["AirportCode"].ToString();
air1List.Add(air1);
}
this.dataGridView2.DataSource = air1List;
}
else if (passengerComboBox.SelectedItem.ToString() == "Booked Flight")
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM BookTicket WHERE BookTicketId = '" + text + "' OR PassengerId LIKE '%" + text + "%' OR PassengerName LIKE '%" + text + "%' OR Seats LIKE '" + text + "%' ";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
Bookticket b;
List <Bookticket> bList = new List <Bookticket>();
if (sdr.Read())
{
b = new Bookticket();
b.BookTicketId = sdr["BookTicketId"].ToString();
b.PassengerId = sdr["PassengerId"].ToString();
b.PassengerUsername = sdr["PassengerName"].ToString();
b.Airplane = sdr["Airplane"].ToString();
b.Source = sdr["Source"].ToString();
b.Destination = sdr["Destination"].ToString();
b.Departure = sdr["Departure"].ToString();
b.Arrival = sdr["Arrival"].ToString();
b.Seats = sdr["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr["Cost"]);
bList.Add(b);
}
this.dataGridView2.DataSource = bList;
}
else
{
MessageBox.Show("Search error");
}
}
