public bool CreateRIRenewalLetterPDF(ClsRenewalLetter_RI objQuotation, int userId)
{
bool blCreationSuccess = true;
ereEvents = new PDFGeneratorEvents();
try
{
createAndOpenNewDoc();
DataSet dsRenLetterInfo = new DataSet();
dsRenLetterInfo = objCoverNoteBI.GetRIRenewalLetterInfo(objQuotation, userId);
foreach (DataRow dRow in dsRenLetterInfo.Tables[1].Rows)
{
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.LoadRIQuotationClientDetail(objQuotation);
//foreach (DataRow dRow in dsPolicyDetail.Tables[0].Rows)
//{
// 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);
}
public DataSet SaveRenLetterInfo_RI(ClsRenewalLetter_RI objRenLetter)
{
object[] parameters = new object[] { objRenLetter.PolicyId,
objRenLetter.PolVersionId,
objRenLetter.ClientId,
objRenLetter.Content,
objRenLetter.UserId,
objRenLetter.AuthName,
objRenLetter.AuthDesignation,
objRenLetter.User };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_Policy_RenewalLetterInfo_InsertUpdate_RI", "Pol_PolicyRenewalLetter_RI"));
}
public DataSet UpdateRenStatus_RI(ClsRenewalLetter_RI objclsQuotation, string Status)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, Status };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_ChangePolicyStatus_RI", "RI_CN_GeneralInformation"));
}
public DataSet GetRIRenewalLetterInfo(ClsRenewalLetter_RI objclsQuotation, int UserId)
{
object[] parameters = new object[] { objclsQuotation.PolicyId, objclsQuotation.PolVersionId, UserId };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_Pol_Policy_RenewalLetterInfo_Select_RI", "RenewalLetterList"));
}
