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);
}
public List <QuizQuestion> getAllQuizQuestionByQuizID(int quizID)
{
SqlConnection conn = new SqlConnection();
List <QuizQuestion> toReturn = new List <QuizQuestion>();
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 [QuizQuestion] where quizID=@quizID";
comm.Parameters.AddWithValue("@quizID", quizID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
QuizQuestion qq = new QuizQuestion();
qq.setQuizQuestionID((int)dr["quizQuestionID"]);
qq.setQuestion((string)dr["question"]);
QuizDAO qDAO = new QuizDAO();
qq.setQuiz(qDAO.getQuizByID((int)dr["quizID"]));
QuizAnswerDAO qaDAO = new QuizAnswerDAO();
qq.setQuizAnswer(qaDAO.getCorrectQuizAnswerByID((int)dr["correctAnswerID"]));
toReturn.Add(qq);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
