public List <AirportDTO> LoadDataAirport()
{
List <AirportDTO> list = new List <AirportDTO>();
using (var db = new TravelAirportContext())
{
var query = from b in db.Airports
orderby b.Name
select b;
foreach (var item in query)
{
AirportDTO p = new AirportDTO();
p.Name = item.Name;
p.GPS = item.GPS;
p.listAirplane = new List <AirplaneDTO>();
foreach (var airplaneitem in item.Airplanes)
{
AirplaneDTO airplane = new AirplaneDTO();
airplane.AirplaneId = airplaneitem.AirplaneId;
airplane.FuelConsumption = airplaneitem.FuelConsumption;
airplane.TakeoffEffort = airplaneitem.TakeoffEffort;
airplane.Title = airplaneitem.Title;
p.listAirplane.Add(airplane);
}
list.Add(p);
}
}
return(list);
}
public void SaveDataTraveltriprecord(TraveltriprecordDTO travel)
{
using (var db = new TravelAirportContext())
{
var traveltriprecord = new Traveltriprecord {
TraveltriprecordId = 5, CustomerName = travel.CustomerName, ArrivalAirportId = travel.ArrivalAirportId, DepartureAirportId = travel.DepartureAirportId, Distance = travel.Distance, FlightTime = travel.FlightTime
};
db.SaveChanges();
}
}
public GeoCoordinate getGPS(int airport)
{
GeoCoordinate gpscoord = new GeoCoordinate();
using (var db = new TravelAirportContext())
{
var query = from b in db.Airports
where b.AirportId == airport
select b.GPS;
gpscoord = query.First();
}
return(gpscoord);
}
public float[] getFuelAndEffort(int airplaine)
{
float[] flightTime = new float[2];
using (var db = new TravelAirportContext())
{
var fuel = from b in db.Airplanes
where b.AirplaneId == airplaine
select b.FuelConsumption;
var effort = from b in db.Airplanes
where b.AirplaneId == airplaine
select b.TakeoffEffort;
flightTime[0] = effort.First();
flightTime[1] = fuel.First();
}
return(flightTime);
}
public List <AirplaneDTO> LoadDataAirplane()
{
List <AirplaneDTO> list = new List <AirplaneDTO>();
using (var db = new TravelAirportContext())
{
var query = from b in db.Airplanes
orderby b.Title
select b;
foreach (var item in query)
{
AirplaneDTO p = new AirplaneDTO();
p.Title = item.Title;
p.TakeoffEffort = item.TakeoffEffort;
p.FuelConsumption = item.FuelConsumption;
list.Add(p);
}
}
return(list);
}
public List <TraveltriprecordDTO> LoadDataTraveltriprecord()
{
List <TraveltriprecordDTO> list = new List <TraveltriprecordDTO>();
using (var db = new TravelAirportContext())
{
var query = from b in db.Traveltriprecords
orderby b.CustomerName
select b;
foreach (var item in query)
{
TraveltriprecordDTO p = new TraveltriprecordDTO();
p.CustomerName = item.CustomerName;
p.DepartureAirportId = item.DepartureAirportId;
p.Distance = item.Distance;
p.ArrivalAirportId = item.ArrivalAirportId;
p.FlightTime = item.FlightTime;
list.Add(p);
}
}
return(list);
}
static void Main(string[] args)
{
using (var db = new TravelAirportContext())
{
// Create and save a new Airport
Console.Write("Enter a name for a new Airport: ");
var name = Console.ReadLine();
Console.Write("Enter a latitude for a new Airport: ");
var latitude = Console.ReadLine();
Console.Write("Enter a longitude for a new Airport: ");
var longitude = Console.ReadLine();
Console.Write("Enter a id for a new Airport: ");
var idap = Console.ReadLine();
var airport = new Airport {
AirportId = int.Parse(idap), Name = name, GPS = new GeoCoordinate {
Latitude = byte.Parse(latitude), Longitude = byte.Parse(longitude)
}
};
db.Airports.Add(airport);
db.SaveChanges();
// Display all Airports from the database
var query = from b in db.Airports
orderby b.Name
select b;
Console.WriteLine("All airports in the database:");
foreach (var item in query)
{
Console.WriteLine(item.Name);
}
// Create and save a new Airplane
Console.Write("Enter a name for a new Airplane: ");
var title = Console.ReadLine();
Console.Write("Enter a latitude for a new Airplane: ");
var takeoffEffort = Console.ReadLine();
Console.Write("Enter a longitude for a new Airplane: ");
var fuelConsumption = Console.ReadLine();
Console.Write("Enter an id for a new Airplane: ");
var idpl = Console.ReadLine();
var airplane = new Airplane {
AirplaneId = int.Parse(idpl), Title = title, TakeoffEffort = float.Parse(takeoffEffort), FuelConsumption = float.Parse(fuelConsumption)
};
db.Airplanes.Add(airplane);
db.SaveChanges();
// Display all Airports from the database
var query2 = from b in db.Airplanes
orderby b.Title
select b;
Console.WriteLine("All airplanes in the database:");
foreach (var item in query2)
{
Console.WriteLine(item.Title);
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
