public IHttpActionResult Get(int postId)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
List <CommentViewModel> comments = new List <CommentViewModel>();
foreach (var x in db.Posts.Find(postId).Comments)
{
CommentViewModel cvm = ApplicationUtils.CreateCommentViewModel(x);
cvm.Likes = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM Users_Comments_Like WHERE Comment_id = {0}", cvm.Id).First();
cvm.Dislikes = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM Users_Comments_Dislike WHERE Comment_id = {0}", cvm.Id).First();
comments.Add(cvm);
}
return(Ok(new { Comments = comments }));
}
}
