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 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));
}
public ActionResult Create([Bind(Include = "MissionID,Designation,Description")] Mission mission)
{
if (ModelState.IsValid)
{
db.Missions.Add(mission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mission));
}
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 Create([Bind(Include = "MissionID,missionName,missionPresidentsName,missionAddress,language,climate,dominantReligion,flagSymbol")] Mission mission)
{
if (ModelState.IsValid)
{
db.Missions.Add(mission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mission));
}
public ActionResult Create([Bind(Include = "userID,userEmail,password,firstName,lastName")] Users users)
{
if (ModelState.IsValid)
{
db.Users.Add(users);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(users));
}
public ActionResult Create([Bind(Include = "AstronautID,Name,Birthday,Nationality")] Astronaut astronaut)
{
if (ModelState.IsValid)
{
db.Astronauts.Add(astronaut);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Nationality = new SelectList(db.Countries, "CountryID", "CountryName", astronaut.Nationality);
return(View(astronaut));
}
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,question,answer")] 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));
}
public ActionResult Create([Bind(Include = "CrewID,Astronaut,Mission,Position")] Crew crew)
{
if (ModelState.IsValid)
{
db.Crews.Add(crew);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Astronaut = new SelectList(db.Astronauts, "AstronautID", "Name", crew.Astronaut);
ViewBag.Mission = new SelectList(db.Missions, "MissionID", "Designation", crew.Mission);
return(View(crew));
}
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 Create([Bind(Include = "MissionQuestionID,MissionID,UserID,Question,Answer")] MissionQuestions missionQuestions, int?id)
{
if (ModelState.IsValid)
{
missionQuestions.MissionID = id;
db.MissionQuestion.Add(missionQuestions);
db.SaveChanges();
return(RedirectToAction("FAQ", "Missions", id));
}
ViewBag.MissionID = new SelectList(db.Mission, "MissionID", "MissionName", missionQuestions.MissionID);
ViewBag.UserID = new SelectList(db.User, "UserID", "UserEmail", missionQuestions.UserID);
return(View(missionQuestions));
}
public ActionResult Create([Bind(Include = "USER_ID,USER_EMAIL,PASSWORD,FIRST_NAME,LAST_NAME")] Users users, int missionID)
{
if (ModelState.IsValid)
{
db.users.Add(users);
db.SaveChanges();
FormsAuthentication.SetAuthCookie(users.USER_EMAIL, false);
return(RedirectToAction("Index", "MissionQuestions", new { missionID = missionID, id = users.USER_ID }));
}
return(View(users));
}
public ActionResult CreateAccount([Bind(Include = "userID,userEmail,password,firstName,lastName")] Users user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
var currentUser =
db.Database.SqlQuery <Users>(
"Select * " +
"FROM Users " +
"WHERE userEmail = '" + user.userEmail + "' AND " +
"password = '******'");
if (currentUser.Count() > 0)
{
FormsAuthentication.SetAuthCookie(user.userEmail, false);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View());
}
}
return(View(user));
}
public ActionResult NewQuestion(FormCollection form, int id)
{
if (form["question"] != null && form["question"] != String.Empty)
{
//new question object
MissionQuestions question = new MissionQuestions();
question.MissionID = id;
question.Question = form["question"];
question.UserID = User.Identity.Name;
//add question to database
db.MissionQuestions.Add(question);
db.SaveChanges();
}
//knows what mission to display
return(RedirectToAction("Faqs", routeValues: new { id = id }));
}
public ActionResult CreateQuestion([Bind(Include = "Mission_Question_ID, Mission_ID, User_ID, Question, Answer")] Mission_Questions mqID)
{
mqID.Mission_ID = missionID;
mqID.User_ID = userID;
mqID.Answer = "";
if (ModelState.IsValid)
{
//add entry
db.Mission_Questions.Add(mqID);
//edit entries
//db.Entry(wo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mqID));
}
public ActionResult SignUp([Bind(Include = "UserID,UserEmail,Password,FirstName,LastName")] Users users, bool rememberMe = false)
{
if (ModelState.IsValid)
{
db.User.Add(users);
db.SaveChanges();
FormsAuthentication.SetAuthCookie(users.UserEmail, rememberMe);
return(RedirectToAction("Index", "Home", new { userlogin = users.UserEmail }));
}
return(View(users));
}
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));
}
public ActionResult CreateUser([Bind(Include = "User_ID, User_Email, User_Password, First_Name, Last_Name")] Users user)
{
if (ModelState.IsValid)
{
//add entry
db.Users.Add(user);
//edit entries
//db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "missionID,missionName,presidentName,missionAddress,missionLanguage,missionClimate,missionDominateReligion")] Mission mission)
{
if (ModelState.IsValid)
{
db.Mission.Add(mission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mission));
}
public ActionResult SignUp(Users newUser)
{
db.Users.Add(newUser);
db.SaveChanges();
return(RedirectToAction("Index", "Missions"));
}
