public DataSet GetPolicyUnderwriterDetailsTotalDueCNNo(clsPolicyUnderwriter objPolicyUnderwriter)
{
dataAccessDS = new DataAccess();
Object[] parameters = new Object[4] {
objPolicyUnderwriter.PolicyId, objPolicyUnderwriter.PolVersionId, objPolicyUnderwriter.UWId, objPolicyUnderwriter.ID
};
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_Underwriters_TotalDue_NonLeader", "UnderwriterDue"));
}
public DataSet GetEndorUWTotalDueLeadBilling(clsPolicyUnderwriter objpolUW)
{
object[] parameters = new object[4] {
objpolUW.PolicyId, objpolUW.PolVersionId, objpolUW.UWId, objpolUW.ID
};
dataAccessDS = new DataAccess();
string[] Tables = { "UnderwriterDue", };
return(dataAccessDS.LoadDataSets(parameters, "P_Pol_Policy_MultiBilling_Indors_Select_UWTotalDue_LeadBilling", Tables));
}
public DataSet GetPolicyEndtPremBilledToDate(clsPolicyUnderwriter objPolicyUnderwriter)
{
object[] parameters = new object[] {
objPolicyUnderwriter.PolicyId,
objPolicyUnderwriter.PolVersionId,
objPolicyUnderwriter.UWId,
objPolicyUnderwriter.ID
};
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyDetails_GetPremBilledToDate_Endt", "PremBilledToDate"));
}
public DataSet GetPolicyEndtBilledUnderwriterTotalPremiumId(clsPolicyUnderwriter objPolicyUnderwriter, string PolStatus)
{
object[] parameters = new object[] {
objPolicyUnderwriter.PolicyId,
objPolicyUnderwriter.PolVersionId,
objPolicyUnderwriter.UWId,
objPolicyUnderwriter.ID,
PolStatus
};
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_PolicyUnderwriters_GetTotalPremiumByID_PremBilled", "GetTotalPremiumByID"));
}
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"));
}
