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);
}
}
