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