public DataSet SaveCoverNoteDetail(clsQuotation objclsQuotation, string process,
string UpfrontDuedateStatus,
string DdlPPWWaiveStatus)
{
object[] parameters = new object[] { objclsQuotation.PolicyId,
objclsQuotation.PolVersionId,
objclsQuotation.PolicyNo,
objclsQuotation.EndorsementNo,
objclsQuotation.PrevPolicyNo,
objclsQuotation.InsurerDBNote,
objclsQuotation.BillingDate,
objclsQuotation.PremiumRate,
objclsQuotation.FollowupDate,
objclsQuotation.FollowupReason,
objclsQuotation.EndDebitNoteNo,
objclsQuotation.EndBillingDate,
objclsQuotation.User,
//added by himanshu for 18065
objclsQuotation.InsurerTaxInvoice,
objclsQuotation.PolicyReceivedDate,
//objclsQuotation.InsurerTaxInvoiceNumber,
objclsQuotation.PPW_Waive_Status,
objclsQuotation.NewDate,
objclsQuotation.EndrsmntStartDate,
objclsQuotation.EndrsmntEndDate,
process,
UpfrontDuedateStatus,
DdlPPWWaiveStatus };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_CoverNoteDetails_InsertUpdate", "CoverNoteList"));
}
public bool IsBillingComplete(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId };
dataAccessDS = new DataAccess();
//return dataAccessDS.LoadDataSet(parameters, "P_Pol_Policy_EndtData_IsInsert", "CancelPolicy");
return(Convert.ToBoolean(dataAccessDS.GetScalarValue(parameters, "P_Pol_PolicyBilling_IsComplete")));
}
public DataSet GetRiskType(clsQuotation objQuotation)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objQuotation.PolicyId, objQuotation.PolVersionId
};
return(dataAccess.LoadDataSet(parameters, "GetRiskType", "GetRiskType"));
}
public DataSet GetBenefitSchedule(clsQuotation objQuotation)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objQuotation.PolicyId, objQuotation.PolVersionId, objQuotation.UnderwriterId
};
return(dataAccess.LoadDataSet(parameters, "GetBenefitLine", "BenefitLine"));
}
public DataSet GetPolicySlipListForLCHCoverNote(clsQuotation objQuotation)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objQuotation.PolicyId, objQuotation.PolVersionId, objQuotation.DateFormat
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_QuotationSlipPrintCoverNoteDetails", "SlipList"));
}
public DataSet getPremiumHistory(clsQuotation objclsQuotation)
{
dataAccessDS = new DataAccess();
Object[] parametes = new Object[2] {
objclsQuotation.PolicyId, objclsQuotation.PolVersionId
};
return(dataAccessDS.LoadDataSet(parametes, "Pol_Policy_HistoryPremiuarySummary", "PremiuarySummary"));
}
public DataSet getEndtPremiumSummary(clsQuotation objclsQuotation)
{
dataAccessDS = new DataAccess();
Object[] parametes = new Object[3] {
objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.UWCoinsuranceApplicable
};
return(dataAccessDS.LoadDataSet(parametes, "Pol_Policy_EndorsementPremiuarySummary", "PremiuarySummary"));
}
public DataSet GetPolicySlipList(clsQuotation objQuotation)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objQuotation.PolicyId, objQuotation.PolVersionId, objQuotation.DateFormat
};
return(dataAccess.LoadDataSet(parameters, "P_Pol_PolicyPrintSlipData_Select", "SlipList"));
}
public DataSet SaveEndtPremiumDetail(clsQuotation objclsQuotation, clsPolicyUnderwriter objUnderwriter, bool manualOverwrite) //changed by megha to merge Aasai changes
{
object[] parameters = new object[] { objclsQuotation.PolicyId,
objclsQuotation.PolVersionId,
objUnderwriter.UWId, //added by megha to merge Aasai changes
objclsQuotation.TotalPremium,
objclsQuotation.AdditionalPremium,
objclsQuotation.ClientDiscount,
objclsQuotation.TotalSurcharge,
objclsQuotation.TotalPremiumSurcharge,
objclsQuotation.SpecialDiscount,
objclsQuotation.SpecialDiscountRate,
objclsQuotation.DueFromClient,
objclsQuotation.HandlingFeeAmount,
objclsQuotation.POIFromDate,
objclsQuotation.POIToDate,
objclsQuotation.User,
objUnderwriter.ID, //added by megha to merge Aasai changes
manualOverwrite,
objUnderwriter.TotalPremiumLAW,
objUnderwriter.StDutyLAW,
objUnderwriter.TaxTypeLAW,
objUnderwriter.TaxLAW,
objUnderwriter.SpDiscLAW,
objUnderwriter.WHTPercentLAW,
objUnderwriter.NetPayLAW,
objUnderwriter.TaxLawrdb,
objUnderwriter.StDutyLAWAmt,
objUnderwriter.WHTAMT,
objUnderwriter.NetPayClient,
objUnderwriter.PolicyCharge,
objUnderwriter.InsurerGSTPer,
objUnderwriter.InsurerGSTPerId,
objUnderwriter.InsurerGSTAmount,
objclsQuotation.ClientDiscountRate,
objUnderwriter.ServiceFee,
objUnderwriter.ServiceFeeGSTPer,
objUnderwriter.ServiceFeeGSTPerId,
objUnderwriter.ServiceFeeGSTAmount,
objUnderwriter.StampDuty,
objUnderwriter.NettPremium,
objUnderwriter.NCDPer,
objUnderwriter.NCDAmount,
objUnderwriter.LoadingByInsurerPer,
objUnderwriter.LoadingByInsurerAmt,
objUnderwriter.DiscountByInsurerPer,
objUnderwriter.DiscountByInsurerAmt };
dataAccessDS = new DataAccess();
//return dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_PremiumDetails_InsertUpdate", "Pol_PolicyMaster");
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_EndtPremiumDetails_InsertUpdate", "Pol_PolicyMaster"));
}
public DataSet GetCoverNoteDetails(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_CoverNoteDetails_Select", "CoverNoteList"));
}
public DataSet GetIntroducerducerDetaisForSummary(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.VessedId, objclsQuotation.IsEndorse };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_IntroducerSummary", "P_IntroducerSummary"));
}
public DataSet HoldPolicy(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.POIFromDate, objclsQuotation.POIToDate, objclsQuotation.MaintenancePeriodFromDate, objclsQuotation.MaintenancePeriodToDate, objclsQuotation.User, objclsQuotation.RenPolStatus };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyHoldCover_InsertUpdate", "ExtendedPolicy"));
}
public DataSet CancelPolicyStatus(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.Pol_Status };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_CancelPolicyStatus", "ExtendedPolicy"));
}
public DataSet GetPolicyInfo(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.CoverNoteNo };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyCNDetail_Select", "Pol_PolicyCNDetail"));
}
public DataSet ConfirmCancelPolicy(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.Pol_Status };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_ConfirmPolicyCancellation", "CancelPolicy"));
}
public DataSet UpdateRenStatus(clsQuotation objclsQuotation, string Status)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, Status, objclsQuotation.RenewalReasonId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_ChangePolicyStatus", "ClaimList"));
}
public DataSet GetRenewalClaimListing(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_RenClaimDetails_Select", "ClaimList"));
}
public DataSet GetRenewalLetterInfo(clsQuotation objclsQuotation, int UserId)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, UserId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_Policy_RenewalLetterInfo_Select", "RenewalLetterList"));
}
public DataSet CancelEndorsement(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_RefreshEndorsement", "CancelExtension"));
}
public DataSet RemarketPolicy(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.User };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyMaster_Remarket", "Remarket"));
}
public DataSet RevisedPolicy(clsQuotation objclsQuotation, int LoginTeamId)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, objclsQuotation.RenPolStatus, objclsQuotation.User, LoginTeamId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_RevisedPolicy", "RenewedPolicy"));
}
public DataSet GetExtendedDetails(clsQuotation objclsQuotation, bool IsExtended)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, IsExtended };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyExtension_Select", "ExtendedPolicy"));
}
public DataSet GetPolicyHistory(clsQuotation objclsQuotation)
{
object[] parameters = new object[] { objclsQuotation.PolicyId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyHistory_Select", "CoverNoteList"));
}
public bool CreateRenewalLetterPDF(clsQuotation objQuotation, int userId)
{
bool blCreationSuccess = true;
ereEvents = new PDFGeneratorEvents();
try
{
createAndOpenNewDoc();
DataSet dsRenLetterInfo = new DataSet();
dsRenLetterInfo = objCoverNoteBI.GetRenewalLetterInfo(objQuotation, userId);
foreach (DataRow dRow in dsRenLetterInfo.Tables[1].Rows)
{
//RejectReason = dsAgent.Tables[0].Rows[0]["RejectReason"].ToString();
Attention = dsRenLetterInfo.Tables[1].Rows[0]["ClientName"].ToString();
UserName = dsRenLetterInfo.Tables[1].Rows[0]["AuthName"].ToString();
UserDesignation = dsRenLetterInfo.Tables[1].Rows[0]["AuthDesignation"].ToString();
Address1 = dsRenLetterInfo.Tables[1].Rows[0]["Address1"].ToString();
Address2 = dsRenLetterInfo.Tables[1].Rows[0]["Address2"].ToString();
Address3 = dsRenLetterInfo.Tables[1].Rows[0]["Address3"].ToString();
ContentHeader = dsRenLetterInfo.Tables[1].Rows[0]["Header"].ToString();
ContentSubject = dsRenLetterInfo.Tables[1].Rows[0]["ContentSubject"].ToString();
ContentPara1 = dsRenLetterInfo.Tables[1].Rows[0]["Para1"].ToString();
ContentPara2 = dsRenLetterInfo.Tables[1].Rows[0]["Para2"].ToString();
ContentPara3 = dsRenLetterInfo.Tables[1].Rows[0]["Para3"].ToString();
ContentPara4 = dsRenLetterInfo.Tables[1].Rows[0]["Para4"].ToString();
ContentFooter = dsRenLetterInfo.Tables[1].Rows[0]["Footer"].ToString();
ereEvents.ShowPageNumber = true;
//ereEvents.PrintFooter = false;
ereEvents.UWCOPY = false;
CreateRenewalPDF(dRow);
docPDF.NewPage();
}
DataSet dsPolicyDetail = new DataSet();
dsPolicyDetail = objQuotationManager.LoadQuotationClientDetail(objQuotation);
foreach (DataRow dRow in dsPolicyDetail.Tables[0].Rows)
{
//RejectReason = dsAgent.Tables[0].Rows[0]["RejectReason"].ToString();
ClientName = dsPolicyDetail.Tables[0].Rows[0]["ClientName"].ToString();
POIFromDate = dsPolicyDetail.Tables[0].Rows[0]["POIFromDate1"].ToString();
POIToDate = dsPolicyDetail.Tables[0].Rows[0]["POIToDate1"].ToString();
CoverNoteNo = dsPolicyDetail.Tables[0].Rows[0]["PolicyNo"].ToString();
ereEvents.ShowPageNumber = true;
//ereEvents.PrintFooter = false;
ereEvents.UWCOPY = false;
CreatePolicyDetailPDF(dRow);
docPDF.NewPage();
}
}
catch (Exception ex)
{
string strTemp = ex.Message;
blCreationSuccess = false;
}
finally
{
closeDoc();
}
return(blCreationSuccess);
}