public List <BookTicket> GetTicket(int ticketId)
{
string query = "SELECT * from BookTicket WHERE BTId = " + ticketId + "";
BookTicket b = null;
List <BookTicket> blist = new List <BookTicket>();
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
b = new BookTicket();
b.BookTicketId = Convert.ToInt32(sdr["BTId"]);
b.PassengerId = Convert.ToInt32(sdr["PassengerId"]);
b.FlightId = Convert.ToInt32(sdr["FlightId"]);
b.PassengerUsername = sdr["PassengerUsername"].ToString();
b.PassengerFullName = sdr["PassengerFullname"].ToString();
b.Airplane = sdr["Airplane"].ToString();
b.Source = sdr["Source"].ToString();
b.Destination = sdr["Destination"].ToString();
b.Departure = sdr["Departure"].ToString();
b.Seats = sdr["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr["Cost"]);
blist.Add(b);
}
dcc.CloseConnection();
return(blist);
}
public bool Insert(BookTicket bTicket)
{
try
{
string query = "INSERT into BookTicket VALUES ( " + bTicket.BookTicketId + ", " + bTicket.PassengerId + ", " + bTicket.FlightId + " , '" + bTicket.PassengerFullName + "', '" + bTicket.PassengerUsername + "', '" + bTicket.Airplane + "', '" + bTicket.Source + "', '" + bTicket.Destination + "', '" + bTicket.Departure + "', " + bTicket.Cost + " , '" + bTicket.Seats + "')";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
private void loadBookedFilghts_Click(object sender, EventArgs e)
{
Repository.BookTicket bt = new Repository.BookTicket();
BookTicketRepository btRepo = new BookTicketRepository();
List <Repository.BookTicket> btList = btRepo.GetTicket(userId);
Console.WriteLine(btList.Count);
if (btList.Count == 0)
{
MessageBox.Show("You Have Not Booked Any Ticket. \nPlease Book a Ticket First.");
}
else
{
dataGridView2.DataSource = btList;
}
}
private void submitBookTicketBtn_Click(object sender, EventArgs e)
{
Repository.BookTicket bt = new Repository.BookTicket();
BookTicketRepository bookRepo = new BookTicketRepository();
BookedSeatRepository bsRepo = new BookedSeatRepository();
BookedSeats bs = new BookedSeats();
bs.BookTicketId = Convert.ToInt32(ticketIdLabel.Text);
bs.FlightId = Convert.ToInt32(flightIdLabel.Text);
bs.Seats = seatLabel.Text;
bt.FlightId = Convert.ToInt32(flightIdLabel.Text);
bt.PassengerId = Convert.ToInt32(passengerIdLabel.Text);
bt.BookTicketId = Convert.ToInt32(ticketIdLabel.Text);
bt.PassengerUsername = usernameLabel.Text;
bt.PassengerFullName = passengerFullNameLabel.Text;
bt.Airplane = airplaneLabel.Text;
bt.Source = sourceLabel.Text;
bt.Destination = destinationLabel.Text;
bt.Departure = departureLabel.Text;
bt.Cost = Convert.ToInt32(costLabel.Text);
bt.Seats = seatLabel.Text;
if (bookRepo.Insert(bt) && bsRepo.Insert(bs))
{
MessageBox.Show("Ticket Booked");
this.bookTicketTabs.SelectTab(0);
Clear();
}
else
{
MessageBox.Show("Error adding ticket");
}
}
private void passengerSearchBtn_Click(object sender, EventArgs e)
{
try
{
if (passengerComboBox.SelectedItem.ToString().Equals("Flight"))
{
string text = this.passengerSearchTextBox.Text;
string query2 = "SELECT * FROM Flight WHERE FlightID = " + text + "";
string query = "SELECT * FROM Flight WHERE AirlineName LIKE '%" + text + "%' " + " OR Source LIKE '%" + text + "%' " + " OR Destination LIKE '%" + text + "%' " + " OR Cost LIKE '%" + text + "%' ";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
Flight f;
float y;
try
{
y = Convert.ToInt32(this.passengerSearchTextBox.Text) / 2;
y = 1;
}
catch (Exception er) { y = -10; }
if (y + 1 >= 1)
{
SqlDataReader sdr2 = dcc.GetData(query2);
List <Flight> fList2 = new List <Flight>();
//id
if (sdr2.Read())
{
f = new Flight();
f.FlightId = Convert.ToInt32(sdr2["FlightID"]);
f.AirlineName = sdr2["AirlineName"].ToString();
f.Source = sdr2["Source"].ToString();
f.Destination = sdr2["Destination"].ToString();
f.Departure = Convert.ToString(sdr2["Departure"]);
f.Cost = Convert.ToInt32(sdr2["Cost"]);
fList2.Add(f);
}
this.dataGridView2.DataSource = fList2;
}
else
{
SqlDataReader sdr = dcc.GetData(query);
List <Flight> fList = new List <Flight>();
if (sdr.Read())
{
f = new Flight();
f.FlightId = Convert.ToInt32(sdr["FlightID"]);
f.AirlineName = sdr["AirlineName"].ToString();
f.Source = sdr["Source"].ToString();
f.Destination = sdr["Destination"].ToString();
f.Departure = Convert.ToString(sdr["Departure"]);
f.Cost = Convert.ToInt32(sdr["Cost"]);
fList.Add(f);
//Console.WriteLine("s");
}
this.dataGridView2.DataSource = fList;
}
}
else if (passengerComboBox.SelectedItem.ToString().Equals("Airplane"))
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM Airplane WHERE Name LIKE '%" + text + "%' ";
string query2 = "SELECT * FROM Airplane WHERE AiplaneId = " + text + "";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
Airplane air;
float y;
try
{
y = Convert.ToInt32(this.passengerSearchTextBox.Text) / 2;
y = 1;
}
catch (Exception er) { y = -10; }
if (y + 1 >= 1)
{
SqlDataReader sdr2 = dcc.GetData(query2);
List <Airplane> airList = new List <Airplane>();
//id
if (sdr2.Read())
{
air = new Airplane();
air.AirplaneId = Convert.ToInt32(sdr2["AiplaneId"]);
air.AirplaneName = sdr2["Name"].ToString();
air.Capacity = Convert.ToInt32(sdr2["Capacity"]);
airList.Add(air);
}
}
else
{
SqlDataReader sdr = dcc.GetData(query);
List <Airplane> airList = new List <Airplane>();
if (sdr.Read())
{
air = new Airplane();
air.AirplaneId = Convert.ToInt32(sdr["AiplaneId"]);
air.AirplaneName = sdr["Name"].ToString();
air.Capacity = Convert.ToInt32(sdr["Capacity"]);
airList.Add(air);
}
this.dataGridView2.DataSource = airList;
}
}
else if (passengerComboBox.SelectedItem.ToString().Equals("Airport"))
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM Airport WHERE AirportName LIKE '%" + text + "%' OR City LIKE '%" + text + "%'";
string query2 = "SELECT * FROM Airport WHERE AirportId = " + text + "";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
Airport air1;
float y;
try
{
y = Convert.ToInt32(this.passengerSearchTextBox.Text) / 2;
y = 1;
}
catch (Exception er) { y = -10; }
if (y + 1 >= 1)
{
SqlDataReader sdr2 = dcc.GetData(query2);
List <Airport> air1List = new List <Airport>();
//id
if (sdr2.Read())
{
air1 = new Airport();
air1.AirportId = Convert.ToInt32(sdr2["AirportID"]);
air1.AirportName = sdr2["AirportName"].ToString();
air1.City = sdr2["City"].ToString();
air1List.Add(air1);
}
this.dataGridView2.DataSource = air1List;
}
else
{
SqlDataReader sdr = dcc.GetData(query);
List <Airport> air1List = new List <Airport>();
if (sdr.Read())
{
air1 = new Airport();
air1.AirportId = Convert.ToInt32(sdr["AirportID"]);
air1.AirportName = sdr["AirportName"].ToString();
air1.City = sdr["City"].ToString();
air1List.Add(air1);
}
this.dataGridView2.DataSource = air1List;
}
}
else if (passengerComboBox.SelectedItem.ToString().Equals("Booked Flight"))
{
string text = this.passengerSearchTextBox.Text;
string query = "SELECT * FROM BookTicket WHERE PassengerUsername LIKE '%" + text + "%' OR Seats LIKE '%" + text + "%' OR PassengerFullName LIKE '%" + text + "%' ";
string query2 = "SELECT * FROM BookTicket WHERE BookTicketId = " + userId + " OR PassengerId LIKE " + text + " OR FlightId LIKE " + text + "";
DatabaseConnection dcc = new DatabaseConnection();
dcc.ConnectWithDB();
Repository.BookTicket b;
float y;
try
{
y = Convert.ToInt32(this.passengerSearchTextBox.Text) / 2;
y = 1;
}
catch (Exception er) { y = -10; }
if (y + 1 >= 1)
{
SqlDataReader sdr2 = dcc.GetData(query2);
List <Repository.BookTicket> bList = new List <Repository.BookTicket>();
//id
if (sdr2.Read())
{
b = new Repository.BookTicket();
b.BookTicketId = Convert.ToInt32(sdr2["BookTicketId"]);
b.PassengerId = Convert.ToInt32(sdr2["PassengerId"]);
b.FlightId = Convert.ToInt32(sdr2["FlightId"]);
b.PassengerUsername = sdr2["PassengerUsername"].ToString();
b.PassengerUsername = sdr2["PassengerFullName"].ToString();
b.Airplane = sdr2["Airplane"].ToString();
b.Source = sdr2["Source"].ToString();
b.Destination = sdr2["Destination"].ToString();
b.Departure = sdr2["Departure"].ToString();
b.Seats = sdr2["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr2["Cost"]);
bList.Add(b);
}
this.dataGridView2.DataSource = bList;
}
else
{
SqlDataReader sdr = dcc.GetData(query);
List <Repository.BookTicket> bList = new List <Repository.BookTicket>();
if (sdr.Read())
{
b = new Repository.BookTicket();
b.BookTicketId = Convert.ToInt32(sdr["BookTicketId"]);
b.PassengerId = Convert.ToInt32(sdr["PassengerId"]);
b.FlightId = Convert.ToInt32(sdr["FlightId"]);
b.PassengerUsername = sdr["PassengerUsername"].ToString();
b.PassengerUsername = sdr["PassengerFullName"].ToString();
b.Airplane = sdr["Airplane"].ToString();
b.Source = sdr["Source"].ToString();
b.Destination = sdr["Destination"].ToString();
b.Departure = sdr["Departure"].ToString();
b.Seats = sdr["Seats"].ToString();
b.Cost = Convert.ToInt32(sdr["Cost"]);
bList.Add(b);
}
this.dataGridView2.DataSource = bList;
}
}
else
{
MessageBox.Show("Search error");
}
}catch (Exception er)
{
MessageBox.Show("Nothing to search. Write something in Search Box");
}
}
