public ActionResult Score()
{
if ((Session["User"] == null) || ((bool)Session["Finshed"] == false)) //Checks that a User is logged in and All the questions have been answered.
{
return(Redirect("../Home/Index")); //return Redirect used instead of return View because Return View simply displays the View without calling the relevant controller method causing the page to be static.
}
else
{
QuestionDB questions = (QuestionDB)Session["Questions"]; //The QuestionDB instance is set from the Session Questions
QuizDBDataContext db = new QuizDBDataContext(); //Creates a instance of the Database
tblResult result = new tblResult //Creates a new instance of tblResult to be saved into the Database
{
PlayerID = (int)Session["UserID"], //Sets the PlayerID from the ID stored in the Session
Score = questions.QuestionRoundScore(), //Sets the Score for the round as well as the current DateTime stamp
ResultDateTime = DateTime.Now
};
db.tblResults.InsertOnSubmit(result);
try //Try catch used to submit the changes to the Database
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
ViewBag.TotalScore = questions.TotalScore();
return(View("Score"));
}
}
public ActionResult Register(string Username, string passWord)
{
QuizDBDataContext db = new QuizDBDataContext(); //Creates a instance of the Database
tblPlayer player = new tblPlayer //Creates a new instance of tblPlayer to be added to the DataBase
{
PlayerName = Username,
PlayerPassword = passWord
};
db.tblPlayers.InsertOnSubmit(player);
try //Try catch statement used to save the new User into the DataBase
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e); //Writes the Error to the console
}
return(Redirect("Login")); //return Redirect used instead of return View because Return View simply displays the View without calling the relevant controller method causing the page to be static.
}
