public int GetTotal() { using (var db = new ModelAdventureWorks()) { return(db.PurchaseOrderDetails.Count()); } }
public IEnumerable <ProductDTO> GetProductsPaged(string name, DateTime?startTime, List <string> keywords, int skip, int pageSize) { using (var db = new ModelAdventureWorks()) { var filteredProducts = db.Products.AsNoTracking() as IQueryable <Product>; if (!string.IsNullOrEmpty(name)) { filteredProducts = filteredProducts.Where(i => i.Name == name); } if (startTime.HasValue) { filteredProducts = filteredProducts.Where(i => i.SellStartDate == startTime); } if (keywords != null && keywords.Count > 0) { filteredProducts = filteredProducts.Where(i => i.ProductModel.ProductModelProductDescriptionCultures.Where(pd => keywords.Any(kw => pd.ProductDescription.Description.Contains(kw))).Count() > 0); } filteredProducts = filteredProducts.OrderBy(p => p.ProductID).Skip(skip).Take(pageSize); return(filteredProducts.AsEnumerable().Select(product => _myMapper.GetMapper().Map <Product, ProductDTO>(product)).ToList()); } }
public int GetTotal() { using (var db = new ModelAdventureWorks()) { return(db.Products.Count()); } }
public IEnumerable <PurchaseOrderDetailDTO> GetPaged(DateTime?startTime, DateTime?endTime, int skip, int pageSize) { using (var db = new ModelAdventureWorks()) { var filteredPurchaseOrderDetailes = db.PurchaseOrderDetails.AsNoTracking() as IQueryable <PurchaseOrderDetail>; if (startTime.HasValue) { filteredPurchaseOrderDetailes = filteredPurchaseOrderDetailes.Where(i => i.DueDate >= startTime.Value); } if (endTime.HasValue) { filteredPurchaseOrderDetailes = filteredPurchaseOrderDetailes.Where(i => i.DueDate <= endTime.Value); } return(filteredPurchaseOrderDetailes.GroupBy(i => i.DueDate).Select(t => new PurchaseOrderDetailDTO { TrafficSum = t.Sum(k => k.LineTotal), NumberOfProductUnitsSold = t.FirstOrDefault().OrderQty, DueDate = t.FirstOrDefault().DueDate }).OrderBy(k => k.DueDate).Skip(skip).Take(pageSize).ToList()); } }