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);
}
