public ActionResult ViewQuestion(int question, string Code) // { QuestionDBContext QDB = new QuestionDBContext(); List <Questions> qset = QDB.Questions.ToList <Questions>(); Questions ques = qset.Where(b => b.QID == question).First(); AnswerDBContext ADB = new AnswerDBContext(); // List <Answer> aset = ADB.Answers.ToList <Answer>(); // aset = aset.Where(a => a.QID == question).ToList <Answer>(); // aset = aset.OrderByDescending(a => Convert.ToDateTime(a.ADate)).ToList <Answer>(); // ViewBag.Answers = aset; // Object rating = db.SelectUserRating(question, LoginInfo.LoginUsername); // if (rating != null) { ViewBag.URating = (bool)rating; // } else { ViewBag.Rating = null; // } ViewBag.Reported = db.SelectUserReport(question, LoginInfo.LoginUsername); ViewBag.Question = ques; Answer answer = new Answer(); answer.QID = question; ViewBag.course = Code; return(View(answer)); }
public ActionResult AddAnswer(Answer answer2) { AnswerDBContext DB = new AnswerDBContext(); answer2.UserName = LoginInfo.LoginUsername; answer2.ADate = DateTime.Now.ToString(); DB.Answers.Add(answer2); DB.SaveChanges(); return(View("~/Views/ST/AnswerSuccess.cshtml")); }