public List <PostsLikedDataVM> GetPostsWithLikesbyArtist(int id) { var userposts = _context.Post.Where(u => u.ApplicationArtistId == id).ToList(); var numberOfPosts = userposts.Count(); var PostsLiked = new List <PostsLikedDataVM>(); foreach (var post in userposts) { var userLikes = _context.Like.Where(u => u.PostId == post.PostId).ToList(); var user = _context.ApplicationUser.Where(ui => ui.Id == post.ApplicationUserId).FirstOrDefault(); var PostswithLikes = new PostsLikedDataVM { ProfileImage = user.ImageUrl, UserId = user.Id, UserName = user.UserName, PostId = post.PostId, Media = post.Media, Caption = post.caption, Video = post.Video, DateCreated = post.DateCreated, }; foreach (var like in userLikes) { var NumberOfLikes = userLikes.Count(); PostswithLikes.NumberofLikes = NumberOfLikes; } PostswithLikes.NumberofPosts = numberOfPosts; PostsLiked.Add(PostswithLikes); } return(PostsLiked); }
public List <PostsLikedDataVM> GetPostsWithLikes(string id) { var userposts = _context.Post.Where(u => u.ApplicationUserId == id).ToList(); var PostsLiked = new List <PostsLikedDataVM>(); foreach (var post in userposts) { var userLikes = _context.Like.Where(u => u.PostId == post.PostId).ToList(); var PostswithLikes = new PostsLikedDataVM { PostId = post.PostId, Media = post.Media, Caption = post.caption, Video = post.Video, DateCreated = post.DateCreated, }; foreach (var like in userLikes) { var NumberOfLikes = userLikes.Count(); PostswithLikes.NumberofLikes = NumberOfLikes; } PostsLiked.Add(PostswithLikes); } return(PostsLiked); }