private IQueryable <PartInventory> PartsOverThreshold(decimal threshold)
{
var weekAgo = DateTime.UtcNow.AddDays(-7);
return
(from partInv in _partInventoryRepository.Queryable()
let partPrice = partInv.Pricing.AveragePrice
where partInv.Condition == "N"
where partInv.MyPrice > (partPrice * threshold)
where partInv.LastUpdated > weekAgo
where partPrice != 0
where partInv.Quantity > 0
select partInv);
}
public IQueryable <PartInventory> GetAllPartsForStockCheck()
{
return(_partInventoryRepo.Queryable().Where(x => !string.IsNullOrEmpty(x.Location) && x.Location != "ASK MOLLY"));
}
