Advertisement
simeon3000

GetTotalProfitByCategory

Nov 21st, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.43 KB | None | 0 0
  1.         public static string GetTotalProfitByCategory(BookShopContext context) //12.
  2.         {
  3.             var result = context.Categories
  4.                 .OrderByDescending(c => c.CategoryBooks.Select(cb => cb.Book.Copies * cb.Book.Price).Sum())
  5.                 .Select(c => $"{c.Name} ${c.CategoryBooks.Select(cb => cb.Book.Copies * cb.Book.Price).Sum():f2}");
  6.  
  7.             return String.Join(Environment.NewLine, result);
  8.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement