public static void Initialise(IServiceProvider serviceProvider) { using (var context = new RoomBookingsContext(serviceProvider.GetRequiredService <DbContextOptions <RoomBookingsContext> >())) { if (context.RoomTimes.Any()) { return; } context.RoomTimes.AddRange( new RoomTime { Id = 1, RoomId = 1, StartTime = new TimeSpan(8), EndTime = new TimeSpan(18) }, new RoomTime { Id = 1, RoomId = 2, StartTime = new TimeSpan(0, 0, 7, 5), EndTime = new TimeSpan(18) }, new RoomTime { Id = 1, RoomId = 3, StartTime = new TimeSpan(8), EndTime = new TimeSpan(16) }, new RoomTime { Id = 1, RoomId = 4, StartTime = new TimeSpan(8), EndTime = new TimeSpan(18) } ); context.SaveChanges(); } }
public static void Initialise(IServiceProvider serviceProvider) { using (var context = new RoomBookingsContext(serviceProvider.GetRequiredService <DbContextOptions <RoomBookingsContext> >())) { if (context.People.Any()) { return; } context.People.AddRange( new Person { Id = 1, Name = "John Smith", DateOfBirth = new DateTime(2000, 12, 1, 12, 0, 0) }, new Person { Id = 2, Name = "Jane Doe", DateOfBirth = new DateTime(1965, 12, 1, 12, 0, 0) }, new Person { Id = 3, Name = "Jack Jones", DateOfBirth = new DateTime(1972, 12, 1, 12, 0, 0) }, new Person { Id = 4, Name = "Mary Murphy", DateOfBirth = new DateTime(2001, 12, 1, 12, 0, 0) }, new Person { Id = 5, Name = "Bob Trent", DateOfBirth = new DateTime(1983, 12, 1, 12, 0, 0) }, new Person { Id = 6, Name = "John Smith", DateOfBirth = new DateTime(1999, 12, 1, 12, 0, 0) } ); context.SaveChanges(); } }
public static void Initialise(IServiceProvider serviceProvider) { using (var context = new RoomBookingsContext(serviceProvider.GetRequiredService <DbContextOptions <RoomBookingsContext> >())) { if (context.Rooms.Any()) { return; } context.Rooms.AddRange( new Room { Id = 1, Name = "Room One" }, new Room { Id = 2, Name = "Room Three" }, new Room { Id = 3, Name = "Room Two" }, new Room { Id = 4, Name = "Room Four" } ); context.SaveChanges(); var roomTwo = context.Rooms.FirstOrDefault(f => f.Id == 2); var roomThree = context.Rooms.FirstOrDefault(f => f.Id == 3); context.RoomBookings.AddRange( new RoomBooking { Id = 1, PersonId = 6, Room = roomTwo, StartTime = new DateTime(2021, 05, 20, 9, 45, 0), EndTime = new DateTime(2021, 05, 20, 10, 00, 0) }, new RoomBooking { Id = 2, PersonId = 4, Room = roomThree, StartTime = new DateTime(2021, 05, 20, 10, 15, 0), EndTime = new DateTime(2021, 05, 20, 11, 15, 0) }, new RoomBooking { Id = 3, PersonId = 1, Room = roomThree, StartTime = new DateTime(2021, 05, 20, 9, 00, 0), EndTime = new DateTime(2021, 05, 20, 10, 00, 0) } ); context.SaveChanges(); } }