public static QuestionWithAnswers GetNextQuestion(long quizId, long previousQuestionId)
{
var tableAdapter = new QuestionTableAdapter();
var dataTable = tableAdapter.GetNextQuestion(previousQuestionId, quizId);
foreach (var row in dataTable) {
var questionWithAnswers = new QuestionWithAnswers
{
Id = row.QuestionId,
QuestionText = row.Text,
QuizId = quizId
};
return questionWithAnswers;
}
return null;
/*using (var connection = new SqlConnection(ConnectionString))
{
var questionWithAnswers = new QuestionWithAnswers();
connection.Open();
var questionCmd =
new SqlCommand("SELECT * FROM Question WHERE QuestionId > @QuestionId AND QuizId = @QuizId",
connection);
questionCmd.Parameters.Add(@"QuestionId", SqlDbType.BigInt).Value = previousQuestionId;
questionCmd.Parameters.Add(@"QuizId", SqlDbType.BigInt).Value = quizId;
questionCmd.Prepare();
var reader = questionCmd.ExecuteReader();
while (reader.Read())
{
questionWithAnswers.Id = (long) reader["QuestionId"];
questionWithAnswers.QuestionText = (string) reader["Text"];
questionWithAnswers.QuizId = (long) reader["QuizId"];
return questionWithAnswers;
}
}
return null;*/
}
