Advertisement
Guest User

asdf

a guest
Nov 17th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.17 KB | None | 0 0
  1. public static string GetSoldProducts(ProductShopContext context)
  2.         {
  3.             var users = context.Users
  4.                 .Where(u => u.ProductsSold.Count > 0 && u.ProductsSold.Any(a => a.BuyerId != null))
  5.                 .Select(a => new
  6.                 {
  7.                     FirstName = a.FirstName,
  8.                     LastName = a.LastName,
  9.                     SoldProducts = a.ProductsSold
  10.                     .Select(b => new
  11.                     {
  12.                         b.Name,
  13.                         Price = b.Price.ToString("F2"),
  14.                         BuyerFirstName = b.Buyer.FirstName,
  15.                         BuyerLastName = b.Buyer.LastName
  16.                     })
  17.                 }).OrderBy(x => x.LastName).ThenBy(x => x.FirstName).ToList();
  18.             var resolver = new DefaultContractResolver()
  19.             {
  20.                 NamingStrategy = new CamelCaseNamingStrategy()
  21.             };
  22.             var sett = new JsonSerializerSettings();
  23.             sett.ContractResolver = resolver;
  24.             sett.Formatting = Formatting.Indented;
  25.  
  26.             var json = JsonConvert.SerializeObject(users, sett);
  27.             return json;
  28.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement