private BaseDataReportDto ReadBaseData(IDataReader reader, ref bool alreadyRead) { BaseDataReportDto retval = null; /* response_id, responser_id, visit_time, response_time, customer_FK, rpe_personal_title, rpe_first_name, rpe_last_name, rpe_job_code_FK, ISNULL(dbo.ISNOTNULL(rpe_job_code_FK, job_description), rpe_job_siebel63) AS rpe_job_code, rpe_jobtitle, rpe_company_name, rpe_address1, rpe_address2, rpe_address3, rpe_town, rpe_county, rpe_postcode, rpe_country_FK, rpe_email_address, rpe_telephone, rpe_business_code_FK, ISNULL(dbo.ISNOTNULL(rpe_business_code_FK, business_name), rpe_business_siebel63) AS rpe_business_code, rpe_world_size_FK, ISNULL(dbo.ISNOTNULL(rpe_world_size_FK, number_of_employees), rpe_worldsize_siebel63) AS rpe_world_size, rpe_allowance_flag, rpe_flexfield1, rpe_flexfield2, rpe_flexfield3, rpe_flexfield4, rpe_flexfield5, rpe_flexfield6, rpe_flexfield7, rpe_flexfield8, rpe_flexfield9, rpe_flexfield10, rpe_flexfield11, rpe_flexfield12, rpe_flexfield13, rpe_flexfield14, rpe_flexfield15, rpe_pwd, country_FK, language_FK, email_address, first_name, last_name, address1, address2, address3, town, county, postcode, telephone, source_db_id, siebel_con_id, siebel_prosp_id, purl, source_db_name, company_id, company_name, world_size_FK, ISNULL(dbo.ISNOTNULL(world_size_FK, number_of_employees), worldsize_siebel63) AS world_size, job_code_FK, ISNULL(dbo.ISNOTNULL(job_code_FK, job_description), job_siebel63) AS job_code, jobtitle, business_code_FK, ISNULL(dbo.ISNOTNULL(business_code_FK, business_name), business_siebel63) AS business_code, greeting_string, edm_list_indicator, personal_title, allowance_flag, flexfield1, flexfield2, flexfield3, flexfield4, flexfield5, flexfield6, flexfield7, flexfield8, flexfield9, flexfield10, flexfield11, flexfield12, flexfield13, flexfield14, flexfield15, pwd, siebel_campaign_code, ISNULL(contact_by_email, contact_by_email_o) AS contact_by_email, email_pref, contact_by_post, contact_by_phone, mailstop_flag, ISNULL(campaign_code_FK, (SELECT campaign_code_FK FROM questionnaires WHERE questionnaire_id = @questionnaire_id)) AS campaign_code_FK */ long responseId = reader.GetInt64(0); string responserId = reader.GetString(1); DateTime visitTime; DateTime.TryParse(reader.GetString(2), System.Globalization.CultureInfo.GetCultureInfo("de-DE"), System.Globalization.DateTimeStyles.None, out visitTime); DateTime? responseTime = null; string temp = GetString(reader, 3);// GetDateTime(reader, 3); DateTime temp2; if (DateTime.TryParse(temp, System.Globalization.CultureInfo.GetCultureInfo("de-DE"), System.Globalization.DateTimeStyles.None, out temp2)) { responseTime = temp2; } string customerFK = GetString(reader, 4); string rpe_personal_title = GetString(reader, 5); string rpe_first_name = GetString(reader, 6); string rpe_last_name = GetString(reader, 7); string rpe_job_code_FK = GetString(reader, 8); string rpe_job_code = GetString(reader, 9); //rpe_job_code_FK job_description rpe_job_siebel63 string rpe_jobtitle = GetString(reader, 10); string rpe_company_name = GetString(reader, 11); string rpe_address1 = GetString(reader, 12); string rpe_address2 = GetString(reader, 13); string rpe_address3 = GetString(reader, 14); string rpe_town = GetString(reader, 15); string rpe_county = GetString(reader, 16); string rpe_postcode = GetString(reader, 17); string rpe_country_FK = GetString(reader, 18); string rpe_email_address = GetString(reader, 19); string rpe_telephone = GetString(reader, 20); string rpe_business_code_FK = GetString(reader, 21); string rpe_business_code = GetString(reader, 22);//rpe_business_code_FK business_name rpe_business_siebel63 string rpe_world_size_FK = GetString(reader, 23); string rpe_world_size = GetString(reader, 24); string rpe_allowance_flag = GetString(reader, 25); string rpe_flexfield1 = GetString(reader, 26); string rpe_flexfield2 = GetString(reader, 27); string rpe_flexfield3 = GetString(reader, 28); string rpe_flexfield4 = GetString(reader, 29); string rpe_flexfield5 = GetString(reader, 30); string rpe_flexfield6 = GetString(reader, 31); string rpe_flexfield7 = GetString(reader, 32); string rpe_flexfield8 = GetString(reader, 33); string rpe_flexfield9 = GetString(reader, 34); string rpe_flexfield10 = GetString(reader, 35); string rpe_flexfield11 = GetString(reader, 36); string rpe_flexfield12 = GetString(reader, 37); string rpe_flexfield13 = GetString(reader, 38); string rpe_flexfield14 = GetString(reader, 39); string rpe_flexfield15 = GetString(reader, 40); string rpe_pwd = GetString(reader, 41); string country_FK = GetString(reader, 42); string language_FK = GetString(reader, 43); string email_address = GetString(reader, 44); string first_name = GetString(reader, 45); string last_name = GetString(reader, 46); string address1 = GetString(reader, 47); string address2 = GetString(reader, 48); string address3 = GetString(reader, 49); string town = GetString(reader, 50); string county = GetString(reader, 51); string postcode = GetString(reader, 52); string telephone = GetString(reader, 53); string source_db_id = GetString(reader, 54); string siebel_con_id = GetString(reader, 55); string siebel_prosp_id = GetString(reader, 56); string purl = GetString(reader, 57); string source_db_name = GetString(reader, 58); string company_id = GetString(reader, 59); string company_name = GetString(reader, 60); string world_size_FK = GetString(reader, 61); string world_size = GetString(reader, 62);// world_size_FK number_of_employees worldsize_siebel63 string job_code_FK = GetString(reader, 63); string job_code = GetString(reader, 64);// job_code_FK job_description job_siebel63 string jobtitle = GetString(reader, 65); string business_code_FK = GetString(reader, 66); string business_code = GetString(reader, 67); // business_code_FK business_name business_siebel63 string greeting_string = GetString(reader, 68); string edm_list_indicator = GetString(reader, 69); string personal_title = GetString(reader, 70); string allowance_flag = GetString(reader, 71); string flexfield1 = GetString(reader, 72); string flexfield2 = GetString(reader, 73); string flexfield3 = GetString(reader, 74); string flexfield4 = GetString(reader, 75); string flexfield5 = GetString(reader, 76); string flexfield6 = GetString(reader, 77); string flexfield7 = GetString(reader, 78); string flexfield8 = GetString(reader, 79); string flexfield9 = GetString(reader, 80); string flexfield10 = GetString(reader, 81); string flexfield11 = GetString(reader, 82); string flexfield12 = GetString(reader, 83); string flexfield13 = GetString(reader, 84); string flexfield14 = GetString(reader, 85); string flexfield15 = GetString(reader, 86); string pwd = GetString(reader, 87); string siebel_campaign_code = GetString(reader, 88); string contact_by_email = GetString(reader, 89); //contact_by_email contact_by_email_o string email_pref = GetString(reader, 90); string contact_by_post = GetString(reader, 91); string contact_by_phone = GetString(reader, 92); string mailstop_flag = GetString(reader, 93); string campaign_code = GetString(reader, 94);// campaign_code_FK (SELECT campaign_code_FK FROM questionnaires WHERE questionnaire_id = @questionnaire_id)) AS campaign_code_FK string rpe_country_name = GetString(reader, 95); string country_name = GetString(reader, 96); string telephone_country = GetString(reader, 97); string telephone_area = GetString(reader, 98); string telephone_extn = GetString(reader, 99); string fax_country = GetString(reader, 100); string fax_area = GetString(reader, 101); string fax = GetString(reader, 102); string fax_extn = GetString(reader, 103); string mobile_country = GetString(reader, 104); string mobile = GetString(reader, 105); string campaign_language_FK = GetString(reader, 115); string campaign_country_FK = GetString(reader, 116); string preferred_language = GetString(reader, 117); //RFG 2.11 |added by Raju string rpe_company_website = GetString(reader, 118); string rpe_company_revenue = GetString(reader, 119); string rpe_company_revenue_range = GetString(reader, 120); if (customerFK == Constants.UnknownCustomer) {//use rpe retval = new BaseDataReportDto(customerFK, rpe_country_FK, campaign_language_FK, campaign_country_FK, rpe_email_address, rpe_first_name, rpe_last_name, source_db_id, siebel_con_id, siebel_prosp_id, source_db_name, campaign_code, company_id, rpe_company_name, rpe_world_size, rpe_job_code, rpe_jobtitle, rpe_business_code, greeting_string, edm_list_indicator, rpe_personal_title, rpe_address1, rpe_address2, rpe_address3, rpe_town, rpe_county, rpe_postcode, rpe_telephone, ConvertOptins(contact_by_email), email_pref, ConvertOptins(contact_by_post), ConvertOptins(contact_by_phone), ConvertOptins(allowance_flag), ConvertOptouts(mailstop_flag), rpe_pwd, rpe_flexfield1, rpe_flexfield2, rpe_flexfield3, rpe_flexfield4, rpe_flexfield5, rpe_flexfield6, rpe_flexfield7, rpe_flexfield8, rpe_flexfield9, rpe_flexfield10, rpe_flexfield11, rpe_flexfield12, rpe_flexfield13, rpe_flexfield14, rpe_flexfield15, visitTime, responseTime, responserId, responseId, rpe_country_name, telephone_country, telephone_area, telephone_extn, fax_country, fax_area, fax, fax_extn, mobile_country, mobile, preferred_language, rpe_company_website, rpe_company_revenue_range); } else { retval = new BaseDataReportDto(customerFK, country_FK, campaign_language_FK, campaign_country_FK, email_address, first_name, last_name, source_db_id, siebel_con_id, siebel_prosp_id, source_db_name, campaign_code, company_id, company_name, world_size, job_code, jobtitle, business_code, greeting_string, edm_list_indicator, personal_title, address1, address2, address3, town, county, postcode, telephone, ConvertOptins(contact_by_email), email_pref, ConvertOptins(contact_by_post), ConvertOptins(contact_by_phone), ConvertOptins(allowance_flag), ConvertOptouts(mailstop_flag), pwd, flexfield1, flexfield2, flexfield3, flexfield4, flexfield5, flexfield6, flexfield7, flexfield8, flexfield9, flexfield10, flexfield11, flexfield12, flexfield13, flexfield14, flexfield15, visitTime, responseTime, responserId, responseId, country_name, telephone_country, telephone_area, telephone_extn, fax_country, fax_area, fax, fax_extn, mobile_country, mobile, preferred_language,rpe_company_website,rpe_company_revenue); } return retval; }
public ReportRowDto(BaseDataReportDto baseData, CustomerAnswerReportDto[] dynamicQuestions, ShippingAddressReportDto shippingAddress, QuestionReportDto[] questions) { DynamicQuestions = dynamicQuestions; _shippingAddress = shippingAddress; BaseData = baseData; Questions = questions; }