Advertisement
Galina841130

json

Aug 6th, 2022
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. var teamsWithFootballers = context.Teams
  2. .ToList()
  3. .Where(x => x.TeamsFootballers.Any(x => x.Footballer.ContractStartDate >= date))
  4. .Select(x => new
  5. {
  6. Name = x.Name,
  7. Footballers = x.TeamsFootballers
  8. .Where(f => f.Footballer.ContractStartDate >= date)
  9. .OrderByDescending(f => f.Footballer.ContractEndDate)
  10. .ThenBy(f => f.Footballer.Name)
  11. .Select(f => new
  12. {
  13. FootballerName = f.Footballer.Name,
  14. ContractStartDate = f.Footballer.ContractStartDate.ToString("d", CultureInfo.InvariantCulture),
  15. ContractEndDate = f.Footballer.ContractEndDate.ToString("d", CultureInfo.InvariantCulture),
  16. BestSkillType = f.Footballer.BestSkillType.ToString(),
  17. PositionType = f.Footballer.PositionType.ToString()
  18. }).ToList()
  19. })
  20. .OrderByDescending(x => x.Footballers.Count)
  21. .ThenBy(x => x.Name)
  22. .Take(5)
  23. .ToList();
  24.  
  25. return JsonConvert.SerializeObject(teamsWithFootballers, Formatting.Indented);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement