public async Task seedDatabase() { _dbContext.Database.EnsureDeleted(); if (_dbContext.Database.EnsureCreated()) { #region Flight Flight flight1 = new Flight("BRUSJO-871X", "Boeing 737", DateTime.Now, DateTime.Now.AddHours(8), "BRU", "SJO"); _dbContext.Flights.Add(flight1); #endregion #region Product Product product1 = new Product("Diet Coke", "Coca-cola formula with zero sugar!", 3.00M, ProductType.BEVERAGE); Product product2 = new Product("Fries with steak", "Fresh French fries with great steak!", 25.50M, ProductType.FOOD); Product product3 = new Product("Marbloro Red 20", "20-pack of Marbloro Red", 7M, ProductType.CIGARETTES); Product product4 = new Product("Jack Daniels 70cl", "70cl's of pure finesse Whisky!", 29.99M, ProductType.LIQUOR); Product product5 = new Product("Swatch watch", "The newest Swiss watch on the market!", 149.99M, ProductType.OTHER); _dbContext.Products.Add(product1); _dbContext.Products.Add(product2); _dbContext.Products.Add(product3); _dbContext.Products.Add(product4); _dbContext.Products.Add(product5); #endregion #region CrewMember CrewMember crewMember1 = new CrewMember("Bram", "De Bleecker"); CrewMember crewMember2 = new CrewMember("Johanna", "De Bruycker"); _dbContext.CrewMembers.Add(crewMember1); _dbContext.CrewMembers.Add(crewMember2); #endregion #region Passenger Passenger passenger1 = new Passenger("Tybo", "Vanderstraeten"); Passenger passenger2 = new Passenger("Rob", "De Putter"); Passenger passenger3 = new Passenger("Tim", "Geldof"); Passenger passenger4 = new Passenger("Michiel", "Schoofs"); Passenger passenger5 = new Passenger("Lars", "Vandenberghe"); _dbContext.Passengers.Add(passenger1); _dbContext.Passengers.Add(passenger2); _dbContext.Passengers.Add(passenger3); _dbContext.Passengers.Add(passenger4); _dbContext.Passengers.Add(passenger5); #endregion #region Seat Seat seat1 = new Seat(SeatType.BUSINESS, passenger1); Seat seat2 = new Seat(SeatType.ECONOMY, passenger2); Seat seat3 = new Seat(SeatType.FIRST_CLASS, passenger3); Seat seat4 = new Seat(SeatType.BUSINESS, passenger4); Seat seat5 = new Seat(SeatType.BUSINESS, passenger5); Seat seat6 = new Seat(SeatType.BUSINESS, null); Seat seat7 = new Seat(SeatType.BUSINESS, null); Seat seat8 = new Seat(SeatType.BUSINESS, null); Seat seat9 = new Seat(SeatType.BUSINESS, null); Seat seat10 = new Seat(SeatType.BUSINESS, null); flight1.AddSeat(seat1); flight1.AddSeat(seat2); flight1.AddSeat(seat3); flight1.AddSeat(seat4); flight1.AddSeat(seat5); flight1.AddSeat(seat6); flight1.AddSeat(seat7); flight1.AddSeat(seat8); flight1.AddSeat(seat9); flight1.AddSeat(seat10); #endregion #region Travelgroup TravelGroup travelGroup1 = new TravelGroup(new List <Passenger> { passenger1, passenger2, passenger3 }); _dbContext.TravelGroups.Add(travelGroup1); #endregion #region Order Order order1 = new Order(passenger1.UserId); order1.AddOrderLine(product1, 2); order1.AddOrderLine(product2, 1); _dbContext.Orders.Add(order1); #endregion #region Message passenger1.sendMessage("Hey!"); passenger2.sendMessage("Hey Tybo :)"); passenger3.sendMessage("Lekker geslapen, Tybo?"); passenger1.sendMessage("Ja hoor!"); #endregion _dbContext.SaveChanges(); } }