public static void Seed(this ModelBuilder modelBuilder)
{
var mall1 = new MallDbModel(Guid.NewGuid(), "Ocean Plaza", "10 Pandora Street");
var store1 = new StoreDbModel(Guid.NewGuid(), "Shields and Weapons", "10 Pandora Street", mall1.Id, 0);
var category1 = new CategoryDbModel(Guid.NewGuid(), "Laptop");
var category2 = new CategoryDbModel(Guid.NewGuid(), "Mouse");
var category3 = new CategoryDbModel(Guid.NewGuid(), "USB");
var storeCatRel1 = new StoreCategoryDbModel(store1.Id, category1.Id);
var storeCatRel2 = new StoreCategoryDbModel(store1.Id, category2.Id);
var product1 = new ProductDbModel(Guid.NewGuid(), "HP 450 G1", 20_000, ProductStatus.OnSale, category1.Id);
var product11 = new ProductDbModel(Guid.NewGuid(), "HP 450 G1", 20_000, ProductStatus.OnSale, category1.Id);
var product111 = new ProductDbModel(Guid.NewGuid(), "HP 450 G1", 20_000, ProductStatus.OnSale, category1.Id);
var product1111 = new ProductDbModel(Guid.NewGuid(), "HP 450 G1", 20_000, ProductStatus.OnSale, category1.Id);
var product11111 = new ProductDbModel(Guid.NewGuid(), "HP 450 G1", 20_000, ProductStatus.OnSale, category1.Id);
var product2 = new ProductDbModel(Guid.NewGuid(), "HP 450 G2", 30_000, ProductStatus.OnSale, category1.Id);
var product3 = new ProductDbModel(Guid.NewGuid(), "HP 450 G3", 40_000, ProductStatus.OnSale, category1.Id);
var product4 = new ProductDbModel(Guid.NewGuid(), "HP 450 G4", 50_000, ProductStatus.OnSale, category1.Id);
var product5 = new ProductDbModel(Guid.NewGuid(), "HP 850 G5", 60_000, ProductStatus.OnSale, category1.Id);
var product6 = new ProductDbModel(Guid.NewGuid(), "LogTech G12", 1000, ProductStatus.OnSale, category2.Id);
var product7 = new ProductDbModel(Guid.NewGuid(), "X7", 2000, ProductStatus.OnSale, category2.Id);
var stPrRel1 = new StoreProductDbModel(store1.Id, product1.Id);
var stPrRel11 = new StoreProductDbModel(store1.Id, product11.Id);
var stPrRel111 = new StoreProductDbModel(store1.Id, product111.Id);
var stPrRel1111 = new StoreProductDbModel(store1.Id, product1111.Id);
var stPrRel11111 = new StoreProductDbModel(store1.Id, product11111.Id);
var stPrRel2 = new StoreProductDbModel(store1.Id, product2.Id);
var stPrRel3 = new StoreProductDbModel(store1.Id, product3.Id);
var stPrRel4 = new StoreProductDbModel(store1.Id, product4.Id);
var stPrRel5 = new StoreProductDbModel(store1.Id, product5.Id);
var stPrRel6 = new StoreProductDbModel(store1.Id, product6.Id);
var stPrRel7 = new StoreProductDbModel(store1.Id, product7.Id);
modelBuilder.Entity <CategoryDbModel>().HasData(
category1, category2, category3
);
modelBuilder.Entity <ProductDbModel>().HasData(
product1, product2, product3, product4, product5, product6, product7, product11, product111, product1111,
product11111
);
modelBuilder.Entity <MallDbModel>().HasData(
mall1
);
modelBuilder.Entity <StoreDbModel>().HasData(
store1
);
modelBuilder.Entity <StoreCategoryDbModel>().HasData(
storeCatRel1, storeCatRel2
);
modelBuilder.Entity <StoreProductDbModel>().HasData(
stPrRel1, stPrRel11, stPrRel111, stPrRel1111, stPrRel11111, stPrRel2, stPrRel3, stPrRel4, stPrRel5,
stPrRel6, stPrRel7
);
}
public void AddCategoryToStore(Category category, Guid storeId)
{
CustomValidator.ValidateObject(category);
CustomValidator.ValidateId(storeId);
var storeCatRel = new StoreCategoryDbModel(storeId, category.Id);
if (!_context.StoreCategoryRelation
.Any(e => e.CategoryDbModelId.Equals(storeCatRel.CategoryDbModelId) &&
e.StoreDbModelId.Equals(storeCatRel.StoreDbModelId)))
{
_context.StoreCategoryRelation.Add(storeCatRel);
_context.SaveChanges();
}
}
public async Task AddCategoryToStore(Guid categoryId, Guid storeId)
{
CustomValidator.ValidateId(categoryId);
CustomValidator.ValidateId(storeId);
await using var context = new MyDbContext(_options);
var exists = await StoreCategoryRelationExists(storeId, categoryId);
if (!exists)
{
var storeCatRel = new StoreCategoryDbModel(storeId, categoryId);
var enState = await context.StoreCategoryRelation.AddAsync(storeCatRel);
enState.State = EntityState.Added;
await context.SaveChangesAsync();
}
}
