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();
}
private void InitiateNewPet()
{
mthisPet = new Pet();
this.Master.PhoneNumber = mCustomer.CallCenter;
if (!string.IsNullOrEmpty(Request.QueryString["pet_name"])) //Check for Pet Name from main page.
{
mthisPet.PetName = txtPetName.Text = (string)Request.QueryString["pet_name"];
}
else if (bAddPet)
{
mthisPet.PetName = "Your Next Pet";
txtPetName.Text = "";
}
else
{
mthisPet.PetName = "Your Pet";
txtPetName.Text = "";
}
mthisPet.Birthday = DateTime.Now;
mthisPet.Gender = "M";
mthisPet.GenderFull = "Male";
mthisPet.SpeciesId = 1;
mthisPet.SpeciesName = "Dog";
mthisPet.BreedId = 0;
}
private void DetermineBreedWeighID(ref Pet p)
{
//kp: 2015-06-29
//int sId =1;
//if(btnCat.CssClass.Contains("active"))
// sId = 2;
int sId = int.Parse (rblSpecies.SelectedValue);
//end 2015-06-29
int bId = int.Parse(ddlBreed.SelectedValue);
int wId = 0;
bool changeBreedId = false;
if (bId == 10001)//fake breedid for mixed
{
wId = 1;
changeBreedId = true;
}
else if (bId == 10002)
{
wId = 2;
changeBreedId = true;
}
else if (bId == 10003)
{
wId = 3;
changeBreedId = true;
}
if (changeBreedId)
{
if (sId == 1)
bId = 54; //mixed breedid for dog
else
bId = 2; //mixed breedid for cat
}
p.BreedId = bId;
p.WeightId = wId;
}
private void SavePet(bool Update, ref Pet mypet)
{
//2015-06-29
mypet.Birthday = new DateTime(int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), 1);
//mypet.Birthday = GetBirthday(txtbirthday.Text);
//end 2015-06-29
mypet.BreedName = ddlBreed.SelectedItem.Text;
//kp: 2015-06-29
//mypet.ColorId = int.Parse(ddlColor.SelectedValue);
//mypet.ColorName = ddlColor.SelectedItem.Text;
mypet.ColorId = 146; //default to any
mypet.ColorName = "Any";
//if (btnMale.CssClass.Contains("active"))
//{
// mypet.Gender = "M";
// mypet.GenderFull = "Male";
//}
//else
//{
// mypet.Gender = "F";
// mypet.GenderFull = "Female";
//}
//if(btnYes.CssClass.Contains("active"))
// mypet.SpayedOrNeutered = true;
//else
// mypet.SpayedOrNeutered = false;
////if (btnYes.Checked)
//// mypet.SpayedOrNeutered = true;
////else
//// mypet.SpayedOrNeutered = false;
//if (btnDog.CssClass.Contains("active"))
//{
// mypet.SpeciesId = 1;
// mypet.SpeciesName = "Dog";
//}
//else
//{
// mypet.SpeciesId = 2;
// mypet.SpeciesName = "Cat";
//}
mypet.Gender = rblGender.SelectedValue;
mypet.SpayedOrNeutered = bool.Parse(rblSpay.SelectedValue);
mypet.SpeciesId =int.Parse( rblSpecies.SelectedValue);
if(mypet.SpeciesId ==1)
mypet.SpeciesName = "Dog";
else
mypet.SpeciesName = "Cat";
//end 2015-06-29
DetermineBreedWeighID(ref mypet);
if (!Update)
{
mypet.PetName = txtPetName.Text.Trim();
mCustomer.MyPets.Add(mypet);
}
}
private QuoteServiceReference.Pet CreateQuotePet(Pet p)
{
return new QuoteServiceReference.Pet()
{
Name = p.PetName,
BirthDate = p.Birthday,
BreedId = p.BreedId,
SpeciesId = p.SpeciesId,
ColorId = p.ColorId,
ChipNumber = string.Empty,
Gender = p.Gender, //male: 1 female =2
WeightId = p.WeightId,
SpayedOrNeutered = p.SpayedOrNeutered
};
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (mCustomer != null)
{
try
{
var mypet = (from p in mCustomer.MyPets
where p.PetName.ToLower().Equals(txtPetName.Text.ToLower())
select p).FirstOrDefault();
if (mypet != null)
{
SavePet(true, ref mypet);//update//note: this is different than current, not allow pets have same name
if (mypet.Enrolled)
{
int quoteId = mypet.QuoteId;
List<Pet> lstEnrolled = (from p in mCustomer.MyPets
where p.QuoteId == quoteId
select p).ToList();
//first check if there is senior pet in family plan
bool bSenior = false;
string seniorName = "";
if (lstEnrolled.Count > 1)
{
foreach (Pet p in lstEnrolled)
{
if (p.Age > 9)
{
bSenior = true;
seniorName = p.PetName;
break;
}
}
}
if (bSenior)
{
lblError.Text = string.Format("Pet {0} is considered senior pet, senior pet is not allowed to be in the family plan, please remove this pet from the enrolled plan before edit", seniorName);
return;
}
else
{
//requote
PetfirstBL pfBl = new PetfirstBL();
DoRequote(pfBl, lstEnrolled);
}
}
}
else
{
mypet = new Pet();
mypet.Enrolled = false;
SavePet(false, ref mypet);
}
try
{
using (PetfirstData pfData = new PetfirstData())
{
pfData.SavePet(mypet, mCustomer.CustomerId);
}
}
catch (Exception ex)
{
LoggingError("Saving Pet", ex.ToString());
}//don't do anything if store data fails
if (this.Request.Url.AbsoluteUri.ToLower().Contains("addpets_xs.aspx"))
{
Response.Redirect("~/AddPets.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else
{
bindPets();
ResetInput();
DetermineButtonText();
}
}
catch (Exception ex)
{
displayError("saving pet", ex.ToString(), true);
}
}
}
}
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);
}
private PolicyServiceReference.Pet CreatePolicyRequestPet(Pet p)
{
return new PolicyServiceReference.Pet()
{
Name = p.PetName,
BirthDate = p.Birthday,
BreedId = p.BreedId,
SpeciesId = p.SpeciesId,
ColorId = p.ColorId,
ChipNumber = string.Empty,
Gender = p.Gender,
WeightId = p.WeightId,
SpayedOrNeutered = p.SpayedOrNeutered
};
}
public void SavePet(Pet pet, int custId)
{
wsQPet dbPet = null;
bool bAdd = false;
if (pet.PetId == 0)
{
dbPet = new wsQPet();
bAdd = true;
dbPet.CreateDate = DateTime.Now;
}
else
dbPet = GetPetById(pet.PetId);
if (dbPet != null)
{
dbPet.Birthdate = pet.Birthday;
dbPet.BreedId = pet.BreedId;
dbPet.BreedName = pet.BreedName;
dbPet.ColorId = pet.ColorId;
dbPet.ColorName = pet.ColorName;
dbPet.PetName = pet.PetName;
dbPet.Gender = pet.Gender;
dbPet.QCustomerID = custId;
dbPet.QPlanID = pet.QPlanId;
dbPet.SpayedOrNeutered = pet.SpayedOrNeutered;
dbPet.SpeciesId = pet.SpeciesId;
dbPet.SpeciesName = pet.SpeciesName;
dbPet.WeightId = pet.WeightId;
if(!bAdd)
dbPet.ModifyDate = DateTime.Now;
else
context.wsQPets.AddObject(dbPet);
context.SaveChanges();
if (pet.PetId == 0)
pet.PetId = dbPet.QPetID;
}
}
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);
}
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;
}
}
}
}
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
}
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();
}
}
private void SavePetAttributes(ref Pet pet)
{
string planName = "";
pet.PlanType = (mCustomer.LifeTimeActive ? "2" : "1");
//pet.PlanType =rblPlanType.SelectedValue;
//string planName = rblPlanType.SelectedValue.Equals("1") ? "Standard" : "Lifetime";
planName = (mCustomer.LifeTimeActive ? "Lifetime" : "Standard");
pet.PlanName = string.Concat(planName, " ", ddlLimit.SelectedValue.Replace("$", ""));//sarah want to display the , but not the $
pet.LimitAmount = decimal.Parse(ddlLimit.SelectedValue.Replace("$", ""));
pet.DeductibleAmount = decimal.Parse(ddlDeductible.SelectedValue.Replace("$", ""));
pet.Reimbursement = decimal.Parse(ddlReimburse.SelectedValue.Replace("%", "")) / 100;
//rider special handle
if (pnlRoutine.Visible)
pet.Routine = rblRoutine.SelectedValue;
if(pnlBreeder.Visible)
pet.Breeder = cbBreeder.Checked;
if(pnlPrescription.Visible)
pet.PrescriptionFood = cbPrescription.Checked;
if(pnlHereditary.Visible)
pet.Hereditary = rblHereditary.SelectedValue;
////kp: 2015-05-04 retrieve quote- phase1 leftover item: show rider name to plan repeater
string riderName = string.Empty;
bool hasRider = false;
if (pnlRoutine.Visible&&rblRoutine.SelectedValue.Equals("routine125"))
{
hasRider = true;
riderName = "Routine Care 125";
}
else if(pnlRoutine.Visible&&rblRoutine.SelectedValue.Equals("routine250"))
{
hasRider = true;
riderName = "Routine Care 250";
}
else if (pnlRoutine.Visible && rblRoutine.SelectedValue.Equals("routine400"))
{
hasRider = true;
riderName = "Routine Care 400";
}
if (pnlPrescription.Visible && cbPrescription.Checked && hasRider)
{
riderName += "<br />" + "Prescription Food";
}
else if (pnlPrescription.Visible && cbPrescription.Checked)
{
hasRider = true;
riderName = "Prescription Food";
}
//Hereditary
if (pnlHereditary.Visible && !rblHereditary.SelectedItem.Text.ToLower().Equals("none") && hasRider)
{
riderName += "<br />" + rblHereditary.SelectedItem.Text;
}
else if (pnlHereditary.Visible && !rblHereditary.SelectedItem.Text.ToLower().Equals("none"))
{
hasRider = true;
riderName = rblHereditary.SelectedItem.Text;
}
//breeder
if (pnlBreeder.Visible && cbBreeder.Checked && hasRider)
{
riderName += "<br />" + "Breeder Coverage";
}
else if (pnlBreeder.Visible && cbBreeder.Checked)
{
riderName = "Breeder Coverage";
}
pet.RiderName = riderName;
////end 2015-05-04
}
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);
}
