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