private void showReport(string reportType) { var ExLC = dbEntities.findExportLC(tbLCCode.Text); var BCustomer = dbEntities.BCUSTOMERS.Find(ExLC.BeneficiaryNo); if (ExLC == null) { lblLCCodeMessage.Text = "Can not find this LC."; return; } // string reportTemplate = "~/DesktopModules/TrainingCoreBanking/BankProject/Report/Template/Export/"; string reportSaveName = ""; DataSet reportData = new DataSet(); DataTable tbl1 = new DataTable(); Aspose.Words.SaveFormat saveFormat = Aspose.Words.SaveFormat.Doc; Aspose.Words.SaveType saveType = Aspose.Words.SaveType.OpenInApplication; try { switch (reportType) { case "ThuThongBao": reportTemplate = Context.Server.MapPath(reportTemplate + "Mau Thong bao LC.doc"); reportSaveName = "ThuThongBao" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; // var dataThuThongBao = new Model.Reports.MauThongBaoVaTuChinhLc() { DateCreate = (ExLC.CreateDate.HasValue ? ExLC.CreateDate.Value.ToString("dd/MM/yyyy") : ""), Ref = ExLC.ExportLCCode, Beneficiary = ExLC.BeneficiaryName, LCCode = ExLC.ImportLCCode, DateOfIssue = (ExLC.DateOfIssue.HasValue ? ExLC.DateOfIssue.Value.ToString("dd/MM/yyyy") : ""), DateOfExpiry = (ExLC.DateOfExpiry.HasValue ? ExLC.DateOfExpiry.Value.ToString("dd/MM/yyyy") : ""), IssuingBank = ExLC.IssuingBankName, Amount = ExLC.Amount + " " + ExLC.Currency, Applicant = ExLC.ApplicantName }; if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr1)) dataThuThongBao.Beneficiary += ", " + ExLC.BeneficiaryAddr1; if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr2)) dataThuThongBao.Beneficiary += ", " + ExLC.BeneficiaryAddr2; if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr3)) dataThuThongBao.Beneficiary += ", " + ExLC.BeneficiaryAddr3; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr1)) dataThuThongBao.IssuingBank += ", " + ExLC.IssuingBankAddr1; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr2)) dataThuThongBao.IssuingBank += ", " + ExLC.IssuingBankAddr2; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr3)) dataThuThongBao.IssuingBank += ", " + ExLC.IssuingBankAddr3; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr1)) dataThuThongBao.Applicant += ", " + ExLC.ApplicantAddr1; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr2)) dataThuThongBao.Applicant += ", " + ExLC.ApplicantAddr2; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr3)) dataThuThongBao.Applicant += ", " + ExLC.ApplicantAddr3; // var lstData = new List<Model.Reports.MauThongBaoVaTuChinhLc>(); lstData.Add(dataThuThongBao); tbl1 = Utils.CreateDataTable<Model.Reports.MauThongBaoVaTuChinhLc>(lstData); reportData.Tables.Add(tbl1); break; case "BiaHs": reportTemplate = Context.Server.MapPath(reportTemplate + "Mau Bia hs lc.doc"); reportSaveName = "BiaHs" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; // var dataBiaHs = new Model.Reports.MauBiaHsLc() { Ref = ExLC.ExportLCCode, LCCode = ExLC.ImportLCCode, DateOfIssue = (ExLC.DateOfIssue.HasValue ? ExLC.DateOfIssue.Value.ToString("dd/MM/yyyy") : ""), Beneficiary = ExLC.BeneficiaryName, Applicant = ExLC.ApplicantName, IssuingBank = ExLC.IssuingBankName, Tenor = ExLC.Tenor, AdvisingBank = ExLC.AdvisingBankName, Amount = ExLC.Amount + " " + ExLC.Currency, LatestDateOfShipment = (ExLC.LatesDateOfShipment.HasValue ? ExLC.LatesDateOfShipment.Value.ToString("dd/MM/yyyy") : ""), DateOfExpiry = (ExLC.DateOfExpiry.HasValue ? ExLC.DateOfExpiry.Value.ToString("dd/MM/yyyy") : ""), Transhipment = ExLC.TranShipment, PartialShipment = ExLC.PartialShipment, Commodity = ExLC.Commodity, PortOfLoading = ExLC.PortOfLoading, PeriodForPresentation = ExLC.PeriodForPresentation, PortOfDischarge = ExLC.PortOfDischarge }; if (!string.IsNullOrEmpty(ExLC.Commodity)) { var bc = dbEntities.BCOMMODITies.FirstOrDefault(p => p.ID.Equals(ExLC.Commodity)); if (bc != null) dataBiaHs.Commodity = bc.Name; } if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr1)) dataBiaHs.Beneficiary += ", " + ExLC.BeneficiaryAddr1; if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr2)) dataBiaHs.Beneficiary += ", " + ExLC.BeneficiaryAddr2; if (!string.IsNullOrEmpty(ExLC.BeneficiaryAddr3)) dataBiaHs.Beneficiary += ", " + ExLC.BeneficiaryAddr3; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr1)) dataBiaHs.IssuingBank += ", " + ExLC.IssuingBankAddr1; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr2)) dataBiaHs.IssuingBank += ", " + ExLC.IssuingBankAddr2; if (!string.IsNullOrEmpty(ExLC.IssuingBankAddr3)) dataBiaHs.IssuingBank += ", " + ExLC.IssuingBankAddr3; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr1)) dataBiaHs.Applicant += ", " + ExLC.ApplicantAddr1; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr2)) dataBiaHs.Applicant += ", " + ExLC.ApplicantAddr2; if (!string.IsNullOrEmpty(ExLC.ApplicantAddr3)) dataBiaHs.Applicant += ", " + ExLC.ApplicantAddr3; if (!string.IsNullOrEmpty(ExLC.AdvisingBankAddr1)) dataBiaHs.AdvisingBank += ", " + ExLC.AdvisingBankAddr1; if (!string.IsNullOrEmpty(ExLC.AdvisingBankAddr2)) dataBiaHs.AdvisingBank += ", " + ExLC.AdvisingBankAddr2; if (!string.IsNullOrEmpty(ExLC.AdvisingBankAddr3)) dataBiaHs.AdvisingBank += ", " + ExLC.AdvisingBankAddr3; // var lstData1 = new List<Model.Reports.MauBiaHsLc>(); lstData1.Add(dataBiaHs); tbl1 = Utils.CreateDataTable<Model.Reports.MauBiaHsLc>(lstData1); reportData.Tables.Add(tbl1); break; case "VAT": reportTemplate = Context.Server.MapPath(reportTemplate + "VAT.doc"); reportSaveName = "VAT" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; // var dataVAT = new Model.Reports.VAT() { UserName = ExLC.CreateBy, VATNo = ExLC.VATNo, TransCode = ExLC.ExportLCCode, // CustomerID = ExLC.BeneficiaryNo, CustomerName = ExLC.BeneficiaryName, CustomerAddress = ExLC.BeneficiaryAddr1 + " " + ExLC.BeneficiaryAddr2 + " " + ExLC.BeneficiaryAddr3, IdentityNo = null == BCustomer ? "" : BCustomer.IdentityNo, // DebitAccount = null == BCustomer ? "" : BCustomer.BankAccount, ChargeRemarks = ExLC.ChargeRemarks }; // var ExLCCharges = dbEntities.BEXPORT_LC_CHARGES.Where(p => p.ExportLCCode.Equals(tbLCCode.Text)); if (ExLCCharges != null) { double TotalTaxAmount = 0, TotalChargeAmount = 0; String currency = ""; foreach (BEXPORT_LC_CHARGES ch in ExLCCharges) { if (ch.ChargeAmt.HasValue && ch.ChargeAmt.Value != 0) { if (string.IsNullOrEmpty(dataVAT.ChargeType1)) { dataVAT.ChargeType1 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount1 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; currency = ch.ChargeCcy; } else if (string.IsNullOrEmpty(dataVAT.ChargeType2)) { dataVAT.ChargeType2 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount2 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; if (currency.Equals("")) { currency = ch.ChargeCcy; } } else if (string.IsNullOrEmpty(dataVAT.ChargeType3)) { dataVAT.ChargeType3 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount3 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; if (currency.Equals("")) { currency = ch.ChargeCcy; } } } } TotalChargeAmount += TotalTaxAmount; if (TotalChargeAmount != 0) { dataVAT.TotalChargeAmount = Utils.CurrencyFormat(TotalChargeAmount, currency) + currency; dataVAT.TotalChargeAmountWord = Utils.ReadNumber(currency, TotalChargeAmount); if (TotalTaxAmount != 0) { dataVAT.TotalTaxAmount = Utils.CurrencyFormat(TotalTaxAmount, currency) + currency + " PL90304"; dataVAT.TotalTaxText = "VAT"; } } } // var lstData2 = new List<Model.Reports.VAT>(); lstData2.Add(dataVAT); tbl1 = Utils.CreateDataTable<Model.Reports.VAT>(lstData2); reportData.Tables.Add(tbl1); break; } if (reportData != null) { try { reportData.Tables[0].TableName = "Table1"; bc.Reports.createFileDownload(reportTemplate, reportData, reportSaveName, saveFormat, saveType, Response); } catch (Exception err) { lblLCCodeMessage.Text = reportData.Tables[0].TableName + "#" + err.Message; } } } catch (Exception ex) { lblLCCodeMessage.Text = ex.Message; } }
private void showReport(string reportType) { var ExLCDocSettlement = dbEntities.findExportLCDocSettlement(tbLCCode.Text); if (ExLCDocSettlement == null) { lblLCCodeMessage.Text = "Can not find this Code."; return; } var ExLCDoc = dbEntities.findExportLCDoc(ExLCDocSettlement.DocsCode); // string reportTemplate = "~/DesktopModules/TrainingCoreBanking/BankProject/Report/Template/Export/DocumentProcessing/Settlement/"; string reportSaveName = ""; DataSet reportData = new DataSet(); DataTable tbl1 = new DataTable(); Aspose.Words.SaveFormat saveFormat = Aspose.Words.SaveFormat.Doc; Aspose.Words.SaveType saveType = Aspose.Words.SaveType.OpenInApplication; try { switch (reportType) { case "VAT": reportTemplate = Context.Server.MapPath(reportTemplate + "VAT.doc"); reportSaveName = "VAT" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; // var dataVAT = new Model.Reports.VAT() { UserName = ExLCDocSettlement.CreateBy, VATNo = ExLCDocSettlement.VATNo, TransCode = ExLCDocSettlement.PaymentCode, // CustomerID = "", CustomerName = "", CustomerAddress = "", IdentityNo = "", // DebitAccount = "", ChargeRemarks = ExLCDocSettlement.ChargeRemarks }; // var ExLCDocCharges = dbEntities.BEXPORT_LC_DOCS_SETTLEMENT_CHARGES.Where(p => p.PaymentCode.Equals(tbLCCode.Text)); if (ExLCDocCharges != null) { double TotalTaxAmount = 0, TotalChargeAmount = 0; foreach (BEXPORT_LC_DOCS_SETTLEMENT_CHARGES ch in ExLCDocCharges) { if (ch.ChargeAmt.HasValue && ch.ChargeAmt.Value != 0) { if (string.IsNullOrEmpty(dataVAT.ChargeType1)) { dataVAT.ChargeType1 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount1 = ch.ChargeAmt.Value + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; } else if (string.IsNullOrEmpty(dataVAT.ChargeType2)) { dataVAT.ChargeType2 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount2 = ch.ChargeAmt.Value + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; } else if (string.IsNullOrEmpty(dataVAT.ChargeType3)) { dataVAT.ChargeType3 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount3 = ch.ChargeAmt.Value + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; } } } TotalChargeAmount += TotalTaxAmount; if (TotalChargeAmount != 0) { dataVAT.TotalChargeAmount = TotalChargeAmount + ExLCDoc.Currency; dataVAT.TotalChargeAmountWord = Utils.ReadNumber(ExLCDoc.Currency, TotalChargeAmount); if (TotalTaxAmount != 0) { dataVAT.TotalTaxAmount = TotalTaxAmount + ExLCDoc.Currency + " PL90304"; dataVAT.TotalTaxText = "VAT"; } } } // var lstData2 = new List<Model.Reports.VAT>(); lstData2.Add(dataVAT); tbl1 = Utils.CreateDataTable<Model.Reports.VAT>(lstData2); reportData.Tables.Add(tbl1); break; } if (reportData != null) { try { reportData.Tables[0].TableName = "Table1"; bc.Reports.createFileDownload(reportTemplate, reportData, reportSaveName, saveFormat, saveType, Response); } catch (Exception err) { lblLCCodeMessage.Text = reportData.Tables[0].TableName + "#" + err.Message; } } } catch (Exception ex) { lblLCCodeMessage.Text = ex.Message; } }
private void showReport(string reportType) { var ExLCDoc = dbEntities.findExportLCDoc(tbLCCode.Text); var BCustomer = dbEntities.BCUSTOMERS.Find(ExLCDoc.BeneficiaryNo); if (ExLCDoc == null) { lblLCCodeMessage.Text = "Can not find this Code."; return; } // string reportTemplate = "~/DesktopModules/TrainingCoreBanking/BankProject/Report/Template/Export/DocumentProcessing/"; string reportSaveName = ""; DataSet reportData = new DataSet(); DataTable tbl1 = new DataTable(); Aspose.Words.SaveFormat saveFormat = Aspose.Words.SaveFormat.Doc; Aspose.Words.SaveType saveType = Aspose.Words.SaveType.OpenInApplication; try { switch (reportType) { case "VAT": reportTemplate = Context.Server.MapPath(reportTemplate + "VAT.doc"); reportSaveName = "VAT" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; // var dataVAT = new Model.Reports.VAT() { UserName = ExLCDoc.CreateBy, VATNo = ExLCDoc.VATNo, TransCode = ExLCDoc.DocCode, // CustomerID = ExLCDoc.BeneficiaryNo, CustomerName = ExLCDoc.BeneficiaryName, CustomerAddress = ExLCDoc.BeneficiaryAddr1 + " " + ExLCDoc.BeneficiaryAddr2 + " " + ExLCDoc.BeneficiaryAddr3, IdentityNo = null == BCustomer ? "" : BCustomer.IdentityNo, // DebitAccount = null,// == BCustomer ? "" : BCustomer.BankAccount, ChargeRemarks = ExLCDoc.ChargeRemarks }; // var ExLCDocCharges = dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Where(p => p.DocsCode.Equals(tbLCCode.Text)); if (ExLCDocCharges != null) { double TotalTaxAmount = 0, TotalChargeAmount = 0; String currency = ""; foreach (BEXPORT_LC_DOCS_PROCESSING_CHARGES ch in ExLCDocCharges) { if (ch.ChargeAmt.HasValue && ch.ChargeAmt.Value != 0) { if (string.IsNullOrEmpty(dataVAT.ChargeType1)) { dataVAT.ChargeType1 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount1 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + " " + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; currency = ch.ChargeCcy; dataVAT.DebitAccount = ch.ChargeAcc; } else if (string.IsNullOrEmpty(dataVAT.ChargeType2)) { dataVAT.ChargeType2 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount2 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + " " + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; if (currency.Equals("")) { currency = ch.ChargeCcy; } dataVAT.DebitAccount = ch.ChargeAcc; } else if (string.IsNullOrEmpty(dataVAT.ChargeType3)) { dataVAT.ChargeType3 = dbEntities.getChargeTypeInfo(ch.ChargeCode, 1); dataVAT.ChargeAmount3 = Utils.CurrencyFormat(ch.ChargeAmt.Value, ch.ChargeCcy) + " " + ch.ChargeCcy + " " + dbEntities.getChargeTypeInfo(ch.ChargeCode, 2); if (ch.TaxAmt.HasValue) TotalTaxAmount += ch.TaxAmt.Value; TotalChargeAmount += ch.ChargeAmt.Value; if (currency.Equals("")) { currency = ch.ChargeCcy; } dataVAT.DebitAccount = ch.ChargeAcc; } } } TotalChargeAmount += TotalTaxAmount; if (TotalChargeAmount != 0) { dataVAT.TotalChargeAmount = Utils.CurrencyFormat(TotalChargeAmount, currency) + currency; dataVAT.TotalChargeAmountWord = Utils.ReadNumber(currency, TotalChargeAmount); if (TotalTaxAmount != 0) { dataVAT.TotalTaxAmount = Utils.CurrencyFormat(TotalTaxAmount, currency) + " " + currency + " PL90304"; dataVAT.TotalTaxText = "VAT"; } } } // var lstData2 = new List<Model.Reports.VAT>(); lstData2.Add(dataVAT); tbl1 = Utils.CreateDataTable<Model.Reports.VAT>(lstData2); reportData.Tables.Add(tbl1); break; case "XuatNgoaiBang": case "NhapNgoaiBang": reportTemplate = Context.Server.MapPath(reportTemplate + reportType + ".doc"); reportSaveName = reportType + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; var dataXuatNgoaiBang = new Model.Reports.PhieuXuatNgoaiBang() { DocCode = ExLCDoc.DocCode, CustomerName = BCustomer.CustomerName, CurrentUserLogin = ExLCDoc.CreateBy, ApplicantName = ExLCDoc.ApplicantName, IdentityNo = BCustomer.IdentityNo, ApplicantAddr1 = BCustomer.Address, ApplicantAddr2 = BCustomer.City, ApplicantAddr3 = BCustomer.Country, Currency = ExLCDoc.Currency }; double oldAmount = 0; if (null != ExLCDoc.AmendNoOriginal) { var ExLCDocOld = dbEntities.findExportLCDoc(ExLCDoc.AmendNoOriginal, true); oldAmount = ExLCDocOld.Amount.Value; } if(reportType.Equals("XuatNgoaiBang")) { dataXuatNgoaiBang.Amount = oldAmount - ExLCDoc.Amount.Value; } else { dataXuatNgoaiBang.Amount = ExLCDoc.Amount.Value - oldAmount; } var lstData = new List<Model.Reports.PhieuXuatNgoaiBang>(); lstData.Add(dataXuatNgoaiBang); tbl1 = Utils.CreateDataTable<Model.Reports.PhieuXuatNgoaiBang>(lstData); reportData.Tables.Add(tbl1); break; } if (reportData != null) { try { reportData.Tables[0].TableName = "Table1"; bc.Reports.createFileDownload(reportTemplate, reportData, reportSaveName, saveFormat, saveType, Response); } catch (Exception err) { lblLCCodeMessage.Text = reportData.Tables[0].TableName + "#" + err.Message; } } } catch (Exception ex) { lblLCCodeMessage.Text = ex.Message; } }