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"));
}
