public List <QuestionClass> getQuestions()
{
List <QuestionClass> questions = new List <QuestionClass>();
conn.Open();
cmd = new SqlCommand("SELECT * FROM Question", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
QuestionClass question = new QuestionClass();
question.qId = reader.GetInt32(0);
question.statement = reader.GetString(1);
question.username = reader.GetString(2);
question.catId = reader.GetInt32(3);
question.qPostTime = reader.GetDateTime(4);
questions.Add(question);
}
conn.Close();
return(questions);
}
public List <QuestionClass> getQuestionsAsPerCategory(int catId)
{
List <QuestionClass> questions = new List <QuestionClass>();
conn.Open();
cmd = new SqlCommand("SELECT * FROM Question WHERE CategoryId=@catId", conn);
cmd.Parameters.AddWithValue("catId", catId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
QuestionClass question = new QuestionClass();
question.qId = reader.GetInt32(0);
question.statement = reader.GetString(1);
question.username = reader.GetString(2);
question.catId = reader.GetInt32(3);
question.qPostTime = reader.GetDateTime(4);
questions.Add(question);
}
conn.Close();
return(questions);
}
