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