public static void SeedZones(FCTContext _context, ILogger <DictionarySeeder> logger)
{
logger.LogInformation("DB Seeder: Zones", DateTime.Now);
if (_context.Zone.Any())
{
return;
}
var zonesFilePath = Path.Combine(AppContext.BaseDirectory, "LoadData\\zone.csv");
var _createdCountries = _context.Country.ToList();
var zoneList = new List <Zone>();
using (var reader = new StreamReader(zonesFilePath))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
csv.Configuration.HasHeaderRecord = false;
var records = csv.GetRecords <ZoneModel>();
foreach (var record in records)
{
zoneList.Add(new Zone()
{
CountryCode = record.CountryCode,
ZoneName = record.ZoneName,
GenericZoneName = TZNames.GetNamesForTimeZone(record.ZoneName, "en-US").Generic,
Country = _createdCountries.Where(c => c.Alpha2Code == record.CountryCode).FirstOrDefault()
});
}
_context.AddRange(zoneList);
_context.SaveChanges();
}
}
private List <Flight> CreateFlights()
{
var flights = new List <Flight>()
{
new Flight()
{
FlightNumber = "P7 1754",
Aircraft = null,
Airline = GetAirline("LLC"),
DepartureAirport = GetAirport("WAW"),
DepartureDate = new DateTime(2015, 8, 29, 3, 0, 0),
ScheduleDepartureDate = new DateTime(2015, 8, 29, 3, 0, 0),
ArrivalAirport = GetAirport("KGS"),
ArrivialDate = new DateTime(2015, 8, 29, 6, 0, 0),
ScheduleArrivialDate = new DateTime(2015, 8, 29, 6, 0, 0),
Distance = 1775,
FlightTypeAssessment = Flight.FlightType.Charter,
FlightPurposeAssessment = Flight.FlightPurpose.Private,
UserFlights = new List <UserFlight>()
{
new UserFlight()
{
TUser = GetUser("Michal")
}
}
},
new Flight()
{
FlightNumber = "P7 1755",
Aircraft = null,
Airline = GetAirline("LLC"),
DepartureAirport = GetAirport("KGS"),
DepartureDate = new DateTime(2015, 9, 05, 10, 0, 0),
ScheduleDepartureDate = new DateTime(2015, 9, 05, 10, 0, 0),
ArrivalAirport = GetAirport("WAW"),
ArrivialDate = new DateTime(2015, 9, 05, 12, 0, 0),
ScheduleArrivialDate = new DateTime(2015, 9, 05, 12, 0, 0),
Distance = 1775,
FlightTypeAssessment = Flight.FlightType.Charter,
FlightPurposeAssessment = Flight.FlightPurpose.Private,
UserFlights = new List <UserFlight>()
{
new UserFlight()
{
TUser = GetUser("Michal")
}
}
},
new Flight()
{
FlightNumber = "W6 1441",
Aircraft = null,
Airline = GetAirline("WZZ"),
DepartureAirport = GetAirport("WAW"),
DepartureDate = new DateTime(2016, 9, 22, 12, 20, 0),
ScheduleDepartureDate = new DateTime(2016, 9, 22, 12, 20, 0),
ArrivalAirport = GetAirport("FCO"),
ArrivialDate = new DateTime(2016, 9, 22, 14, 45, 0),
ScheduleArrivialDate = new DateTime(2016, 9, 22, 14, 45, 0),
Distance = 1327,
FlightTypeAssessment = Flight.FlightType.Scheduled,
FlightPurposeAssessment = Flight.FlightPurpose.Private,
UserFlights = new List <UserFlight>()
{
new UserFlight()
{
TUser = GetUser("Michal")
}
}
}
};
_context.AddRange(flights);
_context.SaveChanges();
return(flights);
}
