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); }