예제 #1
0
        public CustomerInfoDto GetCustomerInfoAndUnsubscribe(string email_address, string rid, int qid)
        {
            CustomerInfoDto retval = null;
            Call_SelectCustomerInfoLogin(email_address, null, qid, rid, null, null, "unsub",
                reader =>
                {
                    retval = new CustomerInfoDto();
                    ReadCustomerInfo(reader, retval);
                });

            return retval;
        }
예제 #2
0
        public CustomerInfoDto GetCustomerInfoForReset(string email_address, int qid)
        {
            CustomerInfoDto retval = null;
            Call_SelectCustomerInfoLogin(email_address, null, qid, null, null, null, null,
                reader => 
                { 
                    retval = new CustomerInfoDto(); 
                    ReadCustomerInfo(reader, retval);
                });

            return retval;
        }
예제 #3
0
 /// <summary>
 /// Replacing Place holders which are not replaced by ReplaceStaticPlaceholders
 /// </summary>
 /// <param name="messageBody"></param>
 /// <param name="data"></param>
 public void ReplacePlaceholders(StringBuilder messageBody, CustomerInfoDto data)
 {
     PlaceholdersFacade.Replace(messageBody, data);
 }
예제 #4
0
        private void ReadCustomerInfo(IDataReader reader, CustomerInfoDto customer)
        { 
            customer.Questionnaire = GetString(reader, (int)fields_customerinfo_fromResponseId.questionnaire);
            customer.Questionnaire_id = (int)GetInt32(reader, (int)fields_customerinfo_fromResponseId.questionnaire_id);
            customer.Customer_id = GetString(reader, (int)fields_customerinfo_fromResponseId.customer_id);
            customer.Country_FK = GetString(reader, (int)fields_customerinfo_fromResponseId.country_FK);
            customer.Language_FK = GetString(reader, (int)fields_customerinfo_fromResponseId.language_FK);
            customer.EmailAddress = GetString(reader, (int)fields_customerinfo_fromResponseId.email_address);
            customer.FirstName = GetString(reader, (int)fields_customerinfo_fromResponseId.first_name);
            customer.LastName = GetString(reader, (int)fields_customerinfo_fromResponseId.last_name);
            customer.Company_id = GetString(reader, (int)fields_customerinfo_fromResponseId.company_id);
            customer.CompanyName = GetString(reader, (int)fields_customerinfo_fromResponseId.company_name);
            customer.CompanyWebsite = GetString(reader, (int)fields_customerinfo_fromResponseId.company_website);
            customer.CompanyRevenue = GetString(reader, (int)fields_customerinfo_fromResponseId.company_revenue); 
            customer.WorldSize = GetString(reader, (int)fields_customerinfo_fromResponseId.number_of_employees);
            customer.JobCode = GetString(reader, (int)fields_customerinfo_fromResponseId.job_code);
            customer.JobTitle = GetString(reader, (int)fields_customerinfo_fromResponseId.jobtitle);
            customer.BusinessCode = GetString(reader, (int)fields_customerinfo_fromResponseId.business_name);
            customer.Greeting_string = GetString(reader, (int)fields_customerinfo_fromResponseId.greeting_string);
            customer.PersonalTitle = GetString(reader, (int)fields_customerinfo_fromResponseId.personal_title);
            customer.Address1 = GetString(reader, (int)fields_customerinfo_fromResponseId.address1);
            customer.Address2 = GetString(reader, (int)fields_customerinfo_fromResponseId.address2);
            customer.Address3 = GetString(reader, (int)fields_customerinfo_fromResponseId.address3);
            customer.Town = GetString(reader, (int)fields_customerinfo_fromResponseId.town);
            customer.County = GetString(reader, (int)fields_customerinfo_fromResponseId.county);
            customer.Postcode = GetString(reader, (int)fields_customerinfo_fromResponseId.postcode);
            customer.TelephoneCountry = GetString(reader, (int)fields_customerinfo_fromResponseId.telephone_country);
            customer.TelephoneArea = GetString(reader, (int)fields_customerinfo_fromResponseId.telephone_area);
            customer.TelephoneNumber = GetString(reader, (int)fields_customerinfo_fromResponseId.telephone);
            customer.TelephoneExt = GetString(reader, (int)fields_customerinfo_fromResponseId.telephone_extn);
            customer.FaxCountry = GetString(reader, (int)fields_customerinfo_fromResponseId.fax_country);
            customer.FaxArea = GetString(reader, (int)fields_customerinfo_fromResponseId.fax_area);
            customer.FaxNumber = GetString(reader, (int)fields_customerinfo_fromResponseId.fax);
            customer.FaxExt = GetString(reader, (int)fields_customerinfo_fromResponseId.fax_extn);
            customer.MobileCountry = GetString(reader, (int)fields_customerinfo_fromResponseId.mobile_country);
            customer.MobileNumber = GetString(reader, (int)fields_customerinfo_fromResponseId.mobile);
            customer.FlexField1 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield1);
            customer.FlexField2 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield2);
            customer.FlexField3 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield3);
            customer.FlexField4 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield4);
            customer.FlexField5 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield5);
            customer.FlexField6 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield6);
            customer.FlexField7 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield7);
            customer.FlexField8 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield8);
            customer.FlexField9 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield9);
            customer.FlexField10 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield10);
            customer.FlexField11 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield11);
            customer.FlexField12 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield12);
            customer.FlexField13 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield13);
            customer.FlexField14 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield14);
            customer.FlexField15 = GetString(reader, (int)fields_customerinfo_fromResponseId.flexfield15);
            customer.Pwd = GetString(reader, (int)fields_customerinfo_fromResponseId.pwd);
            customer.Siebel_con_id = GetInt32(reader, (int)fields_customerinfo_fromResponseId.siebel_con_id);
            customer.Siebel_prosp_id = GetInt32(reader, (int)fields_customerinfo_fromResponseId.siebel_prosp_id);
            customer.Contact_by_email = ConvertToBool(GetString(reader, (int)fields_customerinfo_fromResponseId.contact_by_email));
            customer.Email_pref = ConvertToEmailPreferences(GetString(reader, (int)fields_customerinfo_fromResponseId.email_pref));
            customer.Contact_by_post = ConvertToBool(GetString(reader, (int)fields_customerinfo_fromResponseId.contact_by_post));
            customer.Contact_by_phone = ConvertToBool(GetString(reader, (int)fields_customerinfo_fromResponseId.contact_by_phone));
            customer.Mailstop_flag = ConvertToBool(GetString(reader, (int)fields_customerinfo_fromResponseId.mailstop_flag));
            customer.Response_FK = (long)GetInt64(reader, (int)fields_customerinfo_fromResponseId.response_FK);
            customer.Responser_id = GetString(reader, (int)fields_customerinfo_fromResponseId.responser_id);

        }
