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