コード例 #1
0
        public List<Breed> GetBreedList(int sid, PetfirstCustomer mCustomer)
        {
            List<Breed> lstReturn = null;
            string cacheKey = string.Concat("$BreedList_sid$" ,sid);
            object CachedList = m_Cache.Get(cacheKey) as List<Breed>;
            if (CachedList == null)//get from the service
            {
                CoreServiceReference.CoreServiceClient cs = new CoreServiceClient();
                CoreServiceGetBreedListRequest cRequest = new CoreServiceGetBreedListRequest();
                cRequest.SpeciesId = sid;
                CoreServiceGetBreedListResponse cbResponse = cs.GetBreedList(cRequest);
                //insert select breed on the top
                if (string.IsNullOrEmpty(cbResponse.Error.ErrorText))//check error
                {

                    if (cbResponse.Breeds != null)
                    {
                        lstReturn = ModifyMixedBreed(sid, cbResponse.Breeds);
                        m_Cache.Add(cacheKey, lstReturn);
                    }
                }
                else
                {
                    lstReturn = null;
                    LogException le = new LogException();
                    try
                    {

                        le.LogError(HttpContext.Current.Request.Url.AbsoluteUri, "Error during getting breed list", cbResponse.Error.ErrorText, mCustomer);
                        ///Test email server
                        //le.SendErrorEmail(string.Concat(Request.Url.AbsoluteUri, "<br/><hr />", msg, "<hr />User Input:", le.BuildUserDataString(mCustomer)));
                    }
                    catch (Exception ex)
                    {
                        ///Test email server
                        //lblError.Text = ex.ToString();
                        try
                        {
                            le.SendErrorEmail(string.Concat(HttpContext.Current.Request.Url.AbsoluteUri, "<br/><hr />", ex.Message, "<br />StackTrace: ", ex.StackTrace, "<br /><hr />User Input:", le.BuildUserDataString(mCustomer)));
                        }
                        catch { }
                    }
                }
            }
            else
            {
                lstReturn = (List<Breed>)CachedList;
            }
            return lstReturn;
        }
コード例 #2
0
        public PetColor[] GetColorList(PetfirstCustomer mCustomer)
        {
            PetColor[] lstReturn = null;
            string cacheKey = "$ColorList$";
            object CachedList = m_Cache.Get(cacheKey) as PetColor[];
            if (CachedList == null)//get from the service
            {
                CoreServiceReference.CoreServiceClient cs = new CoreServiceClient();
                CoreServiceGetColorListResponse ccResponse = cs.GetColorList();
                //insert select breed on the top
                if (string.IsNullOrEmpty(ccResponse.Error.ErrorText))//check error
                {
                    if (ccResponse.Colors !=null)
                    {
                        lstReturn = ccResponse.Colors;
                        m_Cache.Add(cacheKey, lstReturn);
                    }
                }
                else
                {
                    lstReturn = null;
                    LogException le = new LogException();
                    try
                    {

                        le.LogError(HttpContext.Current.Request.Url.AbsoluteUri, "Error during getting color list", ccResponse.Error.ErrorText, mCustomer);
                        ///Test email server
                        //le.SendErrorEmail(string.Concat(Request.Url.AbsoluteUri, "<br/><hr />", msg, "<hr />User Input:", le.BuildUserDataString(mCustomer)));
                    }
                    catch (Exception ex)
                    {
                        ///Test email server
                        //lblError.Text = ex.ToString();
                        try
                        {
                            le.SendErrorEmail(string.Concat(HttpContext.Current.Request.Url.AbsoluteUri, "<br/><hr />", ex.Message, "<br />StackTrace: ", ex.StackTrace, "<br /><hr />User Input:", le.BuildUserDataString(mCustomer)));
                        }
                        catch { }
                    }
                }
            }
            else
            {
                lstReturn = (PetColor[])CachedList;
            }
            return lstReturn;
        }
コード例 #3
0
 private QuoteServiceReference.Customer CreateQuoteCustomer(PetfirstCustomer mCustomer)
 {
     return new QuoteServiceReference.Customer()
     {
         FirstName = mCustomer.MembershipInfo.FirstName,
         LastName = mCustomer.MembershipInfo.LastName,
         StreetAddress = mCustomer.MembershipInfo.Address1,
         StreetAddress2 = mCustomer.MembershipInfo.Address2,
         CityName = mCustomer.MembershipInfo.City,
         StateId = mCustomer.MembershipInfo.StateId,
         ZipCode = mCustomer.MembershipInfo.Zip,
         EmailAddress = mCustomer.MembershipInfo.Email,
         HomePhone = mCustomer.MembershipInfo.Phone,
         MobilePhone = String.Empty,
         WorkPhone = String.Empty
     };
 }
