protected void LoadSiebelData(BaseDataStatisticsDto bData)
{
questionnaire_id_label.Text = NullConverter(bData.QuestionnaireId);
type_label.Text = TypeConverter(bData.QuestionnaireType);
campaign_name_label.Text = NullConverter(bData.CampaignCode);
title_label.Text = NullConverter(bData.QuestionnaireTitle);
if (bData.Company_Code == int.Parse(ConfigurationManager.AppSettings["Company_HPE"].ToString())) // RFG 2.20
Company_label.Text = "HPE";
else
Company_label.Text = "HPI";
creator_label.Text = NullConverter(bData.CreatorUser);
business_owner_label.Text = NullConverter(bData.BusinessOwner);
country_setting_label.Text = NullConverter(bData.Country);
language_setting_label.Text = NullConverter(bData.Language);
hp_region_label.Text = NullConverter(bData.Region);
business_unit_label.Text = NullConverter(bData.BusinessUnit);
transfer_to_siebel_label.Text = BoolConverter(bData.TransferToSiebel);
if (bData.TransferToSiebel)
siebel_campaign_row_id_label.Text = NullConverter(bData.SiebelCampaignRowId);
else
siebel_campaign_row_id_label.Text = String.Empty;
siebel_wave_id_label.Text = NullConverter(bData.SiebelWaveId);
asset_leadgen_label.Text = BoolConverter(bData.AnyAsset);
if (bData.AnyAsset)
asset_treatment_label.Text = NullConverter(bData.AnyAssetSiebelTreatmentCode);
else
asset_treatment_label.Text = String.Empty;
hpp_enabled_label.Text = BoolConverter(bData.HPPEnabled);
}
private BaseDataStatisticsDto ReadBaseDataToSiebelReport(IDataReader reader)
{
BaseDataStatisticsDto retval = new BaseDataStatisticsDto();
retval.QuestionnaireId = "-1";
if (GetInt32(reader, 0).HasValue)
retval.QuestionnaireId = GetInt32(reader, 0).Value.ToString();
retval.QuestionnaireType = GetString(reader, 1);
retval.CampaignCode = GetString(reader, 2);
retval.QuestionnaireTitle = GetString(reader, 3);
retval.CreatorUser = GetString(reader, 4);
retval.BusinessOwner = GetString(reader, 5);
retval.Country = GetString(reader, 6);
retval.Language = GetString(reader, 7);
retval.BusinessUnit = GetString(reader, 8);
retval.Region = GetString(reader, 9);
retval.TransferToSiebel = false;
if (GetBoolean(reader, 10).HasValue)
retval.TransferToSiebel = GetBoolean(reader, 10).Value;
retval.SiebelCampaignRowId = GetString(reader, 11);
retval.SiebelWaveId = GetString(reader, 12);
retval.AnyAsset = false;
if (GetBoolean(reader, 13).HasValue)
retval.AnyAsset = GetBoolean(reader, 13).Value;
retval.AnyAssetSiebelTreatmentCode = GetString(reader, 14);
retval.HPPEnabled = false;
if (GetBoolean(reader, 15).HasValue)
retval.HPPEnabled = GetBoolean(reader, 15).Value;
retval.Company_Code = 0;
if (GetInt32(reader, 16).HasValue)
retval.Company_Code = int.Parse(GetInt32(reader, 16).Value.ToString());
return retval;
}
public StatisticsRowDto(BaseDataStatisticsDto baseData)
{
BaseData = baseData;
}
private BaseDataStatisticsDto ReadBaseData(IDataReader reader, ref bool alreadyRead)
{
BaseDataStatisticsDto retval = null;
string questionnaireId = "-1";
if (GetInt32(reader, 0).HasValue)
questionnaireId = GetInt32(reader, 0).Value.ToString();
string questionnaireType = GetString(reader, 1);
string campaignCode = GetString(reader, 2);
string questionnaireTitle = GetString(reader, 3);
string creatorUser = GetString(reader, 4);
string businessOwner = GetString(reader, 5);
string country = GetString(reader, 6);
string language = GetString(reader, 7);
string businessUnit = GetString(reader, 8);
string region = GetString(reader, 9);
DateTime? dateDeleted = null;
if (GetDateTime(reader, 10).HasValue)
dateDeleted = GetDateTime(reader, 10).Value;
bool statusActive = false;
if (GetBoolean(reader, 11).HasValue)
statusActive = GetBoolean(reader, 11).Value;
DateTime? expireDate = null;
if (GetDateTime(reader, 12).HasValue)
expireDate = GetDateTime(reader, 12).Value;
string expireRedirect = GetString(reader, 13);
DateTime? publishDate = null;
if (GetDateTime(reader, 14).HasValue)
publishDate = GetDateTime(reader, 14).Value;
DateTime creationDate = GetDateTime(reader, 15).Value;
bool transferToSiebel = false;
if (GetBoolean(reader, 16).HasValue)
transferToSiebel = GetBoolean(reader, 16).Value;
string siebelCampaignRowId = GetString(reader, 17);
string siebelWaveId = GetString(reader, 18);
bool anyAsset = false;
if (GetBoolean(reader, 19).HasValue)
anyAsset = GetBoolean(reader, 19).Value;
string anyAssetSiebelTreatmentCode = GetString(reader, 20);
bool hPPEnabled = false;
if (GetBoolean(reader, 21).HasValue)
hPPEnabled = GetBoolean(reader, 21).Value;
DateTime? offlineStart = null;
if (GetDateTime(reader, 22).HasValue)
offlineStart = GetDateTime(reader, 22).Value;
DateTime? offlineEnd = null;
if (GetDateTime(reader, 23).HasValue)
offlineEnd = GetDateTime(reader, 23);
int? offlineMode = null;
if (GetInt32(reader, 24).HasValue)
{
offlineMode = GetInt32(reader, 24).Value;
}
DateTime? offlineRecurrenceDate = null;
if (GetDateTime(reader, 25).HasValue)
offlineRecurrenceDate = GetDateTime(reader, 25).Value;
string offlineRedirect = GetString(reader, 26);
bool personalized = false;
if (GetBoolean(reader, 27).HasValue)
personalized = GetBoolean(reader, 27).Value;
bool registeredPersonalized = false;
if (GetBoolean(reader, 28).HasValue)
registeredPersonalized = GetBoolean(reader, 28).Value;
string externalClosure = GetString(reader, 29);
bool thankyouEmail = false;
if (GetBoolean(reader, 30).HasValue)
thankyouEmail = GetBoolean(reader, 30).Value;
bool notificationEmail = false;
if (GetBoolean(reader, 31).HasValue)
notificationEmail = GetBoolean(reader, 31).Value;
bool notificationEmailAstro2 = false;
if(GetBoolean(reader, 32).HasValue)
notificationEmailAstro2 = GetBoolean(reader, 32).Value;
string metaSegment = GetString(reader, 33);
string metaPageContent = GetString(reader, 34);
string pagenameFormPage = GetString(reader, 35);
string salesCycle = GetString(reader, 36);
string contentType = GetString(reader, 37);
string comments = GetString(reader, 38);
string urlLayoutform = GetString(reader, 39);
string themecolour = GetString(reader, 40);
string mainImage = GetString(reader, 41);
string deleteUser = GetString(reader, 42);
int numberOfResponses = 0;
if(GetInt32(reader, 43).HasValue)
numberOfResponses = GetInt32(reader, 43).Value;
string userProfile = GetString(reader, 44);
int numberOfResponsesService = 0;
if (GetInt32(reader, 45).HasValue)
numberOfResponsesService = GetInt32(reader, 45).Value;
int numberOfResponsesStandalone = 0;
if (GetInt32(reader, 46).HasValue)
numberOfResponsesStandalone = GetInt32(reader, 46).Value;
int numberOfResponsesCS = 0;
if (GetInt32(reader, 47).HasValue)
numberOfResponsesCS = GetInt32(reader, 47).Value;
int numberOfResponsesClassic = 0;
if (GetInt32(reader, 48).HasValue)
numberOfResponsesClassic = GetInt32(reader, 48).Value;
int numberOfResponsesProcessor = 0;
if (GetInt32(reader, 49).HasValue)
numberOfResponsesProcessor = GetInt32(reader, 49).Value;
int company_Code = 0;
if (GetInt32(reader, 50).HasValue)
company_Code = GetInt32(reader, 50).Value;
retval = new BaseDataStatisticsDto()
{
QuestionnaireId = questionnaireId,
QuestionnaireType = questionnaireType,
CampaignCode = campaignCode,
QuestionnaireTitle = questionnaireTitle,
CreatorUser = creatorUser,
BusinessOwner = businessOwner,
Country = country,
Language = language,
BusinessUnit = businessUnit,
Region = region,
DateDeleted = dateDeleted,
StatusActive = statusActive,
ExpireDate = expireDate,
ExpireRedirect = expireRedirect,
PublishDate = publishDate,
CreationDate = creationDate,
TransferToSiebel = transferToSiebel,
SiebelCampaignRowId = siebelCampaignRowId,
SiebelWaveId = siebelWaveId,
AnyAsset = anyAsset,
AnyAssetSiebelTreatmentCode = anyAssetSiebelTreatmentCode,
HPPEnabled = hPPEnabled,
OfflineStart = offlineStart,
OfflineEnd = offlineEnd,
OfflineMode = offlineMode,
OfflineRecurrenceDate = offlineRecurrenceDate,
OfflineRedirect = offlineRedirect,
Personalized = personalized,
RegisteredPersonalized = registeredPersonalized,
ExternalClosure = externalClosure,
ThankyouEmail = thankyouEmail,
NotificationEmail = notificationEmail,
NotificationEmailAstro2 = notificationEmailAstro2,
MetaSegment = metaSegment,
MetaPageContent = metaPageContent,
PagenameFormPage = pagenameFormPage,
SalesCycle = salesCycle,
ContentType = contentType,
UserProfile = userProfile,
Comments = comments,
UrlLayoutform = urlLayoutform,
Themecolour = themecolour,
MainImage = mainImage,
DeleteUser = deleteUser,
NumberOfResponses = numberOfResponses,
NumberOfWebServiceResponses = numberOfResponsesService,
NumberOfCSStandaloneResponses = numberOfResponsesStandalone,
NumberOfCSOverlayResponses = numberOfResponsesCS,
NumberOfClassicResponses = numberOfResponsesClassic,
NumberOfProcessorResponses = numberOfResponsesProcessor,
Company_Code = company_Code
};
return retval;
}