//Airport's actions
private void doAirport()
{
Model.Airport mAirport = new Model.Airport();
Controller.Airport cAirport = new Controller.Airport();
if (cmbAirportsAction.SelectedIndex == 0)//insert
{
MessageBox.Show("Please, choose an action!");
}
else if (cmbAirportsAction.SelectedIndex == 1)//insert
{
saveAirports();
}
else if (cmbAirportsAction.SelectedIndex == 2)//delete
{
int select = dgvAirport.CurrentCell.RowIndex;
mAirport.id = Convert.ToInt32(dgvAirport.Rows[select].Cells["cAirportId"].Value.ToString());
cAirport = new Controller.Airport(mAirport);
cAirport.delete();
refreshAirports();
}
else if (cmbAirportsAction.SelectedIndex == 3)//update
{
dgvAirport.Enabled = true;
saveAirports();
}
else if (cmbAirportsAction.SelectedIndex == 4)//refresh
{
refreshAirports();
}
}
//saves an airport
private void saveAirports()
{
try
{
if (!cmbAirportsByPlace.Enabled)
{
Model.Airport mAirport = new Model.Airport();
int select = dgvAirport.CurrentCell.RowIndex;
mAirport.name = dgvAirport.Rows[select].Cells["cAirportName"].Value.ToString();
mAirport.iata = dgvAirport.Rows[select].Cells["cIata"].Value.ToString();
mAirport.id = Convert.ToInt32(dgvAirport.Rows[select].Cells["cAirportId"].Value.ToString());
mAirport.idPlace = Convert.ToInt32(dgvAirport.Rows[select].Cells["cAirportLocation"].Value.ToString());
Controller.Airport cAirport = new Controller.Airport(mAirport);
cAirport.insert();
refreshAirports();
return;
}
else
{
Model.Airport mAirport = new Model.Airport();
mAirport.name = dgvAirport.Rows[dgvAirport.Rows.Count - 1].Cells["cAirportName"].Value.ToString();
mAirport.iata = dgvAirport.Rows[dgvAirport.Rows.Count - 1].Cells["cIata"].Value.ToString();
mAirport.id = Convert.ToInt32(dgvAirport.Rows[dgvAirport.Rows.Count - 1].Cells["cAirportId"].Value.ToString());
mAirport.idPlace = Convert.ToInt32(cmbAirportsByPlace.SelectedValue);;
Controller.Airport cAirport = new Controller.Airport(mAirport);
cAirport.insert();
}
refreshAirports();
}
catch
{
}
}
//loads all the airports
private void refreshAirports()
{
try
{
dgvAirport.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
Controller.Airport cPlace = new Controller.Airport();
DataTable dtAirport = cPlace.select();
dgvAirport.Rows.Clear();
foreach (DataRow row in dtAirport.Rows)
{
dgvAirport.Rows.Add(row["id"], row["name"], row["id_place"], row["iata"]);
}
cmbPlace.DisplayMember = "Name";
cmbPlace.ValueMember = "id";
cmbPlace.DataSource = dtAirport;
}
catch
{
}
}
