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