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