public async Task <IActionResult> Get(
[FromQuery(Name = "pageIndex")] int?pageIndex = null,
[FromQuery(Name = "search")] BrandSearch search = null,
[FromQuery(Name = "sort")] BrandSort?sort = null,
[FromQuery(Name = "pageSize")] int pageSize = 10)
{
var spec = new BrandFilterSpec();
if (sort != null)
{
switch (sort)
{
case BrandSort.ProductsAsc:
spec.Query.OrderBy(a => a.Products.Count);
break;
case BrandSort.ProductsDesc:
spec.Query.OrderByDescending(a => a.Products.Count);
break;
default:
break;
}
}
var lambdaCombiner = new LambdaExpressionCombiner <Brand>();
if (search != null)
{
if (!search.Ids.IsNullOrEmpty())
{
lambdaCombiner.Add(new BrandByIdSpec(search.Ids).WhereExpressions.First());
}
if (!search.Names.IsNullOrEmpty())
{
lambdaCombiner.Add(new BrandByNameContainsSpec(search.Names).WhereExpressions.First());
}
}
var lambda = lambdaCombiner.Combine(ExpressionType.AndAlso);
if (lambda != null)
{
spec.Query.Where(lambda);
}
if (pageIndex.HasValue)
{
spec.Query.Paginate(pageIndex.Value * pageSize, pageSize);
var totalCount = 0;
if (lambda is null)
{
totalCount = await _unitOfWork.BrandRepository.CountAsync();
}
else
{
var noPagingSpec = new BrandFilterSpec();
noPagingSpec.Query.Where(lambda);
totalCount = await _unitOfWork.BrandRepository.CountAsync(noPagingSpec);
}
var items = _mapper.Map <IEnumerable <BrandDto> >(await _unitOfWork.BrandRepository.ListAsync(spec));
var paginatedList = new Page <BrandDto>(items, totalCount, pageIndex.Value, pageSize);
return(Ok(paginatedList));
}
return(Ok(_mapper.Map <IEnumerable <BrandDto> >(await _unitOfWork.BrandRepository.ListAsync())));
}
public async Task <IActionResult> Get(
[FromQuery(Name = "pageIndex")] int?pageIndex = null,
[FromQuery(Name = "search")] ProductSearch search = null,
[FromQuery(Name = "sort")] ProductSort?sort = null,
[FromQuery(Name = "pageSize")] int pageSize = 10)
{
var spec = new ProductFilterSpec();
if (sort != null)
{
switch (sort)
{
case ProductSort.PriceAsc:
spec.Query.OrderBy(a => a.Price);
break;
case ProductSort.PriceDesc:
spec.Query.OrderByDescending(a => a.Price);
break;
case ProductSort.DateAsc:
spec.Query.OrderBy(a => a.Date);
break;
case ProductSort.DateDesc:
spec.Query.OrderByDescending(a => a.Date);
break;
case ProductSort.OrdersAsc:
spec.Query.OrderBy(a => a.OrderProducts.Count);
break;
case ProductSort.OrdersDesc:
spec.Query.OrderByDescending(a => a.OrderProducts.Count);
break;
default:
break;
}
}
var lambdaCombiner = new LambdaExpressionCombiner <Product>();
if (!search.Names.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductByNameContainsSpec(search.Names).WhereExpressions.First());
}
if (!search.Ids.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductByIdSpec(search.Ids).WhereExpressions.First());
}
if (!search.GroupIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductByGroupIdSpec(search.GroupIds).WhereExpressions.First());
}
if (!search.CatalogIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductByCatalogIdSpec(search.CatalogIds).WhereExpressions.First());
}
if (!search.BrandIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductByBrandIdSpec(search.BrandIds).WhereExpressions.First());
}
if (search.PriceRange != null)
{
lambdaCombiner.Add(new ProductByPriceRangeSpec(search.PriceRange.From, search.PriceRange.To).WhereExpressions.First());
}
if (!search.Specifications.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductBySpecNameIdAndValueIdSpec(search.Specifications.ToArray()).WhereExpressions.First());
}
var lambda = lambdaCombiner.Combine(ExpressionType.AndAlso);
if (lambda != null)
{
spec.Query.Where(lambda);
}
if (pageIndex.HasValue)
{
spec.Query.Paginate(pageIndex.Value * pageSize, pageSize);
var totalCount = 0;
if (lambda is null)
{
totalCount = await _unitOfWork.ProductRepository.CountAsync();
}
else
{
var noPagingSpec = new ProductFilterSpec();
noPagingSpec.Query.Where(lambda);
totalCount = await _unitOfWork.ProductRepository.CountAsync(noPagingSpec);
}
var items = _mapper.Map <IEnumerable <ProductDto> >(await _unitOfWork.ProductRepository.ListAsync(spec));
var paginatedList = new Page <ProductDto>(items, totalCount, pageIndex.Value, pageSize);
return(Ok(paginatedList));
}
return(Ok(_mapper.Map <IEnumerable <ProductDto> >(await _unitOfWork.ProductRepository.ListAsync(spec))));
}
public async Task <IActionResult> Get(
[FromQuery] int?page = null,
[FromQuery(Name = "search")] OrderSearchModel search = null,
[FromQuery(Name = "sort")] SortModel sort = null,
[FromQuery] int pageSize = 10)
{
var spec = new OrderFilterSpec();
if (!sort.IsNullOrEmpty())
{
foreach (var item in sort)
{
if (Enum.TryParse <OrderBy>(item.Value, true, out var order))
{
if (item.Key.Equals(nameof(Order.Id), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Id);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Id);
}
}
if (item.Key.Equals(nameof(Order.Comment), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Comment);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Comment);
}
}
if (item.Key.Equals(nameof(Order.Date), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Date);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Date);
}
}
}
}
}
var lambdaCombiner = new LambdaExpressionCombiner <Order>();
if (!search.Ids.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByIdSpec(search.Ids).WhereExpressions.First());
}
if (!search.Comments.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByCommentContainsSpec(search.Comments).WhereExpressions.First());
}
if (!search.BuyerIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByBuyerIdSpec(search.BuyerIds).WhereExpressions.First());
}
if (!search.AddressIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByAddressIdSpec(search.AddressIds).WhereExpressions.First());
}
if (!search.Statuses.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByStatusSpec(search.Statuses).WhereExpressions.First());
}
if (!search.UserOrAnonymousIds.IsNullOrEmpty())
{
lambdaCombiner.Add(new OrderByUserOrAnonymousIdSpec(search.UserOrAnonymousIds).WhereExpressions.First());
}
var lambda = lambdaCombiner.Combine(ExpressionType.AndAlso);
if (lambda != null)
{
spec.Query.Where(lambda);
}
var items = _mapper.Map <IEnumerable <OrderDto> >(await _unitOfWork.OrderRepository.ListAsync(spec));
if (page.HasValue)
{
spec.Query.Paginate((page.Value) * pageSize, pageSize);
var totalCount = 0;
if (lambda is null)
{
totalCount = await _unitOfWork.OrderRepository.CountAsync();
}
else
{
var noPagingSpec = new OrderFilterSpec();
spec.Query.Where(lambda);
totalCount = await _unitOfWork.OrderRepository.CountAsync(noPagingSpec);
}
var paginatedList = new Page <OrderDto>(items, totalCount, page.Value, pageSize);
return(Ok(paginatedList));
}
return(Ok(items));
}
public async Task <IActionResult> CatalogProducts(
[FromRoute] int catalogId,
[FromQuery] int?page = null,
[FromQuery(Name = "search")] ProductSearch search = null,
[FromQuery(Name = "sort")] SortModel sort = null,
[FromQuery] int pageSize = 10)
{
var catalogs = await GetChildsWithSelfRecursive(catalogId);
if (catalogs.IsNullOrEmpty())
{
return(NoContent());
}
var spec = new ProductFilterSpec();
if (!sort.IsNullOrEmpty())
{
foreach (var item in sort)
{
if (Enum.TryParse <OrderBy>(item.Value, true, out var order))
{
if (item.Key.Equals(nameof(Product.Name), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Name);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Name);
}
}
if (item.Key.Equals(nameof(Product.Price), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Price);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Price);
}
}
if (item.Key.Equals(nameof(Product.Date), StringComparison.OrdinalIgnoreCase))
{
if (order == OrderBy.ASC)
{
spec.Query.OrderBy(a => a.Date);
}
else if (order == OrderBy.DESC)
{
spec.Query.OrderByDescending(a => a.Date);
}
}
}
}
}
var lambdaCombiner = new LambdaExpressionCombiner <Product>();
var spec1 = new ProductByCatalogIdSpec(catalogs.Select(a => a.Id).ToArray());
lambdaCombiner.Add(spec1.WhereExpressions.First());
if (!search.BrandIds.IsNullOrEmpty())
{
var spec2 = new ProductByBrandIdSpec(search.BrandIds);
lambdaCombiner.Add(spec2.WhereExpressions.First());
}
if (search.PriceRange != null && (search.PriceRange.From.HasValue || search.PriceRange.To.HasValue))
{
lambdaCombiner.Add(new ProductByPriceRangeSpec(search.PriceRange.From, search.PriceRange.To).WhereExpressions.First());
}
if (!search.Specifications.IsNullOrEmpty())
{
lambdaCombiner.Add(new ProductBySpecNameIdAndValueIdSpec(search.Specifications.ToArray()).WhereExpressions.First());
}
var lambda = lambdaCombiner.Combine(ExpressionType.AndAlso);
if (lambda != null)
{
spec.Query.Where(lambda);
}
if (page.HasValue)
{
spec.Query.Paginate((page.Value) * pageSize, pageSize);
var totalCount = 0;
if (lambda is null)
{
totalCount = await _unitOfWork.ProductRepository.CountAsync();
}
else
{
var noPagingSpec = new ProductFilterSpec();
noPagingSpec.Query.Where(lambda);
totalCount = await _unitOfWork.ProductRepository.CountAsync(noPagingSpec);
}
var items = _mapper.Map <IEnumerable <ProductDto> >(await _unitOfWork.ProductRepository.ListAsync(spec));
var paginatedList = new Page <ProductDto>(items, totalCount, page.Value, pageSize);
return(Ok(paginatedList));
}
return(Ok(_mapper.Map <IEnumerable <ProductDto> >(await _unitOfWork.ProductRepository.ListAsync(spec))));
}