예제 #5
0
        public void TestReplacePlaceholdersFromCustomerInfoDto()
        {         
            EmailFormatterBase f = new EmailFormatterBase();

            CustomerInfoDto data = new CustomerInfoDto();
            data.Questionnaire = "questionnaire";
            data.Questionnaire_id = 1234546; //"[questionnaire_id]";
            data.Customer_id = "customer_id";
            data.Country_FK = "country_fk";
            data.Language_FK = "language_fk";
            data.Company_id = "company_id";
            //data.CompanyRevenue = "";
            data.CompanyWebsite = "companywebsite";
            data.Greeting_string = "greeting_string";
            data.Pwd1 = "pwd";
            data.Siebel_con_id = 234567; // "[siebel_con_id]"
            data.Siebel_prosp_id = 345678; // "[siebel_prosp_id]"
            
            #region TODO: these should also be tested with NULL
            data.Contact_by_email = true; // "[contact_by_email]"
            data.Email_pref = EmailPreferences.Text; // "[email_pref]"
            data.Contact_by_post = true; //"[contact_by_post]"
            data.Contact_by_phone = true; // "[contact_by_phone]"
            data.Mailstop_flag = true; //"[mailstop_flag]"
            #endregion

            data.Response_FK = 456789; //"[response_fk]"
            data.Responser_id = "responser_id";
            //"[url_to_questionnaire], data.questionnaire);
            //"[wavecode]", data.questionnaire);
            //"[flexfield_jumpid]", data.questionnaire);
            //"[number_of_employees]", data.number_of_employees);
            //"[job_code]", data.job_code);
            //"[business_name]", data.business_name);

            string[] placeholders = new string[]
            {
                "[questionnaire]",
                "[questionnaire_id]",
                "[customer_id]",
                "[country_fk]",
                "[language_fk]",
                "[company_id]",
                "[greeting_string]",
                "[pwd]",
                "[siebel_con_id]",
                "[siebel_prosp_id]",
                "[contact_by_email]",
                "[email_pref]",
                "[contact_by_post]",
                "[contact_by_phone]",
                "[mailstop_flag]",
                "[response_fk]",
                "[responser_id]",
                //"[url_to_questionnaire],
                //"[wavecode]",
                //"[flexfield_jumpid]",
                //"[number_of_employees]", 
                //"[job_code]",
                //"[business_name]",
                "[company_website]",
                //"[companyrevenue]", 

            };

            string result = "questionnaire|1234546|customer_id|country_fk|language_fk|company_id|greeting_string|pwd|234567|345678|True|Text|True|True|True|456789|responser_id|companywebsite";

            StringBuilder sb = new StringBuilder();

            foreach (string placeholder in placeholders)
            {
                if (sb.Length > 0)
                    sb.Append('|');
                sb.Append(placeholder);
            }

            f.ReplacePlaceholders(sb, data);

            Assert.AreEqual(result, sb.ToString());
        }