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