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)); }