public UserLandingPage(User user)
{
USER = user;
InitializeComponent();
Console.WriteLine(user.firstName);
welcome_label.Text = "Welcome, " + user.firstName + " " + user.lastName;
userId_value_label.Text = user.id.ToString();
rewardBalance_value_label.Text = user.rewardBalance.ToString();
FormDatabaseHelper.fillAirportsCity(origin_comboBox);
FormDatabaseHelper.fillAirportsCity(destination_comboBox);
bookFlights_groupBox.Hide();
upcomingFlights_groupBox.Show();
pastFlights_groupBox.Hide();
oneway_groupBox.Hide();
return_groupBox.Hide();
ShowReturnComponents(false);
oneway_leg1 = 0;
oneway_leg2 = 0;
return_leg1 = 0;
return_leg2 = 0;
populateUpcomingFlightsGrid(upcomingFlights_datagridview);
populatePastFlightsGrid(pastflights_datagridview);
populateCancelledFlightsGrid(cancelled_datagridview);
}
private void del_submit_button_Click(object sender, EventArgs e)
{
int id = int.Parse(del_flightidvalue_label.Text);
FormDatabaseHelper.removeFlightFromRoutes(id);
string origin = del_destination_combobox.Text;
string destination = del_destination_combobox.Text;
DataTable newEditTable;
BindingSource SBind = new BindingSource();
if ((del_origin_combobox.SelectedItem != null) && (del_destination_combobox.SelectedItem != null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(origin, destination);
}
else if ((del_origin_combobox.SelectedItem != null) && (del_destination_combobox.SelectedItem == null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(origin, null);
}
else if ((del_origin_combobox.SelectedItem == null) && (del_destination_combobox.SelectedItem != null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, destination);
}
else
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, null);
}
SBind.DataSource = newEditTable;
del_flights_datagridview.Columns.Clear();
deleteTableColumnSetup();
del_flights_datagridview.DataSource = SBind;
del_flights_datagridview.Refresh();
}
private void updatePlane_btn_Click(object sender, EventArgs e)
{
String planeModel = "";
String capacityStr = newCapacityValue_textBox.Text;
if (!String.IsNullOrEmpty(capacityStr))
{
planeModel = planesModels_comboBox.SelectedItem.ToString();
int flightId = Int32.Parse(selFlightId_textbox.Text);
int newCapacity = Int32.Parse(capacityStr);
int filledSeats = Int32.Parse(filledSeatsValue_textBox.Text);
//updates in database/flights table
if (newCapacity > filledSeats)
{
FormDatabaseHelper.updatePlaneInFlightsTable(flightId, planeModel, newCapacity);
DataTable newEditTable = FormDatabaseHelper.updateAccountGridViewTable();
BindingSource SBind = new BindingSource();
SBind.DataSource = newEditTable;
flightsTableColumnSetup();
marketing_datagrid.DataSource = SBind;
marketing_datagrid.Refresh();
//update in the data grid view
//marketing_datagrid.SelectedRows[0].Cells[6].Value = planeModel;
//marketing_datagrid.SelectedRows[0].Cells[5].Value = newCapacity;
}
else
{
Console.WriteLine("Select a plane with higher capacity than current");
}
}
}
private void addRoute_submit_btn_Click(object sender, EventArgs e)
{
if (add_origin_comboBox.SelectedItem != null &&
add_dest_comboBox.SelectedItem != null)
{
string defaultPlane = "Boeing 737";
int maxCap = FormDatabaseHelper.getPlaneCapacity(defaultPlane);
flight newFlight = new flight();
newFlight.createFlight(add_origin_comboBox.Text,
add_dest_comboBox.Text,
add_depart_time_DTP.Value,
add_arrival_time_DTP.Value,
defaultPlane,
double.Parse(add_cost_label.Text),
maxCap,
0);
FormDatabaseHelper.uploadFlight(newFlight);
add_status_label.Text = "Flight added successfully";
}
else
{
//error code here
}
}
public UserFlightHistory(int userID, int leg1Id, int leg2Id)
{
this.userID = userID;
this.leg1bookingId = leg1Id;
this.leg2bookingId = leg2Id;
flight leg1_flight = FormDatabaseHelper.getFlight_fromBookingTable(leg1Id);
originAbv = leg1_flight.origin;
leg1deptDate = leg1_flight.deptTime;
leg1ArrivalDate = leg1_flight.arrivalTime;
departureDate = leg1deptDate;
this.paymentAmount = leg1_flight.cost;
flight leg2_flight;
if (leg2Id == 0)
{
finaldestAbv = leg1_flight.dest;
connectionAbv = null;
arrivalDate = leg1ArrivalDate;
}
else
{
leg2_flight = FormDatabaseHelper.getFlight_fromBookingTable(leg2Id);
finaldestAbv = leg2_flight.dest;
connectionAbv = leg2_flight.origin;
leg2deptDate = leg2_flight.deptTime;
leg2ArrivalDate = leg2_flight.arrivalTime;
arrivalDate = leg2ArrivalDate;
this.paymentAmount = this.paymentAmount + leg2_flight.cost + 8;
}
}
private void populateCancelledFlightsGrid(DataGridView gridview)
{
DataTable past = FormDatabaseHelper.generateCancelledFlightsDataTable(USER.id);
gridview.DefaultCellStyle.Format = "g";
gridview.DataSource = past;
gridview.AutoGenerateColumns = false;
gridview.Columns[0].Name = "Status"; // name
gridview.Columns[0].HeaderText = "Status "; // header text
gridview.Columns[0].DataPropertyName = "Status"; // field name
gridview.Columns[1].Name = "OriginAbv"; // name
gridview.Columns[1].HeaderText = "Origin "; // header text
gridview.Columns[1].DataPropertyName = "OriginAbv"; // field name
gridview.Columns[2].Name = "connectionAbv"; // name
gridview.Columns[2].HeaderText = "Connection "; // header text
gridview.Columns[2].DataPropertyName = "connectionAbv"; // field name
gridview.Columns[3].Name = "finaldestAbv"; // name
gridview.Columns[3].HeaderText = "Destination"; // header text
gridview.Columns[3].DataPropertyName = "finaldestAbv"; // field name
gridview.Columns[4].Name = "DepartureDate"; // name
gridview.Columns[4].HeaderText = "Departure Origin"; // header text
gridview.Columns[4].DataPropertyName = "DepartureDate"; // field name
gridview.Columns[5].Name = "ArrivalDate"; // name
gridview.Columns[5].HeaderText = "Arrival final Dest"; // header text
gridview.Columns[5].DataPropertyName = "ArrivalDate"; // field name
gridview.Columns[6].Name = "PaymentType"; // name
gridview.Columns[6].HeaderText = "1- Card 2-Rewards"; // header text
gridview.Columns[6].DataPropertyName = "PaymentType"; // field name
gridview.Columns[7].Name = "PaymentAmount"; // name
gridview.Columns[7].HeaderText = "Cost"; // header text
gridview.Columns[7].DataPropertyName = "PaymentAmount"; // field name
gridview.Columns[8].Name = "UserHistId"; // name
gridview.Columns[8].HeaderText = "UserHist ID"; // header text
gridview.Columns[8].DataPropertyName = "UserHistId"; // field name
gridview.Columns[8].Visible = false;
gridview.Columns[9].Visible = false;
gridview.Columns[10].Visible = false;
gridview.Columns[11].Visible = false;
gridview.Columns[12].Visible = false;
gridview.Columns[13].Visible = false;
gridview.Columns[14].Visible = false;
}
// ==================================================================================
// Add Route Group Methods ==========================================================
// ==================================================================================
private void addRoute_btn_Click(object sender, EventArgs e)
{
editRoute_groupBox.Hide();
deleteRoute_groupBox.Hide();
addRoute_groupBox.Show();
FormDatabaseHelper.fillAirportsAbv(add_origin_comboBox);
FormDatabaseHelper.fillAirportsAbv(add_dest_comboBox);
}
private void populateUpcomingFlightsGrid(DataGridView gridview)
{
//upcomingFlights_datagridview
Console.WriteLine("-------------currsys time->" + currSysTime_DTP.Value.ToString());
DataTable upcoming = FormDatabaseHelper.generateUpcomingFlightsDataTable(USER.id, currSysTime_DTP.Value);
gridview.DefaultCellStyle.Format = "g";
gridview.DataSource = upcoming;
gridview.AutoGenerateColumns = false;
gridview.Columns[0].Name = "OriginAbv"; // name
gridview.Columns[0].HeaderText = "Origin "; // header text
gridview.Columns[0].DataPropertyName = "OriginAbv"; // field name
gridview.Columns[1].Name = "connectionAbv"; // name
gridview.Columns[1].HeaderText = "Connection "; // header text
gridview.Columns[1].DataPropertyName = "connectionAbv"; // field name
gridview.Columns[2].Name = "finaldestAbv"; // name
gridview.Columns[2].HeaderText = "Destination"; // header text
gridview.Columns[2].DataPropertyName = "finaldestAbv"; // field name
gridview.Columns[3].Name = "DepartureDate"; // name
gridview.Columns[3].HeaderText = "Departure Origin"; // header text
gridview.Columns[3].DataPropertyName = "DepartureDate"; // field name
gridview.Columns[4].Name = "ArrivalDate"; // name
gridview.Columns[4].HeaderText = "Arrival final Dest"; // header text
gridview.Columns[4].DataPropertyName = "ArrivalDate"; // field name
gridview.Columns[5].Name = "PaymentType"; // name
gridview.Columns[5].HeaderText = "1- Card 2-Rewards"; // header text
gridview.Columns[5].DataPropertyName = "PaymentType"; // field name
gridview.Columns[6].Name = "PaymentAmount"; // name
gridview.Columns[6].HeaderText = "Cost"; // header text
gridview.Columns[6].DataPropertyName = "PaymentAmount"; // field name
gridview.Columns[7].Name = "UserHistId"; // name
gridview.Columns[7].HeaderText = "UserHist ID"; // header text
gridview.Columns[7].DataPropertyName = "UserHistId"; // field name
gridview.Columns[8].Visible = false;
gridview.Columns[9].Visible = false;
gridview.Columns[10].Visible = false;
gridview.Columns[11].Visible = false;
gridview.Columns[12].Visible = false;
gridview.Columns[13].Visible = false;
gridview.Columns[14].Visible = false;
}
public LoadEngLandingPage()
{
InitializeComponent();
editRoute_groupBox.Hide();
deleteRoute_groupBox.Hide();
addRoute_groupBox.Show();
FormDatabaseHelper.fillAirportsAbv(add_origin_comboBox);
FormDatabaseHelper.fillAirportsAbv(add_dest_comboBox);
}
private void updateTable()
{
DataTable newEditTable = new DataTable();
BindingSource SBind = new BindingSource();
bool location = false, date = false;
location = origin_dest_checkbox.Checked;
date = date_checkbox.Checked;
bool multiPassTableSort = false;
if (location && date)
{
multiPassTableSort = true;
}
if (location && !multiPassTableSort)
{
string origin = origin_combobox.Text;
string destination = dest_combobox.Text;
if (origin_combobox.SelectedItem != null && dest_combobox.SelectedItem != null)
{
newEditTable = FormDatabaseHelper.updateAccountGridViewTable(origin, destination);
}
else if (origin_combobox.SelectedItem != null && dest_combobox.SelectedItem == null)
{
newEditTable = FormDatabaseHelper.updateAccountGridViewTable(origin, null);
}
else if (origin_combobox.SelectedItem == null && dest_combobox.SelectedItem != null)
{
newEditTable = FormDatabaseHelper.updateAccountGridViewTable(null, destination);
}
else
{
newEditTable = FormDatabaseHelper.updateAccountGridViewTable(null, null);
}
}
else if (date && !multiPassTableSort)
{
DateTime before = beforeDate_DTP.Value.Date;
DateTime after = afterDate_DTP.Value.Date;
if (date_after_checkbox.Checked && date_before_checkbox.Checked)
{
newEditTable = FormDatabaseHelper.updateGridViewTableWithDate(true, true, before, after);
}
else if (!date_after_checkbox.Checked && date_before_checkbox.Checked)
{
newEditTable = FormDatabaseHelper.updateGridViewTableWithDate(true, false, before);
}
else if (date_after_checkbox.Checked && !date_before_checkbox.Checked)
{
newEditTable = FormDatabaseHelper.updateGridViewTableWithDate(false, true, default, after);
private void showFlights_btn_Click(object sender, EventArgs e)
{
if (origin_comboBox.SelectedItem != null && destination_comboBox.SelectedItem != null)
{
String originCity = origin_comboBox.SelectedItem.ToString();
String destCity = destination_comboBox.SelectedItem.ToString();
String originAbv = FormDatabaseHelper.getAirportAbvFromCity(originCity);
String destAbv = FormDatabaseHelper.getAirportAbvFromCity(destCity);
DateTime currSysTime = currSysTime_DTP.Value;
DateTime deptDate = deptDate_dtp.Value;
DateTime returnDate;
bool oneWay = oneWay_rBtn.Checked;
bool returnBooking = return_rBtn.Checked;
oneway_groupBox.Text = originCity + "-->" + destCity;
return_groupBox.Text = destCity + "-->" + originCity;
if (originAbv != destAbv && (deptDate <= currSysTime.AddDays(60)))
{
if (returnBooking)
{
returnDate = returnDate_dtp.Value;
if (returnDate > deptDate)
{
oneway_groupBox.Show();
DataTable onewayOptionsTable = FormDatabaseHelper.getAvailableFlights(originAbv, destAbv, deptDate);
populateDataGridView(oneway_datagridview, onewayOptionsTable);
return_groupBox.Show();
DataTable returnOptionsTable = FormDatabaseHelper.getAvailableFlights(destAbv, originAbv, returnDate);
populateDataGridView(return_datagridview, returnOptionsTable);
}
else
{
Console.WriteLine("return should be after departure date");
}
}
else
{
return_groupBox.Hide();
oneway_groupBox.Show();
DataTable onewayOptionsTable = FormDatabaseHelper.getAvailableFlights(originAbv, destAbv, deptDate);
populateDataGridView(oneway_datagridview, onewayOptionsTable);
}
}
else
{
Console.WriteLine("Depature date should be within 6 months AND ");
Console.WriteLine("origin and dest cannot be same");
}
}
}
// =================================================================================================
// Single Flight Report Functionality ==============================================================
// =================================================================================================
private void single_report_button_Click(object sender, EventArgs e)
{
int flightID = int.Parse(flights_dataview.CurrentRow.Cells["id"].Value.ToString());
DataTable bookedFlightInfo = FormDatabaseHelper.returnFlightInformation(flightID);
DataTable flightTransactions = FormDatabaseHelper.returnSingleFlightTransactions(flightID);
fillSingleReport(bookedFlightInfo, flightTransactions);
tools_groupbox.Hide();
singleflight_report_groupbox.Show();
}
private void fillFullReport()
{
DataTable allBookedFlights = FormDatabaseHelper.returnFlightInformation();
allBookedFlights.Columns.Add("percCapacity", typeof(double));
allBookedFlights.Columns.Add("cardRev", typeof(double));
allBookedFlights.Columns.Add("rewardRev", typeof(double));
int count = allBookedFlights.Rows.Count;
full_flightCount_label.Text = count.ToString();
int flightID;
int currentRow = 0;
double cardRev = 0.00;
double rewardRev = 0.00;
foreach (DataRow row in allBookedFlights.Rows)
{
flightID = row.Field <int>("id");
DataTable transactions = FormDatabaseHelper.returnSingleFlightTransactions(flightID);
double currentCardRev = findRevenue(transactions, 1);
currentCardRev = Math.Round(currentCardRev, 2);
double currentRewardRev = findRevenue(transactions, 2);
allBookedFlights.Rows[currentRow].SetField <double>("cardRev", currentCardRev);
allBookedFlights.Rows[currentRow].SetField <double>("rewardRev", currentRewardRev);
cardRev = cardRev + currentCardRev;
rewardRev = rewardRev + currentRewardRev;
double maxCap = row.Field <int>("maxCapacity");
double currCap = row.Field <int>("currCapacity");
double percCap = (currCap / maxCap) * 100.00;
percCap = Math.Round(percCap, 2);
allBookedFlights.Rows[currentRow].SetField <double>("percCapacity", percCap);
currentRow++;
}
full_cardRev_label.Text = cardRev.ToString();
full_pointRev_label.Text = rewardRev.ToString();
BindingSource SBind = new BindingSource();
SBind.DataSource = allBookedFlights;
full_report_datagridview.Columns.Clear();
fullTransactionsTableColumnSetup();
full_report_datagridview.DataSource = SBind;
full_report_datagridview.Refresh();
}
// =================================================================================================
// Print Manifest Functionality ====================================================================
// =================================================================================================
private void printManifest_btn_Click(object sender, EventArgs e)
{
flight_search_groupbox.Hide();
manifest_groupbox.Show();
int flightID = int.Parse(flights_dataview.CurrentRow.Cells["id"].Value.ToString());
DataTable bookedFlightInfo = FormDatabaseHelper.returnFlightInformation(flightID);
DataTable flightTransactions = FormDatabaseHelper.returnSingleFlightTransactions(flightID);
fillDataManifest(bookedFlightInfo, flightTransactions);
}
private void del_clearSort_button_Click(object sender, EventArgs e)
{
del_origin_combobox.SelectedItem = null;
del_destination_combobox.SelectedItem = null;
DataTable newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, null);
BindingSource SBind = new BindingSource();
SBind.DataSource = newEditTable;
deleteTableColumnSetup();
del_flights_datagridview.DataSource = SBind;
del_flights_datagridview.Refresh();
}
public void createFlight(string origin, string dest, DateTime deptTime, DateTime arrivalTime, string planeType,
double cost, int maxCapacity, int currCapacity)
{
this.origin = origin;
this.dest = dest;
this.deptTime = deptTime;
this.arrivalTime = arrivalTime;
this.planeType = planeType;
this.cost = cost;
this.maxCapacity = maxCapacity;
this.currCapacity = currCapacity;
this.maxCapacity = FormDatabaseHelper.getPlaneCapacity(planeType);
this.distance = FormDatabaseHelper.getDistance(origin, dest);
}
private void getDistance()
{
if (add_origin_comboBox.SelectedItem == null || add_dest_comboBox.SelectedItem == null)
{
// error code here
}
else
{
String origin = add_origin_comboBox.SelectedItem.ToString();
String dest = add_dest_comboBox.SelectedItem.ToString();
String distance = String.Format("{0:0.00}", FormDatabaseHelper.getDistance(origin, dest).ToString("0.00"));
add_distanceValue_label.Text = distance;
}
}
private void cancelFlight_btn_Click(object sender, EventArgs e)
{
if (currSysTime_DTP.Value > upcoming_selected_dept.AddDays(-1))
{
//flight within 24 hours cannot cancel
MessageBox.Show("Flight takes off in 24 hours cannot cancel");
}
else
{
//cancel in userhistid
Console.WriteLine("cancelling the booking");
FormDatabaseHelper.cancelBooking(upcoming_selectedID_ufh);
populateUpcomingFlightsGrid(upcomingFlights_datagridview);
}
}
public MarketingLandingPage()
{
InitializeComponent();
DataTable newEditTable = FormDatabaseHelper.updateAccountGridViewTable();
BindingSource SBind = new BindingSource();
SBind.DataSource = newEditTable;
flightsTableColumnSetup();
marketing_datagrid.DataSource = SBind;
marketing_datagrid.Refresh();
FormDatabaseHelper.FillPlaneModelsBox(planesModels_comboBox);
FormDatabaseHelper.fillAirportsAbv(origin_combobox);
FormDatabaseHelper.fillAirportsAbv(dest_combobox);
}
// ==================================================================================
// Delete Route Group Methods and Variables =========================================
// ==================================================================================
private void deleteRoute_btn_Click(object sender, EventArgs e)
{
addRoute_groupBox.Hide();
deleteRoute_groupBox.Show();
editRoute_groupBox.Hide();
FormDatabaseHelper.fillAirportsAbv(del_origin_combobox);
FormDatabaseHelper.fillAirportsAbv(del_destination_combobox);
DataTable newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, null);
BindingSource SBind = new BindingSource();
SBind.DataSource = newEditTable;
deleteTableColumnSetup();
del_flights_datagridview.DataSource = SBind;
del_flights_datagridview.Refresh();
}
public FlightManLandingPage()
{
InitializeComponent();
DataTable newEditTable = FormDatabaseHelper.updateAccountGridViewTable();
BindingSource SBind = new BindingSource();
SBind.DataSource = newEditTable;
flightsTableColumnSetup();
flights_dataview.DataSource = SBind;
flights_dataview.Refresh();
FormDatabaseHelper.fillAirportsAbv(origin_combobox);
FormDatabaseHelper.fillAirportsAbv(dest_combobox);
flight_search_groupbox.Show();
manifest_groupbox.Hide();
}
private void book_btn_Click(object sender, EventArgs e)
{
bool cardpayment = card_payment_rbtn.Checked == true;
if (cardpayment)
{
ticket1.paymentType = 1;
int pointsEarned = FormDatabaseHelper.getPointsEarnedFromCost(ticket1.paymentAmount);
FormDatabaseHelper.updateUserReward(USER.id, pointsEarned);
}
else
{
ticket1.paymentType = 2;
int pointsRedeem = FormDatabaseHelper.getPointsNeededForCost(ticket1.paymentAmount) * -1;
FormDatabaseHelper.updateUserReward(USER.id, pointsRedeem);
}
// FormDatabaseHelper.insert_UserFlightHistory(ticket1);
FormDatabaseHelper.createBooking(ticket1, USER);
if (ROUNDTRIP)
{
if (cardpayment)
{
ticket2.paymentType = 1;
int pointsEarned = FormDatabaseHelper.getPointsEarnedFromCost(ticket2.paymentAmount);
FormDatabaseHelper.updateUserReward(USER.id, pointsEarned);
}
else
{
ticket2.paymentType = 1;
int pointsRedeem = FormDatabaseHelper.getPointsNeededForCost(ticket1.paymentAmount) * -1;
FormDatabaseHelper.updateUserReward(USER.id, pointsRedeem);
}
FormDatabaseHelper.createBooking(ticket2, USER);
}
this.Visible = false;
this.Dispose();
}
private void del_destination_combobox_TextChanged(object sender, EventArgs e)
{
string destination = del_destination_combobox.Text;
DataTable newEditTable;
BindingSource SBind = new BindingSource();
if (del_origin_combobox.SelectedItem != null)
{
string origin = del_origin_combobox.Text;
newEditTable = FormDatabaseHelper.updateEditGridViewTable(origin, destination);
}
else
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, destination);
}
SBind.DataSource = newEditTable;
del_flights_datagridview.Columns.Clear();
deleteTableColumnSetup();
del_flights_datagridview.DataSource = SBind;
del_flights_datagridview.Refresh();
}
private void edit_submit_btn_Click(object sender, EventArgs e)
{
int flightID = int.Parse(edit_flights_dataview.CurrentRow.Cells["id"].Value.ToString());
double cost = double.Parse(edit_costValue_label.Text);
DateTime arrival_time = edit_arrival_time_DTP.Value;
DateTime departure_time = edit_depart_time_DTP.Value;
FormDatabaseHelper.updateTimesInFlightsTable(flightID, arrival_time, departure_time, cost);
string destination = edit_dest_combobox.Text;
string origin = edit_origin_combobox.Text;
DataTable newEditTable;
BindingSource SBind = new BindingSource();
if ((edit_origin_combobox.SelectedItem != null) && (edit_dest_combobox.SelectedItem != null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(origin, destination);
}
else if ((edit_origin_combobox.SelectedItem == null) && (edit_dest_combobox.SelectedItem != null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(destination, null);
}
else if ((edit_origin_combobox.SelectedItem != null) && (edit_dest_combobox.SelectedItem == null))
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, origin);
}
else
{
newEditTable = FormDatabaseHelper.updateEditGridViewTable(null, null);
}
SBind.DataSource = newEditTable;
edit_flights_dataview.Columns.Clear();
editTableColumnSetup();
edit_flights_dataview.DataSource = SBind;
edit_flights_dataview.Refresh();
}
public BoardingPass(User user, int ufh_id)
{
UserFlightHistory ticket = FormDatabaseHelper.GetUserFlightHistory(ufh_id);
InitializeComponent();
name_value_label.Text = user.lastName + " , " + user.firstName;
account_value_label.Text = user.id.ToString();
leg1_groupbox.Show();
leg2_groupbox.Hide();
layover_label.Hide();
String fullflight = "";
String leg1ID = "";
String leg1_flight = "";
String leg1departure = "";
String leg1Arrival = "";
String layover = "";
String leg2ID = "";
String leg2_flight = "";
String leg2departure = "";
String leg2Arrival = "";
leg1ID = ticket.leg1bookingId.ToString();
leg2ID = ticket.leg2bookingId.ToString();
leg1departure = ticket.departureDate.ToString();
if (ticket.leg2bookingId == 0)
{
fullflight = ticket.originAbv + " ----> " + ticket.finaldestAbv;
leg1Arrival = ticket.arrivalDate.ToString();
leg1_flight = ticket.originAbv + " ----> " + ticket.finaldestAbv;
}
else
{
fullflight = ticket.originAbv + " ----> " + ticket.connectionAbv + " ---- >" + ticket.finaldestAbv;
leg1_flight = ticket.originAbv + " ----> " + ticket.connectionAbv;
leg1Arrival = ticket.leg1ArrivalDate.ToString();
leg2departure = ticket.leg2deptDate.ToString();
leg2Arrival = ticket.arrivalDate.ToString();
leg2_flight = ticket.connectionAbv + " ---- >" + ticket.finaldestAbv;
TimeSpan diff = ticket.leg2deptDate - ticket.leg1ArrivalDate;
layover = diff.Hours.ToString() + "Hrs " + diff.Minutes + " min " + "Layover ";
layover_label.Show();
leg2_groupbox.Show();
}
fullflight_value_label.Text = fullflight;
leg1_flightid_label.Text = leg1ID;
leg1_dept_value_label.Text = leg1departure;
leg1_arrival_value_label.Text = leg1Arrival;
leg1_flight_label.Text = leg1_flight;
layover_label.Text = layover;
leg2_flightid_label.Text = leg2ID;
leg2_dept_value_label.Text = leg2departure;
leg2_arrival_value_label.Text = leg2Arrival;
leg2_flight_label.Text = leg2_flight;
}
public Checkout(bool tripTypeisReturn, User user, UserFlightHistory fh1, UserFlightHistory fh2)
{
USER = user;
ticket1 = fh1;
ticket2 = fh2;
ROUNDTRIP = tripTypeisReturn;
InitializeComponent();
userid_label.Text = user.id.ToString();
userreward_balance_label.Text = user.rewardBalance.ToString();
double totalcost = fh1.paymentAmount;
String fh1_str = "";
fh1.userID = user.id;
if (fh1.leg2bookingId == 0)
{
fh1_str = fh1.originAbv + "--->" + fh1.finaldestAbv + " | " + fh1.departureDate.ToString() + " | " + fh1.arrivalDate.ToString();
}
else
{
fh1_str = fh1.originAbv + "-->" + fh1.connectionAbv + "-->" + fh1.finaldestAbv + " | " + fh1.departureDate.ToString() + " | " + fh1.arrivalDate.ToString();
}
flight1_value_label.Text = fh1_str;
if (tripTypeisReturn)
{
fh2.userID = user.id;
flight2_value_label.Show();
flight2_label.Show();
String fh2_str = "";
totalcost += fh2.paymentAmount;
if (fh2.leg2bookingId == 0)
{
fh2_str = fh2.originAbv + "--->" + fh2.finaldestAbv + " | " + fh2.departureDate.ToString() + " | " + fh2.arrivalDate.ToString();
}
else
{
fh2_str = fh2.originAbv + "-->" + fh2.connectionAbv + "-->" + fh2.finaldestAbv + " | " + fh2.departureDate.ToString() + " | " + fh2.arrivalDate.ToString();
}
flight2_value_label.Text = fh2_str;
}
else
{
flight2_value_label.Hide();
flight2_label.Hide();
}
int pointsReq = FormDatabaseHelper.getPointsNeededForCost(totalcost);
if (pointsReq > user.rewardBalance)
{
point_payment_rbtn.Hide();
notenoughpoints_label.Show();
}
else
{
point_payment_rbtn.Show();
notenoughpoints_label.Hide();
}
}
private void planesModels_comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
newCapacityValue_textBox.Text = FormDatabaseHelper.getPlaneCapacity(planesModels_comboBox.SelectedItem.ToString()).ToString();
//FormDatabaseHelper.updateCapacityBox(planesModels_comboBox.SelectedItem.ToString() , newCapacityValue_label);
}
private void return_datagridview_SelectionChanged(object sender, EventArgs e)
{
if (return_datagridview.SelectedRows.Count > 0)
{
DataGridViewRow currentRow = return_datagridview.SelectedRows[0];
if (currentRow != null)
{
String originAbv = currentRow.Cells["originAbv"].Value.ToString();
String leg1destAbv = currentRow.Cells["leg1dest"].Value.ToString();
String leg1deptTime = currentRow.Cells["leg1DeptTime"].Value.ToString();
String leg1ArrivalTime = currentRow.Cells["leg1ArrivalTime"].Value.ToString();
int leg1id = (int)currentRow.Cells["leg1id"].Value;
Console.WriteLine("-------------->" + leg1id);
return_leg1_selectedflight_label.Text = originAbv + "-->" + leg1destAbv;
return_leg1_departure_label.Text = "Departure: " + leg1deptTime;
return_leg1_arrival_label.Text = "Arrival: " + leg1ArrivalTime;
double cost_total_return = 0;
double cost_leg1 = FormDatabaseHelper.getCostFromBookingTable(Convert.ToInt32(leg1id));
cost_total_return += cost_leg1;
string cost_str_return = "Cost: " + cost_leg1.ToString();
String leg2origin = ""; //6
String leg2dest = ""; //7
String leg2deptTime = ""; //8
String leg2arrivalTime = ""; //9
double cost_leg2 = 0;
int leg2id = (int)currentRow.Cells["leg2id"].Value;
return_leg1 = 0;
return_leg2 = 0;
return_leg1 = leg1id;
return_leg2 = leg2id;
if (leg2id != 0)
{
leg2origin = currentRow.Cells["leg2origin"].Value.ToString();
leg2dest = currentRow.Cells["leg2Dest"].Value.ToString();
leg2deptTime = currentRow.Cells["leg2deptTime"].Value.ToString();
leg2arrivalTime = currentRow.Cells["leg2ArrivalTime"].Value.ToString();
return_leg2_groupbox.Show();
return_leg2_selectedflight_label.Text = leg2origin + "-->" + leg2dest;
return_leg2_departure_label.Text = "Departure: " + leg2deptTime;
return_leg2_arrival_label.Text = "Arrival: " + leg2arrivalTime;
cost_leg2 = FormDatabaseHelper.getCostFromBookingTable(Convert.ToInt32(leg2id));
cost_str_return = cost_str_return + " + " + cost_leg2.ToString() + " + 8 = ";
cost_total_return += (cost_leg2 + 8);
cost_str_return = cost_str_return + cost_total_return.ToString();
}
else
{
return_leg2_groupbox.Hide();
}
return_cost_label.Text = cost_str_return;
}
}
}
