public ArrayList getAllQuizResultByQuizID(int quizID, string userID)
{
SqlConnection conn = new SqlConnection();
ArrayList toReturn = new ArrayList();
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 [QuizResult] where quizID=@quizID and userID=@userID";
comm.Parameters.AddWithValue("@quizID", quizID);
comm.Parameters.AddWithValue("@userID", userID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
QuizResult qr = new QuizResult();
UserDAO userDAO = new UserDAO();
QuizDAO quizDAO = new QuizDAO();
QuizResultHistoryDAO qrhDAO = new QuizResultHistoryDAO();
qr.setQuizResultID((int)dr["quizResultID"]);
qr.setUser(userDAO.getUserByID((string)dr["userID"]));
qr.setQuiz(quizDAO.getQuizByID((int)dr["quizID"]));
qr.setScore((int)dr["score"]);
qr.setGrade((string)dr["grade"]);
qr.setDateSubmitted(dr.GetDateTime(5));
qr.setAttempt((int)dr["attempt"]);
toReturn.Add(qr);
}
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);
}
