public ActionResult Reply(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var mission =
db.Database.SqlQuery <Mission>(
"Select * " +
"FROM Mission " +
"WHERE MissionName = '" + currentMissionName + "'");
MissionQuestion missionQuestion = db.MissionQuestions.Find(id);
missionQuestion.MissionID = mission.First().MissionID;
//Need to assign UserID here once login has been set up
if (missionQuestion == null)
{
return(HttpNotFound());
}
return(View(missionQuestion));
}
public ActionResult DeleteConfirmed(int id)
{
MissionQuestion missionQuestion = db.MissionQuestions.Find(id);
db.MissionQuestions.Remove(missionQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "missionQuestionID,missionID,userID,question,answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestion).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("FAQs", new { id = missionQuestion.missionID }));
}
public ActionResult Edit([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Ansswer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("QuestionPage", "UserMissionQuestions", new { id = missionQuestion.MissionID }));
}
return(View(missionQuestion));
}
public ActionResult Edit([Bind(Include = "missionQuestionID,userID,question,answer,missionID")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
return(View(missionQuestion));
}
public ActionResult Reply([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("FAQ"));
}
return(View(missionQuestion));
}
public ActionResult Create([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Ansswer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("QuestionPage", "UserMissionQuestions", new { id = missionQuestion.MissionID }));
}
return(View(missionQuestion));
}
public ActionResult Create([Bind(Include = "missionQuestionID,userID,question,answer,missionID")] MissionQuestion missionQuestion, int?id)
{
if (ModelState.IsValid)
{
missionQuestion.missionID = id;
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("FAQs", new { id = missionQuestion.missionID }));
}
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
return(View(missionQuestion));
}
public ActionResult Create([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MissionID = new SelectList(db.Missions, "MissionID", "MissionName", missionQuestion.MissionID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "UserEmail", missionQuestion.UserID);
return(View(missionQuestion));
}
// GET: MissionQuestions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MissionQuestion missionQuestion = db.MissionQuestions.Find(id);
if (missionQuestion == null)
{
return(HttpNotFound());
}
return(View(missionQuestion));
}
// GET: MissionQuestions/Create
public ActionResult Create(int MissionID)
{
IEnumerable <MissionQuestion> MaxID = db.Database.SqlQuery <MissionQuestion>(
@"Select *
FROM MissionQuestion"
);
MissionQuestion CreateQuestion = new MissionQuestion();
CreateQuestion.MissionQuestionID = MaxID.Count() + 1;
CreateQuestion.MissionID = MissionID;
return(View(CreateQuestion));
}
// GET: MissionQuestions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MissionQuestion missionQuestion = db.MissionQuestions.Find(id);
if (missionQuestion == null)
{
return(HttpNotFound());
}
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
return(View(missionQuestion));
}
public ActionResult AskQuestions(MissionQuestion missionQuestion)
{
int user = db.Database.SqlQuery <int>("" +
"SELECT * FROM Users" +
"WHERE Users.userEmail = " + User.Identity.Name).FirstOrDefault();
missionQuestion.userID = user;
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
ViewBag.userID = new SelectList(db.Users, "userID", "userEmail", missionQuestion.userID);
return(View(missionQuestion));
}
public ActionResult Edit([Bind(Include = "missionquestionID,missionID,userID,question,answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.Entry(missionQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
db.Database.ExecuteSqlCommand("" +
"UPDATE MissionQuestions " +
"SET answer = '" + missionQuestion.answer + "'" +
"WHERE missionID = " + missionQuestion.missionID + "" +
"AND missionquestionID = " + missionQuestion.missionquestionID + "");
return(RedirectToAction("ViewQuestions", "FAQ", new { id = missionQuestion.missionID }));
//ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
//ViewBag.userID = new SelectList(db.Users, "userID", "userEmail", missionQuestion.userID);
//return View(missionQuestion);
}
public ActionResult PostQuestion([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
var mission =
db.Database.SqlQuery <Mission>(
"Select * " +
"FROM Mission " +
"WHERE MissionName = '" + currentMissionName + "'");
missionQuestion.MissionID = mission.First().MissionID;
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("MissionView"));
}
return(View(missionQuestion));
}
public ActionResult Create([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
// Make the userID the same as the current user
// Find the user first
string userToFind = User.Identity.Name;
User originalUser = db.Users.FirstOrDefault(x => x.UserEmail == userToFind);
missionQuestion.UserID = originalUser.UserID;
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MissionID = new SelectList(db.Missions, "MissionID", "MissionName", missionQuestion.MissionID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "UserEmail", missionQuestion.UserID);
return(View(missionQuestion));
}
public ActionResult Create([Bind(Include = "missionquestionID,missionID,userID,question,answer")] MissionQuestion missionQuestion)
{
if (ModelState.IsValid)
{
db.MissionQuestions.Add(missionQuestion);
db.SaveChanges();
Mission missions = db.Missions.Find(missionQuestion.missionID);
return(RedirectToAction("Missions", "FAQ", new { id = missions.missionID }));
}
int user = db.Database.SqlQuery <int>("" +
"SELECT * FROM Users" +
"WHERE Users.userEmail = " + User.Identity.Name).FirstOrDefault();
db.Database.ExecuteSqlCommand("" +
"INSERT INTO MissionQuestions (missionID, userID, question) " +
"VALUES(" + missionQuestion.missionID + ", " + user + ", '" + missionQuestion.question + "')" +
"" +
"");
return(RedirectToAction("Index"));
//ViewBag.missionID = new SelectList(db.Missions, "missionID", "missionName", missionQuestion.missionID);
//ViewBag.userID = new SelectList(db.Users, "userID", "userEmail", missionQuestion.userID);
//return View(missionQuestion);
}