コード例 #4
0
        private void SetQuoteOtherAttributes(ref QuoteServiceCreateNewQuoteRequest qRequest, PetfirstCustomer mCustomer, List<Pet> lstPets,bool bMontly)
        {
            qRequest.UnderwriterID = mCustomer.Underwriter;
            qRequest.IncludeRoutine = false;
            qRequest.IncludeRoutine125 = false;
            qRequest.IncludeRoutine250 = false;
            qRequest.IncludeRoutine400 = false;
            qRequest.MilitaryDiscount = mCustomer.DiscountMilitarySelected;
            qRequest.InternetDiscount = mCustomer.DiscountInternetPurchase;
            qRequest.VetDiscount = mCustomer.DiscountVetSelected;

            if (!lstPets[0].Routine.ToLower().Equals("0"))
            {
                qRequest.IncludeRoutine = true;
                switch (lstPets[0].Routine.ToLower())
                {
                    case "routine125":
                        qRequest.IncludeRoutine125 = true;
                        break;
                    case "routine250":
                        qRequest.IncludeRoutine250 = true;
                        break;
                    case "routine400": qRequest.IncludeRoutine400 = true;
                        break;

                }
            }
            qRequest.PlanId = lstPets[0].PlanId;
            if (bMontly)
                qRequest.PaymentFrequencyId = 1;//1 monthly, 2: annually
            else
                qRequest.PaymentFrequencyId = 2;
            qRequest.IncludeBreeders = lstPets[0].Breeder;

            if(lstPets[0].Hereditary.ToLower().Equals("hereditary100"))
            {
              qRequest.IncludeHereditary100 =true;
            }
            else if (lstPets[0].Hereditary.ToLower().Equals("hereditary25"))
            {
                qRequest.IncludeHereditary25 = true;
            }
            else
            {
                qRequest.IncludeHereditary100 = false;
                qRequest.IncludeHereditary25 = false;

            }
            qRequest.IncludePrescriptionFood = lstPets[0].PrescriptionFood;
            qRequest.KrogerLoyaltyNumber = String.Empty;
            qRequest.EnrollmentCode = mCustomer.EnrollmentCode;
            qRequest.Deductible = lstPets[0].DeductibleAmount;
            qRequest.CoInsurance = 1-lstPets[0].Reimbursement;
            qRequest.UnderwriterID = mCustomer.Underwriter;

            try
            {

                int nPlan = lstPets[0].PlanId;
                qRequest.FilingID = (from pts in context.v_PlansToStates
                                     where pts.stateProvinceID.Equals(mCustomer.MembershipInfo.StateId) &&
                                         pts.UnderwriterID.Equals(mCustomer.Underwriter) &&
                                         pts.plan_id == nPlan
                                     select pts.FilingID).First();
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
コード例 #5
0
        private bool LoadPlanInfo(ref PetfirstCustomer mCustomer, string splanLookup)
        {
            bool bReturn = true;
            SqlConnection con = GetConnection();
            SqlDataReader sdr = null;
            SqlCommand cmd = new SqlCommand("usp_pricecompare_prequote_get_by_quote_id", con);
            string sMemberCodeString = "I";

            if (mCustomer.DiscountMilitarySelected)
            {
                sMemberCodeString += "M";
            }

            if (mCustomer.DiscountVetSelected)
            {
                sMemberCodeString += "A";
            }

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@pre_quote_id", SqlDbType.BigInt));
            cmd.Parameters["@pre_quote_id"].Value = Int32.Parse(splanLookup);

            cmd.Parameters.Add(new SqlParameter("@membercodestring", SqlDbType.VarChar, 20));
            cmd.Parameters["@membercodestring"].Value = sMemberCodeString;

            try
            {
                con.Open();
                sdr = cmd.ExecuteReader();

                while (sdr.Read())
                {
                    foreach (Pet mp in mCustomer.MyPets)
                    {
                        mp.AnnualPaymentTotal = sdr.GetDecimal(PTANNUALTOTAL);
                        mp.DeductibleAmount = sdr.GetDecimal(PTDEDUCTIBLE);
                        mp.Enrolled = true;
                        mp.FirstMonthPaymentTotal = sdr.GetDecimal(PTFIRSTMONTHTOTAL);
                        mp.FirstMonthPremiumOnly = sdr.GetDecimal(PTFIRSTMONTHTOTAL);
                        mp.FirstMonthTax = sdr.GetDecimal(PTFIRSTMONTHTAXFEE);
                        mp.IsFamilyPlan = false;
                        mp.PlanId = sdr.GetByte(PTPLANID);
                        mp.QuoteId = sdr.GetInt32(PTQUOTEID);
                        mp.RecurringMonthPaymentTotal = sdr.GetDecimal(PTRECURRINGMONTHTOTAL);
                        mp.RecurringMonthPremiumOnly = sdr.GetDecimal(PTRECURRINGMONTHTOTAL);
                        mp.RecurringMonthTax = sdr.GetDecimal(PTRECURRINGMONTHTAXFEE);
                        mp.Reimbursement = 1 - sdr.GetDecimal(PTCOPAY);
                        mp.InternetDiscountAmount = sdr.GetDecimal(PTDISCOUNTS);

                        using (PetfirstData pfData = new PetfirstData())
                        {
                            mp.LimitAmount = pfData.GetPlanLimitByPlanId(mp.PlanId);
                            mp.PlanName = pfData.GetPlanShortNameByPlanId(mp.PlanId);
                            pfData.SavePet(mp, mCustomer.CustomerId);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                bReturn = false;
                LoggingError(ex.Message, ex.StackTrace);
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                    con.Dispose();
                    con = null;
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                    cmd = null;
                }
            }

            return (bReturn);
        }
コード例 #6
0
        public void StoreLeadCapture(ref PetfirstCustomer mCustomer, List<Pet> lstPets)
        {
            //lead capture
            string[,] petData = new string[3, 5] { { "", "", "", "", "" }, { "", "", "", "", "" }, { "", "", "", "", "" } };
            int count = lstPets.Count;
            if (count == 1)
            {
                SetLeadPet1(ref petData, lstPets);
            }
            else if (count == 2)
            {
                SetLeadPet2(ref petData, lstPets);
            }
            else if (count ==3)
            {
                SetLeadPet3(ref petData, lstPets);
            }
            decimal reimbursement = 0;
            decimal dedcutible = 0;
            decimal coverage = 0;
            int quoteId = 0;
            string planName = "";
            string policyNumber = "";
            string leadId = "";
            Int64 policyId = 0;
            foreach(Pet pet in lstPets)//only create one lead
            {
                reimbursement = pet.Reimbursement;
                dedcutible = pet.DeductibleAmount;
                coverage = pet.LimitAmount;
                quoteId = pet.QuoteId;
                planName = pet.PlanName;
                policyNumber = pet.PolicyNumber;
                leadId = pet.LeadId;
                policyId = pet.PolicyId;
                break;
            }
            LeadCaptureServiceStoreLeadCaptureRequest lRequest = new LeadCaptureServiceStoreLeadCaptureRequest()
            {
                Email = mCustomer.MembershipInfo.Email,
                //ExtensionData = null,
                City = !String.IsNullOrEmpty(mCustomer.MembershipInfo.City) ? mCustomer.MembershipInfo.City : "",
                Company = "PetFirst Web",
                EnrollmentCode = mCustomer.EnrollmentCode,
                PlanCopay = reimbursement != 0m ? ((1 - reimbursement) * 100).ToString() : null,
                PlanDeductible = dedcutible != 0m ? dedcutible.ToString() : null,
                Coverage = coverage != -0m ? coverage.ToString("C0") : null,
                PlanSelected = planName,
                EmailNow = false, //what value??
                FirstName = mCustomer.MembershipInfo.FirstName,
                LastName = mCustomer.MembershipInfo.LastName,
                LoyaltyCard = string.Empty,
                PaymentType = mCustomer.PayFrequency.ToString(),
                Pet1Name = petData[0, 0],
                Pet1BDay = petData[0, 1],
                Pet1Breed = petData[0, 2],
                Pet1Species = petData[0, 3],
                Pet1Gender = petData[0, 4],
                Pet2Name = petData[1, 0],
                Pet2BDay = petData[1, 1],
                Pet2Breed = petData[1, 2],
                Pet2Species = petData[1, 3],
                Pet2Gender = petData[1, 4],
                Pet3Name = petData[2, 0],
                Pet3BDay = petData[2, 1],
                Pet3Breed = petData[2, 2],
                Pet3Species = petData[2, 3],
                Pet3Gender = petData[2, 4],
                PetsCovered = count.ToString(),
                PhoneNumber = mCustomer.MembershipInfo.Phone,
                //PolicyId = policyNumber,
                PolicyId = policyId.ToString(),
                QuoteId = quoteId.ToString(),
                State = mCustomer.MembershipInfo.StateId != 0 ? mCustomer.MembershipInfo.StateId.ToString() : null,
                StreetAddress1 = mCustomer.MembershipInfo.Address1,
                StreetAddress2 = mCustomer.MembershipInfo.Address2,
                ZipCode = mCustomer.MembershipInfo.Zip,
                PolicySold = !String.IsNullOrEmpty(policyNumber),
                LeadId = leadId
            };
            Lead_CaptureServiceClient lsClient = new Lead_CaptureServiceClient();
            try
            {

                LeadCaptureServiceStoreLeadCaptureResponse response = lsClient.InsertLeadCapture(lRequest);
                if (string.IsNullOrEmpty(response.Error.ErrorText))
                {
                    foreach (Pet pet in lstPets)//only create one lead
                    {
                        pet.LeadId = response.LeadId;
                    }
                    mCustomer.WebserviceErrorMsg = "";
                }
                else
                {
                    mCustomer.WebserviceErrorMsg = response.Error.ErrorText;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                try
                {
                    if (lsClient.State == CommunicationState.Faulted)
                        lsClient.Abort();
                    else if(lsClient.State == CommunicationState.Opened)
                        lsClient.Close();
                }
                catch { }
            }
        }
コード例 #7
0
        public string BuildUserDataString(PetfirstCustomer mCustomer)
        {
            StringBuilder sb = null;
            if (mCustomer != null)
            {
                //capture the user input data
                sb = new StringBuilder(3000);
                sb.Append(string.Concat("Enrollment:", mCustomer.EnrollmentCode,","));
                if (mCustomer.MyPets != null)
                {
                    int i = 1;
                    foreach (Pet pet in mCustomer.MyPets)
                    {
                        sb.Append(string.Concat("Pet",i,"Name:", pet.PetName, ","));
                        sb.Append(string.Concat("Pet",i,"Species:", pet.SpeciesId.ToString(), ","));
                        sb.Append(string.Concat("Pet",i,"bDay:", pet.Birthday.ToShortDateString(), ","));
                        sb.Append(string.Concat("Pet",i,"Breed:", pet.BreedId.ToString(), ","));
                        if (pet.LimitAmount != 0)
                            sb.Append(string.Concat("Pet", i, "Limit:", pet.LimitAmount.ToString("C0"), ","));
                        if (pet.DeductibleAmount != 0)
                            sb.Append(string.Concat("Pet", i, "Deductible:", pet.DeductibleAmount.ToString("C0"), ","));
                        if (pet.Reimbursement != 0)
                        {
                            sb.Append(string.Concat("Pet", i, "Copay:", pet.Reimbursement.ToString("0%"), ","));
                            sb.Append(string.Concat("Pet", i, "Routine:", pet.Routine.ToString(), ","));
                            sb.Append(string.Concat("Pet", i, "PlanId:", pet.PlanId.ToString(), ","));
                        }
                        i++;
                    }

                }

                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.FirstName))
                    sb.Append(string.Concat("MemberFirstName:", mCustomer.MembershipInfo.FirstName, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.LastName))
                    sb.Append(string.Concat("MemberLastName:", mCustomer.MembershipInfo.LastName, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.Address1))
                    sb.Append(string.Concat("MemberAddress1:", mCustomer.MembershipInfo.Address1, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.Address2))
                    sb.Append(string.Concat("MemberAddress2:", mCustomer.MembershipInfo.Address2, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.City))
                    sb.Append(string.Concat("MemberCity:", mCustomer.MembershipInfo.City, ","));
                if( mCustomer.MembershipInfo.StateId!=0)
                    sb.Append(string.Concat("MemberStateId:", mCustomer.MembershipInfo.StateId.ToString(), ","));
                if(!string.IsNullOrEmpty(mCustomer.MembershipInfo.Zip))
                    sb.Append(string.Concat("MemberZip:", mCustomer.MembershipInfo.Zip, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.Phone))
                    sb.Append(string.Concat("MemberPhone:", mCustomer.MembershipInfo.Phone, ","));
                if (!string.IsNullOrEmpty(mCustomer.MembershipInfo.Email))
                    sb.Append(string.Concat("MemberEmail:", mCustomer.MembershipInfo.Email, ","));
                if (!mCustomer.IsBillSameAsMembership)
                {
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.FirstName))
                        sb.Append(string.Concat("BillingFirstName:", mCustomer.BillingInfo.FirstName, ","));
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.LastName))
                        sb.Append(string.Concat("BillingLastName:", mCustomer.BillingInfo.LastName, ","));
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.Address1))
                        sb.Append(string.Concat("BillingAddress1:", mCustomer.BillingInfo.Address1, ","));
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.Address2))
                        sb.Append(string.Concat("BillingAddress2:", mCustomer.BillingInfo.Address2, ","));
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.City))
                        sb.Append(string.Concat("BillingCity:", mCustomer.BillingInfo.City, ","));
                    if (mCustomer.BillingInfo.StateId != 0)
                        sb.Append(string.Concat("BillingStateId:", mCustomer.BillingInfo.StateId.ToString(), ","));
                    if (!string.IsNullOrEmpty(mCustomer.BillingInfo.Zip))
                        sb.Append(string.Concat("BillingZip:", mCustomer.BillingInfo.Zip, ","));
                }
                if (!string.IsNullOrEmpty(mCustomer.CcNumber))
                    sb.Append(string.Concat("CC:", GetCCLast4(mCustomer.CcNumber), ","));
                if (!string.IsNullOrEmpty(mCustomer.SecCode))
                    sb.Append(string.Concat("Cvv2:", mCustomer.SecCode, ","));
                if (mCustomer.ExpirationMonth != 0)
                    sb.Append(string.Concat("CCExpireMonth:", mCustomer.ExpirationMonth.ToString(), ","));
                if (mCustomer.ExpirationYear != 0)
                    sb.Append(string.Concat("CCExpireYear:", mCustomer.ExpirationYear.ToString(), ","));
                if (mCustomer.PayFrequency != 0)
                    sb.Append(string.Concat("PaymentFrequency:", mCustomer.PayFrequency.ToString()));
                if (mCustomer.GiftCards != null)
                {
                    int i = 1;
                    foreach (GiftCard gc in mCustomer.GiftCards)
                    {
                        sb.Append(string.Concat("GC", i, "Number:", gc.Number, ","));
                        sb.Append(string.Concat("GC", i, "Pin:", gc.Pin, ","));
                        i++;
                    }
                }
            }
            else
            {
                sb = new StringBuilder(30);
                sb.Append("Session data is null");
            }
            return sb.ToString();
        }
