public PagedResult <Product> GetProductsByName(int pageSize, int currentPage, string name)
{
IOrderedQueryable <Product> queryProducts = productRepository.Get(orderBy: q => q.OrderBy(d => d.Name), x => x.Name.Contains(name));
PagedResultExtension extension = new PagedResultExtension();
return(extension.GetPaged <Product>(queryProducts, currentPage, pageSize));
}
public PagedResult <Product> GetProductsBySellingStartDate(int pageSize, int currentPage, DateTime sellingStartDate)
{
IOrderedQueryable <Product> queryProducts = productRepository.Get(orderBy: q => q.OrderBy(d => d.Name), x => x.SellStartDate.Equals(sellingStartDate));
PagedResultExtension extension = new PagedResultExtension();
return(extension.GetPaged <Product>(queryProducts, currentPage, pageSize));
}
public PagedResult <PurchaseOrderDetailData> GetPurchaseOrderDetailData(int pageSize, int currentPage, DateTime from, DateTime to)
{
IOrderedQueryable <PurchaseOrderDetailData> query = purchaseRepository.Get(orderBy: q => q.OrderBy(d => d.PurchaseOrderDetailID), x => x.ModifiedDate <to.Date && x.ModifiedDate> from.Date).GroupBy(v => DbFunctions.TruncateTime(v.ModifiedDate)).Select(g => new
PurchaseOrderDetailData
{
SumOfTraffic = g.Sum(i => i.LineTotal),
NumberOfProductUnitSold = g.Sum(z => z.OrderQty)
}).OrderBy(d => d.SumOfTraffic);
PagedResultExtension extension = new PagedResultExtension();
return(extension.GetPaged <PurchaseOrderDetailData>(query, currentPage, pageSize));
}