private CustomerAnswerReportDto ReadCustomerAnswerReport(IDataReader reader, ref bool alreadyRead)
{
CustomerAnswerReportDto retval = null;
/*
* int rt.questionnaire_FK,
* long rt.response_id,
* datetime rt.visit_time,
* int rq.choice_FK,
* string c.choice_label,
* string rq.choice_text,
* int? dbo.ISNOTNULL(rq.lov_FK, (SELECT lov_local_name FROM lov_locals WHERE lov_fk = rq.lov_FK AND in_country_FK = @cc AND in_language_FK = @ll)) AS lov_FK,
* int c.questionelement_FK,
* string q.element_type_FK
* */
int questionnaire_FK = reader.GetInt32(0);
long response_id = reader.GetInt64(1);
DateTime visit_time = reader.GetDateTime(2);
int? choice_FK = GetInt32(reader, 3);
string choice_label = GetString(reader, 4);
string choice_text = GetString(reader, 5);
string lov_FK_value = GetString(reader, 6);
int? questionelement_FK = GetInt32(reader, 7);
string element_type_FK = GetString(reader, 8);
int? lov_FK = GetInt32(reader, 9);
//int? lov_FK = GetInt32(reader, 6);
//retval == null choice_fk, questionelement_FK ?
if (choice_FK == null || questionelement_FK == null)
{
retval = null;
}
else
{
retval = new CustomerAnswerReportDto(questionnaire_FK, response_id, visit_time, choice_FK, choice_label, choice_text, lov_FK, questionelement_FK, element_type_FK, lov_FK_value);
}
return retval;
}
public ReportRowDto(BaseDataReportDto baseData, CustomerAnswerReportDto[] dynamicQuestions, ShippingAddressReportDto shippingAddress, QuestionReportDto[] questions)
{
DynamicQuestions = dynamicQuestions;
_shippingAddress = shippingAddress;
BaseData = baseData;
Questions = questions;
}