//last ten of current Employeers orders
private List <OrderTen> LastTenOrder(int userId)
{
var orderTen = (from o in db.Orders
join od in db.Order_Details on o.OrderID equals od.OrderID
join e in db.Employees on o.EmployeeID equals e.EmployeeID
where (e.EmployeeID == userId)
group od by o.OrderID into x
select new { OrderID = x.Key, Cost = x.Sum(o => o.UnitPrice * o.Quantity) })
.OrderByDescending(x => x.Cost)
.Take(10);
;
List <OrderTen> lastTenOrderData = new List <OrderTen>();
//IQueryable->list
foreach (var itemOrderTen in orderTen)
{
OrderTen lastTenOrdeElementr = new OrderTen();
lastTenOrdeElementr.OrderID = itemOrderTen.OrderID;
lastTenOrdeElementr.Cost = decimal.Round(itemOrderTen.Cost, 2);
lastTenOrderData.Add(lastTenOrdeElementr);
}
return(lastTenOrderData);
}
//last ten of current user orders
private List <OrderTen> LastTenOrder(string user)
{
var orderTen = (from o in db.Orders
join od in db.Order_Details on o.OrderID equals od.OrderID
join c in db.Customers on o.CustomerID equals c.CustomerID
where (c.ContactName == user)
group od by o.OrderID into x
select new { OrderID = x.Key, Cost = x.Sum(o => o.UnitPrice * o.Quantity) })
.OrderByDescending(x => x.Cost)
.Take(10);
;
List <OrderTen> lastTenOrderData = new List <OrderTen>();
//IQueryable->list
foreach (var itemOrderTen in orderTen)
{
OrderTen lastTenOrdeElementr = new OrderTen
{
OrderID = itemOrderTen.OrderID,
Cost = Math.Round(itemOrderTen.Cost, 2)
};
lastTenOrderData.Add(lastTenOrdeElementr);
}
return(lastTenOrderData);
}
