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