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