コード例 #8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            mCustomer = (PetfirstCustomer)Session["Customer"];
            if (mCustomer == null)
            {
                Response.Redirect("Default.aspx", false);
                Context.ApplicationInstance.CompleteRequest();
            }
            else
            {
                if (String.IsNullOrEmpty(mCustomer.MembershipInfo.Email))// add check to deal with android browser cache
                {
                    Response.Redirect("Default.aspx", false);
                    Context.ApplicationInstance.CompleteRequest();
                }
                else
                {
                    if (!Page.IsPostBack)
                    {
                        if (Request.UrlReferrer != null)////kp: 2015-05-04 retrieve quote - show quote retrieved pop up modal ////if it comes from default.aspx page
                        {
                            if (Request.UrlReferrer.AbsoluteUri.ToLower().Contains("default.aspx") || Request.UrlReferrer.AbsoluteUri.ToLower().EndsWith("petfirst.com/") || Request.UrlReferrer.AbsoluteUri.ToLower().Contains("petfirst.com/?"))
                            {
                                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                                sb.Append("$('#retrieve_quote').modal('show');");
                                ClientScript.RegisterStartupScript(typeof(Page), "ShowModalCheckout", sb.ToString(), true );
                            }
                        }

                        PopulateCCExpiration();
                        rblPayFrequency.SelectedValue = "1";
                        //lblpetcount.Text = mCustomer.MyPets.Count.ToString();

                        List<Pet> myPet = new List<Pet>();
                        foreach (Pet p in mCustomer.MyPets)
                        {
                            myPet.Add(p);
                        }
                        FakeMultiPet(ref myPet);
                        CreatePetsTable(myPet);
                        CalculateTotals();
                        BindPlanRepeater();
                        load_states();
                        lblCoverageDate.Text = (DateTime.Now.AddDays(1)).ToShortDateString();

                        //load from session
                        LoadCustomerInfo();
                        txtAddress1.Attributes.Add("onchange", "TextBoxChange()");
                        txtAddress2.Attributes.Add("onchange", "TextBoxChange()");
                        txtCity.Attributes.Add("onchange", "TextBoxChange()");
                        txtZip.Attributes.Add("onchange", "TextBoxChange()");
                        ddlState.Attributes.Add("onchange", "DropdownListChange()");

                    }
                    this.Master.PhoneNumber = mCustomer.CallCenter;

                }
            }
        }
コード例 #9
0
 private void SaveCustomerToDb(PetfirstCustomer mCustomer, wsQCustomer dbCustomer, bool bAdd)
 {
     dbCustomer.BillCity = mCustomer.BillingInfo.City;
     dbCustomer.BillFirstName = mCustomer.BillingInfo.FirstName;
     dbCustomer.BillLastName = mCustomer.BillingInfo.LastName;
     dbCustomer.BillState = mCustomer.BillingInfo.State;
     dbCustomer.BillStateId = mCustomer.BillingInfo.StateId;
     dbCustomer.BillStreetAddress = mCustomer.BillingInfo.Address1;
     dbCustomer.BillStreetAddress2 = mCustomer.BillingInfo.Address2;
     dbCustomer.BillZipcode = mCustomer.BillingInfo.Zip;
     dbCustomer.City = mCustomer.MembershipInfo.City;
     dbCustomer.FirstName = mCustomer.MembershipInfo.FirstName;
     dbCustomer.LastName = mCustomer.MembershipInfo.LastName;
     dbCustomer.State = mCustomer.MembershipInfo.State;
     dbCustomer.StateId = mCustomer.MembershipInfo.StateId;
     dbCustomer.StreetAddress = mCustomer.MembershipInfo.Address1;
     dbCustomer.StreetAddress2 = mCustomer.MembershipInfo.Address2;
     dbCustomer.Zipcode = mCustomer.MembershipInfo.Zip;
     dbCustomer.Email = mCustomer.MembershipInfo.Email;
     dbCustomer.EnrollmentCode = mCustomer.EnrollmentCode;
     dbCustomer.Phone = mCustomer.MembershipInfo.Phone;
     dbCustomer.PaymentFrequency = mCustomer.PayFrequency;
     if (!bAdd)
         dbCustomer.ModifyDate = DateTime.Now;
     else
         context.wsQCustomers.AddObject(dbCustomer);
     context.SaveChanges();
     if (mCustomer.CustomerId == 0)
         mCustomer.CustomerId = dbCustomer.QCustomerID;
 }
コード例 #10
0
 protected void Page_Load(object sender, EventArgs e)
 {
     mCustomer = (PetfirstCustomer)Session["Customer"];
     if (mCustomer == null)
     {
         Response.Redirect("Default.aspx", false);
         Context.ApplicationInstance.CompleteRequest();
     }
     else
     {
         if (String.IsNullOrEmpty(mCustomer.MembershipInfo.Email))// add check to deal with android browser cache
         {
             Response.Redirect("Default.aspx", false);
             Context.ApplicationInstance.CompleteRequest();
         }
         else
         {
             if (!Page.IsPostBack)
             {
                 lblEmail.Text = mCustomer.MembershipInfo.Email;
                 txtEmail.Text = mCustomer.MembershipInfo.Email;
                 //kp: 2015-06-29
                 //loadColorList();
                 LoadBirthYear();
                 //end 2015-06-29
                 ResetInput();//this will default to dog and load breed
                 ////kp: 2015-05-04 retrieve quote
                 //try
                 //{
                 //    if (mCustomer.OldCustData)
                 //    {
                 //        RetrieveSavedData();
                 //    }
                 //}
                 //catch{ }
                ////end 2015-05-04
                 bindPets();
                 DetermineButtonText();
             }
             this.Master.PhoneNumber = mCustomer.CallCenter;
         }
     }
 }
