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