public ActionResult ViewAll(int id) { var ViewAllReply = _db.Replies.Include(u => u.User).Where(c => c.QuestionId == id).ToList(); var viewSpecificQuestion = _db.Questions.Where(c => c.Id == id).ToList(); var view = new ViewReplies { Replies = ViewAllReply, Questions = viewSpecificQuestion }; return(View(view)); }
public ActionResult ReplySave(Replies replies, int id) { replies.QuestionId = id; replies.ReplyDate = DateTime.Now; string user = User.Identity.GetUserId(); replies.UserId = user; _db.Replies.Add(replies); _db.SaveChanges(); var ViewAllReply = _db.Replies.Include(u => u.User).Where(c => c.QuestionId == id).ToList(); var viewSpecificQuestion = _db.Questions.Where(c => c.Id == id).ToList(); var view = new ViewReplies { Replies = ViewAllReply, Questions = viewSpecificQuestion }; return(View(view)); }
//It is a public function with a parameter of type Object of the Replies Model Class and id of the question. it is used to save replies for a particular Question and returns a view with the question and a list of replies for the question public ActionResult ReplySave(Replies replies, int id) { string user = User.Identity.GetUserId(); replies.QuestionId = id; replies.ReplyDate = DateTime.Now; replies.UserId = user; _db.Replies.Add(replies); _db.SaveChanges(); // Replies to specific question var AllReplies = _db.Replies.Include(u => u.User).Where(c => c.QuestionId == id).ToList(); var RepliedQuestion = _db.Questions.Where(c => c.Id == id).ToList(); // Using View Model, Joining two tables together var ViewModel = new ViewReplies { Reply = AllReplies, Questions = RepliedQuestion }; return(View(ViewModel)); }