コード例 #11
0
        public void RetrieveSavedData(ref PetfirstCustomer mCustomer)
        {
            wsQCustomer dbCustomer = GetCustomerById(mCustomer.CustomerId);
            if (dbCustomer != null)
            {
                mCustomer.BillingInfo.City = dbCustomer.BillCity;
                mCustomer.BillingInfo.FirstName = dbCustomer.BillFirstName;
                mCustomer.BillingInfo.LastName = dbCustomer.BillLastName;
                mCustomer.BillingInfo.State = dbCustomer.BillState;
                if(dbCustomer.BillStateId !=null)
                    mCustomer.BillingInfo.StateId = (int)dbCustomer.BillStateId;
                mCustomer.BillingInfo.Address1 = dbCustomer.BillStreetAddress;
                mCustomer.BillingInfo.Address2 = dbCustomer.BillStreetAddress2;
                mCustomer.BillingInfo.Zip = dbCustomer.BillZipcode;
                mCustomer.MembershipInfo.City = dbCustomer.City;
                mCustomer.MembershipInfo.FirstName = dbCustomer.FirstName;
                mCustomer.MembershipInfo.LastName = dbCustomer.LastName;
                mCustomer.MembershipInfo.State = dbCustomer.State;
                if(dbCustomer.StateId !=null)
                    mCustomer.MembershipInfo.StateId = (int)dbCustomer.StateId;
                mCustomer.MembershipInfo.Address1 = dbCustomer.StreetAddress;
                mCustomer.MembershipInfo.Address2 = dbCustomer.StreetAddress2;
                mCustomer.MembershipInfo.Zip = dbCustomer.Zipcode;
                mCustomer.MembershipInfo.Email = dbCustomer.Email;
                mCustomer.EnrollmentCode = dbCustomer.EnrollmentCode;
                mCustomer.MembershipInfo.Phone = dbCustomer.Phone;
                if(dbCustomer.PaymentFrequency !=null)
                    mCustomer.PayFrequency = (short)dbCustomer.PaymentFrequency;
            }
            int custId =mCustomer.CustomerId;
            ////kp:2015-05-04 Retrieve Quote
            DateTime endDate = DateTime.Today.AddDays(90);// prinsloo wants to data from 90 days back//TODO: verify with Prinsloo
            //end 2015-05-04
            //retrieve pets
            if (custId != 0)
            {
                mCustomer.MyPets.Clear();
                //find the pets that does not have a policy but have plandata

                var lstDbPet1 = (from p in context.wsQPets
                                 join
                                     pl in context.wsQPlans on p.QPlanID equals pl.QPlanID
                                 where p.QCustomerID == custId
                                 && (pl.PolicyNumber.Equals("") || pl.PolicyNumber == null)
                                 && pl.CreateDate <= endDate
                                 select p).ToList();
                //list of pets that does not have a quote yet
                var lstDbPet2 = (from p in context.wsQPets
                                 where p.QCustomerID == custId
                                 && (p.QPlanID==0 ||p.QPlanID ==null)
                                 //&& p.CreateDate <=endDate
                                 select p).ToList();
                var lstDbPet = lstDbPet1.Concat(lstDbPet2).ToList();
                //this filter dup
                //var lstDbPet = new List<wsQPet>(lstDbPet1);
                //lstDbPet.AddRange(lstDbPet2.Where(p2 => lstDbPet1.All(p1 => p1.QPetID != p2.QPetID)));
                foreach (wsQPet dbPet in lstDbPet)
                {
                    Pet pet = new Pet();
                    pet.PetId = dbPet.QPetID;
                    if(dbPet.Birthdate !=null)
                        pet.Birthday =(DateTime) dbPet.Birthdate;

                    if (dbPet.BreedId != null)
                    {
                        pet.BreedId = (int)dbPet.BreedId;
                        pet.BreedName = dbPet.BreedName;
                    }
                    if (dbPet.ColorId != null)
                    {
                        pet.ColorId = (int)dbPet.ColorId;
                        pet.ColorName = dbPet.ColorName;
                    }
                    pet.PetName = dbPet.PetName;
                    pet.Gender = dbPet.Gender;
                    if (dbPet.Gender.Equals("M"))
                        pet.GenderFull = "Male";
                    else if (dbPet.Gender.Equals("F"))
                        pet.GenderFull = "Female";
                    custId = dbPet.QCustomerID;
                    if(dbPet.QPlanID !=null)
                        pet.QPlanId =(int) dbPet.QPlanID;
                    if(dbPet.SpayedOrNeutered !=null)
                        pet.SpayedOrNeutered = (bool)dbPet.SpayedOrNeutered;
                    if (dbPet.SpeciesId != null)
                    {
                        pet.SpeciesId = (int)dbPet.SpeciesId;
                        pet.SpeciesName = dbPet.SpeciesName;
                    }
                    if(dbPet.WeightId!=null)
                        pet.WeightId =(int) dbPet.WeightId;
                    if (dbPet.QPlanID !=null)
                    {
                        pet.QPlanId = (int)dbPet.QPlanID;
                    }
                    else
                        pet.Enrolled = false;
                    if (dbPet.ModifyDate == null)
                        pet.ModifiedDate = dbPet.CreateDate;
                    else
                        pet.ModifiedDate = (DateTime)dbPet.ModifyDate;
                    mCustomer.MyPets.Add(pet);
                }
               //retrieve plans
                var lstDbPlan = (from p in context.wsQPets
                                 join
                                     pl in context.wsQPlans on p.QPlanID equals pl.QPlanID
                                 where p.QCustomerID == custId
                                 && (pl.PolicyNumber.Equals("") || pl.PolicyNumber == null)
                                 && pl.CreateDate <= endDate
                                 ////kp: 2015-05-21 delete standard plan site wide
                                 && pl.PlanId >=61 //only retrieve lifetime
                                 ////end 2015-05-21
                                 select pl).ToList();
                foreach (wsQPlan dbQPlan in lstDbPlan)
                {
                    foreach (Pet p in mCustomer.MyPets)
                    {
                        int count = 0;
                        if (p.QPlanId == dbQPlan.QPlanID)
                        {
                            count++;
                            if (dbQPlan.Deductible != null)
                                p.DeductibleAmount = (decimal)dbQPlan.Deductible;
                            p.LeadId = dbQPlan.LeadId;
                            if (dbQPlan.PlanId != null)
                                p.PlanId = (int)dbQPlan.PlanId;
                            if (dbQPlan.PlanTypeId != null)
                                p.PlanType = dbQPlan.PlanTypeId.ToString();
                            p.PlanName = dbQPlan.PlanName;
                            if (dbQPlan.QuoteId != null)
                                p.QuoteId = (int)dbQPlan.QuoteId;
                            if (dbQPlan.Limit != null)
                                p.LimitAmount = (decimal)dbQPlan.Limit;
                            if (dbQPlan.Reimbursement != null)
                                p.Reimbursement = (decimal)dbQPlan.Reimbursement;
                            p.Breeder = dbQPlan.RiderBreeders;
                            if (dbQPlan.RiderHereditary100)
                                p.Hereditary = "hereditary100";
                            else if (dbQPlan.RiderHereditary25)
                                p.Hereditary = "hereditary25";
                            p.PrescriptionFood = dbQPlan.RiderPrescriptionFood;
                            if (dbQPlan.RiderRoutine125)
                                p.Routine = "routine125";
                            else if (dbQPlan.RiderRoutine250)
                                p.Routine = "routine250";
                            else if (dbQPlan.RiderRoutine400)
                                p.Routine = "routine400";
                            if (dbQPlan.AnnualPayment != null)
                                p.AnnualPaymentTotal = (decimal)dbQPlan.AnnualPayment;
                            if (dbQPlan.FirstMonthPayment != null)
                                p.FirstMonthPaymentTotal = (decimal)dbQPlan.FirstMonthPayment;
                            if (dbQPlan.FirstMonthTax != null)
                                p.FirstMonthTax = (decimal)dbQPlan.FirstMonthTax;
                            if (dbQPlan.RecurringMonthPayment != null)
                                p.RecurringMonthPaymentTotal = (decimal)dbQPlan.RecurringMonthPayment;
                            if (dbQPlan.RecurringMonthTax != null)
                                p.RecurringMonthTax = (decimal)dbQPlan.RecurringMonthTax;
                            if (dbQPlan.PolicyId != null)
                                p.PolicyId = (Int64)dbQPlan.PolicyId;
                            p.Enrolled = true;
                            p.OldQuoteData = true; //retrieved old quote amount
                            ////kp: 2015-05-04 retrieve quote
                            if (dbQPlan.ModifyDate == null)
                                p.ModifiedDate = dbQPlan.CreateDate;
                            else
                                p.ModifiedDate = (DateTime)dbQPlan.ModifyDate;
                            //concat rider name to display on the page
                            string ridername = string.Empty;
                            bool hasRider = false;
                            //routine
                            if (p.Routine.Equals("routine125"))
                            {
                                hasRider = true;
                                ridername = "Routine Care 125";
                            }
                            else if (p.Routine.Equals("routine250"))
                            {
                                hasRider = true;
                                ridername = "Routine Care 250";
                            }
                            else if (p.Routine.Equals("routine400"))
                            {
                                hasRider = true;
                                ridername = "Routine Care 400";
                            }
                            //prescrption food
                            if (hasRider && p.PrescriptionFood)
                            {
                                ridername += "<br />" + "Prescription Food";
                            }
                            else if (p.PrescriptionFood)
                            {
                                hasRider = true;
                                ridername = "Prescription Food";
                            }
                            //hereditary
                            if (hasRider && p.Hereditary.Equals("hereditary25"))
                            {
                                ridername += "<br />" + "Hereditary & Chronic 25%";
                            }
                            else if (hasRider && p.Hereditary.Equals("hereditary100"))
                            {
                                ridername += "<br />" + "Hereditary & Chronic 100%";
                            }
                            else if (p.Hereditary.Equals("hereditary25"))
                            {
                                hasRider = true;
                                ridername = "Hereditary & Chronic 25%";
                            }
                            else if (p.Hereditary.Equals("hereditary100"))
                            {
                                hasRider = true;
                                ridername = "Hereditary & Chronic 100%";
                            }
                            //breeder
                            if (hasRider && p.Breeder)
                            {
                                ridername += "<br />" + "Breeder Coverage";
                            }
                            else if (p.Breeder)
                            {
                                ridername = "Breeder Coverage";
                            }
                            p.RiderName = ridername;
                            ////end 2015-05-04
                        }
                        if (count > 1)
                            p.IsFamilyPlan = true;
                    }
                }

            }
        }
コード例 #12
0
 public void SaveCustomer(PetfirstCustomer mCustomer)
 {
     wsQCustomer dbCustomer = null;
     bool bAdd = false;
     dbCustomer = GetCustomerByEmailZip(mCustomer.MembershipInfo.Email, mCustomer.MembershipInfo.Zip);//tries to get by email and zip
     if (dbCustomer == null)
     {
         if (mCustomer.CustomerId==0)
         {
             dbCustomer = new wsQCustomer();
             bAdd = true;
             dbCustomer.CreateDate = DateTime.Now;
         }
         else
             dbCustomer = GetCustomerById(mCustomer.CustomerId);
     }
     else
     {
         mCustomer.OldCustData = true;//customer saved in db
         mCustomer.CustomerId = dbCustomer.QCustomerID;
     }
     if (dbCustomer == null)
     {
         dbCustomer = new wsQCustomer();
         bAdd = true;
         dbCustomer.CreateDate = DateTime.Now;
         SaveCustomerToDb(mCustomer, dbCustomer, bAdd);
     }
     else {
         SaveCustomerToDb(mCustomer, dbCustomer, bAdd);
     }
 }
