Ejemplo n.º 1
0
    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
            );
    }
Ejemplo n.º 2
0
    public void AddProductToStore(Product product, Guid storeId)
    {
        CustomValidator.ValidateObject(product);
        CustomValidator.ValidateId(storeId);
        var storeProdRel = new StoreProductDbModel(storeId, product.Id);

        if (!Exists(product.Id))
        {
            AddOne(product);
        }
        if (!_context.StoreProductRelation
            .Any(e => e.ProductDbModelId.Equals(storeProdRel.ProductDbModelId) &&
                 e.StoreDbModelId.Equals(storeProdRel.StoreDbModelId)))
        {
            _context.StoreProductRelation.Add(storeProdRel);
            _context.SaveChanges();
        }
    }
        public async Task AddProductToStore(Product product, Guid storeId)
        {
            CustomValidator.ValidateObject(product);
            CustomValidator.ValidateId(storeId);
            await using var context = new MyDbContext(_options);
            if (!Exists(product.Id))
            {
                await AddOne(product);
            }

            var storeProdRelExists = await StoreProductRelationExists(storeId, product.Id);

            if (!storeProdRelExists)
            {
                var storeProdRel = new StoreProductDbModel(storeId, product.Id);
                await context.StoreProductRelation.AddAsync(storeProdRel);
            }

            await context.SaveChangesAsync();
        }