private void AddAnswer(QuestionnaireAnswer answer) { foreach (QuestionnaireQuestion question in Questions) { if (question.QuestionID == answer.QuestionID) { question.Answers.Add(answer); break; } } }
private void GetData() { /*** get questions ***/ DataCommand command = new DataCommand("spGetQuestionnaireQuestions"); DataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { QuestionnaireQuestion question = new QuestionnaireQuestion(dataReader); if (!question.Enabled) { continue; } Questions.Add(question); } /*** get question groups ***/ command = new DataCommand("spGetQuestionnaireQuestionGroups"); dataReader = command.ExecuteReader(); while (dataReader.Read()) { QuestionnaireQuestionGroup questionGroup = new QuestionnaireQuestionGroup(dataReader); AddQuestionGroup(questionGroup); } /*** get answer types ***/ command = new DataCommand("spGetQuestionnaireAnswerTypes"); dataReader = command.ExecuteReader(); while (dataReader.Read()) { QuestionnaireAnswerType answerType = new QuestionnaireAnswerType(dataReader); AddAnswerType(answerType); } /*** get answers ***/ command = new DataCommand("spGetQuestionnaireAnswers"); dataReader = command.ExecuteReader(); while (dataReader.Read()) { QuestionnaireAnswer answer = new QuestionnaireAnswer(dataReader); AddAnswer(answer); } /*** get questionnaire responses ***/ command = new DataCommand("spGetQuestionnaireResponses"); command.AddParameter("@jurorId", JurorID); dataReader = command.ExecuteReader(); while (dataReader.Read()) { QuestionnaireResponse response = new QuestionnaireResponse(dataReader); AddResponse(response); } }