public List <GetCommentViewModels> GetComments(Post post) { List <Comment> comments = db.Comments. Where(x => x.PostID == post.Id).OrderByDescending(x => x.PostedAt).ToList(); var userIDs = comments.Select(x => x.Author); List <ApplicationUser> users = db.Users .Where(x => userIDs.Contains(x.Id)).ToList(); List <GetCommentViewModels> model = new List <GetCommentViewModels>(); foreach (var item in comments) { var commentuser = users.SingleOrDefault(x => x.Id == item.Author); var input = new GetCommentViewModels(); input.User = commentuser; input.Comment = item; input.ConvertedDateTime = item.PostedAt.ToString(); model.Add(input); } return(model); }
public IActionResult Gets(string CustomerId) { var Gets = DB.Comments.Where(w => w.CustomerId == CustomerId).ToList(); var User = DB.Users; var Customer = DB.Customers; var ViewModels = new List <GetCommentViewModels>(); foreach (var Get in Gets) { var Model = new GetCommentViewModels(); Model.Title = Get.Title; Model.Comment = Get.Comment; Model.CommentBy = User.Where(w => w.Id == Get.CommentBy).Select(s => s.FirstName + " " + s.LastName).FirstOrDefault(); Model.CommentDate = Helper.getShortDateAndTime(Get.CommentDate); Model.CommentId = Get.CommentId; Model.CustomerName = Customer.Where(w => w.CustomerId == Get.CustomerId).Select(s => s.CompanyName).FirstOrDefault(); ViewModels.Add(Model); } return(PartialView("Gets", ViewModels)); }