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