public ActionResult EditAnswer(int id)
{
using (QuestionAnswerContext context = new QuestionAnswerContext())
{
var answer = context.Answers
.Find(id);
context.Entry(answer).Reference(x => x.Question).Load();
context.Entry(answer).Reference(x => x.User).Load();
return(View(answer));
}
}
public ActionResult EditAnswer(Answer answer)
{
using (QuestionAnswerContext context = new QuestionAnswerContext())
{
answer.CreationDate = DateTime.Now;
context.Entry(answer).State = EntityState.Modified;
context.SaveChanges();
context.Entry(answer).Reference(x => x.Question).Load();
//return View(answer);
return(RedirectToAction("AnswerQuestion", "Questions", new { id = answer.Question.Id }));
}
}
public ActionResult AnswerQuestion(QuestionAnswer questionAnswermodel)
{
using (QuestionAnswerContext context = new QuestionAnswerContext())
{
var questionId = questionAnswermodel.Question.Id;
var newAnswer = questionAnswermodel.Answer;
var question = context.Questions.Find(questionId);
newAnswer.Question = question;
question.AnswerCount += 1;
context.Entry(question).State = EntityState.Modified;
//Using default user as ID = 1, since we still dont have the login feature
newAnswer.User = context.Users.Find(1);
newAnswer.CreationDate = DateTime.Now;
context.Answers.Add(newAnswer);
context.SaveChanges();
var updatedquestion = context.Questions
.OrderBy(q => q.CreationDate)
.Where(q => q.Id == questionId)
.Include(q => q.Category)
.Include(q => q.User)
.Include(q => q.Answers)
.Include(q => q.Answers.Select(lp => lp.User))
.First();
var questionanswermodel = new QuestionAnswer();
questionanswermodel.Question = updatedquestion;
return(View(questionanswermodel));
}
}
public ActionResult AnswerQuestion(QuestionAnswer questionAnswermodel)
{
using (QuestionAnswerContext context = new QuestionAnswerContext())
{
var questionId = questionAnswermodel.Question.Id;
var newAnswer = questionAnswermodel.Answer;
var question = context.Questions.Find(questionId);
newAnswer.Question = question;
//question.AnswerCount += 1;
context.Entry(question).State = EntityState.Modified;
var username = User.Identity.Name;
var user = context.Users.Where(x => x.Email == username).FirstOrDefault();
newAnswer.User = user;
newAnswer.CreationDate = DateTime.Now;
context.Answers.Add(newAnswer);
context.SaveChanges();
var updatedquestion = context.Questions
//.OrderBy(q => q.CreationDate)
.Where(q => q.Id == questionId)
.Include(q => q.Category)
.Include(q => q.User)
.Include(q => q.Answers)
.Include(q => q.Votes)
.Include(q => q.Answers.Select(lp => lp.User))
.First();
var questionanswermodel = new QuestionAnswer();
questionanswermodel.Question = updatedquestion;
var userid = context.Users
.Where(q => q.Email == User.Identity.Name)
.First();
ViewBag.ID = userid.Id;
return(View(questionanswermodel));
}
}
