public List <ProductFilterValueResultSet> GetProductFilterValues(int productId)
{
using (ProductSpecificationDataContext dc = new ProductSpecificationDataContext())
{
ProductSpecificationRepository repo = new ProductSpecificationRepository(dc);
return(repo.GetProductFilterValues(productId));
}
return(null);
}
public bool UpdateFilterParameters(List <CategoryMasterFilterResultSet> categoryMasterFilter)
{
using (ProductSpecificationDataContext dc = new ProductSpecificationDataContext())
{
ProductSpecificationRepository repo = new ProductSpecificationRepository(dc);
repo.AddCategoryMasterFilter(categoryMasterFilter);
}
return(true);
}
public List <CategoryMasterFilter> GetCategoryFilters(int categoryId)
{
//var categoryfilterQuery = "Select Id, Category, FilterParameter from [CategoryMasterFilter] Where Category = {categoryId}".FormatWith(categoryId);
//List<CategoryMasterFilter> categoryMasterFilterList = _unitOfWork.ExecuteQuery<CategoryMasterFilter>(categoryfilterQuery).ToList();
//return categoryMasterFilterList;
using (ProductSpecificationDataContext dc = new ProductSpecificationDataContext())
{
ProductSpecificationRepository repo = new ProductSpecificationRepository(dc);
return(repo.GetCategoryMasterFilter(categoryId));
}
}
public bool UpdateProductSpecifications(ProductSpecificationsAllDTO productSpecifications)
{
var filter = productSpecifications.productFilters;
var keyFeatures = productSpecifications.productKeyFeatures;
var specifications = productSpecifications.productSpecifications;
using (ProductSpecificationDataContext dc = new ProductSpecificationDataContext())
{
ProductSpecificationRepository repo = new ProductSpecificationRepository(dc);
repo.AddFilter(filter);
repo.AddKeyFeatures(keyFeatures);
repo.AddSpecifications(specifications);
}
return(true);
}
public async Task ProductSpecificationRepositoryCRUDTest()
{
var context = new NoodleDbContext("NoodleDb");
context.Init();
IProductSpecificationRepository repository = new ProductSpecificationRepository(context);
var id = Guid.NewGuid();
var record = new ProductSpecification
{
Id = id,
BaseQty = 10,
Child = new Product
{
Id = Guid.Empty
},
ChildUom = new Data.Business.Uom
{
Id = Guid.Empty
},
Parent = new Product
{
Id = Guid.Empty
}
};
await repository.CreateAsync(record);
record.BaseQty = 15;
await repository.UpdateAsync(record);
var record2 = await repository.GetByIdAsync(id);
Assert.AreEqual(record.Id, record2.Id);
Assert.AreEqual(record.BaseQty, record2.BaseQty);
await repository.DeleteAsync(record.Id);
var record3 = await repository.GetByIdAsync(id);
Assert.IsNull(record3);
}
public UnitOfWork(ApplicationDbContext context)
{
this._context = context;
Categories = new CategoryRepository(_context);
Producers = new ProducerRepository(_context);
Roles = new RoleRepository(_context);
Accounts = new AccountRepository(_context);
AvatarOfProducts = new AvatarOfProductRepository(_context);
Carts = new CartRepository(_context);
Comments = new CommentRepository(_context);
Customers = new CustomerRepository(_context);
Invoices = new InvoiceRepository(_context);
Orders = new OrderRepository(_context);
Products = new ProductRepository(_context);
ProductsOfOrders = new ProductsOfOrderRepository(_context);
ProductSpecifications = new ProductSpecificationRepository(_context);
SpecificationValues = new SpecificationValueRepository(_context);
StarRatings = new StarRatingRepository(_context);
Sellers = new SellerRepository(_context);
}
