public async System.Threading.Tasks.Task GetActiveAndNonDeletedProducts_ReturnRecordWhenDeleteDateHasNotPast() { // Arrange var options = new DbContextOptionsBuilder <ProductContext>() .UseInMemoryDatabase(databaseName: "Products Test 3") .Options; using (var context = new ProductContext(options)) { context.Products.Add(new Product { ProductId = 1, DeleteDate = new DateTime(2022, 11, 1) }); context.SaveChanges(); } using (var context = new ProductContext(options)) { // Act _productsController = new ProductsController(context); var response = await _productsController.GetActiveAndNonDeletedProducts(); // Assert Assert.NotNull(response.Value); Assert.Single(response.Value); } }
public async System.Threading.Tasks.Task GetActiveAndNonDeletedProducts_ReturnMultipleRecordsInDescendingOrderOfCreateDate() { // Arrange var options = new DbContextOptionsBuilder <ProductContext>() .UseInMemoryDatabase(databaseName: "Products Test 11") .Options; using (var context = new ProductContext(options)) { context.Products.Add(new Product { ProductId = 10, CreateDate = new DateTime(2011, 11, 1) }); context.Products.Add(new Product { ProductId = 11, CreateDate = new DateTime(2012, 11, 1) }); context.SaveChanges(); } using (var context = new ProductContext(options)) { // Act _productsController = new ProductsController(context); var response = await _productsController.GetActiveAndNonDeletedProducts(); // Assert Assert.NotNull(response.Value); Assert.Equal(2, response.Value.Count); Assert.Equal(new DateTime(2012, 11, 1), response.Value[0].CreateDate); Assert.Equal(new DateTime(2011, 11, 1), response.Value[1].CreateDate); } }