public ActionResult Create([Bind(Include = "MissionQ_ID,Question,Answer,MissionID,UserID")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
missionQuestions.MissionID = M_ID;
var id = Session["UserID"];
int U_ID = Convert.ToInt32(id);
if (string.IsNullOrEmpty(U_ID.ToString()) || U_ID == 0)
{
missionQuestions.UserID = 1;
}
else
{
missionQuestions.UserID = U_ID;
}
db.MissionQuestions.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MissionID = new SelectList(db.Missions, "MissionID", "MissionName", missionQuestions.MissionID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "UserFName", missionQuestions.UserID);
return(View(missionQuestions));
}
// GET: MissionQuestions/AddQuestion/5
public ActionResult AddQuestion(int?missionid, int?userid)
{
int id = 1;
if (missionid != null)
{
id = Convert.ToInt32(missionid);
}
//ViewBags to send MissionID and userid to view
ViewBag.Mission = id;
ViewBag.User = userid;
if (missionid == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
MissionQuestions newMissionQuestions = new MissionQuestions()
{
MissionID = id
};
//Query Mission name for breadcrumb
Missions mission = db.Mission.Find(id);
ViewBag.MissionName = mission.MissionName;
ViewBag.MissionNumber = mission.MissionID;
return(View(newMissionQuestions));
}
}
public ActionResult Edit([Bind(Include = "missionQuestionID,missionID,userID,question,answer,answeredBy")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
ViewBag.test = User.Identity.Name;
ViewBag.answerer = null;
var use = db.Users;
//cycles through the users model to find the user who has that email (User.Identity.Name)
foreach (var id in use)
{
if (id.userEmail == ViewBag.test)
{
//Stores the first name of the answerer
ViewBag.answerer = id.userFName;
}
}
//Assigns the first name of answerer as the current user's first name
missionQuestions.answeredBy = ViewBag.answerer;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "missionQuestionID,missionID,userID,question,answer,answeredBy")] MissionQuestions missionQuestions, int mid)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestions);
//Assigns the mission id as the specific mission the questions forum was accessed through
missionQuestions.missionID = mid;
//This code gets the userID of the currently logged in user
ViewBag.test = User.Identity.Name;
ViewBag.use = null;
var use = db.Users;
//cycles through the users model to find the user who has that email (User.Identity.Name)
foreach (var id in use)
{
if (id.userEmail == ViewBag.test)
{
ViewBag.use = id.userID;
}
}
//Assigns the userID of the question to the currently logged in user
missionQuestions.userID = ViewBag.use;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(missionQuestions));
}
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 }));
}
public ActionResult DeleteConfirmed(int id)
{
MissionQuestions missionQuestions = db.MissionQuestions.Find(id);
db.MissionQuestions.Remove(missionQuestions);
db.SaveChanges();
return RedirectToAction("Index");
}
// GET: MissionQuestions/Create
public ActionResult Create()
{
MissionQuestions mishQ = new MissionQuestions();
mishQ.MISSION_ID = globalMission.MISSION_ID;
mishQ.USER_ID = UserID;
return(View(mishQ));
}
public ActionResult AnswerQuestion(FormCollection form)
{
MissionQuestions updateQuestion = db.MissionQuestion.Find(int.Parse(form["MissionQuestionID"]));
updateQuestion.Answer = form["newAnswer"];
db.SaveChanges();
return(RedirectToAction("FAQ", missionquestions));
}
public ActionResult Edit([Bind(Include = "mission_question_id,mission_id,user_id,question,answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(missionQuestions);
}
public ActionResult Answer([Bind(Include = "missionquestionID, missionID, userID, question, answer")] MissionQuestions newQuestion)
{
if (ModelState.IsValid)
{
db.Entry(newQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newQuestion));
}
public ActionResult SelectMission([Bind(Include = "MissionID")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
MissionIDPointer = missionQuestions.MissionID;
return(RedirectToAction("MissionFAQ", new { id = UserIDPointer }));
}
return(View());
}
public ActionResult Edit([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(missionQuestions));
}
public ActionResult Edit([Bind(Include = "QUESTION_ID,MISSION_ID,USER_ID,QUESTION,ANSWER")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { missionID = globalMission.MISSION_ID, id = UserID }));
}
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "mission_question_id,mission_id,user_id,question,answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestions);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(missionQuestions);
}
public ActionResult UpdateAnswer([Bind(Include = "missionquestionID,missionID,userID,question,answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
missionQuestions.question = missionQuestions.question;
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("MissionFAQ", new { id = missionQuestions.missionID }));
}
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "QUESTION_ID,MISSION_ID,USER_ID,QUESTION,ANSWER")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.missionQuestions.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index", new { missionID = globalMission.MISSION_ID, id = UserID }));
}
return(View(missionQuestions));
}
public ActionResult Edit([Bind(Include = "missionQuestionID,MissionID,UserID,question,answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MissionID = new SelectList(db.Missions, "MissionID", "missionName", missionQuestions.MissionID);
return(View(missionQuestions));
}
public ActionResult AddQuestion(string question, int mID)
{
MissionQuestions newQ = new MissionQuestions();
newQ.MissionID = mID;
newQ.MissionQuestion = question;
newQ.UserID = UserIDPointer;
db.MissionQuestions.Add(newQ);
db.SaveChanges();
return(RedirectToAction("MissionFAQ", new { id = UserIDPointer }));
}
public ActionResult Create([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.MissionQuestion.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "missionquestionID,question,answer,missionID")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestions.missionID);
return(View(missionQuestions));
}
//code for when we will answer/update a question
public ActionResult answerQuestion(FormCollection form, int missionQuestionID, int missionID)
{
//load the db object based on the id given in parameters (missionQuestionID)
MissionQuestions tempQuestion = db.MissionsQuestion.Find(missionQuestionID);
int tempMissionIDs = missionID;
string tempAnswer = form["Answer"].ToString();
tempQuestion.Answer = tempAnswer;
db.Entry(tempQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("SingleMission", "Missions", new { missionID = tempMissionIDs }));
}
public ActionResult Edit([Bind(Include = "missionQuestionID,question,answer,missionID,userID")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Asked", "Action", new { id = missionQuestions.missionID }));
}
ViewBag.missionID = new SelectList(db.Mission, "missionID", "missionName", missionQuestions.missionID);
ViewBag.userID = new SelectList(db.Users, "userID", "userEmail", missionQuestions.userID);
return(View(missionQuestions));
}
public ActionResult MissionPage(FormCollection answer, int?question_ID, int?mission_ID)
{
MissionQuestions myQuestion = db.MissionQuestion.Find(question_ID);
myQuestion.answer = answer["answer" + question_ID];
string fullname = TempData["firstname"].ToString() + " " + TempData["lastname"].ToString();
myQuestion.user_ID = fullname;
db.SaveChanges();
return(RedirectToAction("MissionPage", new { mission_ID = myQuestion.mission_ID }));
}
public ActionResult Create([Bind(Include = "MissionQuestionID,MissionID,UserID,MissionQuestion,MissionAnswer")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MissionID = new SelectList(db.Missions, "MissionID", "MissionName", missionQuestions.MissionID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "UserEmail", missionQuestions.UserID);
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "question")] MissionQuestions newQuestion)
{
newQuestion.userID = usID;
newQuestion.missionID = missID;
newQuestion.answer = "";
if (ModelState.IsValid)
{
db.MissionQuestions.Add(newQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newQuestion));
}
public ActionResult EditQuestionAnswer(MissionQuestions model)
{
db.Database.ExecuteSqlCommand(
"UPDATE MissionQuestions " +
"SET Answer = '" + model.Answer +
"' WHERE MissionQuestionID = " + model.MissionQuestionID);
Missions redirectMission = new Missions();
redirectMission.MissionID = model.MissionID;
return(RedirectToAction("RedirectToMission", new { missionID = model.MissionID }));
}
public ActionResult Create([Bind(Include = "missionQuestionID,missionQuestion,userID,missionID")] MissionQuestions missionQuestions)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("Index", "Home", null));
}
ViewBag.userID = User.Identity.GetUserName();
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestions.missionID);
return(View(missionQuestions));
}
// GET: MissionQuestions/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
MissionQuestions missionQuestions = db.MissionQuestions.Find(id);
if (missionQuestions == null)
{
return HttpNotFound();
}
return View(missionQuestions);
}
public ActionResult postQuestion(FormCollection form)
{
int tempMissionIDs = Convert.ToInt32(form["hdnMission"]);
int tempUserID = 1;
string tempQuestion = form["Question"].ToString();
string tempAnswer = "No answer has been given.";
MissionQuestions temp = new MissionQuestions {
MissionID = tempMissionIDs, UserID = tempUserID, Question = tempQuestion, Answer = tempAnswer
};
db.MissionsQuestion.Add(temp);
db.SaveChanges();
return(RedirectToAction("SingleMission", "Missions", new { missionID = tempMissionIDs }));
}
// GET: MissionQuestions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MissionQuestions missionQuestions = db.MissionQuestion.Find(id);
if (missionQuestions == null)
{
return(HttpNotFound());
}
return(View(missionQuestions));
}
