Advertisement
Guest User

Untitled

a guest
Dec 6th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. public static string ExportSongsAboveDuration(MusicHubDbContext context, int duration)
  2. {
  3. var songs = context.Songs
  4. .Where(d => d.Duration.TotalSeconds > duration)
  5. .Select(x => new ExportSongDto
  6. {
  7. SongName = x.Name,
  8. Writer = x.Writer.Name,
  9. Performer = x.SongPerformers.Select(p => p.Performer.FirstName + " " + p.Performer.LastName).FirstOrDefault(),
  10. AlbumProducer = x.Album.Producer.Name,
  11. Duration = x.Duration.ToString("c")
  12. })
  13. .OrderBy(x => x.SongName)
  14. .ThenBy(w => w.Writer)
  15. .ToArray();
  16.  
  17. var xmlSerializer = new XmlSerializer(typeof(ExportSongDto[]), new XmlRootAttribute("Songs"));
  18.  
  19. var sb = new StringBuilder();
  20.  
  21. var namespaces = new XmlSerializerNamespaces(new[]
  22. {
  23. XmlQualifiedName.Empty
  24. });
  25. xmlSerializer.Serialize(new StringWriter(sb), songs, namespaces);
  26.  
  27. return sb.ToString().TrimEnd();
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement