public void ShouldSaveTheDeskBooking() { // Arrange var options = new DbContextOptionsBuilder <DeskBookerContext>() .UseInMemoryDatabase(databaseName: "ShouldSaveTheDeskBooking") .Options; var deskBooking = new DeskBooking { FirstName = "Thomas", LastName = "Huber", Date = new DateTime(2020, 1, 25), Email = "*****@*****.**", DeskId = 1 }; // Act using (var context = new DeskBookerContext(options)) { var repository = new DeskBookingRepository(context); repository.Save(deskBooking); } // Assert using (var context = new DeskBookerContext(options)) { var bookings = context.DeskBooking.ToList(); Assert.AreEqual(1, bookings.Count); var storedDeskBooking = bookings.Single(); Assert.AreEqual(deskBooking.FirstName, storedDeskBooking.FirstName); Assert.AreEqual(deskBooking.LastName, storedDeskBooking.LastName); Assert.AreEqual(deskBooking.Email, storedDeskBooking.Email); Assert.AreEqual(deskBooking.DeskId, storedDeskBooking.DeskId); Assert.AreEqual(deskBooking.Date, storedDeskBooking.Date); } }
public void ShouldGetAllOrderedByDate() { // Arrange var options = new DbContextOptionsBuilder <DeskBookerContext>() .UseInMemoryDatabase(databaseName: "ShouldGetAllOrderedByDate") .Options; var storedList = new List <DeskBooking> { CreateDeskBooking(1, new DateTime(2020, 1, 27)), CreateDeskBooking(2, new DateTime(2020, 1, 25)), CreateDeskBooking(3, new DateTime(2020, 1, 29)) }; var expectedList = storedList.OrderBy(x => x.Date).ToList(); using (var context = new DeskBookerContext(options)) { foreach (var deskBooking in storedList) { context.Add(deskBooking); context.SaveChanges(); } } // Act List <DeskBooking> actualList; using (var context = new DeskBookerContext(options)) { var repository = new DeskBookingRepository(context); actualList = repository.GetAll().ToList(); } // Assert CollectionAssert.AreEqual(expectedList, actualList, new DeskBookingEqualityComparer()); }
public void ShouldSaveTheDeskBooking() { // Arrange var options = new DbContextOptionsBuilder <DeskBookerContext>() .UseInMemoryDatabase(databaseName: "ShouldSaveTheDeskBooking") .Options; var deskBooking = new DeskBooking { FirstName = "Fabio", LastName = "Oquendo", Date = new DateTime(2021, 4, 10), Email = "*****@*****.**", DeskId = 1 }; // Act using (var context = new DeskBookerContext(options)) { var repository = new DeskBookingRepository(context); repository.Save(deskBooking); } // Assert using (var context = new DeskBookerContext(options)) { var bookings = context.DeskBooking.ToList(); var storedDeskBooking = Assert.Single(bookings); Assert.Equal(deskBooking.FirstName, storedDeskBooking.FirstName); Assert.Equal(deskBooking.LastName, storedDeskBooking.LastName); Assert.Equal(deskBooking.Email, storedDeskBooking.Email); Assert.Equal(deskBooking.DeskId, storedDeskBooking.DeskId); Assert.Equal(deskBooking.Date, storedDeskBooking.Date); } }