public bool UpdateProductCountInCategories(List <int> CateLV1, List <int> CateLV2, List <int> CateLV3) { var svCategory = new Category.CategoryService(); var lstCateLV1 = CateLV1.Distinct(); var lstCateLV2 = CateLV2.Distinct(); var lstCateLV3 = CateLV3.Distinct(); foreach (var it in lstCateLV3) { IsResult = svCategory.UpdateProductCount(3, it); } foreach (var it in lstCateLV2) { IsResult = svCategory.UpdateProductCount(2, it); } foreach (var it in lstCateLV1) { IsResult = svCategory.UpdateProductCount(1, it); } return(IsResult); }
public bool MoveProductInCateLV(int oldcatelv1, int oldcatelv2, int oldcatelv3, int newcatelv1, int newcatelv2, int newcatelv3) { var svCategory = new Category.CategoryService(); using (var trans = new TransactionScope()) { MoveProductInCate(3, oldcatelv3, newcatelv3, oldcatelv3); MoveProductInCate(2, oldcatelv2, newcatelv2, newcatelv3); MoveProductInCate(1, oldcatelv1, newcatelv1, newcatelv3); trans.Complete(); IsResult = true; } using (var trans = new TransactionScope()) { #region Update Product Count svCategory.UpdateProductCount(3, oldcatelv3); svCategory.UpdateProductCount(2, oldcatelv2); svCategory.UpdateProductCount(1, oldcatelv1); svCategory.UpdateProductCount(3, newcatelv3); svCategory.UpdateProductCount(2, newcatelv2); svCategory.UpdateProductCount(1, newcatelv1); #endregion trans.Complete(); IsResult = true; } return(IsResult); }
public bool UpdateBuyleadCountInCategories(int CateLV1, int CateLV2, int CateLV3) { var svCategory = new Category.CategoryService(); IsResult = svCategory.UpdateBuyleadCount(3, CateLV3); IsResult = svCategory.UpdateBuyleadCount(2, CateLV2); IsResult = svCategory.UpdateBuyleadCount(1, CateLV1); return(IsResult); }
public bool UpdateProductCountInCategories(int CateLV1, int CateLV2, int CateLV3) { var svCategory = new Category.CategoryService(); if (CateLV3 != 0) { IsResult = svCategory.UpdateProductCount(3, CateLV3); } if (CateLV1 != 0) { IsResult = svCategory.UpdateProductCount(2, CateLV2); } if (CateLV2 != 0) { IsResult = svCategory.UpdateProductCount(1, CateLV1); } return(IsResult); }
public bool Delete(List <int> BuyleadID, List <int> CateLV1, List <int> CateLV2, List <int> CateLV3, int CompID = 0) { var svCompany = new Company.CompanyService(); var svCategory = new Category.CategoryService(); var sqlWhere = SQLWhereListInt(BuyleadID, "BuyleadID"); if (CompID > 0) { sqlWhere += " AND CompID = " + CompID; } UpdateByCondition <b2bBuylead>(" IsDelete = 1 , ListNo = 0 ", sqlWhere); if (CompID > 0) { IsResult = svCompany.UpdateBuyleadCount(CompID); } UpdateBuyleadCountInCategories(CateLV1, CateLV2, CateLV3); return(IsResult); }
public bool Delete(int ProductID, int CateLV1, int CateLV2, int CateLV3, int CompID = 0) { var svCompany = new Company.CompanyService(); var svCategory = new Category.CategoryService(); var sqlWhere = "ProductID = " + ProductID; if (CompID > 0) { sqlWhere += " AND CompID = " + CompID; } UpdateByCondition <b2bProduct>(" ModifiedDate = GETDATE() , IsDelete = 1 , ListNo = 0 ", sqlWhere); if (CompID > 0) { IsResult = svCompany.UpdateProductCount(CompID); } UpdateProductCountInCategories(CateLV1, CateLV2, CateLV3); UpdateProductCountInCompany(CompID); return(IsResult); }