private void AddResponse(QuestionnaireResponse response)
{
foreach (QuestionnaireQuestion question in Questions)
{
if (question.QuestionID == response.QuestionID)
{
question.Response = response;
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);
}
}
