internal List <QuestionInstance> GetQuestionInstances(int quizInstanceId)
{
var command = new SqlCommand();
command.CommandText = @"SELECT * FROM QuestionInstance
WHERE QuizInstanceId=@QuizInstanceId";
command.Parameters.AddWithValue("@QuizInstanceId", quizInstanceId);
DBContestant dbContestant = new DBContestant();
List <QuestionInstance> questionInstances = repository.MultiRead(command);
foreach (QuestionInstance obj in questionInstances)
{
obj.CorrectAnswer = dbContestant.GetContestant(quizInstanceId, obj.QuestionId);
obj.WrongAnswers = dbContestant.GetContestants(obj.QuizInstanceId, obj.QuestionId);
}
return(questionInstances);
}
/// <summary>
/// Used in the performance test for QuestionViewModel
/// </summary>
/// <param name="contestantId"></param>
/// <param name="quizInstanceId"></param>
/// <returns></returns>
public List <QuestionInstance> GetQuestionInstances(int quizInstanceId, Guid contestantId)
{
List <QuestionInstance> questionInstances = new List <QuestionInstance>();
var command = new SqlCommand();
command.CommandText = @"SELECT * FROM QuestionInstance
WHERE QuizInstanceId=@QuizInstanceId";
command.Parameters.AddWithValue("@QuizInstanceId", quizInstanceId);
QuestionInstance questionInstance = new QuestionInstance();
DBContestant dbContestant = new DBContestant();
foreach (QuestionInstance obj in repository.MultiRead(command))
{
questionInstance.CorrectAnswer = dbContestant.GetContestant(quizInstanceId, questionInstance.QuestionId);
questionInstance.WrongAnswers = dbContestant.GetContestants(questionInstance.QuizInstanceId, questionInstance.QuestionId);
questionInstances.Add(questionInstance);
}
return(questionInstances);
}