コード例 #13
0
        protected void Page_Load(object sender, EventArgs e)
        {
            HandleMenuItems();

            mCustomer = (PetfirstCustomer)Session["Customer"];
            mthisPet = (Pet)Session["Pet"];
            if (mCustomer == null)
            {
                Response.Redirect("Default.aspx", false);
                Context.ApplicationInstance.CompleteRequest();
            }
            else
            {
                if (!Page.IsPostBack)
                {
                    if (mCustomer != null)
                    {
                        ListsManager lm = new ListsManager();
                        PopulatePlanDetails(lm);
                    }

                    if (mthisPet != null)
                    {
                        if(!string.IsNullOrEmpty(Request.QueryString["canceladd"])) //see if we are cancelling add pet. If so, then load latest pet.
                        {
                            mthisPet = mCustomer.MyPets.ElementAtOrDefault(mCustomer.MyPets.Count - 1);
                            mCustomer.MyPets.RemoveAt(mCustomer.MyPets.Count - 1);
                        }

                        string jd;
                        PetName.Text = mthisPet.PetName + "'s";
                        ddlLimit.SelectedValue = mthisPet.LimitAmount.ToString("C0");
                        ddlDeductible.SelectedValue  = mthisPet.DeductibleAmount.ToString("C0");
                        ddlReimburse.SelectedValue = jd = (mthisPet.Reimbursement.ToString("P0").Replace(" ", ""));
                        ddlRoutine.SelectedValue = GetRiderNameFromValue(mthisPet.Routine);
                        lblDiscounts.Text = (mthisPet.InternetDiscountAmount +
                                             mthisPet.EBDiscountAmount +
                                             mthisPet.MilitaryDiscountAmount +
                                             mthisPet.VetDiscountAmount).ToString("C2");
                    }
                }

                if (mthisPet != null)
                {
                    UpdateLabels();
                }

                this.Master.NumberofPets = (mCustomer.MyPets.Count + 1).ToString();

            }

            #region debug
            //            if (mCustomer != null && mthisPet != null)
            //            {
            //                CustomerDebug.Text = String.Format(@"  First Name: [{0}], Last Name: [{1}], Add1: [{2}], Add2: [{3}], City: [{4}], State: [{5}], StateCode: [{6}],
            //                                                 Zip: [{7}], Phone: [{8}], Email: [{9}], CustomerID: [{10}], CallCenter: [{11}], EC: [{12}], Pay Freq: [{13}],
            //                                                 CC Num: [{14}], Sec Code: [{15}], Exp: [{16}/{17}], LifeTimeActive: [{18}] DISCOUNTS: EBEC: [{19}], Vet: [{20}],
            //                                                 Military: [{21}], MilBranchID [{22}], MilStatusID[{23}]",
            //                   mCustomer.MembershipInfo.FirstName,
            //                   mCustomer.MembershipInfo.LastName,
            //                   mCustomer.MembershipInfo.Address1,
            //                   mCustomer.MembershipInfo.Address2,
            //                   mCustomer.MembershipInfo.City,
            //                   mCustomer.MembershipInfo.State,
            //                   mCustomer.MembershipInfo.StateId,
            //                   mCustomer.MembershipInfo.Zip,
            //                   mCustomer.MembershipInfo.Phone,
            //                   mCustomer.MembershipInfo.Email,
            //                   mCustomer.CustomerId,
            //                   mCustomer.CallCenter,
            //                   mCustomer.EnrollmentCode,
            //                   mCustomer.PayFrequency,
            //                   mCustomer.CcNumber,
            //                   mCustomer.SecCode,
            //                   mCustomer.ExpirationMonth,
            //                   mCustomer.ExpirationYear,
            //                   mCustomer.LifeTimeActive,
            //                   mCustomer.EBEnrollmentCodeDiscount,
            //                   mCustomer.VetDiscount,
            //                   mCustomer.MilitaryDiscount,
            //                   mCustomer.MilitaryBranchID,
            //                   mCustomer.MilitaryStatusID
            //                   );
            //                CurrentPetDebug.Text = String.Format(@"ID: [{0}], Name: [{1}], SpeciesID: [{2}], SpeciesName: [{3}], BreedID: [{4}], BreedName: [{5}], Age: [{6}],
            //                                                 BirthDay: [{7}], WeightID: [{8}], Gender: [{9}], GenderFull: [{10}], Limit Amount: [{11}], Deductible Amount: [{12}], Reimbursement: [{13}],
            //                                                 Rider Name: [{14}], Routine: [{15}], AnnualPaymentTotal: [{16}], FirstMonthlyPaymentTotal: [{17}], FirstMonthlyPremiumOnly: [{18}],
            //                                                 FirstMonthTax: [{19}], RecurringMonthPaymentTotal: [{20}], RecurringMonthPremiumOnly: [{21}], RecurringMonthTax [{22}], PolicyNumber[{23}],
            //                                                 PolicyID: [{24}], PlanType: [{25}], PlanName: [{26}], PlanID: [{27}], SpayedNeutered: [{28}]",
            //                    mthisPet.PetId,
            //                    mthisPet.PetName,
            //                    mthisPet.SpeciesId,
            //                    mthisPet.SpeciesName,
            //                    mthisPet.BreedId,
            //                    mthisPet.BreedName,
            //                    mthisPet.Age,
            //                    mthisPet.Birthday,
            //                    mthisPet.WeightId,
            //                    mthisPet.Gender,
            //                    mthisPet.GenderFull,
            //                    mthisPet.LimitAmount,
            //                    mthisPet.DeductibleAmount,
            //                    mthisPet.Reimbursement,
            //                    mthisPet.RiderName,
            //                    mthisPet.Routine,
            //                    mthisPet.AnnualPaymentTotal,
            //                    mthisPet.FirstMonthPaymentTotal,
            //                    mthisPet.FirstMonthPremiumOnly,
            //                    mthisPet.FirstMonthTax,
            //                    mthisPet.RecurringMonthPaymentTotal,
            //                    mthisPet.RecurringMonthPremiumOnly,
            //                    mthisPet.RecurringMonthTax,
            //                    mthisPet.PolicyNumber,
            //                    mthisPet.PolicyId,
            //                    mthisPet.PlanType,
            //                    mthisPet.PlanName,
            //                    mthisPet.PlanId,
            //                    mthisPet.SpayedOrNeutered);
            //            }
            #endregion
        }
コード例 #14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            HandleMenuItems();
            bCurrentCustomer = false;

            if (!string.IsNullOrEmpty(Request.QueryString["current_customer"]))
            {
                bCurrentCustomer = true;
            }

            mCustomer = (PetfirstCustomer)Session["Customer"];
            mthisPet = (Pet)Session["Pet"];
            if (mCustomer == null)
            {
                Response.Redirect("Default.aspx", false);
                Context.ApplicationInstance.CompleteRequest();
            }
            else
            {
                if (!Page.IsPostBack)
                {
                    if (bCurrentCustomer)
                    {
                        chkInternetDiscount.Checked = mCustomer.DiscountInternetPurchase;
                        MilitaryBlock.Visible = mCustomer.DiscountMilitaryAvailable;
                        chkMilitary.Checked = mCustomer.DiscountMilitarySelected;
                        chkEmployeeGroup.Checked = mCustomer.DiscountEBEnrollmentCode;
                        txtEmployer.Text = mCustomer.EBEnrollmentCodeCompany;
                        VetBlock.Visible = mCustomer.DiscountVetAvailable;
                        chkVetEmp.Checked = mCustomer.DiscountVetSelected;
                        txtEmail.Text = mCustomer.MembershipInfo.Email;
                        load_militarybranches();
                        ddlBranch.SelectedIndex = mCustomer.MilitaryBranchID;
                        load_militarystatus();
                        rblServiceType.SelectedIndex = mCustomer.MilitaryStatusID;
                        bCurrentCustomer = true;

                    }
                    else
                    {
                        chkInternetDiscount.Checked = mCustomer.DiscountInternetPurchase;
                        PetfirstData pfData = new PetfirstData();
                        chkEmployeeGroup.Checked = mCustomer.DiscountEBEnrollmentCode = pfData.IsCorporateDiscount(mCustomer.EnrollmentCode);
                        MilitaryBlock.Visible = mCustomer.DiscountMilitaryAvailable;
                        VetBlock.Visible = mCustomer.DiscountVetAvailable;
                        load_militarystatus();
                        load_militarybranches();
                    }
                }

                this.Master.NumberofPets = mCustomer.MyPets.Count.ToString();
            }
        }
コード例 #15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            mCustomer = (PetfirstCustomer)Session["Customer"];
            if (mCustomer == null)
            {
                Response.Redirect("Default.aspx", false);
                Context.ApplicationInstance.CompleteRequest();
            }
            else
            {
                if (String.IsNullOrEmpty(mCustomer.MembershipInfo.Email))// add check to deal with android browser cache
                {
                    Response.Redirect("Default.aspx", false);
                    Context.ApplicationInstance.CompleteRequest();
                }
                else
                {
                    this.Master.PhoneNumber = mCustomer.CallCenter;
                    if (!Page.IsPostBack)
                    {
                        ////kp: 2015-05-04 retrieve quote--add popup if comes from default.aspx page
                        if (Request.UrlReferrer != null)
                        {
                            //default page url example:
                            //http://quoteuat.petfirst.com/default.aspx
                            //http://quoteuat.petfirst.com/ or https://quotewww.petfirst.com/
                            //http://quoteuat.petfirst.com/?enrollment_code=99-99-20-6120
                            if (Request.UrlReferrer.AbsoluteUri.ToLower().Contains("default.aspx") || Request.UrlReferrer.AbsoluteUri.ToLower().EndsWith("petfirst.com/") || Request.UrlReferrer.AbsoluteUri.ToLower().Contains("petfirst.com/?"))
                            {
                                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                                sb.Append("$('#retrieve_quote').modal('show');");
                                ClientScript.RegisterStartupScript(typeof(Page), "ShowModalPlanInfo", sb.ToString(), true);
                            }
                        }
                        ////end 2015-05-04
                        Session.Remove("EditPlanPet");
                        lblEmail.Text = mCustomer.MembershipInfo.Email;
                        txtEmail.Text = mCustomer.MembershipInfo.Email;
                        BindPetsRepeater();
                        //dvStandard.Visible = false;
                        //dvLifetime.Visible = false;
                        try
                        {
                            ////kp: 2015-05-21 delete standard plan site wide
                            //ListsManager lm = new ListsManager();
                            //List<PlanType> lstPlanType = lm.GetPlanType(mCustomer.EnrollmentCode);
                            //foreach (PlanType pt in lstPlanType)
                            //{
                            //    if (pt.TypeName.ToLower().Contains("standard"))
                            //    {
                            //        dvStandard.Visible = true;
                            //    }
                            //    else if (pt.TypeName.ToLower().Contains("lifetime"))
                            //    {
                            //        dvLifetime.Visible = true;
                            //    }
                            //}
                            ////end 2015-05-21
                            DetermineReviewQuoteStatus();
                            //when edit is clicked on Checkout page, it will redirect to this page with quoteid in session
                            int quoteId = 0;
                            if (Session["qid"] != null)
                            {
                                quoteId = int.Parse(Session["qid"].ToString());
                                SetEditPets(quoteId);
                                Session.Remove("qid");
                            }
                            else
                            {
                                //default to lifetime and calls to populate plan detail: limit, reimbursement, etc and riders
                                ////kp: 2015-05-21 delete standard plan site wide
                                //ToggleButtonActive(false);
                                mCustomer.LifeTimeActive = true;
                                PopulatePlanPanel();
                                ////end 2015-05-21
                                DetermineFamilyOrIndividualPlan();
                            }

                        }
                        catch (Exception ex)
                        {
                            displayError(string.Concat("Error during load plan info by enrollment code:", mCustomer.EnrollmentCode), ex.ToString(), lblStartError);
                        }
                    }
                }
            }
        }
