private static bool SeedRoutes(MetroDBContext context) { int i = 0; try { foreach (RouteDescription route in _parser.Routes.Values) { Console.WriteLine("Seeding routes: " + i + "/" + _parser.Routes.Count); context.Routes.Add(new Route { RouteNumber = route.Route, Description = route.Description, Direction = route.Direction.ToString("G") });; i++; } context.SaveChanges(); } catch (Exception e) { Console.WriteLine("Routes seeding failed: \n" + e.InnerException.Message); return(false); } Console.WriteLine("Routes successfully seeded"); return(true); }
private static bool SeedLocations(MetroDBContext context) { int i = 0; try { foreach (LocationRecord location in _parser.Locations.Values) { Console.WriteLine("Seeding locations: " + i + "/" + _parser.Locations.Count); context.Locations.Add(new Location { ShortForm = location.Location, FullForm = location.FullLocation, GridEasting = location.GridEasting, GridNorthing = location.GridNorthing }); i++; } context.SaveChanges(); } catch (Exception e) { Console.WriteLine("Locations seeding failed: \n" + e.InnerException.Message); return(false); } Console.WriteLine("Locations successfully seeded"); return(true); }
private static bool SeedJourneys(MetroDBContext context) { int i = 0; try { foreach (JourneyRecord journey in _parser.Journeys) { Console.WriteLine("Seeding journeys: " + i + "/" + _parser.Journeys.Count); Route journeyRoute = context.Routes .Where(r => r.RouteNumber == journey.Header.Route && r.Direction == (journey.Header.Direction.ToString("G"))) .FirstOrDefault(); context.Journeys.Add(new Journey { Route = journeyRoute, Monday = journey.Header.OperationDays[0], Tuesday = journey.Header.OperationDays[1], Wednesday = journey.Header.OperationDays[2], Thursday = journey.Header.OperationDays[3], Friday = journey.Header.OperationDays[4], Saturday = journey.Header.OperationDays[5], Sunday = journey.Header.OperationDays[6], BankHolidays = journey.Header.BankHolidays, Stops = StopsFromJourney(journey, context) }); i++; } context.SaveChanges(); } catch (Exception e) { Console.WriteLine("Journey seeding failed: \n" + e.InnerException.Message); return(false); } Console.WriteLine("Journey successfully seeded"); return(true); }