public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
//Look for any products.
if (context.Products.Any())
{
return; // DB has been seeded
}
InMemoryProductData productData = new InMemoryProductData();
using (var trans = context.Database.BeginTransaction())
{
foreach (var section in productData.GetSections())
{
context.Sections.Add(section);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF");
trans.Commit();
}
using (var trans = context.Database.BeginTransaction())
{
foreach (var brand in productData.GetBrands())
{
context.Brands.Add(brand);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF");
trans.Commit();
}
using (var trans = context.Database.BeginTransaction())
{
foreach (var product in productData.GetProducts())
{
context.Products.Add(product);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF");
trans.Commit();
}
}
public IActionResult Shop(int?sectionId, int?brandId)
{
var products = new InMemoryProductData().GetProducts(new ProductFilter
{
BrandId = brandId,
SectionId =
sectionId
});
var model = new CatalogViewModel()
{
BrandId = brandId,
SectionId = sectionId,
Products = products.Select(p => new ProductViewModel()
{
Id = p.Id,
ImageUrl = p.ImageUrl,
Name = p.Name,
Order = p.Order,
Price = p.Price
}).OrderBy(p => p.Order).ToList()
};
return(View(model));
}