Advertisement
Guest User

Query 18. Export Total Sales by Customer

a guest
Nov 22nd, 2019
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. //Query 18. Export Total Sales by Customer
  2. public static string GetTotalSalesByCustomer(CarDealerContext context)
  3. {
  4. var customers = context
  5. .Customers
  6. .Where(c => c.Sales.Count > 0)
  7. .Select(c => new
  8. {
  9. fullName = c.Name,
  10. boughtCars = c.Sales.Count,
  11. spentMoney = c.Sales.Sum(s => s.Car.PartCars.Sum(p => p.Part.Price))
  12. })
  13. .OrderByDescending(c => c.spentMoney)
  14. .ThenByDescending(c => c.boughtCars)
  15. .ToList();
  16.  
  17. var json = JsonConvert.SerializeObject(customers, Formatting.Indented);
  18.  
  19. return json;
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement