protected void Page_Load(object sender, EventArgs e)
{
#region This page is restricted to those who have signed in to take a test
if ((string)Session["TakingTest"] != "true")
{
// If the session state is lost, check for the existence of a backup cookie
HttpCookie SessionBackup = Request.Cookies.Get("FCSdata");
if (SessionBackup != null)
{
string[] FCSdata = Global.Decrypt(SessionBackup.Value).Split(';');
if (FCSdata[0] == "true")
{
Session["ConferenceID"] = FCSdata[1];
Session["RegionalTestsID"] = FCSdata[2];
Session["MemberID"] = FCSdata[3];
Session["Name"] = FCSdata[4];
Session["EventID"] = FCSdata[5];
Session["EventType"] = FCSdata[6];
}
else
{
// If the cookie is not valid, go to login in page
Server.Transfer("default.aspx");
}
}
else
{
// If the cookie is missing , go to login in page
Server.Transfer("default.aspx");
}
}
// Display menu
((SiteMapDataSource)Master.FindControl("FCSSiteMapData")).StartingNodeUrl = "#TakingTest";
((Menu)Master.FindControl("FCSMenu")).DataBind();
#endregion
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConfDB"].ToString());
SqlCommand sqlCmd = new SqlCommand("", cnn);
cnn.Open();
if (!IsPostBack)
{
#region Get the name of the conference and the event being tested on
SqlDataAdapter sqlConfEvent = new SqlDataAdapter(
"SELECT ConferenceName, EventName, EventType FROM Conferences INNER JOIN NationalEvents E ON" +
" E.EventID=" + Session["EventID"] + " WHERE ConferenceID=" + Session["ConferenceID"], cnn);
DataTable tblConfEvent = new DataTable();
sqlConfEvent.Fill(tblConfEvent);
lblConferenceName.Text = tblConfEvent.Rows[0]["ConferenceName"].ToString();
lblEventName.Text = tblConfEvent.Rows[0]["EventName"].ToString();
Session["EventType"] = tblConfEvent.Rows[0]["EventType"].ToString();
// As a backup of the session state, store an encrypted cookie
HttpCookie cookie = new HttpCookie("FCSdata");
cookie.Value = Global.Encrypt("true;" +
Session["ConferenceID"].ToString() + ";" +
Session["RegionalTestsID"].ToString() + ";" +
Session["MemberID"].ToString() + ";" +
Session["Name"].ToString() + ";" +
Session["EventID"].ToString() + ";" +
Session["EventType"].ToString());
Response.Cookies.Add(cookie);
#endregion
#region Determine if the student is re-entering the test by seeing if they have an elapsed time for this event
sqlCmd.CommandText =
"SELECT ElapsedTime=ISNULL(ObjectiveElapsedTime,0) FROM ConferenceMemberEvents " +
"WHERE ConferenceID=" + Session["ConferenceID"] +
" AND EventID=" + Session["EventID"] +
" AND MemberID=" + Session["MemberID"];
int ElapsedTime = (Int32)sqlCmd.ExecuteScalar();
#endregion
#region Initialize new test
Session.Remove("Questions");
if (ElapsedTime == 0)
{
// Assign a default score to indicate that the test has been taken
// For team events, update the objective score for all team members; otherwise, just update the member's individual score
string sqlMember;
if (Session["EventType"].ToString() == "T")
{
sqlMember =
"MemberID IN (SELECT TM.MemberID FROM ConferenceMemberEvents CME" +
" INNER JOIN NationalMembers M ON CME.MemberID=M.MemberID" +
" INNER JOIN ConferenceMemberEvents TEAM ON CME.ConferenceID=TEAM.ConferenceID AND CME.EventID=TEAM.EventID AND CME.TeamName=TEAM.TeamName" +
" INNER JOIN NationalMembers TM ON TEAM.MemberID=TM.MemberID AND M.ChapterID=TM.ChapterID " +
"WHERE" +
" CME.ConferenceID=" + Session["ConferenceID"] +
" AND CME.EventID=" + Session["EventID"] +
" AND CME.MemberID=" + Session["MemberID"] + ")";
}
else
{
sqlMember = "MemberID=" + Session["MemberID"];
}
// Give team members a default score of -9
sqlCmd.CommandText =
"UPDATE ConferenceMemberEvents SET ObjectiveScore=-9 " +
"WHERE ConferenceID=" + Session["ConferenceID"] + " AND EventID=" + Session["EventID"] + " AND " + sqlMember;
sqlCmd.ExecuteNonQuery();
// Give the person who signed in a default score of -10
sqlCmd.CommandText =
"UPDATE ConferenceMemberEvents SET ObjectiveScore=-10 " +
"WHERE ConferenceID=" + Session["ConferenceID"] + " AND EventID=" + Session["EventID"] + " AND MemberID=" + Session["MemberID"];
sqlCmd.ExecuteNonQuery();
// Set Testing Time for only the person who is signed in for the test -- for team events, this is just one of the team members
sqlCmd.CommandText =
"UPDATE ConferenceMemberEvents SET TestingTime=SYSDATETIME()" +
" WHERE ConferenceID=" + Session["ConferenceID"] + " AND EventID=" + Session["EventID"] + " AND MemberID=" + Session["MemberID"];
sqlCmd.ExecuteNonQuery();
// Delete any previous test responses for this event for this member, just in case
sqlCmd.CommandText =
"DELETE R FROM TestResponses R INNER JOIN TestQuestions Q ON R.QuestionID=Q.QuestionID " +
"WHERE ConferenceID=" + Session["ConferenceID"] + " AND EventID=" + Session["EventID"] + " AND MemberID=" + Session["MemberID"];
sqlCmd.ExecuteNonQuery();
// Generate default answers for this test for this member
sqlCmd.CommandText =
"INSERT INTO TestResponses" +
" SELECT MemberID=" + Session["MemberID"] + ", ConferenceID=" + Session["ConferenceID"] + ", QuestionID, Response=5" +
" FROM TestQuestions Q" +
" WHERE Q.RegionalTestsID=" + Session["RegionalTestsID"] + " AND Q.EventID=" + Session["EventID"];
sqlCmd.ExecuteNonQuery();
// Start the test time limit countdown
Session["TestTimeLimit"] = DateTime.Now.AddMinutes(60);
}
#endregion
#region Re-enter a test in progress
if (ElapsedTime != 0)
{
// If there is a non-zero elapsed time, then the student is re-entering a test already in progress.
// The TestResponses table contains all the answers they've entered so far.
// We just need to reset the objective score (in case it's been set to -1) and set the countdown clock to give them as much time as they had remaining.
sqlCmd.CommandText =
"UPDATE ConferenceMemberEvents SET ObjectiveScore=-10 " +
"WHERE ConferenceID=" + Session["ConferenceID"] + " AND EventID=" + Session["EventID"] + " AND MemberID=" + Session["MemberID"];
sqlCmd.ExecuteNonQuery();
TimeSpan time1 = new TimeSpan(0, 0, 0, 0, ElapsedTime);
Session["TestTimeLimit"] = DateTime.Now.AddMinutes(60).Subtract(time1);
}
#endregion
#region Populate the form with the questions for this test and the responses for this student
sqlTestQuestions.SelectParameters["RegionalTestsID"].DefaultValue = Session["RegionalTestsID"].ToString();
sqlTestQuestions.SelectParameters["ConferenceID"].DefaultValue = Session["ConferenceID"].ToString();
sqlTestQuestions.SelectParameters["EventID"].DefaultValue = Session["EventID"].ToString();
sqlTestQuestions.SelectParameters["MemberID"].DefaultValue = Session["MemberID"].ToString();
sqlTestQuestions.DataBind();
fvTestQuestions.DataBind();
lblCurrentQuestion.Text = (fvTestQuestions.PageIndex + 1).ToString();
lblTotalQuestions.Text = fvTestQuestions.PageCount.ToString();
#endregion
}
#region Every time the page loads, see if we have a cached table containing the current responses; generate one if needed
DataTable tblCurrentResponses = new DataTable();
if (Session["Responses"] == null)
{
SqlDataAdapter sqlQuestionResponses = new SqlDataAdapter(
"SELECT R.* FROM TestResponses R INNER JOIN TestQuestions Q ON R.QuestionID=Q.QuestionID " +
"WHERE Q.EventID=" + Session["EventID"] +
" AND R.ConferenceID=" + Session["ConferenceID"] +
" AND R.MemberID=" + Session["MemberID"], cnn);
sqlQuestionResponses.Fill(tblCurrentResponses);
Session["Responses"] = tblCurrentResponses;
}
else
{
tblCurrentResponses = (DataTable)Session["Responses"];
}
#endregion
#region Every time the page loads, display the number of unanswered questions remaining and how much time is left
DataRow[] NumUnanswered = tblCurrentResponses.Select("Response=5");
lblUnanswered.Text = NumUnanswered.Length.ToString();
Timer1_Tick(null, null);
#endregion
cnn.Close();
}
