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