private void MakeFunnyThingsHappen(PersonalDataSectionDto elementDto, PersonalResponseDto response, List<int> validationHints)
{
foreach (KeyValuePair<PersonalDataSectionElements, Triple<int?, bool, bool>> elementToCheck in elementDto.PresentationPosition)
{
if (elementToCheck.Value != null)
{
if (elementToCheck.Value.Second)//mandatory
{
int validationHint = DoTheSwitch(elementDto, response, elementToCheck.Key);
if (validationHint > 0)
{
validationHints.Add(validationHint);
}
}
else
{
if (response != null)
{
switch (elementToCheck.Key)
{
case PersonalDataSectionElements.Email:
if (!DataValidation.ValidateEmail(response.EmailAddress, false))
{
validationHints.Add(PersonalDataSectionDto.InvalidEmailAddress);
}
break;
case PersonalDataSectionElements.Telephone:
if (!ValidateLongPhone(response.TelephoneCountry, response.TelephoneArea, response.TelephoneNumber, response.TelephoneExt, false))
{
validationHints.Add(PersonalDataSectionDto.InvalidTelephone);
}
break;
case PersonalDataSectionElements.Fax:
if (!ValidateLongPhone(response.FaxCountry, response.FaxArea, response.FaxNumber, response.FaxExt, false))
{
validationHints.Add(PersonalDataSectionDto.InvalidFax);
}
break;
case PersonalDataSectionElements.Mobile:
if (!ValidateShortPhone(response.MobileCountry, response.MobileNumber, false))
{
validationHints.Add(PersonalDataSectionDto.InvalidMobile);
}
break;
case PersonalDataSectionElements.CompanyWebsite:
if (!string.IsNullOrEmpty(response.CompanyWebsite) && !IsValidWebsite(response.CompanyWebsite))
{
validationHints.Add(PersonalDataSectionDto.InvalidCompanyWebsite);
}
break;
default:
break;
}
}
}
}
}
}
public void Setup()
{
CreateNewQuestionnaire();
CreateNewFormPage();
long responseKey = FormRegistry.ResponseDao.CreateSubmitResponse(Constants.UnknownCustomer, null, _currentQuestionnaire.QuestionnaireId, ViewType.CleanSheetOverlay).First;
PersonalResponseDto dto = new PersonalResponseDto(responseKey, "address1", "address2", "address3", "bus", "businessSiebel63", "company name", "UK", "county", Constants.UnknownCustomer, "email", "firstname", "flex1", "flex10", "flex11", "flex12", "flex13", "flex14", "flex15", "flex2", "flex3", "flex4", "flex5", "flex6", "flex7", "flex8", "flex9", "job", "jobsiebel", "jobtitle", "lastname", "persontit", "postcode", "pwd", "telephone", "telephone2", "telephone3", "telephone4", "fax", "fax2", "fax3", "fax4", "mobile", "mobile2", "town", "wor", "world6", "United Kingdom", null, "prefLang", "companyWebsite", "companyRevenue");
FormRegistry.ResponseDao.Add(dto);
SpecificCrmResponseDto dto2 = new SpecificCrmResponseDto(responseKey, false, true, SpecificCrmResponseDto.ElementTypeRequestOptInOut, _currentPage.PageId, null, _currentPage.QuestionnaireId, "respdesc");
FormRegistry.ResponseDao.Add(dto2);
dto3 = new PrivacyResponseDto(responseKey, true, true, true, EmailPreferences.Html, true);
FormRegistry.ResponseDao.Add(dto3);
PrivacyDataSectionDto dto4 = new PrivacyDataSectionDto("privacy header", true, _currentPage.PageId, true,
"privacy text", "email", "email pref", "email pref html", "email pref text", "post", "phone",
"general opt out", "yeys", "no", "crm offer code", true);
PrivacyDataSectionDto pers = FormRegistry.PrivacyDao.Create(dto4);
PageElementType type = PageElementType.RequestedMoreInfo;
PageElementReqDto dto5 = new PageElementReqDto("element text", true, type, _currentPage.PageId, 0, Migration.GetMaxLength(type), true);
PageElementReqDto pers2 = FormRegistry.PageElementDao.Create(dto5);
}
internal static PersonalResponseDto TestAddPersonalResponseDto(QuestionnaireDto _currentQuestionnaire, bool uniqueEmail)
{
string email = "email";
if (uniqueEmail)
{
const string source = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
const int NumOfChars = 50; // email is nvarchar(60)
Random rnd = new Random();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < NumOfChars; i++)
{
sb.Append(source[rnd.Next(source.Length)]);
}
email = sb.ToString();
}
long responseKey = FormRegistry.ResponseDao.CreateSubmitResponse(Constants.UnknownCustomer, null, _currentQuestionnaire.QuestionnaireId, ViewType.CleanSheetOverlay).First;
Assert.Greater(responseKey, 0);
PersonalResponseDto dto = new PersonalResponseDto(responseKey, "address1", "address2", "address3", "bus", "businessSiebel63", "company name", "UK", "county", Constants.UnknownCustomer, email, "firstname", "flex1", "flex10", "flex11", "flex12", "flex13", "flex14", "flex15", "flex2", "flex3", "flex4", "flex5", "flex6", "flex7", "flex8", "flex9", "job", "jobsiebel", "jobtitle", "lastname", "persontit", "postcode", "pwd", "telephone", "telephone2", "telephone3", "telephone4", "fax", "fax2", "fax3", "fax4", "mobile", "mobile2", "town", "wor", "world6", "United Kingdom", null, "prefLang", "companyWebsite", "cre");
Assert.IsTrue(FormRegistry.ResponseDao.Add(dto));
return dto;
}
public bool Add(PersonalResponseDto dto)
{
bool retval = false;
DbCommand sp = null;
DbConnection connection = null;
IDataReader reader = null;
try
{
connection = _dbLayer.GetConnection();
sp = connection.CreateCommand();
sp.CommandText = "insert_response_personal";
sp.CommandType = CommandType.StoredProcedure;
Write(sp, dto);
sp.ExecuteNonQuery();
retval = true;
}
catch (DbException e)
{
Trace.WriteLine("ResponseDao.Add(" + dto + "): " + e.Message);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (sp != null)
{
sp.Dispose();
}
if (connection != null)
{
_dbLayer.ReturnConnection(connection);
}
else
{
_dbLayer.ReturnConnection(connection, true);
}
}
return retval;
}
private void ReadPrivacy(IDataReader reader, PersonalResponseDto personal, int privacyOffset)
{
PrivacyResponseDto privacy = new PrivacyResponseDto();
ReadPrivacy(reader, privacy, privacyOffset);
personal.EmailPreferences = privacy.EmailPreferences;
}
// method code has been generated mostly by EXCEL Sheet, which was also used to create enums
private void ReadPersonal(IDataReader reader, PersonalResponseDto personal, int personalOffset)
{
long? key = GetInt64(reader, personalOffset + (int)fields_personal_response.response_FK);
personal.ResponseKey = (key.HasValue) ? key.Value : 0;
personal.PersonalTitle = GetString(reader, personalOffset + (int)fields_personal_response.personal_title);
personal.FirstName = GetString(reader, personalOffset + (int)fields_personal_response.first_name);
personal.LastName = GetString(reader, personalOffset + (int)fields_personal_response.last_name);
personal.JobCode = GetString(reader, personalOffset + (int)fields_personal_response.job_code_FK);
personal.JobTitle = GetString(reader, personalOffset + (int)fields_personal_response.jobtitle);
personal.CompanyName = GetString(reader, personalOffset + (int)fields_personal_response.company_name);
personal.Address1 = GetString(reader, personalOffset + (int)fields_personal_response.address1);
personal.Address2 = GetString(reader, personalOffset + (int)fields_personal_response.address2);
personal.Address3 = GetString(reader, personalOffset + (int)fields_personal_response.address3);
personal.Town = GetString(reader, personalOffset + (int)fields_personal_response.town);
personal.County = GetString(reader, personalOffset + (int)fields_personal_response.county);
personal.Postcode = GetString(reader, personalOffset + (int)fields_personal_response.postcode);
personal.CountryCode = GetString(reader, personalOffset + (int)fields_personal_response.country_FK);
personal.EmailAddress = GetString(reader, personalOffset + (int)fields_personal_response.email_address);
personal.TelephoneNumber = GetString(reader, personalOffset + (int)fields_personal_response.telephone);
personal.BusinessCode = GetString(reader, personalOffset + (int)fields_personal_response.business_code_FK);
personal.WorldSize = GetString(reader, personalOffset + (int)fields_personal_response.world_size_FK);
// personal.x = GetString(reader, personalOffset + (int)fields_personal_response.allowance_flag); ??
personal.JobSiebel63 = GetString(reader, personalOffset + (int)fields_personal_response.job_siebel63);
personal.BusinessSiebel63 = GetString(reader, personalOffset + (int)fields_personal_response.business_siebel63);
personal.WorldSize63 = GetString(reader, personalOffset + (int)fields_personal_response.worldsize_siebel63);
personal.FlexField1 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield1);
personal.FlexField2 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield2);
personal.FlexField3 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield3);
personal.FlexField4 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield4);
personal.FlexField5 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield5);
personal.FlexField6 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield6);
personal.FlexField7 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield7);
personal.FlexField8 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield8);
personal.FlexField9 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield9);
personal.FlexField10 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield10);
personal.FlexField11 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield11);
personal.FlexField12 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield12);
personal.FlexField13 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield13);
personal.FlexField14 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield14);
personal.FlexField15 = GetString(reader, personalOffset + (int)fields_personal_response.flexfield15);
personal.Pwd = GetString(reader, personalOffset + (int)fields_personal_response.pwd);
personal.TelephoneCountry = GetString(reader, personalOffset + (int)fields_personal_response.Telephone_country);
personal.TelephoneArea = GetString(reader, personalOffset + (int)fields_personal_response.Telephone_area);
personal.TelephoneExt = GetString(reader, personalOffset + (int)fields_personal_response.Telephone_extn);
personal.FaxCountry = GetString(reader, personalOffset + (int)fields_personal_response.fax_country);
personal.FaxArea = GetString(reader, personalOffset + (int)fields_personal_response.fax_area);
personal.FaxNumber = GetString(reader, personalOffset + (int)fields_personal_response.fax);
personal.FaxExt = GetString(reader, personalOffset + (int)fields_personal_response.fax_extn);
personal.MobileCountry = GetString(reader, personalOffset + (int)fields_personal_response.mobile_country);
personal.MobileNumber = GetString(reader, personalOffset + (int)fields_personal_response.mobile);
personal.PreferredLanguage = GetString(reader, personalOffset + (int)fields_personal_response.language_FK);
personal.CompanyWebsite = GetString(reader, personalOffset + (int)fields_personal_response.company_website);
personal.CompanyRevenue = GetString(reader, personalOffset + (int)fields_personal_response.company_revenue);
}
/// <summary>
/// Common code for GetCustomerByRID and GetCustomerByCID
/// </summary>
/// <param name="cid"></param>
/// <param name="rid"></param>
/// <param name="callback"></param>
/// <returns></returns>
private PersonalResponseDto Call_Select_Customer(string cid, string rid, ReaderCallback callback)
{
PersonalResponseDto retval = new PersonalResponseDto();
DbConnection connection = null;
try
{
connection = _dbLayer.GetConnection();
DbCommand sp = null;
IDataReader reader = null;
try
{
sp = connection.CreateCommand();
sp.CommandText = "select_customer";
sp.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(cid))
_dbLayer.AddParameter(sp, "@customer_id", ParameterDirection.Input, DbType.String, cid);
if (!string.IsNullOrEmpty(rid))
_dbLayer.AddParameter(sp, "@responser_id", ParameterDirection.Input, DbType.String, rid);
_dbLayer.AddReturnParameter(sp);
reader = sp.ExecuteReader();
if (reader.Read())
{
callback(reader);
}
else
{
int err = _dbLayer.GetReturnValue(sp);
Trace.WriteLine("ResponseDao.Call_Select_Customer(" + cid + ", " + rid + ") returned " + err);
}
}
catch (DbException e)
{
Trace.WriteLine("ResponseDao.GetCustomer(" + cid + ", " + rid + "): " + e.Message);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (sp != null)
{
sp.Dispose();
}
}
}
catch (DbException e)
{
Trace.WriteLine("ResponseDao.GetCustomer(" + cid + ", " + rid + "): " + e.Message);
}
finally
{
if (connection != null)
{
_dbLayer.ReturnConnection(connection);
}
else
{
_dbLayer.ReturnConnection(connection, true);
}
}
return retval;
}
private int DoTheSwitch(PersonalDataSectionDto elementDto, PersonalResponseDto response, PersonalDataSectionElements elementToCheck)
{
int validationHint = -1;
switch (elementToCheck)
{
case PersonalDataSectionElements.PersonalTitle:
if (response == null || elementDto.PersonalTitleChoices == null || elementDto.PersonalTitleChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidPersonalTitle;
else if (!IsValidSelection(elementDto.PersonalTitleChoices, response.PersonalTitle))
validationHint = PersonalDataSectionDto.InvalidPersonalTitle;
break;
case PersonalDataSectionElements.FirstName:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidFirstName;
else if (String.IsNullOrEmpty(response.FirstName))
validationHint = PersonalDataSectionDto.InvalidFirstName;
break;
case PersonalDataSectionElements.LastName:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidLastName;
else if (String.IsNullOrEmpty(response.LastName))
validationHint = PersonalDataSectionDto.InvalidLastName;
break;
case PersonalDataSectionElements.JobSelectName:
if (response == null || elementDto.JobChoices == null || elementDto.JobChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidJobCode;
else if (!IsValidSelection(elementDto.JobChoices, response.JobCode))
validationHint = PersonalDataSectionDto.InvalidJobCode;
break;
case PersonalDataSectionElements.JobEnterName:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidJobTitle;
else if (String.IsNullOrEmpty(response.JobTitle))
validationHint = PersonalDataSectionDto.InvalidJobTitle;
break;
case PersonalDataSectionElements.CompanyName:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidCompanyName;
else if (String.IsNullOrEmpty(response.CompanyName))
validationHint = PersonalDataSectionDto.InvalidCompanyName;
break;
case PersonalDataSectionElements.Address:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidAddress1;
else if (String.IsNullOrEmpty(response.Address1))
validationHint = PersonalDataSectionDto.InvalidAddress1;
break;
case PersonalDataSectionElements.Address2:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidAddress2;
else if (String.IsNullOrEmpty(response.Address2))
validationHint = PersonalDataSectionDto.InvalidAddress2;
break;
case PersonalDataSectionElements.Address3:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidAddress3;
else if (String.IsNullOrEmpty(response.Address3))
validationHint = PersonalDataSectionDto.InvalidAddress3;
break;
case PersonalDataSectionElements.Town:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidTown;
else if (String.IsNullOrEmpty(response.Town))
validationHint = PersonalDataSectionDto.InvalidTown;
break;
case PersonalDataSectionElements.County:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidCounty;
else if (String.IsNullOrEmpty(response.County))
validationHint = PersonalDataSectionDto.InvalidCounty;
break;
case PersonalDataSectionElements.PostalCode:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidPostcode;
else if (String.IsNullOrEmpty(response.Postcode))
validationHint = PersonalDataSectionDto.InvalidPostcode;
break;
case PersonalDataSectionElements.CountryRegion:
if (response == null || elementDto.CountryRegionChoices == null || elementDto.CountryRegionChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidCountryCode;
else if (!IsValidSelection(elementDto.CountryRegionChoices, response.CountryCode))
validationHint = PersonalDataSectionDto.InvalidCountryCode;
break;
case PersonalDataSectionElements.Email:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidEmailAddress;
else if (!DataValidation.ValidateEmail(response.EmailAddress, true))
validationHint = PersonalDataSectionDto.InvalidEmailAddress;
break;
case PersonalDataSectionElements.EmailPreferences:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidEmailPreferences;
else if (!response.EmailPreferences.HasValue)
validationHint = PersonalDataSectionDto.InvalidEmailPreferences;
break;
case PersonalDataSectionElements.Telephone:
if (response == null || !ValidateLongPhone(response.TelephoneCountry, response.TelephoneArea, response.TelephoneNumber, response.TelephoneExt, true))
{
validationHint = PersonalDataSectionDto.InvalidTelephone;
}
break;
case PersonalDataSectionElements.Fax:
if (response == null || !ValidateLongPhone(response.FaxCountry, response.FaxArea, response.FaxNumber, response.FaxExt, true))
{
validationHint = PersonalDataSectionDto.InvalidFax;
}
break;
case PersonalDataSectionElements.Mobile:
if (response == null || !ValidateShortPhone(response.MobileCountry, response.MobileNumber, true))
{
validationHint = PersonalDataSectionDto.InvalidMobile;
}
break;
case PersonalDataSectionElements.PrimaryBusiness:
if (response == null || elementDto.BusinessChoices == null || elementDto.BusinessChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidBusinessCode;
else if (!IsValidSelection(elementDto.BusinessChoices, response.BusinessCode))
validationHint = PersonalDataSectionDto.InvalidBusinessCode;
break;
case PersonalDataSectionElements.CompanySize:
if (response == null || elementDto.CompanySizeChoices == null || elementDto.CompanySizeChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidWorldSize;
else if (!IsValidSelection(elementDto.CompanySizeChoices, response.WorldSize))
validationHint = PersonalDataSectionDto.InvalidWorldSize;
break;
case PersonalDataSectionElements.PreferredLanguage:
if (response == null || elementDto.PreferredLanguageChoices == null || elementDto.PreferredLanguageChoices.Count == 0)
validationHint = PersonalDataSectionDto.InvalidPreferredLanguage;
else if (!IsValidSelection(elementDto.PreferredLanguageChoices, response.PreferredLanguage))
validationHint = PersonalDataSectionDto.InvalidPreferredLanguage;
break;
//RFG 2.11 | Added by Raju
case PersonalDataSectionElements.CompanyWebsite:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidCompanyWebsite;
else if (!IsValidWebsite(response.CompanyWebsite))
validationHint = PersonalDataSectionDto.InvalidCompanyWebsite;
break;
case PersonalDataSectionElements.CompanyRevenue:
if (response == null)
validationHint = PersonalDataSectionDto.InvalidCompanyRevenue;
else if (!IsValidSelection(elementDto.CompanyRevenueChoices, response.CompanyRevenue))
validationHint = PersonalDataSectionDto.InvalidCompanyRevenue;
break;
}
return validationHint;
}
private PersonalResponseDto GetCustomerByCID(string cid)
{
PersonalResponseDto retval = new PersonalResponseDto();
const int customerOffset = 0;
const int privacyOffset = customerOffset + (int)fields_customer_datarecords.__COUNT;
Call_Select_Customer(cid, null,
delegate(IDataReader reader)
{
do
{
ReadCustomerDataRecords(reader, retval, customerOffset);
ReadPrivacy(reader, retval, privacyOffset);
} while (reader.Read());
});
return retval;
}
private void Write(DbCommand sp, PersonalResponseDto dto)
{
_dbLayer.AddInParameter(sp, "@response_id", DbType.Int64, dto.ResponseKey);
_dbLayer.AddInParameter(sp, "@customer_id", DbType.String, dto.CustomerId);
_dbLayer.AddInParameter(sp, "@personal_title", DbType.String, dto.PersonalTitle);
_dbLayer.AddInParameter(sp, "@first_name", DbType.String, dto.FirstName);
_dbLayer.AddInParameter(sp, "@last_name", DbType.String, dto.LastName);
_dbLayer.AddInParameter(sp, "@job_code_FK", DbType.String, dto.JobCode);
_dbLayer.AddInParameter(sp, "@jobtitle", DbType.String, dto.JobTitle);
_dbLayer.AddInParameter(sp, "@company_name", DbType.String, dto.CompanyName);
_dbLayer.AddInParameter(sp, "@company_website", DbType.String, dto.CompanyWebsite); //RFG 2.11 | Added by Raju
_dbLayer.AddInParameter(sp, "@company_revenue", DbType.String, dto.CompanyRevenue);
_dbLayer.AddInParameter(sp, "@address1", DbType.String, dto.Address1);
_dbLayer.AddInParameter(sp, "@address2", DbType.String, dto.Address2);
_dbLayer.AddInParameter(sp, "@address3", DbType.String, dto.Address3);
_dbLayer.AddInParameter(sp, "@town", DbType.String, dto.Town);
_dbLayer.AddInParameter(sp, "@county", DbType.String, dto.County);
_dbLayer.AddInParameter(sp, "@postcode", DbType.String, dto.Postcode);
_dbLayer.AddInParameter(sp, "@country_FK", DbType.String, dto.CountryCode);
_dbLayer.AddInParameter(sp, "@email_address", DbType.String, dto.EmailAddress);
_dbLayer.AddInParameter(sp, "@telephone_country", DbType.String, dto.TelephoneCountry);
_dbLayer.AddInParameter(sp, "@telephone_area", DbType.String, dto.TelephoneArea);
_dbLayer.AddInParameter(sp, "@telephone", DbType.String, dto.TelephoneNumber);
_dbLayer.AddInParameter(sp, "@telephone_extn", DbType.String, dto.TelephoneExt);
_dbLayer.AddInParameter(sp, "@fax_country", DbType.String, dto.FaxCountry);
_dbLayer.AddInParameter(sp, "@fax_area", DbType.String, dto.FaxArea);
_dbLayer.AddInParameter(sp, "@fax", DbType.String, dto.FaxNumber);
_dbLayer.AddInParameter(sp, "@fax_extn", DbType.String, dto.FaxExt);
_dbLayer.AddInParameter(sp, "@mobile_country", DbType.String, dto.MobileCountry);
_dbLayer.AddInParameter(sp, "@mobile", DbType.String, dto.MobileNumber);
_dbLayer.AddInParameter(sp, "@business_code_FK", DbType.String, dto.BusinessCode);
_dbLayer.AddInParameter(sp, "@world_size_FK", DbType.String, dto.WorldSize);
_dbLayer.AddInParameter(sp, "@job_siebel63", DbType.String, dto.JobSiebel63);
_dbLayer.AddInParameter(sp, "@business_siebel63", DbType.String, dto.BusinessSiebel63);
_dbLayer.AddInParameter(sp, "@worldsize_siebel63", DbType.String, dto.WorldSize63);
_dbLayer.AddInParameter(sp, "@flexfield1", DbType.String, dto.FlexField1);
_dbLayer.AddInParameter(sp, "@flexfield2", DbType.String, dto.FlexField2);
_dbLayer.AddInParameter(sp, "@flexfield3", DbType.String, dto.FlexField3);
_dbLayer.AddInParameter(sp, "@flexfield4", DbType.String, dto.FlexField4);
_dbLayer.AddInParameter(sp, "@flexfield5", DbType.String, dto.FlexField5);
_dbLayer.AddInParameter(sp, "@flexfield6", DbType.String, dto.FlexField6);
_dbLayer.AddInParameter(sp, "@flexfield7", DbType.String, dto.FlexField7);
_dbLayer.AddInParameter(sp, "@flexfield8", DbType.String, dto.FlexField8);
_dbLayer.AddInParameter(sp, "@flexfield9", DbType.String, dto.FlexField9);
_dbLayer.AddInParameter(sp, "@flexfield10", DbType.String, dto.FlexField10);
_dbLayer.AddInParameter(sp, "@flexfield11", DbType.String, dto.FlexField11);
_dbLayer.AddInParameter(sp, "@flexfield12", DbType.String, dto.FlexField12);
_dbLayer.AddInParameter(sp, "@flexfield13", DbType.String, dto.FlexField13);
_dbLayer.AddInParameter(sp, "@flexfield14", DbType.String, dto.FlexField14);
_dbLayer.AddInParameter(sp, "@flexfield15", DbType.String, dto.FlexField15);
_dbLayer.AddInParameter(sp, "@pwd", DbType.String, dto.Pwd);
_dbLayer.AddInParameter(sp, "@language_FK", DbType.String, dto.PreferredLanguage);
}
public override List<ResponseDto> GetResponseDto(long responseId)
{
IResponseProvider provider = Page as IResponseProvider;
if (provider == null)
{
throw new BugException(GetType().Name + " only supported in response providers");
}
List<ResponseDto> retval = null;
_hasData = false;
PersonalResponseDto personalDto = null;
Triple<PersonalDataSectionElements, WebControl, Label> element = null;
#region init variables and flex fields
string address1 = null;
string address2 = null;
string address3 = null;
string businessCode = null;
string businessSiebel63 = null;
string companyName = null;
string companyWebsite = null; //RFG 2.11 | Added by Raju
string companyRevenue = null;
string countryCode = null;
string county = null;
string customerId = provider.CustomerId;
string emailAddress = null;
string firstName = null;
string flexField1 = GetFlexField(1);
string flexField10 = GetFlexField(10);
string flexField11 = GetFlexField(11);
string flexField12 = GetFlexField(12);
string flexField13 = GetFlexField(13);
string flexField14 = GetFlexField(14);
string flexField15 = GetFlexField(15);
string flexfield2 = GetFlexField(2);
string flexField3 = GetFlexField(3);
string flexField4 = GetFlexField(4);
string flexField5 = GetFlexField(5);
string flexField6 = GetFlexField(6);
string flexField7 = GetFlexField(7);
string flexField8 = GetFlexField(8);
string flexField9 = GetFlexField(9);
string jobCode = null;
string jobSiebel63 = null;
string jobTitle = null;
string lastName = null;
string personalTitle = null;
string language = null;
string postcode = null;
string pwd = null;
string telephoneCountry = null;
string telephoneArea = null;
string telephoneNumber = null;
string telephoneExt = null;
string faxCountry = null;
string faxArea = null;
string faxNumber = null;
string faxExt = null;
string mobileCountry = null;
string mobileNumber = null;
string town = null;
string worldSize = null;
string worldSize63 = null;
string countryName = null;
EmailPreferences? emailPreferences = null;
#endregion
#region address
//_currentElement = PersonalDataSectionElements.Address;
//element = _controls.Find(IsCurrent);
//if (element != null)
//{
// TextBox control = element.Second.FindControl("Uxd_" + _currentElement) as TextBox;
// if (control != null)
// {
// address1 = control.Text;
// }
// control = element.Second.FindControl("Uxd_" + _currentElement + "2") as TextBox;
// if (control != null)
// {
// address2 = control.Text;
// }
// control = element.Second.FindControl("Uxd_" + _currentElement + "3") as TextBox;
// if (control != null)
// {
// address3 = control.Text;
// }
// if (!String.IsNullOrEmpty(address1) || !String.IsNullOrEmpty(address2) || !String.IsNullOrEmpty(address3))
// {
// _hasData = true;
// }
//}
#endregion
#region telephone
_currentElement = PersonalDataSectionElements.Telephone;
element = _controls.Find(IsCurrent);
/*AddTextFieldToPanel(p, _element.TelephoneCountry, "TelephoneCountry", mandatory, control.Third);
AddTextFieldToPanel(p, _element.TelephoneArea, "TelephoneArea", mandatory, control.Third);
AddTextFieldToPanel(p, _element.TelephoneNumber, "TelephoneNumber", mandatory, control.Third);
AddTextFieldToPanel(p, _element.TelephoneExt, "TelephoneExt", mandatory, control.Third);*/
if (element != null)
{
TextBox control = element.Second.FindControl("Uxd_TelephoneCountry") as TextBox;
if (control != null)
{
telephoneCountry = control.Text;
}
control = element.Second.FindControl("Uxd_TelephoneArea") as TextBox;
if (control != null)
{
telephoneArea = control.Text;
}
control = element.Second.FindControl("Uxd_TelephoneNumber") as TextBox;
if (control != null)
{
telephoneNumber = control.Text;
}
control = element.Second.FindControl("Uxd_TelephoneExt") as TextBox;
if (control != null)
{
telephoneExt = control.Text;
}
if (!String.IsNullOrEmpty(telephoneCountry) || !String.IsNullOrEmpty(telephoneArea) || !String.IsNullOrEmpty(telephoneNumber) || !String.IsNullOrEmpty(telephoneExt))
{
_hasData = true;
}
}
#endregion
#region fax
_currentElement = PersonalDataSectionElements.Fax;
element = _controls.Find(IsCurrent);
/*AddTextFieldToPanel(p, _element.FaxCountry, "FaxCountry", mandatory, control.Third);
AddTextFieldToPanel(p, _element.FaxArea, "FaxArea", mandatory, control.Third);
AddTextFieldToPanel(p, _element.FaxNumber, "FaxNumber", mandatory, control.Third);
AddTextFieldToPanel(p, _element.FaxExt, "FaxExt", mandatory, control.Third);*/
if (element != null)
{
TextBox control = element.Second.FindControl("Uxd_FaxCountry") as TextBox;
if (control != null)
{
faxCountry = control.Text;
}
control = element.Second.FindControl("Uxd_FaxArea") as TextBox;
if (control != null)
{
faxArea = control.Text;
}
control = element.Second.FindControl("Uxd_FaxNumber") as TextBox;
if (control != null)
{
faxNumber = control.Text;
}
control = element.Second.FindControl("Uxd_FaxExt") as TextBox;
if (control != null)
{
faxExt = control.Text;
}
if (!String.IsNullOrEmpty(faxCountry) || !String.IsNullOrEmpty(faxArea) || !String.IsNullOrEmpty(faxNumber) || !String.IsNullOrEmpty(faxExt))
{
_hasData = true;
}
}
#endregion
#region Mobile
// mobile number fix in crm_records for 2.1.2
_currentElement = PersonalDataSectionElements.Mobile;
element = _controls.Find(IsCurrent);
/*AddTextFieldToPanel(p, _element.MobileCountry, "MobileCountry", mandatory, control.Third);
AddTextFieldToPanel(p, _element.MobileNumber, "MobileArea", mandatory, control.Third);*/
if (element != null)
{
TextBox control = element.Second.FindControl("Uxd_MobileCountry") as TextBox;
if (control != null)
{
mobileCountry = control.Text;
}
control = element.Second.FindControl("Uxd_MobileNumber") as TextBox;
if (control != null)
{
mobileNumber = control.Text;
}
if (!String.IsNullOrEmpty(mobileCountry) || !String.IsNullOrEmpty(mobileNumber))
{
_hasData = true;
}
}
#endregion
#region email pref
_currentElement = PersonalDataSectionElements.EmailPreferences;
element = _controls.Find(IsCurrent);
if (element != null)
{
RadioButtonList control = element.Second as RadioButtonList;
if (control != null)
{
if (control.SelectedItem != null)
{
if (control.SelectedItem.Value.EndsWith("html"))
{
emailPreferences = EmailPreferences.Html;
_hasData = true;
}
else if (control.SelectedItem.Value.EndsWith("text"))
{
emailPreferences = EmailPreferences.Text;
_hasData = true;
}
}
}
}
#endregion
#region select
PersonalDataSectionElements[] selects = SelectControls;
foreach (PersonalDataSectionElements currentElement in selects)
{
string selectedValue = FindValueForSelect(currentElement);
switch (currentElement)
{
case PersonalDataSectionElements.PersonalTitle:
personalTitle = selectedValue;
break;
case PersonalDataSectionElements.JobSelectName:
jobCode = selectedValue;
if (!String.IsNullOrEmpty(jobCode) && jobCode.StartsWith("s"))
{
jobSiebel63 = selectedValue;
}
break;
case PersonalDataSectionElements.CountryRegion:
countryCode = selectedValue;
if (countryCode == null)
countryCode = _questionnaire.CountryCode;
break;
case PersonalDataSectionElements.County:
if(boolCountyDDLExists == true)
county = selectedValue;
break;
case PersonalDataSectionElements.PrimaryBusiness:
businessCode = selectedValue;
if (!String.IsNullOrEmpty(businessCode) && businessCode.StartsWith("s"))
{
businessSiebel63 = businessCode;
}
break;
case PersonalDataSectionElements.CompanySize:
worldSize = selectedValue;
if (!String.IsNullOrEmpty(worldSize) && worldSize.StartsWith("s"))
{
worldSize63 = worldSize;
}
break;
case PersonalDataSectionElements.PreferredLanguage:
language = selectedValue;
break;
//RFG 2.11
case PersonalDataSectionElements.CompanyRevenue:
companyRevenue = selectedValue;
break;
default:
throw new BugException("personal data section element \"" + currentElement + "\" is not a select");
}
}
#endregion
#region texts
selects = TextControls;
foreach (PersonalDataSectionElements currentElement in selects)
{
string selectedValue = FindValueForText(currentElement);
switch (currentElement)
{
case PersonalDataSectionElements.FirstName:
firstName = selectedValue;
break;
case PersonalDataSectionElements.LastName:
lastName = selectedValue;
break;
case PersonalDataSectionElements.JobEnterName:
jobTitle = selectedValue;
break;
case PersonalDataSectionElements.CompanyName:
companyName = selectedValue;
break;
//RFG 2.11 | Added by Raju
case PersonalDataSectionElements.CompanyWebsite:
companyWebsite = selectedValue;
break;
case PersonalDataSectionElements.CompanyRevenue:
companyRevenue = selectedValue;
break;
case PersonalDataSectionElements.Town:
town = selectedValue;
break;
case PersonalDataSectionElements.County:
if(boolCountyExists == true)
county = selectedValue;
break;
case PersonalDataSectionElements.PostalCode:
postcode = selectedValue;
break;
case PersonalDataSectionElements.Email:
emailAddress = selectedValue;
break;
case PersonalDataSectionElements.Address:
address1 = selectedValue;
break;
case PersonalDataSectionElements.Address2:
address2 = selectedValue;
break;
case PersonalDataSectionElements.Address3:
address3 = selectedValue;
break;
default:
throw new BugException("personal data text element \"" + currentElement + "\" is not a text");
}
}
#endregion
if (_hasData)
{
personalDto = new PersonalResponseDto(responseId, address1, address2, address3, businessCode, businessSiebel63,
companyName, countryCode, county, customerId, emailAddress, firstName, flexField1, flexField10,
flexField11, flexField12, flexField13, flexField14, flexField15, flexfield2, flexField3, flexField4,
flexField5, flexField6, flexField7, flexField8, flexField9, jobCode, jobSiebel63, jobTitle, lastName,
personalTitle, postcode, pwd, telephoneCountry, telephoneArea, telephoneNumber, telephoneExt, faxCountry, faxArea, faxNumber, faxExt, mobileCountry, mobileNumber, town, worldSize, worldSize63, countryName, emailPreferences, language, companyWebsite,companyRevenue); //RFG 2.11
retval = new List<ResponseDto>();
retval.Add(personalDto);
}
return retval;
}
public void TestReplaceStaticPlaceholdersFromPersonalResponseDto()
{
EmailFormatterBase f = new EmailFormatterBase();
PersonalResponseDto dto = new PersonalResponseDto(12345, "address1", "address2", "address3", "bus", "businessSiebel63", "company name", "UK", "county", Constants.UnknownCustomer, "email", "firstname", "flex1", "flex10", "flex11", "flex12", "flex13", "flex14", "flex15", "flex2", "flex3", "flex4", "flex5", "flex6", "flex7", "flex8", "flex9", "job", "jobsiebel", "jobtitle", "lastname", "persontit", "postcode", "pwd", "telephone", "telephone2", "telephone3", "telephone4", "fax", "fax2", "fax3", "fax4", "mobile", "mobile2", "town", "wor", "world6", "United Kingdom", null, "prefLang", "companyWebsite", "companyRevenue");
string[] placeholders = new string[]
{
"[customer_id]",
"[country_fk]",
"[language_fk]",
"[pwd]",
"[EMAIL_ADDRESS]".ToLower(),
"[FIRST_NAME]".ToLower(),
"[LAST_NAME]".ToLower(),
"[COMPANY_NAME]".ToLower(),
//"[NUMBER_OF_EMPLOYEES]".ToLower(),
//"[JOB_CODE]".ToLower(),
"[JOBTITLE]".ToLower(),
//"[BUSINESS_NAME]".ToLower(),
"[COMPANY_WEBSITE]".ToLower(),
//"[COMPANYREVENUE]".ToLower(),
"[PERSONAL_TITLE]".ToLower(),
"[ADDRESS1]".ToLower(),
"[ADDRESS2]".ToLower(),
"[ADDRESS3]".ToLower(),
"[TOWN]".ToLower(),
"[COUNTY]".ToLower(),
"[POSTCODE]".ToLower(),
"[TELEPHONE_COUNTRY]".ToLower(),
"[TELEPHONE_AREA]".ToLower(),
"[TELEPHONE]".ToLower(),
"[TELEPHONE_EXTN]".ToLower(),
"[FAX_COUNTRY]".ToLower(),
"[FAX_AREA]".ToLower(),
"[FAX]".ToLower(),
"[FAX_EXTN]".ToLower(),
"[MOBILE_COUNTRY]".ToLower(),
"[MOBILE]".ToLower(),
"[FLEXFIELD1]".ToLower(),
"[FLEXFIELD2]".ToLower(),
"[FLEXFIELD3]".ToLower(),
"[FLEXFIELD4]".ToLower(),
"[FLEXFIELD5]".ToLower(),
"[FLEXFIELD6]".ToLower(),
"[FLEXFIELD7]".ToLower(),
"[FLEXFIELD8]".ToLower(),
"[FLEXFIELD9]".ToLower(),
"[FLEXFIELD10]".ToLower(),
"[FLEXFIELD11]".ToLower(),
"[FLEXFIELD12]".ToLower(),
"[FLEXFIELD13]".ToLower(),
"[FLEXFIELD14]".ToLower(),
"[FLEXFIELD15]".ToLower(),
};
string result = "unknown|UK|prefLang|pwd|email|firstname|lastname|company name|jobtitle|companyWebsite|persontit|address1|address2|address3|town|county|postcode|telephone|telephone2|telephone3|telephone4|fax|fax2|fax3|fax4|mobile|mobile2|flex1|flex2|flex3|flex4|flex5|flex6|flex7|flex8|flex9|flex10|flex11|flex12|flex13|flex14|flex15";
StringBuilder sb = new StringBuilder();
foreach (string placeholder in placeholders)
{
if (sb.Length > 0)
sb.Append('|');
sb.Append(placeholder);
}
f.ReplaceStaticPlaceholders(sb, dto);
Assert.AreEqual(result, sb.ToString());
}
public void SubmitPersonalSectionData(string CountryCode)
{
#region init variables and flex fields
string address1 = string.Empty;
string address2 = string.Empty;
string address3 = string.Empty;
string businessCode = string.Empty;
string businessSiebel63 = string.Empty;
string companyName = string.Empty;
string countryCode = string.Empty;
string county = string.Empty;
string customerId = CustomerID;
string emailAddress = string.Empty;
string firstName = string.Empty;
string flexField1 = string.Empty;
string flexField10 = string.Empty;
string flexField11 = string.Empty;
string flexField12 = string.Empty;
string flexField13 = string.Empty;
string flexField14 = string.Empty;
string flexField15 = string.Empty;
string flexfield2 = string.Empty;
string flexField3 = string.Empty;
string flexField4 = string.Empty;
string flexField5 = string.Empty;
string flexField6 = string.Empty;
string flexField7 = string.Empty;
string flexField8 = string.Empty;
string flexField9 = string.Empty;
string jobCode = string.Empty;
string jobSiebel63 = string.Empty;
string jobTitle = string.Empty;
string lastName = string.Empty;
string personalTitle = string.Empty;
string postcode = string.Empty;
string pwd = string.Empty;
string telephoneCountry = string.Empty;
string telephoneArea = string.Empty;
string telephoneNumber = string.Empty;
string telephoneExt = string.Empty;
string faxCountry = string.Empty;
string faxArea = string.Empty;
string faxNumber = string.Empty;
string faxExt = string.Empty;
string mobileCountry = string.Empty;
string mobileNumber = string.Empty;
string preferredLanguage = String.Empty;
//RFG 2.11 | Added by Raju
string companyWebsite = String.Empty;
string companyRevenue = String.Empty;
string town = string.Empty;
string worldSize = string.Empty;
string worldSize63 = string.Empty;
string countryName = string.Empty;
EmailPreferences? emailPreferences = null;
#endregion
string CamaignCode = string.Empty;
string WaveCode = null; //QC6166
string JumpId = null;
string numberOfEmployees = string.Empty;
PersonalResponseDto ResponseDto = null;
FormSubmissionPersonalSectionLabels ObjPersonalLabels = new FormSubmissionPersonalSectionLabels();
// EmailPreferences? emailPreferences = null;
if (HashPersonalFields != null)
{
if (HashPersonalFields.Count > 0)
{
foreach (DictionaryEntry Item in HashPersonalFields)
{
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Address1)
{
address1 = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Address2)
{
address2 = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Address3)
{
address3 = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.CompanyName)
{
companyName = Item.Value.ToString();
}
//RFG 2.11 | Added by Raju
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.CompanyWebsite)
{
companyWebsite = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.CompanyRevenue)
{
string[] ArrayCompanyRevenue = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayCompanyRevenue = Item.Value.ToString().Split(',');
if (ArrayCompanyRevenue[0] != null)
companyRevenue = ArrayCompanyRevenue[0];
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Email_Address)
{
emailAddress = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Email_Pref)
{
string[] ArrayEmailPref = new string[1];
string EmailPref = string.Empty;
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayEmailPref = Item.Value.ToString().Split(',');
if (ArrayEmailPref[0] != null)
EmailPref = ArrayEmailPref[0];
}
}
if (EmailPref == "html")
emailPreferences = EmailPreferences.Html;
if (EmailPref == "text")
emailPreferences = EmailPreferences.Text;
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.County)
{
county = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Country_code)
{
string[] ArrayCountry = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayCountry = Item.Value.ToString().Split(',');
if (ArrayCountry[0] != null)
countryCode = ArrayCountry[0];
}
}
if (countryCode == "")
countryCode = CountryCode;
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.JobCode)
{
string[] ArrayJob = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayJob = Item.Value.ToString().Split(',');
if (ArrayJob[0] != null)
jobCode = ArrayJob[0];
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.PreferredLanguage)
{
string[] ArrayPreferredLanguage = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayPreferredLanguage = Item.Value.ToString().Split(',');
if (ArrayPreferredLanguage[0] != null)
preferredLanguage = ArrayPreferredLanguage[0];
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Business_Code)
{
string[] ArrayBusinessCode = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayBusinessCode = Item.Value.ToString().Split(',');
if (ArrayBusinessCode[0] != null)
businessCode = ArrayBusinessCode[0];
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.FirstName)
{
firstName = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.JobTitle)
{
jobTitle = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.LastName)
{
lastName = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.WorlSize_Code)
{
string[] ArrayWorldSize_fk = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayWorldSize_fk = Item.Value.ToString().Split(',');
if (ArrayWorldSize_fk.Length > 0)
{
if (ArrayWorldSize_fk[0] != null)
worldSize = ArrayWorldSize_fk[0].ToString();
if (ArrayWorldSize_fk[1] != null)
numberOfEmployees = ArrayWorldSize_fk[1].ToString();
}
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Title)
{
string[] ArrayTitle = new string[1];
if (Item.Value != null)
{
if (Item.Value.ToString().Trim() != string.Empty.ToString())
{
ArrayTitle = Item.Value.ToString().Split(',');
if (ArrayTitle.Length > 0)
{
if (ArrayTitle[1] != null)
personalTitle = ArrayTitle[1].ToString();
}
}
}
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.PostCode)
{
postcode = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Telephone_Country)
{
telephoneCountry = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Telephone_Area)
{
telephoneArea = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Telephone)
{
telephoneNumber = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Telephone_Extn)
{
telephoneExt = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Fax_Country)
{
faxCountry = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Fax_Area)
{
faxArea = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Fax)
{
faxNumber = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Fax_Extn)
{
faxExt = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Mobile_Country)
{
mobileCountry = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Mobile)
{
mobileNumber = Item.Value.ToString();
}
if (Item.Key.ToString() == "aid_p_" + ObjPersonalLabels.Town)
{
town = Item.Value.ToString();
}
#region flexfileds
if (Item.Key.ToString() == ObjPersonalLabels.flexfield1)
{
flexField1 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield2)
{
flexfield2 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield3)
{
flexField3 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield4)
{
flexField4 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield5)
{
flexField5 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield6)
{
flexField6 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield7)
{
flexField7 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield8)
{
flexField8 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield9)
{
flexField9 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield10 )
{
//flexField10 = Item.Value.ToString(); //RFG 2.12 QC:6946
flexField10 = Item.Value.ToString().Equals("") ? null : Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield11)
{
flexField11 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield12)
{
flexField12 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield13)
{
flexField13 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield14)
{
flexField14 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.flexfield15)
{
flexField15 = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.campaign_code)
{
CamaignCode = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.wavecode)
{
WaveCode = Item.Value.ToString();
}
if (Item.Key.ToString() == ObjPersonalLabels.JumpId)
{
JumpId = Item.Value.ToString();
}
#endregion
}
}
}
if (countryCode == "")
countryCode = CountryCode;
ResponseDto = new PersonalResponseDto(Convert.ToInt64(ResponseID), address1, address2, address3, businessCode, businessSiebel63,
companyName, countryCode, county, customerId, emailAddress, firstName, flexField1, flexField10,
flexField11, flexField12, flexField13, flexField14, flexField15, flexfield2, flexField3, flexField4,
flexField5, flexField6, flexField7, flexField8, flexField9, jobCode, jobSiebel63, jobTitle, lastName,
personalTitle, postcode, pwd, telephoneCountry, telephoneArea, telephoneNumber, telephoneExt, faxCountry, faxArea, faxNumber, faxExt, mobileCountry, mobileNumber, town, worldSize, worldSize63, countryName, emailPreferences, preferredLanguage, companyWebsite,companyRevenue); //RFG 2.11
FormRegistry.ResponseDao.Add(ResponseDto);
responses.Add(ResponseDto);
ShippingAddressResponseDto ResponseShippingDetails = null;
ResponseShippingDetails = new ShippingAddressResponseDto(Convert.ToInt64(ResponseID), address1, address2, address3, countryCode, county, customerId, emailAddress, postcode, town, true, countryName);
FormRegistry.ResponseDao.Add(ResponseShippingDetails);
}
public override List<ResponseDto> GetResponseDto(long responseId)
{
List<ResponseDto> retval = new List<ResponseDto>();
PersonalResponseDto pResponse = new PersonalResponseDto();
if(_textIds != null && _textIds.Count >= 2)
{
TextBox pwd = FindControl(_textIds[0]) as TextBox;
TextBox pwdconf = FindControl(_textIds[1]) as TextBox;
pResponse.Pwd = pwd.Text;
pResponse.Pwdconfirm = pwdconf.Text;
}
retval.Add(pResponse);
return retval;
}
/// <summary>
/// Mapps as much as possible from customer_datarecords to PersonalResponseDto
/// </summary>
/// <param name="reader"></param>
/// <param name="personal">PersonalResponseDto to be filled</param>
/// <param name="o">offset of fields in fields_customer_datarecords in the given reader</param>
private void ReadCustomerDataRecords(IDataReader reader, PersonalResponseDto personal, int o)
{
//personal = GetString(reader, o + (int)fields_customer_datarecords.GUID);
personal.CountryCode = GetString(reader, o + (int)fields_customer_datarecords.country_FK);
// fields_customer_datarecords.language_FK -> moved down to handling for fields_customer_datarecords.preferred_language
personal.EmailAddress = GetString(reader, o + (int)fields_customer_datarecords.email_address);
personal.FirstName = GetString(reader, o + (int)fields_customer_datarecords.first_name);
personal.LastName = GetString(reader, o + (int)fields_customer_datarecords.last_name);
personal.BusinessCode = GetString(reader, o + (int)fields_customer_datarecords.company_id); // TODO: Correct Mapping ?
personal.CompanyName = GetString(reader, o + (int)fields_customer_datarecords.company_name);
personal.Address1 = GetString(reader, o + (int)fields_customer_datarecords.address1);
personal.Address2 = GetString(reader, o + (int)fields_customer_datarecords.address2);
personal.Address3 = GetString(reader, o + (int)fields_customer_datarecords.address3);
personal.Town = GetString(reader, o + (int)fields_customer_datarecords.town);
personal.County = GetString(reader, o + (int)fields_customer_datarecords.county);
personal.Postcode = GetString(reader, o + (int)fields_customer_datarecords.postcode);
personal.TelephoneNumber = GetString(reader, o + (int)fields_customer_datarecords.telephone);
//personal = GetString(reader, o + (int)fields_customer_datarecords.contact_by_email_o);
//personal = GetString(reader, o + (int)fields_customer_datarecords.source_db_id);
//personal = GetString(reader, o + (int)fields_customer_datarecords.siebel_con_id);
//personal = GetString(reader, o + (int)fields_customer_datarecords.siebel_prosp_id);
//personal = GetString(reader, o + (int)fields_customer_datarecords.purl);
//personal = GetString(reader, o + (int)fields_customer_datarecords.source_db_name);
//personal = GetString(reader, o + (int)fields_customer_datarecords.campaign_code_FK);
personal.WorldSize = GetString(reader, o + (int)fields_customer_datarecords.world_size_FK);
personal.JobCode = GetString(reader, o + (int)fields_customer_datarecords.job_code_FK);
personal.JobTitle = GetString(reader, o + (int)fields_customer_datarecords.jobtitle);
personal.BusinessCode = GetString(reader, o + (int)fields_customer_datarecords.business_code_FK);
personal.WorldSize63 = GetString(reader, o + (int)fields_customer_datarecords.worldsize_siebel63);
personal.JobSiebel63 = GetString(reader, o + (int)fields_customer_datarecords.job_siebel63);
personal.BusinessSiebel63 = GetString(reader, o + (int)fields_customer_datarecords.business_siebel63);
//personal = GetString(reader, o + (int)fields_customer_datarecords.greeting_string);
//personal = GetString(reader, o + (int)fields_customer_datarecords.edm_list_indicator);
personal.PersonalTitle = GetString(reader, o + (int)fields_customer_datarecords.personal_title);
//personal = GetString(reader, o + (int)fields_customer_datarecords.allowance_flag); ??
personal.FlexField1 = GetString(reader, o + (int)fields_customer_datarecords.flexfield1);
personal.FlexField2 = GetString(reader, o + (int)fields_customer_datarecords.flexfield2);
personal.FlexField3 = GetString(reader, o + (int)fields_customer_datarecords.flexfield3);
personal.FlexField4 = GetString(reader, o + (int)fields_customer_datarecords.flexfield4);
personal.FlexField5 = GetString(reader, o + (int)fields_customer_datarecords.flexfield5);
personal.FlexField6 = GetString(reader, o + (int)fields_customer_datarecords.flexfield6);
personal.FlexField7 = GetString(reader, o + (int)fields_customer_datarecords.flexfield7);
personal.FlexField8 = GetString(reader, o + (int)fields_customer_datarecords.flexfield8);
personal.FlexField9 = GetString(reader, o + (int)fields_customer_datarecords.flexfield9);
personal.FlexField10 = GetString(reader, o + (int)fields_customer_datarecords.flexfield10);
personal.FlexField11 = GetString(reader, o + (int)fields_customer_datarecords.flexfield11);
personal.FlexField12 = GetString(reader, o + (int)fields_customer_datarecords.flexfield12);
personal.FlexField13 = GetString(reader, o + (int)fields_customer_datarecords.flexfield13);
personal.FlexField14 = GetString(reader, o + (int)fields_customer_datarecords.flexfield14);
personal.FlexField15 = GetString(reader, o + (int)fields_customer_datarecords.flexfield15);
//personal = GetString(reader, o + (int)fields_customer_datarecords.siebel_campaign_code);
personal.Pwd = GetString(reader, o + (int)fields_customer_datarecords.pwd);
//personal = GetString(reader, o + (int)fields_customer_datarecords.date_deleted);
//personal = GetString(reader, o + (int)fields_customer_datarecords.delete_user);
//personal = GetString(reader, o + (int)fields_customer_datarecords.loadID);
personal.TelephoneCountry = GetString(reader, o + (int)fields_customer_datarecords.Telephone_country);
personal.TelephoneArea = GetString(reader, o + (int)fields_customer_datarecords.Telephone_area);
personal.TelephoneExt = GetString(reader, o + (int)fields_customer_datarecords.Telephone_extn);
personal.FaxCountry = GetString(reader, o + (int)fields_customer_datarecords.fax_country);
personal.FaxArea = GetString(reader, o + (int)fields_customer_datarecords.fax_area);
personal.FaxNumber = GetString(reader, o + (int)fields_customer_datarecords.fax);
personal.FaxExt = GetString(reader, o + (int)fields_customer_datarecords.fax_extn);
personal.MobileCountry = GetString(reader, o + (int)fields_customer_datarecords.mobile_country);
personal.MobileNumber = GetString(reader, o + (int)fields_customer_datarecords.mobile);
personal.PreferredLanguage = GetString(reader, o + (int)fields_customer_datarecords.language_FK);
if (string.IsNullOrEmpty(personal.PreferredLanguage))
personal.PreferredLanguage = GetString(reader, o + (int)fields_customer_datarecords.language_FK);
personal.CompanyWebsite = GetString(reader, o + (int)fields_customer_datarecords.company_website);
personal.CompanyRevenue = GetString(reader, o + (int)fields_customer_datarecords.company_revenue);
}
private CustomerInfoDto ReadCustomer(IDataReader reader, PersonalResponseDto personal)
{
// TODO: rewrite with indexes
CustomerInfoDto e = (personal is CustomerInfoDto) ? (CustomerInfoDto)personal : new CustomerInfoDto();
string strtemp;
for (int i = 0; i < reader.FieldCount; i++)
{
string field = reader.GetName(i);
switch (field)
{
case "questionnaire":
e.Questionnaire = GetString(reader, i); break;
case "questionnaire_id":
e.Questionnaire_id = (int)GetInt32(reader, i); break;
case "customer_id":
personal.CustomerId = GetString(reader, i); break;
case "country_FK":
personal.CountryCode = GetString(reader, i); break;
// case "language_FK": rfg 2.20 pro-issue fixed
case "Language_FK":
e.Language_FK = GetString(reader, i); break;
case "email_address":
personal.EmailAddress = GetString(reader, i); break;
case "first_name":
personal.FirstName = GetString(reader, i); break;
case "last_name":
personal.LastName = GetString(reader, i); break;
case "company_id":
e.Company_id = GetString(reader, i); break;
case "company_name":
personal.CompanyName = GetString(reader, i); break;
case "company_website":
personal.CompanyWebsite = GetString(reader, i); break;
case "company_revenue":
personal.CompanyRevenue = GetString(reader, i); break;
case "number_of_employees":
case "world_size_FK":
personal.WorldSize = GetString(reader, i); break;
case "worldsize_siebel63":
personal.WorldSize = GetString(reader, i); break;
case "job_code":
case "job_code_FK":
personal.JobCode = GetString(reader, i); break;
case "job_siebel63":
personal.JobSiebel63 = GetString(reader, i); break;
case "jobtitle":
personal.JobTitle = GetString(reader, i); break;
case "business_name":
case "business_code_FK":
personal.BusinessCode = GetString(reader, i); break;
case "business_siebel63":
personal.BusinessSiebel63 = GetString(reader, i); break;
case "greeting_string":
e.Greeting_string = GetString(reader, i); break;
case "personal_title":
personal.PersonalTitle = GetString(reader, i); break;
case "address1":
personal.Address1 = GetString(reader, i); break;
case "address2":
personal.Address2 = GetString(reader, i); break;
case "address3":
personal.Address3 = GetString(reader, i); break;
case "town":
personal.Town = GetString(reader, i); break;
case "county":
personal.County = GetString(reader, i); break;
case "postcode":
personal.Postcode = GetString(reader, i); break;
case "telephone_country":
personal.TelephoneCountry = GetString(reader, i); break;
case "telephone_area":
personal.TelephoneArea = GetString(reader, i); break;
case "telephone":
personal.TelephoneNumber = GetString(reader, i); break;
case "telephone_extn":
personal.TelephoneExt = GetString(reader, i); break;
case "fax_country":
personal.FaxCountry = GetString(reader, i); break;
case "fax_area":
personal.FaxArea = GetString(reader, i); break;
case "fax":
personal.FaxNumber = GetString(reader, i); break;
case "fax_extn":
personal.FaxExt = GetString(reader, i); break;
case "mobile_country":
personal.MobileCountry = GetString(reader, i); break;
case "mobile":
personal.MobileNumber = GetString(reader, i); break;
case "flexfield1":
personal.FlexField1 = GetString(reader, i); break;
case "flexfield2":
personal.FlexField2 = GetString(reader, i); break;
case "flexfield3":
personal.FlexField3 = GetString(reader, i); break;
case "flexfield4":
personal.FlexField4 = GetString(reader, i); break;
case "flexfield5":
personal.FlexField5 = GetString(reader, i); break;
case "flexfield6":
personal.FlexField6 = GetString(reader, i); break;
case "flexfield7":
personal.FlexField7 = GetString(reader, i); break;
case "flexfield8":
personal.FlexField8 = GetString(reader, i); break;
case "flexfield9":
personal.FlexField9 = GetString(reader, i); break;
case "flexfield10":
personal.FlexField10 = GetString(reader, i); break;
case "flexfield11":
personal.FlexField11 = GetString(reader, i); break;
case "flexfield12":
personal.FlexField12 = GetString(reader, i); break;
case "flexfield13":
personal.FlexField13 = GetString(reader, i); break;
case "flexfield14":
personal.FlexField14 = GetString(reader, i); break;
case "flexfield15":
personal.FlexField15 = GetString(reader, i); break;
case "pwd":
personal.Pwd = GetString(reader, i); break;
case "siebel_con_id":
e.Siebel_con_id = GetInt32(reader, i); break;
case "siebel_prosp_id":
e.Siebel_prosp_id = GetInt32(reader, i); break;
case "contact_by_email":
strtemp = GetString(reader, i);
e.Privacy.ContactByEmail = string.IsNullOrEmpty(strtemp) ? (bool?)null : strtemp.Equals(0) ? false : true;
break;
case "email_pref":
strtemp = GetString(reader, i);
personal.EmailPreferences = e.Privacy.EmailPreferences = string.IsNullOrEmpty(strtemp)? (EmailPreferences?)null : strtemp.ToLower().Equals("html")? EmailPreferences.Html : EmailPreferences.Text;
break;
case "contact_by_post":
strtemp = GetString(reader, i);
e.Privacy.ContactByPost = string.IsNullOrEmpty(strtemp) ? (bool?)null : strtemp.Equals(0) ? false : true;
break;
case "contact_by_phone":
strtemp = GetString(reader, i);
e.Privacy.ContactByPhone = string.IsNullOrEmpty(strtemp) ? (bool?)null : strtemp.Equals(0) ? false : true;
break;
case "mailstop_flag":
strtemp = GetString(reader, i);
e.Privacy.MailStop = string.IsNullOrEmpty(strtemp) ? (bool?)null : strtemp.Equals(0) ? false : true;
break;
case "response_id":
case "response_FK":
long? responseFK = GetInt64(reader, i);
if (responseFK.HasValue)
e.Privacy.ResponseKey = personal.ResponseKey = (long)responseFK; break;
case "responser_id":
case "RID":
e.Responser_id = GetString(reader, i); break;
default:
break;
}
}
return e;
}
public void PersonalizeWith(PersonalResponseDto customer)
{
_customer = customer;
}
private PersonalResponseDto GetCustomerByRID(string rid)
{
PersonalResponseDto retval = new PersonalResponseDto();
const int personalOffset = 2; // offset 2, as two fields are inserted before the PersonalResponse Table in Select
const int privacyOffset = personalOffset + (int)fields_personal_response.__COUNT;
Call_Select_Customer(null, rid,
delegate(IDataReader reader)
{
do
{
// first two values in reader are not needed, as already known
ReadPersonal(reader, retval, personalOffset);
ReadPrivacy(reader, retval, privacyOffset);
} while (reader.Read());
});
return retval;
}
public void ReplaceStaticPlaceholders(StringBuilder messageBody, PersonalResponseDto data)
{
PlaceholdersFacade.Replace(messageBody, data);
}
private void SendUnsubscribeEmail(QuestionnaireDto questionnaire, PersonalResponseDto customer, string rid)
{
List<ResponseDto> responses = new List<ResponseDto>();
CompleteResponseDTO complete = new CompleteResponseDTO(customer.CustomerId, rid, responses,
new FormSubmissionFacade.IResponseServiceClass(questionnaire, this.PageAssembly.Page, questionnaire.CountryCode, questionnaire.LanguageCode, true),
customer.ResponseKey);
responses.Add(customer);
EmailFacade.SendUnsubscribeEmail(complete, customer.EmailAddress);
}
private void PhoneValidationStatus(PersonalDataSectionDto elementDto, PersonalResponseDto response, List<int> validationHints)
{
foreach (KeyValuePair<PersonalDataSectionElements, Triple<int?, bool, bool>> elementToCheck in elementDto.PresentationPosition)
{
if (elementToCheck.Value != null)
{
// if (!(elementToCheck.Value.Second))//mandatory
// {
//int validationHint = DoTheSwitch(elementDto, response, elementToCheck.Key);
//if (validationHint > 0)
//{
// validationHints.Add(validationHint);
//}
if (response != null)
{
switch (elementToCheck.Key)
{
case PersonalDataSectionElements.Telephone:
if (!ValidateLongPhone(response.TelephoneCountry, response.TelephoneArea, response.TelephoneNumber, response.TelephoneExt, false))
{
validationHints.Add(PersonalDataSectionDto.InvalidTelephone);
}
break;
default:
break;
}
}
// }
}
}
}