コード例 #16
0
        private void something(PetfirstCustomer mCustomer)
        {
            //int count = 0;
            string[,] petData = new string[3, 5] { { "", "", "", "", "" }, { "", "", "", "", "" }, { "", "", "", "", "" } };
            //foreach (PlanPet pp in mCustomer.PlanPets)
            //{
            //    if (pp.PetsEnrolled.Count != 0)
            //    {
            //        count = 1;
            //        petData[0, 0] = pp.PetsEnrolled[0].PetName; ;
            //        petData[0, 1] = pp.PetsEnrolled[0].Birthday.ToShortDateString();
            //        petData[0, 2] = pp.PetsEnrolled[0].BreedId.ToString();
            //        petData[0, 3] = pp.PetsEnrolled[0].SpeciesId.ToString();
            //        petData[0, 4] = pp.PetsEnrolled[0].Gender;
            //        if (pp.PetsEnrolled[1] != null)
            //        {
            //            petData[1, 0] = pp.PetsEnrolled[1].PetName;
            //            petData[1, 1] = pp.PetsEnrolled[1].Birthday.ToShortDateString();
            //            petData[1, 2] = pp.PetsEnrolled[1].BreedId.ToString();
            //            petData[1, 3] = pp.PetsEnrolled[1].SpeciesId.ToString();
            //            petData[1, 4] = pp.PetsEnrolled[1].Gender;
            //            count++;
            //        }
            //        if (pp.PetsEnrolled[2] != null)
            //        {
            //            petData[2, 0] = pp.PetsEnrolled[2].PetName;
            //            petData[2, 1] = pp.PetsEnrolled[2].Birthday.ToShortDateString();
            //            petData[2, 2] = pp.PetsEnrolled[2].BreedId.ToString();
            //            petData[2, 3] = pp.PetsEnrolled[2].SpeciesId.ToString();
            //            petData[2, 4] = pp.PetsEnrolled[2].Gender;
            //            count++;
            //        }

            //    }

            //}
        }
コード例 #17
0
 public void GetAnnualQuote(ref PetfirstCustomer mCustomer, List<Pet> lstPets)
 {
     mCustomer.WebserviceErrorMsg = "";
     QuoteServiceClient qclient = new QuoteServiceClient();
     QuoteServiceCreateNewQuoteRequest qRequest = new QuoteServiceCreateNewQuoteRequest();
     qRequest.Customer = CreateQuoteCustomer(mCustomer);
     SetQuoteRequestPets(ref qRequest,lstPets);
     SetQuoteOtherAttributes(ref qRequest,mCustomer,lstPets, false);
     try
     {
         QuoteServiceCreateNewQuoteResponse resp = qclient.CreateNewQuote(qRequest);
         if (string.IsNullOrEmpty(resp.Error.ErrorText))
         {
             foreach (Pet p in lstPets)
             {
                 p.AnnualPaymentTotal = resp.FirstDebitAmt;
             }
         }
         else
         {
             mCustomer.WebserviceErrorMsg = resp.Error.ErrorText;
         }
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         try
         {
             if (qclient.State == CommunicationState.Faulted)
                 qclient.Abort();
             else if (qclient.State == CommunicationState.Opened)
                 qclient.Close();
         }
         catch { }
     }
 }
コード例 #18
0
        public void CreatePolicy(ref PetfirstCustomer mCustomer, List<Pet> lstPets)
        {
            mCustomer.WebserviceErrorMsg = "";
            PolicyServiceSellPolicyRequest pRequest = new PolicyServiceSellPolicyRequest();
            if (!string.IsNullOrEmpty(mCustomer.CcNumber))
            {
                pRequest.CreditCard = new CreditCard()
                {
                    Address1 = mCustomer.BillingInfo.Address1,
                    Address2 = mCustomer.BillingInfo.Address2,
                    City = mCustomer.BillingInfo.City,
                    Cvvs2 = mCustomer.SecCode,
                    ExpirationMonth = mCustomer.ExpirationMonth,
                    ExpirationYear = mCustomer.ExpirationYear,
                    FirstName = mCustomer.BillingInfo.FirstName,
                    LastName = mCustomer.BillingInfo.LastName,
                    Number = mCustomer.CcNumber,
                    StateId = mCustomer.BillingInfo.StateId,
                    ZipCode = mCustomer.BillingInfo.Zip

                };
            }
            if (mCustomer.GiftCards != null)
            {
                int gcCount = mCustomer.GiftCards.Count;
                pRequest.GiftCards = new PolicyServiceReference.GiftCard[gcCount];
                int i =0;
                foreach (GiftCard gc in mCustomer.GiftCards)
                {
                    PolicyServiceReference.GiftCard pGC = new PolicyServiceReference.GiftCard();
                    pGC.Pin = gc.Pin;
                    pGC.SrcRefNum = 0;
                    pRequest.GiftCards[i] = pGC;
                    i++;
                }
            }
            pRequest.Customer = new PolicyServiceReference.Customer()
            {
                ZipCode = mCustomer.MembershipInfo.Zip,
                WorkPhone = String.Empty,
                StreetAddress2 = mCustomer.MembershipInfo.Address2,
                StreetAddress = mCustomer.MembershipInfo.Address1,
                StateId = mCustomer.MembershipInfo.StateId,
                MobilePhone = String.Empty,
                LastName = mCustomer.MembershipInfo.LastName,
                FirstName = mCustomer.MembershipInfo.FirstName,
                HomePhone = mCustomer.MembershipInfo.Phone,
                CityName = mCustomer.MembershipInfo.City,
                EmailAddress = mCustomer.MembershipInfo.Email
            };
            pRequest.CoInsurance = 1-lstPets[0].Reimbursement;
            pRequest.Deductible = lstPets[0].DeductibleAmount;
            pRequest.EnrollmentCode = mCustomer.EnrollmentCode;
            pRequest.PlanId = lstPets[0].PlanId;
            pRequest.PaymentFrequencyId = (int)mCustomer.PayFrequency;//annual
            pRequest.IncludeRoutine = false;
            pRequest.IncludeRoutine125 = false;
            pRequest.IncludeRoutine250 = false;
            pRequest.IncludeRoutine400 = false;
            if (!lstPets[0].Routine.ToLower().Equals("0"))
            {
                pRequest.IncludeRoutine = true;
                switch (lstPets[0].Routine.ToLower())
                {
                    case "routine125":
                        pRequest.IncludeRoutine125 = true;
                        break;
                    case "routine250":
                        pRequest.IncludeRoutine250 = true;
                        break;
                    case "routine400": pRequest.IncludeRoutine400 = true;
                        break;

                }
            }

            pRequest.InternetDiscount = mCustomer.DiscountInternetPurchase;
            pRequest.MilitaryDiscount = mCustomer.DiscountMilitarySelected;
            pRequest.VetDiscount = mCustomer.DiscountVetSelected;
            int nPlan = lstPets[0].PlanId;
            int stateid = mCustomer.MembershipInfo.StateId;
            int underwriter = mCustomer.Underwriter;
            pRequest.UnderwriterID = mCustomer.Underwriter;
            pRequest.FilingID = (from pts in context.v_PlansToStates
                                 where pts.stateProvinceID.Equals(stateid) &&
                                     pts.UnderwriterID.Equals(underwriter) &&
                                     pts.plan_id == nPlan
                                 select pts.FilingID).First();

            pRequest.IncludeBreeders = lstPets[0].Breeder;
            if (lstPets[0].Hereditary.ToLower().Equals("hereditary100"))
            {
                pRequest.IncludeHereditary100 = true;
            }
            else if (lstPets[0].Hereditary.ToLower().Equals("hereditary25"))
            {
                pRequest.IncludeHereditary25 = true;
            }
            else
            {
                pRequest.IncludeHereditary100 = false;
                pRequest.IncludeHereditary25 = false;
            }
            pRequest.IncludePrescriptionFood = lstPets[0].PrescriptionFood;
            pRequest.KrogerLoyaltyNumber = string.Empty;

            PolicyServiceReference.Pet p1 = CreatePolicyRequestPet(lstPets[0]);
            if (lstPets.Count ==3)//3 pets
            {
                pRequest.Pets = new PolicyServiceReference.Pet[3];
                pRequest.Pets[0] = p1;
                pRequest.Pets[1] = CreatePolicyRequestPet(lstPets[1]);
                pRequest.Pets[2] = CreatePolicyRequestPet(lstPets[2]);
            }
            else if (lstPets.Count ==2)
            {
                pRequest.Pets = new PolicyServiceReference.Pet[2];
                pRequest.Pets[0] = p1;
                pRequest.Pets[1] = CreatePolicyRequestPet(lstPets[1]);
            }
            else
            {
                pRequest.Pets = new PolicyServiceReference.Pet[1];
                pRequest.Pets[0] = p1;
            }

            PolicyServiceClient pc = new PolicyServiceClient();
            try
            {
                PolicyServiceSellPolicyResponse resp = pc.SellPolicy(pRequest);
                if (string.IsNullOrEmpty(resp.Error))
                {
                    foreach (Pet p in lstPets)
                    {
                        p.PolicyNumber = resp.PolicyNumber;
                        p.PolicyId = resp.PolicyId;
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(resp.PolicyNumber))
                    {
                        foreach (Pet p in lstPets)
                        {
                            p.PolicyNumber = resp.PolicyNumber;
                            p.PolicyId = resp.PolicyId;
                        }
                    }
                    mCustomer.WebserviceErrorMsg = resp.Error;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                try
                {
                    if (pc.State == CommunicationState.Faulted)
                        pc.Abort();
                    else if (pc.State == CommunicationState.Opened)
                        pc.Close();
                }
                catch { }
            }
        }
コード例 #19
0
        public List<MilitaryStatus> GetMilitaryStatusList(PetfirstCustomer mCustomer)
        {
            List<MilitaryStatus> lstReturn = new List<MilitaryStatus>();
            string cacheKey = "$MilitaryStatusList$";
            object CachedList = m_Cache.Get(cacheKey) as List<MilitaryBranch>;
            if (CachedList == null)//get from the service
            {
                CoreServiceReference.CoreServiceClient cs = new CoreServiceClient();
                CoreServiceGetMilitaryStatusResponse ccResponse = cs.GetMilitaryStatusList();

                foreach (MilitaryStatus ms in ccResponse.Status)
                {
                    lstReturn.Add(ms);
                }

                if (lstReturn.Count > 0)
                {
                    m_Cache.Add(cacheKey, lstReturn);
                }
                else
                {
                    lstReturn = null;
                    LogException le = new LogException();
                    try
                    {

                        le.LogError(HttpContext.Current.Request.Url.AbsoluteUri, "Error retreiving military status", ccResponse.Error.ErrorText, mCustomer);
                        ///Test email server
                        //le.SendErrorEmail(string.Concat(Request.Url.AbsoluteUri, "<br/><hr />", msg, "<hr />User Input:", le.BuildUserDataString(mCustomer)));
                    }
                    catch (Exception ex)
                    {
                        ///Test email server
                        //lblError.Text = ex.ToString();
                        try
                        {
                            le.SendErrorEmail(string.Concat(HttpContext.Current.Request.Url.AbsoluteUri, "<br/><hr />", ex.Message, "<br />StackTrace: ", ex.StackTrace, "<br /><hr />User Input:", le.BuildUserDataString(mCustomer)));
                        }
                        catch { }
                    }
                }
            }
            else
            {
                lstReturn = (List<MilitaryStatus>)CachedList;
            }

            return lstReturn;
        }
コード例 #20
0
 public void LogError(string source, string msg, string stack, PetfirstCustomer mCustomer)
 {
     //string hostname = GetDnsName();
     string ip = GetIPAddress();
     string userName = GetUserName();
     string userData = BuildUserDataString(mCustomer);
     WebExceptionCaptureServiceRequest wrequest = new WebExceptionCaptureServiceRequest();
     wrequest.CustomizedData = userData;
     wrequest.UserName = userName;
     wrequest.IPAddress = GetIPAddress();
     wrequest.HostName = GetDnsName();
     wrequest.Stacktrace = stack;
     wrequest.ErrorPageUrl = source;
     wrequest.ErrorMessage = msg;
     WebExceptionServiceClient wsc = new WebExceptionServiceClient();
     try
     {
         WebExceptionCaptureServiceResponse resp = wsc.SaveWebException(wrequest);
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         try
         {
             if (wsc.State == CommunicationState.Faulted)
                 wsc.Abort();
             else if (wsc.State == CommunicationState.Opened)
                 wsc.Close();
         }
         catch { }
     }
 }
コード例 #21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            mCustomer = (PetfirstCustomer)Session["Customer"];
            mthisPet = (Pet)Session["Pet"];

            HandleMenuItems();

            if (!string.IsNullOrEmpty(Request.QueryString["new_pet"]) && mCustomer != null)//if there is query srtring passed
            {
                bAddPet = true; //adding a new pet only
                CancelLink.HRef = "customizeplan.aspx?canceladd=true";
            }

            if (!string.IsNullOrEmpty(Request.QueryString["current_pet"]))
            {
                bSamePet = true;
            }

            if (!Page.IsPostBack)
            {
                if(bSamePet)
                {
                    txtZip.Text = mCustomer.MembershipInfo.Zip;
                    txtPetName.Text = mthisPet.PetName;

                    DateTime today = DateTime.Today;
                    int age = today.Year - mthisPet.Birthday.Year;
                    //if (mthisPet.Birthday > today.AddYears(-age)) age--;

                    ddlAge.SelectedIndex = age;
                    load_breeds(mthisPet.SpeciesId);
                    if (mthisPet.BreedId == 54)
                    {
                        ddlBreed.SelectedValue = "10000"; //+ mthisPet.WeightId).ToString();
                        rbRadioButtonListMixed.SelectedValue = mthisPet.WeightId.ToString();
                    }
                    else
                    {
                        ddlBreed.SelectedValue = mthisPet.BreedId.ToString();
                    }

                    rblSpecies.SelectedValue = mthisPet.SpeciesId.ToString();
                }
                else
                {
                    InitiatePetfirstCustomer();
                    InitiateNewPet();
                    rblSpecies.SelectedValue = "1";
                    load_breeds(1);
                    ddlBreed.SelectedIndex = 0;
                    rbRadioButtonListMixed.SelectedValue = "1";
                }

            }

            lblYourPet.Text = mthisPet.PetName;

            if (bAddPet)
            {
                txtZip.Text = mCustomer.MembershipInfo.Zip;
                txtZip.Enabled = false;
            }

            this.Master.NumberofPets = mCustomer.MyPets.Count.ToString();
        }
