private IQueryable <Product> FilterProduct(IQueryable <Product> products, GetProductsQuery query)
{
if (!string.IsNullOrEmpty(query.CategoryId))
{
if (query.CategoryType == "main")
{
products = products.Where(x => x.MainCategoryId == query.CategoryId);
}
else if (query.CategoryType == "sub")
{
products = products.Where(x => x.SubCategoryId == query.CategoryId);
}
else if (query.CategoryType == "tri")
{
products = products.Where(x => x.TertiaryCategoryId == query.CategoryId);
}
}
if (!string.IsNullOrEmpty(query.SearchString))
{
products = products.Where(x => EF.Functions.Like(x.Name, $"%{query.SearchString}%"));
}
return(products);
}
public IEnumerable <ProductViewModel> Do(GetProductsQuery query, int limit = 9)
{
//var discounts = _ctx.AccountUsers
// .Include(x => x.Account)
// .ThenInclude(x => x.Discounts)
// .FirstOrDefault(x => x.UserId == query.UserId && x.Active)
// ?.Account
// ?.Discounts;
var realProducts = _ctx.Products.Where(x => x.Published != false);
var actualRealProducts = FilterProduct(realProducts, query)
.OrderBy(p => p.Id) // Added just to get rid of warnings in AWS cloudwatch logs
.Take(limit)
.ToList();
if (_discounts.Value.DiscountPercentage > 0)
{
var products = actualRealProducts.Select(x => new ProductViewModel
{
Id = x.Id,
Name = x.Name,
Description = x.Description,
Price = GetPrice(x, null),
//discounts for dynamic pricing
//Discount = discounts?.Any(y => y.ProductId == x.Id) ?? false,
//DiscountedValue = GetPrice(x, discounts),
ImageUrl = x.ImageUrl,
UOM = x.Unit,
Colour = x.Colour,
Code = x.ExternalId,
ValueAdded = x.ValueAddedProduct,
OutOfStock = x.OutOfStock
});
foreach (var x in products)
{
if (x.Discount != true)
{
// x.ThresholdDiscountedPrice = Convert.ToDecimal(x.Price) * _discounts.Value.DiscountPercentage;
}
}
return(products);
}
else
{
var products = actualRealProducts.Select(x => new ProductViewModel
{
Id = x.Id,
Name = x.Name,
Description = x.Description,
Price = GetPrice(x, null),
//discounts for dynamic pricing
//Discount = discounts?.Any(y => y.ProductId == x.Id) ?? false,
//DiscountedValue = GetPrice(x, discounts),
ImageUrl = x.ImageUrl,
UOM = x.Unit,
Colour = x.Colour,
Code = x.ExternalId,
ValueAdded = x.ValueAddedProduct,
OutOfStock = x.OutOfStock
});
return(products);
}
}