Пример #1
0
        public static string ExportCommentsOnPosts(InstagraphContext context)
        {
            using (context)
            {
                var users = context.Users
                            .Select(x => new
                {
                    Username          = x.Username,
                    PostCommentsCount = x.Posts.Select(p => p.Comments.Count).ToArray()
                });

                var userList = new List <UserMostCommentsDto>();

                var xmlDoc = new XDocument(new XElement("users"));

                foreach (var user in users)
                {
                    int mostComments = 0;
                    if (user.PostCommentsCount.Any())
                    {
                        mostComments = user.PostCommentsCount.OrderByDescending(x => x).First();
                    }

                    var newUser = new UserMostCommentsDto()
                    {
                        Username     = user.Username,
                        MostComments = mostComments
                    };

                    userList.Add(newUser);
                }

                userList = userList.OrderByDescending(x => x.MostComments)
                           .ThenBy(x => x.Username)
                           .ToList();

                foreach (var user in userList)
                {
                    xmlDoc.Root.Add(new XElement("user",
                                                 new XElement("Username", user.Username),
                                                 new XElement("MostComments", user.MostComments)));
                }
                var result = xmlDoc.ToString();
                return(result);
            }
        }
Пример #2
0
        public static string ExportCommentsOnPosts(InstagraphContext context)
        {
            var users = context.Users
                        .Select(u => new
            {
                Username      = u.Username,
                CommentsCount = u.Posts.Select(p => p.Comments.Count).ToArray()
            })
                        .ToArray();

            var userDtos = new List <UserMostCommentsDto>();

            foreach (var u in users)
            {
                var mostComments = 0;

                if (u.CommentsCount.Any())
                {
                    mostComments = u.CommentsCount.OrderByDescending(x => x).First();
                }

                var userDto = new UserMostCommentsDto()
                {
                    Username     = u.Username,
                    MostComments = mostComments
                };

                userDtos.Add(userDto);
            }

            var xDoc = new XDocument(new XElement("users"));

            foreach (var user in userDtos.OrderByDescending(u => u.MostComments).ThenBy(u => u.Username))
            {
                xDoc.Root.Add(new XElement("user",
                                           new XElement("Username", user.Username),
                                           new XElement("MostComments", user.MostComments)));
            }

            return(xDoc.ToString());
        }