コード例 #22
0
        public bool GetFastQuote(ref PetfirstCustomer mCustomer, ref Pet thispet, bool bNewQuote)
        {
            bool bReturn = false;

            //Load from prequote;
            if (bNewQuote)
            {
                bReturn = LoadFastQuote(ref mCustomer, ref thispet);
            }

            if (thispet.preQuotes != null)
            {
                Int16 nPlanID = (Int16)thispet.PlanId;
                decimal dDeductible = thispet.DeductibleAmount;
                decimal dCopay = (1 - thispet.Reimbursement);
                Boolean b125 = false;
                Boolean b250 = false;
                Boolean b400 = false;

                switch (thispet.Routine)
                {
                    case "routine125":
                        b125 = true;
                        break;
                    case "routine250":
                        b250 = true;
                        break;
                    case "routine400":
                        b400 = true;
                        break;
                    default:
                        break;
                }

                try
                {
                    FastQuoteResponse thisQuote = (from qr in thispet.preQuotes.AsEnumerable()
                                                   where dDeductible == qr.Field<decimal>("Deductible") &&
                                                         dCopay == qr.Field<decimal>("Copay") &&
                                                         nPlanID == qr.Field<Int16>("PlanId") &&
                                                         b125 == qr.Field<Boolean>("Routine125") &&
                                                         b250 == qr.Field<Boolean>("Routine250") &&
                                                         b400 == qr.Field<Boolean>("Routine400")
                                                   select new FastQuoteResponse
                                                   {
                                                       QuoteID = qr.Field<int>("QuoteID"),
                                                       FilingID = qr.Field<int>("FilingID"),
                                                       AnnualPremiumAmount = qr.Field<decimal>("AnnualPremiumAmount"),
                                                       AdminFee = qr.Field<decimal>("AdminFee"),
                                                       RecurringMonthlyAmount = qr.Field<decimal>("ReccuringMonthlyAmount"),
                                                       FirstMonthPremiumAmount = qr.Field<decimal>("FirstMonthPremiumAmount"),
                                                       AnnualSavings = qr.Field<decimal>("AnnualSavings"),
                                                       AnnualDiscountAmount = qr.Field<decimal>("AnnualDiscountAmount")
                                                   }).FirstOrDefault();

                    if (thisQuote == null)
                    {
                        bReturn = false;
                    }
                    else
                    {

                        thispet.FirstMonthPaymentTotal = thisQuote.FirstMonthPremiumAmount;
                        thispet.FirstMonthTax = thisQuote.AdminFee;
                        thispet.RecurringMonthPaymentTotal = thisQuote.RecurringMonthlyAmount;
                        thispet.RecurringMonthTax = thisQuote.AdminFee;
                        thispet.InternetDiscountAmount = thisQuote.AnnualDiscountAmount;
                        thispet.EBDiscountAmount = 0;
                        thispet.MilitaryDiscountAmount = 0;
                        thispet.VetDiscountAmount = 0;
                        thispet.AnnualPaymentTotal = thisQuote.AnnualPremiumAmount;

                        if (mCustomer.Underwriter == 4)
                        {
                            thispet.FirstMonthPremiumOnly = thisQuote.FirstMonthPremiumAmount - thisQuote.AdminFee;
                            thispet.RecurringMonthPremiumOnly = thisQuote.RecurringMonthlyAmount - thisQuote.AdminFee;
                        }
                        else
                        {
                            thispet.FirstMonthPremiumOnly = thisQuote.FirstMonthPremiumAmount - thisQuote.AdminFee;
                            thispet.RecurringMonthPremiumOnly = thisQuote.RecurringMonthlyAmount - thisQuote.AdminFee;
                        }
                        thispet.QuoteId = thisQuote.QuoteID;
                        thispet.Enrolled = true;
                        thispet.OldQuoteData = false;

                        if (thisQuote.FilingID > 47)
                            thispet.MultiPetAvailable = true;

                        bReturn = true;
                    }
                }
                catch (Exception ex)
                {
                    bReturn = false;
                }
            }

            return (bReturn);
        }
コード例 #23
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(Request.QueryString["quoteref"])) //Make sure we have a quote
            {
                Response.Redirect("Default.aspx", false);
                Context.ApplicationInstance.CompleteRequest();
            }
            else
            {
                string[] sQuoteRef = (Request.QueryString["quoteref"]).Split('-');

                if (sQuoteRef.Count() == 2)
                {
                    if (!string.IsNullOrEmpty(sQuoteRef[0]) && !string.IsNullOrEmpty(sQuoteRef[1])) //Make sure the quote is well formed
                    {
                        mCustomer = new PetfirstCustomer();

                        if (mCustomer != null)
                        {
                            if (LoadCustomerInfo(ref mCustomer, sQuoteRef[1]))
                            {
                                if (LoadPlanInfo(ref mCustomer, sQuoteRef[0]))
                                {

                                    //Everthing is loaded that we can so move on to checkout.
                                    Session["Customer"] = mCustomer;
                                    Response.Redirect("Checkout.aspx", false);
                                    Context.ApplicationInstance.CompleteRequest();
                                }
                                else
                                {
                                    //couldn't find plan in db.....
                                    Response.Redirect("Default.aspx", false);
                                    Context.ApplicationInstance.CompleteRequest();
                                }
                            }
                            else
                            {
                                //couldn't load customer data from db....
                                Response.Redirect("Default.aspx", false);
                                Context.ApplicationInstance.CompleteRequest();
                            }
                        }
                        else
                        {
                            Response.Redirect("Default.aspx", false);
                            Context.ApplicationInstance.CompleteRequest();
                        }
                    }
                    else
                    {
                        Response.Redirect("Default.aspx", false);
                        Context.ApplicationInstance.CompleteRequest();
                    }
                }
                else
                {
                    Response.Redirect("Default.aspx", false);
                    Context.ApplicationInstance.CompleteRequest();
                }
            }
        }
