//loads all the airlines
private void refreshAirline()
{
try
{
dgvAirline.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
Controller.Airline cPlace = new Controller.Airline();
DataTable dtPlace = cPlace.select();
dgvAirline.Rows.Clear();
foreach (DataRow row in dtPlace.Rows)
{
dgvAirline.Rows.Add(row["id"], row["id_from_country"], row["id_to_country"], row["duration"]);
}
}
catch
{
}
}
//Airport's actions
private void doAirlne()
{
Model.Airline mAirport = new Model.Airline();
Controller.Airline cAirport = new Controller.Airline();
if (cmbAirlineActions.SelectedIndex == 0)//nothing
{
MessageBox.Show("Please, choose an action!");
}
else if (cmbAirlineActions.SelectedIndex == 1)//select
{
refreshAirline();
}
else if (cmbAirlineActions.SelectedIndex == 2)//delete
{
cAirport = new Controller.Airline();
int select = dgvAirline.CurrentCell.RowIndex;
mAirport.id = Convert.ToInt32(dgvAirline.Rows[select].Cells["cAirlineId"].Value.ToString());
cAirport = new Controller.Airline(mAirport);
cAirport.delete();
}
else if (cmbAirlineActions.SelectedIndex == 3)//update
{
cAirport = new Controller.Airline();
int select = dgvVehicles.CurrentCell.RowIndex;
mAirport.id = Convert.ToInt32(dgvAirline.Rows[select].Cells["cAirlineId"].Value.ToString());
mAirport.idFromCountry = Convert.ToInt32(cmbFrom.SelectedValue);
mAirport.idToCountry = Convert.ToInt32(cmbTo.SelectedValue);
mAirport.duration = Convert.ToInt32(txtHoursAirline.Text.Trim());
cAirport = new Controller.Airline(mAirport);
cAirport.insert();
}
else if (cmbAirlineActions.SelectedIndex == 4)//insert
{
cAirport = new Controller.Airline();
mAirport.idFromCountry = Convert.ToInt32(cmbFrom.SelectedValue);
mAirport.idToCountry = Convert.ToInt32(cmbTo.SelectedValue);
mAirport.duration = Convert.ToInt32(txtHoursAirline.Text.Trim());
cAirport = new Controller.Airline(mAirport);
cAirport.insert();
}
}
