private void _AppendBalance(FinAcctBalResp aBal, StringBuilder sb) { FinAcct aAcct = aBal.Account; SwiftBalance aCurrentBal = aBal.CurrentBal; SwiftBalance aPendingBal = aBal.IncludingPendingTransBal; if (aCurrentBal != null) { sb.AppendFormat("BOOKED;{0};{1};{2};{3};{4}", aAcct.BankCode, aAcct.AcctNo, aCurrentBal.Date.ToString(SwiftDateFormat.StandardDate), aCurrentBal.Currency, SwiftAmt.Format(aCurrentBal.DecValue, ',', 2)); sb.Append(Environment.NewLine); } if (aPendingBal != null) { sb.AppendFormat("FORWARD;{0};{1};{2};{3};{4}", aAcct.BankCode, aAcct.AcctNo, aPendingBal.Date.ToString(SwiftDateFormat.StandardDate), aPendingBal.Currency, SwiftAmt.Format(aPendingBal.DecValue, ',', 2)); sb.Append(Environment.NewLine); } }
private string _GetCsvStatementData(Swift9xxBase aStmt) { StringBuilder sb = new StringBuilder(20000); sb.Append("EntryDate;ValueDate;Value;AcctNo;BankCode;Name1;Name2;PaymtPurpose;EntryText;PrimaNotaNo;TranTypeIdCode;ZkaTranCode;TextKeyExt;BankRef;OwnerRef;SupplementaryDetails"); sb.Append(Environment.NewLine); foreach (SwiftStatementLine aStmtLine in aStmt.StatementLines) { CsvValues aCsv = new CsvValues(16); if (!aStmtLine.EntryDate.IsNull) { aCsv[0] = aStmtLine.EntryDate.ToString(SwiftDateFormat.StandardDate); } if (!aStmtLine.ValueDate.IsNull) { aCsv[1] = aStmtLine.ValueDate.ToString(SwiftDateFormat.StandardDate); } aCsv[2] = SwiftAmt.Format(aStmtLine.DecValue, ',', 2); aCsv[3] = aStmtLine.PayeePayerAcctNo; aCsv[4] = aStmtLine.PayeePayerBankCode; aCsv[5] = aStmtLine.PayeePayerName1; aCsv[6] = aStmtLine.PayeePayerName2; string[] vsPaymtPurpose = aStmtLine.PaymtPurpose; if (vsPaymtPurpose != null) { aCsv[7] = String.Join("|", vsPaymtPurpose); } aCsv[8] = aStmtLine.EntryText; aCsv[9] = aStmtLine.PrimaNotaNo; aCsv[10] = aStmtLine.TranTypeIdCode; aCsv[11] = aStmtLine.ZkaTranCode; aCsv[12] = aStmtLine.TextKeyExt; aCsv[13] = aStmtLine.BankRef; aCsv[14] = aStmtLine.OwnerRef; aCsv[15] = aStmtLine.SupplementaryDetails; sb.Append(aCsv); sb.Append(Environment.NewLine); } return(sb.ToString()); }