コード例 #24
0
        public void GetMonthlyQuote(ref PetfirstCustomer mCustomer, List<Pet> lstPets)
        {
            mCustomer.WebserviceErrorMsg = "";
            QuoteServiceClient qclient = new QuoteServiceClient();
            QuoteServiceCreateNewQuoteRequest qRequest = new QuoteServiceCreateNewQuoteRequest();
            qRequest.Customer = CreateQuoteCustomer(mCustomer);
            SetQuoteRequestPets(ref qRequest, lstPets);
            SetQuoteOtherAttributes(ref qRequest, mCustomer,lstPets, true);
            try
            {
                QuoteServiceCreateNewQuoteResponse resp = qclient.CreateNewMonthlyQuote(qRequest);
                if (string.IsNullOrEmpty(resp.Error.ErrorText))
                {
                    foreach (Pet p in lstPets)
                    {
                        p.FirstMonthPaymentTotal = resp.FirstDebitAmt;
                        p.FirstMonthTax = resp.FirstTaxAmt;//this include tax and admin fee
                        p.RecurringMonthPaymentTotal = resp.RecurringDebitAmt;
                        p.RecurringMonthTax = resp.RecurringTaxAmt;//this include tax and admin fee
                        p.InternetDiscountAmount = resp.InternetDiscountAmount;
                        p.EBDiscountAmount = resp.EBDiscountAmount;
                        p.MilitaryDiscountAmount = resp.MilitaryDiscountAmount;
                        p.VetDiscountAmount = resp.VetDiscountAmount;

                        if (mCustomer.Underwriter == 4)
                        {
                            p.FirstMonthPremiumOnly = resp.FirstDebitAmt - resp.FirstTaxAmt;
                            p.RecurringMonthPremiumOnly = resp.RecurringDebitAmt - resp.RecurringTaxAmt;
                        }
                        else
                        {
                            p.FirstMonthPremiumOnly = resp.FirstDebitAmt - resp.FirstTaxAmt;
                            p.RecurringMonthPremiumOnly = resp.RecurringDebitAmt - resp.RecurringTaxAmt;
                        }
                        p.QuoteId = resp.Id;
                        p.Enrolled = true;
                        p.OldQuoteData = false;
                        p.MultiPetAvailable = resp.MultiPolicyDiscountAvailable;
                    }
                }
                else
                {
                    mCustomer.WebserviceErrorMsg = resp.Error.ErrorText;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                try
                {
                    if (qclient.State == CommunicationState.Faulted)
                        qclient.Abort();
                    else if (qclient.State == CommunicationState.Opened)
                        qclient.Close();
                }
                catch { }
            }
        }
コード例 #25
0
        public bool LoadFastQuote(ref PetfirstCustomer mCustomer, ref Pet thispet)
        {
            bool bReturn = false;

            string sMemberCodeString = "";

            sMemberCodeString += mCustomer.DiscountMilitarySelected ? "M" : "";
            sMemberCodeString += mCustomer.DiscountInternetPurchase ? "I" : "";
            sMemberCodeString += mCustomer.DiscountVetSelected ? "A" : "";

            try
            {
                if (thispet.preQuotes == null)
                {
                    thispet.preQuotes = new DataTable();
                }
                thispet.preQuotes.Clear();
                using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["PFQuoteDB"].ConnectionString))
                {
                    using (var cmd = new SqlCommand("usp_GetPreQuotes", con))
                    {
                        cmd.Parameters.Add("@StateID", SqlDbType.TinyInt);
                        cmd.Parameters["@StateID"].Value = (byte)mCustomer.MembershipInfo.StateId;
                        cmd.Parameters.Add("@BreedID", SqlDbType.Int);

                        cmd.Parameters.Add("@Age", SqlDbType.Int);
                        cmd.Parameters["@Age"].Value = thispet.Age;
                        cmd.Parameters.Add("@WeightID", SqlDbType.TinyInt);

                        cmd.Parameters.Add("@EnrollmentCode", SqlDbType.VarChar, 20).Value = mCustomer.EnrollmentCode;
                        cmd.Parameters.Add("@MemberCodeString", SqlDbType.VarChar, 20).Value = sMemberCodeString;

                        if (thispet.SpeciesId == 2)
                        {
                            cmd.Parameters["@WeightID"].Value = (byte)1;
                            cmd.Parameters["@BreedID"].Value = 2;
                        }
                        else if (thispet.SpeciesId == 1 && thispet.BreedId == 54)
                        {
                            cmd.Parameters["@WeightID"].Value = (byte)thispet.WeightId;
                            cmd.Parameters["@BreedID"].Value = thispet.BreedId;
                        }
                        else
                        {
                            cmd.Parameters["@WeightID"].Value = (byte)0;
                            cmd.Parameters["@BreedID"].Value = thispet.BreedId;
                        }

                        using (var da = new SqlDataAdapter(cmd))
                        {
                            cmd.CommandType = CommandType.StoredProcedure;
                            da.Fill(thispet.preQuotes);

                            if (thispet.preQuotes.Rows.Count > 0)
                            {
                                bReturn = true;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                bReturn = false;
                mCustomer.WebserviceErrorMsg = ex.Message;
            }
            return (bReturn);
        }
コード例 #26
0
 private void InitiatePetfirstCustomer()
 {
     if (!bAddPet)
     {
         mCustomer = new PetfirstCustomer();
         if (!string.IsNullOrEmpty(Request.QueryString["enrollment_code"]))//if there is query srtring passed
         {
             mCustomer.EnrollmentCode = (string)Request.QueryString["enrollment_code"];
             GetPhoneNumber();
             //mCustomer.DiscountEBEnrollmentCode = true;
         }
     }
 }
コード例 #27
0
        private bool LoadCustomerInfo(ref PetfirstCustomer mCustomer, string scustomerLookup)
        {
            bool bReturn = true;
            SqlConnection con = GetConnection();
            SqlDataReader sdr = null;
            SqlCommand cmd = new SqlCommand("usp_pricecompare_tmpcustomer_get_by_customer_id", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@customer_id", SqlDbType.BigInt));
            cmd.Parameters["@customer_id"].Value = Int32.Parse(scustomerLookup);

            try
            {
                con.Open();
                sdr = cmd.ExecuteReader();

                while (sdr.Read())
                {
                    mCustomer.MembershipInfo.FirstName = sdr.GetString(CTFIRSTNAME);
                    mCustomer.MembershipInfo.LastName = sdr.GetString(CTLASTNAME);
                    mCustomer.EnrollmentCode = sdr.GetString(CTENROLLMENTCODE);

                    using (PetfirstData pfData = new PetfirstData())
                    {
                        mCustomer.CallCenter = pfData.GetPhoneNumber(mCustomer.EnrollmentCode);
                    }

                    mCustomer.MembershipInfo.Email = sdr.GetString(CTEMAIL);
                    mCustomer.MembershipInfo.Zip = sdr.GetString(CTZIP);
                    mCustomer.MembershipInfo.Phone = sdr.GetString(CTPHONE);

                    if ((sdr.GetString(CTPAYFREQUENCY)).ToString().Contains("monthly") == true)
                    {
                        mCustomer.PayFrequency = 1;
                    }
                    else
                    {
                        mCustomer.PayFrequency = 2;
                    }

                    CoreServiceClient csc = new CoreServiceClient();
                    CoreServiceGetStateByZipResponse resp = csc.GetStateByZip(mCustomer.MembershipInfo.Zip);
                    if (string.IsNullOrEmpty(resp.Error.ErrorText))
                    {
                        mCustomer.MembershipInfo.StateId = resp.State.Id;
                        mCustomer.MembershipInfo.City = resp.State.CityName;
                        mCustomer.MembershipInfo.State = resp.State.StateName;
                    }

                    Pet myPet = new Pet();

                    myPet.Birthday = sdr.GetDateTime(CTPETBIRTHDAY);
                    myPet.ColorId = 146; //Any Breed//
                    myPet.ColorName = "Any";

                    if ((sdr.GetString(CTSPECIESNAME)).ToString().Contains("dog") == true)
                    {
                        myPet.SpeciesId = 1;
                        myPet.SpeciesName = "Dog";
                    }
                    else
                    {
                        myPet.SpeciesId = 2;
                        myPet.SpeciesName = "Cat";
                    }

                    myPet.BreedId = sdr.GetInt32(CTBREEDID);
                    myPet.WeightId = sdr.GetByte(CTWEIGHTID);
                    myPet.PetName = sdr.GetString(CTPETNAME);
                    myPet.GenderFull = sdr.GetString(CTPETGENDER);
                    myPet.GenderFull.Trim();

                    if (myPet.GenderFull.Contains("female"))
                    {
                        myPet.Gender = "F";
                    }
                    else
                    {
                        myPet.Gender = "M";
                    }

                    myPet.DeductibleAmount = sdr.GetDecimal(CTDEDUCTIBLE);
                    myPet.Reimbursement = sdr.GetDecimal(CTREIMBURSEMENT);
                    myPet.SpayedOrNeutered = sdr.GetBoolean(CTSPAYORNEUTER);
                    //stored procedure will take care of figuring out if this is true or not.
                    mCustomer.DiscountVetAvailable = true;
                    mCustomer.DiscountMilitaryAvailable = true;
                    mCustomer.DiscountMilitarySelected = sdr.GetBoolean(CTMILITARY);
                    mCustomer.DiscountVetSelected = sdr.GetBoolean(CTVETPROFFESIONAL);

                    mCustomer.MyPets.Add(myPet);

                    try
                    {
                        using (PetfirstData pfData = new PetfirstData())
                        {
                            pfData.SaveCustomer(mCustomer);
                        }
                    }
                    catch
                    {
                        throw;
                    }

                }

                con.Close();
            }
            catch (Exception ex)
            {
                bReturn = false;
                LoggingError(ex.Message, ex.StackTrace);
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                    con.Dispose();
                    con = null;
                }
                if (cmd != null)
                {
                    cmd.Dispose();
                    cmd = null;
                }
            }

            return (bReturn);
        }