private void PreviewAction(SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement)
{
DataTable dtRegistrationDetail = GetRegistrationDetail();
if (dtRegistrationDetail.Rows.Count > 0)
{
string sIssueTransNo = string.Empty;
for (int rowIndx = 0; rowIndx < dtRegistrationDetail.Rows.Count; rowIndx++)
{
sIssueTransNo += ",'" + Convert.ToString(dtRegistrationDetail.Rows[rowIndx]["IssueTransNo"]) + "'";
}
sIssueTransNo = sIssueTransNo.Substring(1);
if (!string.IsNullOrEmpty(ddlSpType.SelectedItem.Text))
{
string[] TypeDesc = ddlSpType.SelectedItem.Text.Split(':');
oSalesStatement.SPType.TypeDesc = TypeDesc[1];
}
CreateReportDocument(oSalesStatement);
//GetMasterCertificateDetailData(strIssueTransNo, cStrSaleStatementTransNo)
}
else
{
ucMessage.OpenMessage("Select at least one registration to PREVIEW sales statement.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
private bool SaveAndPreviewAction()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
if (txtReferenceNo.Text.Equals(string.Empty))
{
DataTable dtRegDetail = GetRegistrationDetail();
if (dtRegDetail.Rows.Count > 0)
{
CalculateData();
#region 01. GetObject ... Get Value
SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement = GetObject();
#endregion
#region 02. Call and varify..
SalesStatementDAL salStatementDAL = new SalesStatementDAL();
Result oResult = salStatementDAL.InsertData(oSalesStatement, dtRegDetail);
if (!oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return(false);
}
#endregion
#region 03. for preview
oSalesStatement.SaleStatementReferenceNo = Convert.ToString(oResult.Return);
PreviewAction(oSalesStatement);
#endregion
}
else
{
ucMessage.OpenMessage("Select at least one registration to save & print sales statement.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return(false);
}
}
return(true);
}
return(false);
}
private SBM_BLC1.Entity.Claim.SalesStatement GetObject()
{
SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement = new SBM_BLC1.Entity.Claim.SalesStatement();
if (!string.IsNullOrEmpty(ddlDuration.SelectedValue))
{
oSalesStatement.DurationType = Util.GetIntNumber(ddlDuration.SelectedValue);
}
oSalesStatement.FromDate = Util.GetDateTimeByString(txtDateFrom.Text);
oSalesStatement.SaleStatementReferenceNo = txtReferenceNo.Text;
oSalesStatement.SPType.SPTypeID = ddlSpType.SelectedValue;
oSalesStatement.StatementDate = Util.GetDateTimeByString(txtStatementDate.Text);
oSalesStatement.ToDate = Util.GetDateTimeByString(ddlDateTo.SelectedValue);
oSalesStatement.TotalFaceValue = Util.GetDoubleNumber(txtTotalFaceValue.Text);
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
oSalesStatement.UserDetails.MakerID = oConfig.UserName;
oSalesStatement.UserDetails.Division = oConfig.DivisionID;
oSalesStatement.UserDetails.BankID = oConfig.BankCodeID;
return(oSalesStatement);
}
public void CreateReportDocument(SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement)
{
ClaimReportDAL oCRDAL = new ClaimReportDAL();
bool isCoverLetter = false;
foreach (ListItem item in chkListForBB.Items)
{
if (item.Selected)
{
if (item.Value.Equals("With Cover Letter"))
{
isCoverLetter = true;
}
else
{
}
}
}
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
int iReportFormat = 0;
Result oResult = new Result();
Result oResult1 = new Result();
Result oResult2 = new Result();
SalesStatementDAL sDAL = new SalesStatementDAL();
Result oResultFormat = sDAL.GetSaleStatementReportFormat(ddlSpType.SelectedValue);
if (oResultFormat.Status)
{
iReportFormat = (int)oResultFormat.Return;
}
if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.SP))
{
oResult1 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.BSPSalesDetails, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.BSPSalesCoverLetter, oConfig.BranchID);
}
}
else if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.DollarBond))
{
oResult2 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.DPBSalesDetails2, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.DPBSalesCoverLetter, oConfig.BranchID);
}
}
else if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.WDB))
{
oResult1 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.WEDBSalesDetais, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.WEDBSalesCoverLetter, oConfig.BranchID);
}
}
Session["ExportType"] = ddlExportType.SelectedValue;
if (oResult.Status) //cover letter
{
Session[Constants.SES_RPT_DATA] = oResult.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport2(1));
}
if (oResult1.Status)
{
Session[Constants.SES_RPT_DATA_2] = oResult1.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW_2, Util.OpenReport2(2));
//Session[Constants.SES_RPT_DATA] = oResult1.Return as ReportDocument;
//Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
}
if (oResult2.Status)
{
Session[Constants.SES_RPT_DATA_2] = oResult2.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW_2, Util.OpenReport2(2));
}
}
}
protected void btnPreview_Click(object sender, EventArgs e)
{
CalculateData();
SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement = GetObject();
PreviewAction(oSalesStatement);
}
