public ActionResult AddComment(int id, ArticleCommentModel comment)
{
comment.ArticleID = id;
comment.Date = DateTime.Now;
tblComments dbComment = new tblComments()
{
Comment = comment.Text,
Date = comment.Date,
ArticleID = comment.ArticleID,
UserID = 1
};
var comments = _commentsManager.AddCommentToArticleById(id, dbComment).OrderByDescending(n => n.Date).ToList <tblComments>();
ViewBag.Comments = comments;
ViewBag.ArticleID = id;
return(View("CommentPartial"));
}
public List <tblComments> AddCommentToArticleById(int ArticleID, tblComments comment)
{
List <tblComments> comments;
using (DbContext context = this.CreateDbContext())
{
tblUsers user = context.Set <tblUsers>().Single(n => n.ID == comment.UserID);
tblArticles article = context.Set <tblArticles>().Single(n => n.ID == ArticleID);
comment.tblArticles = article;
comment.tblUsers = user;
context.Set <tblComments>().Add(comment);
context.SaveChanges();
comments = context.Set <tblComments>()
.Where(n => n.ArticleID == ArticleID)
.Include(n => n.tblUsers)
.ToList();
}
return(comments);
}
