public static void Initialize(SmartAppartmentDbContext context)
{
var initializer = new SmartAppartmentDbInitializer();
initializer.SeedCustomers(context);
initializer.SeedProducts(context);
initializer.SeedOrders(context);
initializer.SeedOrderDetails(context);
}
private void SeedOrders(SmartAppartmentDbContext context)
{
context.Orders.AddRange(new Order[]
{
new Order {
OrderId = 1, CustomerId = 1, OrderDate = new DateTime(2019, 01, 01), ShippedDate = null
},
new Order {
OrderId = 2, CustomerId = 2, OrderDate = new DateTime(2019, 02, 02), ShippedDate = new DateTime(2019, 04, 04)
},
new Order {
OrderId = 3, CustomerId = 3, OrderDate = new DateTime(2019, 03, 03), ShippedDate = null
},
});
context.SaveChanges();
}
private void SeedProducts(SmartAppartmentDbContext context)
{
context.Products.AddRange(new Product[]
{
new Product {
ProductId = 1, ProductName = "Product 1", UnitPrice = 11
},
new Product {
ProductId = 2, ProductName = "Product 2", UnitPrice = 22
},
new Product {
ProductId = 3, ProductName = "Product 2", UnitPrice = 33
},
});
context.SaveChanges();
}
private void SeedCustomers(SmartAppartmentDbContext context)
{
context.Customers.AddRange(new Customer[]
{
new Customer {
CustomerId = 1, CompanyName = "Company 1", Address = "Street 1"
},
new Customer {
CustomerId = 2, CompanyName = "Company 2", Address = "Street 2"
},
new Customer {
CustomerId = 3, CompanyName = "Company 3", Address = "Street 3"
},
});
context.SaveChanges();
}
public async void ShoudThrowException()
{
var options = CreateContextOptions();
using (var context = new SmartAppartmentDbContext(options))
{
Persistence.InMemory.SmartAppartmentDbInitializer.Initialize(context);
}
using (var context = new SmartAppartmentDbContext(options))
{
var service = new ProductService(context, _logger);
Func <Task> act = async() => await service.GetAsync(4, CancellationToken.None);
await act.Should()
.ThrowAsync <NotFoundException>()
.WithMessage("Entity \"Product\" (4) was not found.");
}
}
private void SeedOrderDetails(SmartAppartmentDbContext context)
{
context.OrderDetails.AddRange(new OrderDetail[]
{
new OrderDetail {
OrderDetailId = 11, OrderId = 1, ProductId = 1, Quantity = 100, UnitPrice = 11
},
new OrderDetail {
OrderDetailId = 12, OrderId = 1, ProductId = 2, Quantity = 200, UnitPrice = 22
},
new OrderDetail {
OrderDetailId = 21, OrderId = 2, ProductId = 2, Quantity = 1, UnitPrice = 1000
},
new OrderDetail {
OrderDetailId = 31, OrderId = 3, ProductId = 2, Quantity = 1, UnitPrice = 1000
},
});
context.SaveChanges();
}
public async void ShoudReturnOneDto()
{
var options = CreateContextOptions();
using (var context = new SmartAppartmentDbContext(options))
{
Persistence.InMemory.SmartAppartmentDbInitializer.Initialize(context);
}
var expected = new ProductDto {
ProductId = 1, ProductName = "Product 1", UnitPrice = 11
};
using (var context = new SmartAppartmentDbContext(options))
{
var service = new ProductService(context, _logger);
var actual = await service.GetAsync(1, CancellationToken.None);
actual.Should().BeEquivalentTo(expected);
}
}
