protected void btnRemove_Click(object sender, CommandEventArgs e) { if (mCustomer != null) { if (e.CommandName.Equals("lbtnRemove")) { var mypet = (from p in mCustomer.MyPets where p.QuoteId == int.Parse(e.CommandArgument.ToString()) select p).ToList(); if (mypet != null) { int quoteId = 0; using (PetfirstData pfData = new PetfirstData()) { foreach (Pet p in mypet)//release pet from enrolledplan { quoteId = p.QuoteId; p.QuoteId = 0; p.Enrolled = false; p.FirstMonthPaymentTotal = 0; p.FirstMonthTax = 0; p.PlanId = 0; p.PlanName = string.Empty; p.RecurringMonthPaymentTotal = 0; p.RecurringMonthTax = 0; p.AnnualPaymentTotal = 0; p.FirstMonthPremiumOnly = 0; p.RecurringMonthPremiumOnly = 0; //p.LeadId = ""; try { pfData.BreakPlanForPet(p.PetId);//set qplanid =0 in qpet table pfData.RemoveEnrolledPlan(p.QPlanId); //delete qplan entry } catch (Exception ex) { displayError("Removing Enrolled Plan ", ex.ToString(), null); } p.QPlanId = 0; } } BindPetsRepeater(); DetermineFamilyOrIndividualPlan(); DetermineReviewQuoteStatus(); //user may come to this page from checkout page and then delete the plan first Session.Remove("EditPlanPet"); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("$('#remove_plan').modal('show');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ShowPetRemovedModal", sb.ToString(), false); } } } }