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