public ActionResult MissionFAQ(FormCollection form, int missionKey) { String formType = form["formType"].ToString(); if (formType == "Question") { String question = form["NewQuestion"].ToString(); MissionQuestions newQuestion = new MissionQuestions(); newQuestion.missionQuestion = question; newQuestion.userID = User.Identity.GetUserName(); newQuestion.missionID = missionKey; if (ModelState.IsValid) { MissionContext.MissionQuestions.Add(newQuestion); MissionContext.SaveChanges(); return(RedirectToAction("MissionFAQ", "Mission", new { missionKey = newQuestion.missionID, questionID = newQuestion.missionQuestionID })); } } else { int missionQuestionID = Convert.ToInt32(form["missionQuestionID"]); MissionAnswers newAnswer = new MissionAnswers(); newAnswer.answer = form["NewComment"].ToString(); newAnswer.missionQuestionID = missionQuestionID; IEnumerable <string> handler = MissionContext.Database.SqlQuery <String>("SELECT Handler FROM AspNetUsers WHERE UserName = @p0", User.Identity.GetUserName()); newAnswer.handler = "@" + handler.ToList()[0]; //there will only be one if (ModelState.IsValid) { MissionContext.MissionAnswers.Add(newAnswer); MissionContext.SaveChanges(); return(RedirectToAction("MissionFAQ", "Mission", new { missionKey = missionKey, questionID = missionQuestionID })); } } return(RedirectToAction("MissionFAQ", "Mission", new { missionKey = missionKey })); }
//delete answer public ActionResult DeleteA(string uId, int aId, int missionId) { if (uId == User.Identity.Name) { //find answer and remove (finds by the primary key) MissionAnswers answer = db.MissionAnswers.Find(aId); db.MissionAnswers.Remove(answer); db.SaveChanges(); } return(RedirectToAction("Faqs", routeValues: new { id = missionId })); }
public ActionResult NewAnswer(FormCollection form, int missionID, int questionID) { if (form["answer_" + questionID] != null && form["answer_" + questionID] != String.Empty) { MissionAnswers answer = new MissionAnswers(); answer.Answer = form["answer_" + questionID]; answer.MissionQuestionID = questionID; answer.UserID = User.Identity.Name; //add answer to database db.MissionAnswers.Add(answer); db.SaveChanges(); } return(RedirectToAction("Faqs", routeValues: new { id = missionID })); }