public DataSet SaveRenRemarketList(clsRenewalChkList objRenewalChkList, string xmlData, string SubClassXml) { object[] parameters = new object[] { objRenewalChkList.PolicyId, objRenewalChkList.PolVersionId, xmlData, SubClassXml }; dataAccessDS = new DataAccess(); return(dataAccessDS.LoadDataSet(parameters, "P_Pol_Policy_RenRemarketList_InsertUpdate", "RemarketList")); }
public DataSet SaveRenewalChkListDetail(clsRenewalChkList objRenewalChkList) { object[] parameters = new object[] { objRenewalChkList.PolicyId, objRenewalChkList.PolVersionId, objRenewalChkList.PolicyNo, objRenewalChkList.Insurer, objRenewalChkList.PaymentMode, objRenewalChkList.RenewalDate, objRenewalChkList.ClmsExpForLast2YrsYN, objRenewalChkList.ClmsExpForLast2YrsDate, objRenewalChkList.ClmsExpForLast2YrsRemarks, objRenewalChkList.RenewalOfferYN, objRenewalChkList.RenewalOfferDate, objRenewalChkList.RenewalOfferRemarks, objRenewalChkList.RenOfferFrwdToMrkgClgsDate, objRenewalChkList.UpdateCensusYN, objRenewalChkList.UpdateCensusDate, objRenewalChkList.UpdateCensusRemarks, objRenewalChkList.OverageOverseaLoadingYN, objRenewalChkList.OverageOverseaLoadingRemarks, objRenewalChkList.PrpslToClientYN, objRenewalChkList.PrpslToClientDate, objRenewalChkList.PrpslToClientRemarks, objRenewalChkList.PrpslToClientRevised1YN, objRenewalChkList.PrpslToClientRvsd1Date, objRenewalChkList.PrpslToClientRvsd1Remarks, objRenewalChkList.PrpslToClientRvsd2YN, objRenewalChkList.PrpslToClientRvsd2Date, objRenewalChkList.PrpslToClientRvsd2Remarks, objRenewalChkList.CntctClientDscussRnwlYN, objRenewalChkList.CntctClientDscussRnwlDate, objRenewalChkList.MediTopPromotionYN, objRenewalChkList.MediTopPromotionDate, objRenewalChkList.MeetingWithClientYN, objRenewalChkList.MeetingWithClientDate, objRenewalChkList.VaccinationYN, objRenewalChkList.VaccinationDate, objRenewalChkList.MeetingWithClient2ndYN, objRenewalChkList.MeetingWithClient2ndDate, objRenewalChkList.StaffBriefingYN, objRenewalChkList.StaffBriefingDate, objRenewalChkList.MeetingWithClient3rdYN, objRenewalChkList.MeetingWithClient3rdDate, objRenewalChkList.AfterSalesServiceYN, objRenewalChkList.AfterSalesServiceDate, objRenewalChkList.RcvdCnfmtnSlpFrmClientYN, objRenewalChkList.RcvdCnfmtnSlpFrmClientDate, objRenewalChkList.RcvdCnfmtnSlpFrmClientRemarks, objRenewalChkList.MakeCnfmtnToInsurerYN, objRenewalChkList.MakeCnfmtnToInsurerDate, objRenewalChkList.MakeCnfmtnToInsurerRemarks, objRenewalChkList.PolicyEndrsmntIssuedYN, objRenewalChkList.PolicyEndrsmntDate, objRenewalChkList.PolicyEndrsmntRemarks, objRenewalChkList.SOSCardMdclCardYN, objRenewalChkList.SOSCardMdclCardDate, objRenewalChkList.SOSCardMdclCardRemarks, objRenewalChkList.MmbrBookletLeafletYN, objRenewalChkList.MmbrBookletLeafletDate, objRenewalChkList.MmbrBookletLeafletRemarks, objRenewalChkList.PanelDoctorLstYN, objRenewalChkList.PanelDoctorLstDate, objRenewalChkList.PanelDoctorLstRemarks, objRenewalChkList.PremiumBillYN, objRenewalChkList.PremiumBillDate, objRenewalChkList.PremiumBillRemarks, objRenewalChkList.PremiumBillAdjstmntYN, objRenewalChkList.PremiumBillAdjstmntDate, objRenewalChkList.PremiumBillAdjstmntRemarks, objRenewalChkList.ExistingBrokerage, objRenewalChkList.ExistingPremium, objRenewalChkList.RenewalBrokerage, objRenewalChkList.RenewalPremium, objRenewalChkList.InsurerName, objRenewalChkList.Marketing, objRenewalChkList.Admin, objRenewalChkList.DcmntsFrwdToAdminColleagueOn, objRenewalChkList.User }; dataAccessDS = new DataAccess(); return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_RenewalChkListDetails_InsertUpdate", "RenewalChkList")); }
public DataSet GetRenewalChkListDetails(clsRenewalChkList objRenewalChkList) { object[] parameters = new object[] { objRenewalChkList.PolicyId, objRenewalChkList.PolVersionId }; dataAccessDS = new DataAccess(); return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyRenewalChkList_Select", "CoverNoteList")); }