public Boolean createQuizResultHistory(QuizResultHistory qrh) // Insert.
{
SqlConnection conn = null;
Boolean toReturn = false;
try
{
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "Insert into [QuizResultHistory] (userID, quizQuestionID, quizAnswerID, attempt, quizID) VALUES (@userID, @quizQuestionID, @quizAnswerID, @attempt, @quizID)";
comm.Parameters.AddWithValue("@userID", qrh.getUserID());
comm.Parameters.AddWithValue("@quizQuestionID", qrh.getQuestion().getQuizQuestionID());
comm.Parameters.AddWithValue("@quizAnswerID", qrh.getAnswer().getQuizAnswerID());
comm.Parameters.AddWithValue("@attempt", qrh.getAttempt());
comm.Parameters.AddWithValue("@quizID", qrh.getQuizID());
int rowsAffected = comm.ExecuteNonQuery();
toReturn = true;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (rblAnswers.SelectedIndex != -1)
{
int quizID = Convert.ToInt32(Request.QueryString["id"]);
User currentUser = (User)Session["currentUser"];
//handle question counter
int counter = (int)Session["questionCounter"];
counter++;
lblQnNum.Text = counter.ToString();
Session["questionCounter"] = counter;
//handle remaining questions
List <QuizQuestion> remainingQuestions = (List <QuizQuestion>)Session["remainingQuestions"];
remainingQuestions.RemoveAt(0);
Session["remainingQuestions"] = remainingQuestions;
//handle current question and answer
QuizResultHistory currentAnswer = new QuizResultHistory();
QuizResultHistoryDAO qrhDAO = new QuizResultHistoryDAO();
QuizQuestionDAO qqDAO = new QuizQuestionDAO();
QuizQuestion currentQuestion = (QuizQuestion)Session["previousQuestion"];
QuizAnswer currentSelectedAnswer = new QuizAnswer(Convert.ToInt32(rblAnswers.SelectedValue), currentQuestion, rblAnswers.SelectedItem.Text);
int attempt = qrhDAO.getAttemptForQuiz(currentQuestion.getQuizQuestionID());
attempt++;
currentAnswer.setAttempt(attempt);
currentAnswer.setUserID(currentUser.getUserID());
currentAnswer.setQuestion(currentQuestion);
currentAnswer.setAnswer(currentSelectedAnswer);
currentAnswer.setQuizID(quizID);
List <QuizResultHistory> userAnswers = (List <QuizResultHistory>)Session["userAnswers"];
userAnswers.Add(currentAnswer);
Session["userAnswers"] = userAnswers;
if (remainingQuestions.Count > 0)
{
//handle displaying next qn
QuizQuestion nextQuestion = remainingQuestions[0];
Session["previousQuestion"] = nextQuestion;
QuizAnswerDAO qaDAO = new QuizAnswerDAO();
List <QuizAnswer> nextPossibleAnswers = qaDAO.getAllQuizAnswersByQuizQuestionID(nextQuestion.getQuizQuestionID());
lblQuestion.Text = nextQuestion.getQuestion();
rblAnswers.Items.Clear();
foreach (QuizAnswer qa in nextPossibleAnswers)
{
rblAnswers.Items.Add(new ListItem(qa.getAnswer(), qa.getQuizAnswerID().ToString()));
}
}
if (remainingQuestions.Count == 1)
{
btnFinish.Visible = true;
btnNext.Visible = false;
}
}
}
public List <QuizResultHistory> getAllQuizResultHistoryByQuizIDandAttempt(int attempt, int quizID)
{
SqlConnection conn = new SqlConnection();
List <QuizResultHistory> toReturn = new List <QuizResultHistory>();
try
{
conn = new SqlConnection();
string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();
conn.ConnectionString = connstr;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "select * from [QuizResultHistory] where attempt=@attempt and quizID=@quizID";
comm.Parameters.AddWithValue("@attempt", attempt);
comm.Parameters.AddWithValue("quizID", quizID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
QuizResultHistory qrh = new QuizResultHistory();
qrh.setUserID((string)dr["userID"]);
QuizQuestionDAO qqDAO = new QuizQuestionDAO();
QuizAnswerDAO qaDAO = new QuizAnswerDAO();
qrh.setQuestion(qqDAO.getQuizQuestionByID((int)dr["quizQuestionID"]));
qrh.setAnswer(qaDAO.getQuizAnswerByID((int)dr["quizAnswerID"]));
qrh.setAttempt((int)dr["attempt"]);
qrh.setQuizID((int)dr["quizID"]);
toReturn.Add(qrh);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
protected void btnFinish_Click(object sender, EventArgs e)
{
if (rblAnswers.SelectedIndex != -1)
{
int quizID = Convert.ToInt32(Request.QueryString["id"]);
User currentUser = (User)Session["currentUser"];
//handle current question and answer
QuizDAO quizDAO = new QuizDAO();
QuizResultDAO qrDAO = new QuizResultDAO();
QuizResultHistory currentAnswer = new QuizResultHistory();
QuizResultHistoryDAO qrhDAO = new QuizResultHistoryDAO();
QuizQuestionDAO qqDAO = new QuizQuestionDAO();
QuizQuestion currentQuestion = (QuizQuestion)Session["previousQuestion"];
Quiz currentQuiz = quizDAO.getQuizByID(quizID);
QuizAnswer currentSelectedAnswer = new QuizAnswer(Convert.ToInt32(rblAnswers.SelectedValue), currentQuestion, rblAnswers.SelectedItem.Text);
//int attempt = qrhDAO.getAttemptForQuiz(currentQuestion.getQuizQuestionID());
int attempt = qrDAO.getAttemptForQuiz(quizID, currentUser.getUserID());
attempt++;
currentAnswer.setAttempt(attempt);
currentAnswer.setUserID(currentUser.getUserID());
currentAnswer.setQuestion(currentQuestion);
currentAnswer.setAnswer(currentSelectedAnswer);
currentAnswer.setQuizID(quizID);
List <QuizResultHistory> userAnswers = (List <QuizResultHistory>)Session["userAnswers"];
userAnswers.Add(currentAnswer);
//to calculate score
int userScore = calculateScore(userAnswers);
//to get all other details needed to insert to QuizResult
string grade = "fail";
if (checkIfUserPass(quizID, userScore))
{
grade = "pass";
}
DateTime currentDate = DateTime.Now.Date;
//insert quizResultHistory
foreach (QuizResultHistory qrh in userAnswers)
{
qrhDAO.createQuizResultHistory(qrh);
}
//insert QuizResult
int quizResultID = qrDAO.createQuizResult(currentUser.getUserID(), quizID, userScore, grade, currentDate, attempt);
string displayAnswer = currentQuiz.getDisplayAnswer();
if (displayAnswer.Equals("always"))
{
Response.Redirect("viewResults.aspx?id=" + quizResultID);
}
else if (displayAnswer.Equals("never"))
{
Response.Redirect("noResult.aspx?id=" + quizResultID);
}
else
{
if (grade.Equals("pass"))
{
Response.Redirect("viewResults.aspx?id=" + quizResultID);
}
else
{
Response.Redirect("viewMyResult.aspx?id=" + quizResultID);
}
}
}
}