public void SeedRideshares(CarpoolDbContext context) { var rideshares = new[] { new Rideshare { Id = 1, Car = Cars[1], StartLocation = "Zagreb", EndLocation = "Rijeka", StartDate = new DateTime(2020, 1, 4, 8, 0, 0), EndDate = new DateTime(2020, 1, 4, 18, 30, 0), EmployeeRideshares = new[] { new EmployeeRideshare { EmployeeId = 4 }, new EmployeeRideshare { EmployeeId = 10 }, new EmployeeRideshare { EmployeeId = 19 }, new EmployeeRideshare { EmployeeId = 6 } } }, new Rideshare { Id = 2, Car = Cars[4], StartLocation = "Zagreb", EndLocation = "Split", StartDate = new DateTime(2020, 1, 7, 8, 0, 0), EndDate = new DateTime(2020, 1, 7, 17, 0, 0), EmployeeRideshares = new[] { new EmployeeRideshare { EmployeeId = 5 }, new EmployeeRideshare { EmployeeId = 12 }, new EmployeeRideshare { EmployeeId = 20 } } } }; context.Rideshares.AddRange(rideshares.ToList()); context.SaveChanges(); }
public void SeedData(CarpoolDbContext context) { context.Database.EnsureCreated(); if (context.Cars.Any()) { return; } SeedCars(context); SeedEmployees(context); SeedRideshares(context); }
public void SeedCars(CarpoolDbContext context) { Cars.Add(1, new Car { Id = 1, Name = "Mercedes GLA Intermediate for longer rides", Type = "Mercedes GLA", Color = "Cosmos Black Metallic", LicensePlate = "ZG-334-CD", NumberOfSeats = 5 }); Cars.Add(2, new Car { Id = 2, Name = "BMW X2 Premium", Type = "BMW X2", Color = "Mineral Grey Metallic", LicensePlate = "ZG-5564-AA", NumberOfSeats = 5 }); Cars.Add(3, new Car { Id = 3, Name = "Mercedes CLA Premium", Type = "Mercedes CLA", Color = "Lunar Blue Metallic", LicensePlate = "ZG-652-FD", NumberOfSeats = 5 }); Cars.Add(4, new Car { Id = 4, Name = "Jaguar XE Executive", Type = "Jaguar XE", Color = "Firenze Red", LicensePlate = "ZG-299-DA", NumberOfSeats = 5 }); Cars.Add(5, new Car { Id = 5, Name = "Audi A4 Luxury", Type = "Audi A4", Color = "Myth Black Metallic", LicensePlate = "ZG-4456-CC", NumberOfSeats = 5 }); Cars.Add(6, new Car { Id = 6, Name = "Ford Transit Standard", Type = "Ford Transit", Color = "Oxford White", LicensePlate = "ZG-941-AD", NumberOfSeats = 10 }); Cars.Add(7, new Car { Id = 7, Name = "Renault Zoe Electric", Type = "Renault Zoe", Color = "Glacier White", LicensePlate = "ZG-1143-BA", NumberOfSeats = 4 }); Cars.Add(8, new Car { Id = 8, Name = "BMW 3 Series Premium", Type = "BMW 320d SE", Color = "Mineral Grey", LicensePlate = "ZG-555-BB", NumberOfSeats = 5 }); Cars.Add(9, new Car { Id = 9, Name = "Citroen C3", Type = "Citroen C3 Aircross", Color = "Cobalt Blue", LicensePlate = "ZG-5663-AA", NumberOfSeats = 5 }); Cars.Add(10, new Car { Id = 10, Name = "Skoda Fabia Urban", Type = "Skoda Fabia Hatch", Color = "Briliant Silver", LicensePlate = "ZG-778-DC", NumberOfSeats = 5 }); context.Cars.AddRange(Cars.Values.ToList()); context.SaveChanges(); }
public void SeedEmployees(CarpoolDbContext context) { Employees.Add(1, new Employee { Id = 1, FirstName = "Marko", LastName = "Kranjcec", IsDriver = true }); Employees.Add(2, new Employee { Id = 2, FirstName = "Karlo", LastName = "Maletic", IsDriver = false }); Employees.Add(3, new Employee { Id = 3, FirstName = "Matija", LastName = "Cesar", IsDriver = true }); Employees.Add(4, new Employee { Id = 4, FirstName = "Luka", LastName = "Blazic", IsDriver = false }); Employees.Add(5, new Employee { Id = 5, FirstName = "Katarina", LastName = "Lipovac", IsDriver = true }); Employees.Add(6, new Employee { Id = 6, FirstName = "Anita", LastName = "Jandras", IsDriver = true }); Employees.Add(7, new Employee { Id = 7, FirstName = "Borna", LastName = "Horvat", IsDriver = false }); Employees.Add(8, new Employee { Id = 8, FirstName = "Martina", LastName = "Peic", IsDriver = false }); Employees.Add(9, new Employee { Id = 9, FirstName = "Laura", LastName = "Horvat", IsDriver = false }); Employees.Add(10, new Employee { Id = 10, FirstName = "Bozidar", LastName = "Gaspar", IsDriver = true }); Employees.Add(11, new Employee { Id = 11, FirstName = "Andrija", LastName = "Dominikovic", IsDriver = true }); Employees.Add(12, new Employee { Id = 12, FirstName = "Bruno", LastName = "Kovac", IsDriver = false }); Employees.Add(13, new Employee { Id = 13, FirstName = "Vesna", LastName = "Dudas", IsDriver = true }); Employees.Add(14, new Employee { Id = 14, FirstName = "Marina", LastName = "Poljak", IsDriver = false }); Employees.Add(15, new Employee { Id = 15, FirstName = "Nada", LastName = "Medved", IsDriver = true }); Employees.Add(16, new Employee { Id = 16, FirstName = "Kristina", LastName = "Madunic", IsDriver = true }); Employees.Add(17, new Employee { Id = 17, FirstName = "Mirko", LastName = "Nemet", IsDriver = false }); Employees.Add(18, new Employee { Id = 18, FirstName = "Vedran", LastName = "Zubak", IsDriver = false }); Employees.Add(19, new Employee { Id = 19, FirstName = "Patrik", LastName = "Colic", IsDriver = false }); Employees.Add(20, new Employee { Id = 20, FirstName = "Budimir", LastName = "Belic", IsDriver = false }); Employees.Add(21, new Employee { Id = 21, FirstName = "Tamara", LastName = "Cigir", IsDriver = false }); Employees.Add(22, new Employee { Id = 22, FirstName = "Ljiljana", LastName = "Vidovic", IsDriver = true }); Employees.Add(23, new Employee { Id = 23, FirstName = "Mia", LastName = "Srsen", IsDriver = true }); Employees.Add(24, new Employee { Id = 24, FirstName = "Frodo", LastName = "Baggins", IsDriver = false }); Employees.Add(25, new Employee { Id = 25, FirstName = "Samwise", LastName = "Gamgee", IsDriver = true }); context.Employees.AddRange(Employees.Values.ToList()); context.SaveChanges(); }
public static void InitializeDatabase(CarpoolDbContext context) { var generator = new CarpoolDataGenerator(); generator.SeedData(context); }