public ArrayList readAllQuestionsToAnswer() { ArrayList allQTA = new ArrayList(); string query = "SELECT * FROM QuestionsToAnswer"; conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { QuestionToAnswer qta = new QuestionToAnswer(re["QuestionToAnswerID"].ToString(), re["IssuedHomeworkID"].ToString(), re["QuestionText"].ToString(), re["QuestionNumber"].ToString(), re["MarksForQuestion"].ToString(), re["Answer"].ToString(), re["Results"].ToString(), re["Feedback"].ToString()); allQTA.Add(qta); } conn.Close(); return(allQTA); }
public QuestionToAnswer readMarkedQuestion(string id, string qNum) { string query = "SELECT * FROM QuestionsToAnswer WHERE IssuedHomeworkID = " + id + " AND QuestionNumber = " + qNum; QuestionToAnswer selectedQuestionToAnswer = new QuestionToAnswer(); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { selectedQuestionToAnswer = new QuestionToAnswer(re["QuestionToAnswerID"].ToString(), re["IssuedHomeworkID"].ToString(), re["QuestionText"].ToString(), re["QuestionNumber"].ToString(), re["MarksForQuestion"].ToString(), re["Answer"].ToString(), re["Results"].ToString(), re["Feedback"].ToString()); } conn.Close(); return(selectedQuestionToAnswer); }
public QuestionToAnswer readSelectedQuestionToAnswer(string id) { string query = "SELECT * FROM QuestionsToAnswer WHERE QuestionToAnswerID = @id"; QuestionToAnswer selectedQuestionToAnswer = new QuestionToAnswer(); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { selectedQuestionToAnswer = new QuestionToAnswer(re["QuestionToAnswerID"].ToString(), re["IssuedHomeworkID"].ToString(), re["QuestionText"].ToString(), re["QuestionNumber"].ToString(), re["MarksForQuestion"].ToString(), re["Answer"].ToString(), re["Results"].ToString(), re["Feedback"].ToString()); } conn.Close(); return(selectedQuestionToAnswer); }
public ArrayList readSelectedQuestionInHomework(string id) { string query = "SELECT * FROM QuestionsToAnswer WHERE IssuedHomeworkID = @id"; ArrayList selectedQuestionToAnswer = new ArrayList(); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { QuestionToAnswer thisQuestion = new QuestionToAnswer(re["QuestionToAnswerID"].ToString(), re["IssuedHomeworkID"].ToString(), re["QuestionText"].ToString(), re["QuestionNumber"].ToString(), re["MarksForQuestion"].ToString()); selectedQuestionToAnswer.Add(thisQuestion); } conn.Close(); return(selectedQuestionToAnswer); }