//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
{
}
}
public List <Model.Airport> GetAllUSAirports()
{
List <Model.Airport> airports = new List <Model.Airport>();
var lines = System.IO.File.ReadAllLines("test.txt").Select(a => a.Split(','));
foreach (var row in lines)
{
var airport = new Model.Airport()
{
Code = row[3], Country = row[2]
};
if (airport.Country.ToLower() == "united states")
{
airports.Add(airport);
}
}
return(airports);
}
public Airport(Model.Airport airports)
{
this.Airports = airports;
}
public Airport()
{
this.Airports = new Model.Airport();
}
