53d3a0b5-23c1-4e9e-92dd-06da50f0ecd7 BNZ Direct Debit Cashbook Integration BNZ Direct Debit integration.
Supports the creation and export of direct debit batches.
After importing the plugin, run the attached SQL Scripts for a) creating abstract permissions, and b) creating the stored procedure for generating the candidate payments.
System settings provide a default export location and a transaction age window as a basic sanity check.
Note that the stored procedure will need to be modified - account numbers and payment types will need to be set - they are hard-coded into the stored procedure (on the basis that only domestic payments will get direct debits, and there will most likely only be one bank account being used for it).
Includes verification of NZ bank account numbers. true false 103 Advanced ERP 23.05.28.0210

//-----------------------------------------------------------------------
//     Author: Ryan Price
//     Copyright (c) Advanced ERP Limited 2020-2023.
//     Web site: https://aerp.co.nz
//     Contact Email: info@aerp.co.nz
//
//     Note: use of this software is governed by Advanced ERP terms and conditions
//           which can be found at https://aerp.co.nz/tc.
//
//	   This code may be modified and adapted as required, as long as credit
//     for the original work is retained in the source code.
//-----------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;

using FarPoint.Win.Spread;

using Infragistics.Win.UltraWinToolbars;

using JiwaFinancials.Jiwa.JiwaApplication;
using JiwaFinancials.Jiwa.JiwaApplication.Controls;
using JiwaFinancials.Jiwa.JiwaApplication.CustomFields;
using JiwaFinancials.Jiwa.JiwaApplication.Plugin;

using JiwaFinancials.Jiwa.JiwaApplication.Security;
using JiwaFinancials.Jiwa.JiwaBankDetails;
using JiwaFinancials.Jiwa.JiwaBankDetailsUI;
using JiwaFinancials.Jiwa.JiwaCashBook;
using JiwaFinancials.Jiwa.JiwaCashBookUI;
using JiwaFinancials.Jiwa.JiwaODBC;

using SD = System.Drawing;
using WF = System.Windows.Forms;

namespace Aerp.Cashbook.Bnz
{
    public class FormPlugin : System.MarshalByRefObject, IJiwaFormPlugin
    {
        /// <summary>
        /// Fallback default location for upload files.
        /// Should be set in system settings.
        /// </summary>
        private const string FallbackBnzUploadFolder = @"C:\TEMP";

        /// <summary>
        /// Other party particulars - 12 character value.
        /// </summary>
        private const string FallbackOtherPartyParticulars = @"ADVANCEDERP";

        // C = Individual listing, details copied from other party.
        // I = Individual listing, payer's and other party's details entered individually.
        // O = Individual listing, payer's details all the same.
        // <Blank> = Bulk listing.
        private const string FallbackBulkImportFlag = "";

        /// <summary>
        /// Set to false to disable bank account validation.
        /// Turning it off will break the hash total calculations if the account number formats are not uniform N(16).
        /// </summary>
        private bool ValidateBankAccounts = true;

        /// <summary>
        /// Maximum age of transactions to include in batch.
        /// </summary>
        private const int FallbackMaximumAgeOfTransactionInDays = 180;

        /// <summary>
        /// Minimum age of transactions to include in batch.
        /// </summary>
        private const int FallbackMinimumAgeOfTransactionInDays = 10;

        /// <summary>
        /// Maximum number of records in a single batch
        /// </summary>
        private const int FallbackMaximumDirectDebitBatchSize = 1000;

        /// <summary>
        /// This is at the top for the file, so that it's easy to get to for making minor changes to the bank file formatting
        /// </summary>
        /// <param name="fileName">Will be selected by a 'save file' dialog</param>
        /// <param name="Plugin"></param>
        public void SaveBnzDirectDebitFile(Plugin Plugin, CashBook batch, string fileName)
        {
//            if (Debugger.IsAttached && Environment.UserName == "ryan")
//            {
//                Debugger.Break();
//            }

            var manager = batch.Manager;

            // get our bank account no from the GL.

            var bankDetails = manager.GetBankAccount(batch.BankLedgerID);
            if (bankDetails == null)
            {
                WF.MessageBox.Show(batch.Client.Form, "Bank details for GL Ledger not found");
                return;
            }

            var ourBankAccountNo = BankAccountValidation.ParseBankAccountNumber(bankDetails.AccountNumber);
            if (string.IsNullOrEmpty(ourBankAccountNo))
            {
                WF.MessageBox.Show(batch.Client.Form, "Invalid or missing local bank account number.bnz \r\nAccount number must be a valid NZ Bank Account.");
                return;
            }

            var authority = bankDetails.EFTBankCode;
            if (string.IsNullOrEmpty(authority) || !Regex.IsMatch(authority, @"\d{7}"))
            {
                WF.MessageBox.Show(batch.Client.Form, "Invalid or missing direct debit authority.\r\nAuthority must be a 7-digit number.");
                return;
            }

            try
            {
                // open the export file.
                var f = new StreamWriter(fileName, false, Encoding.ASCII);

                var recordCount = 0;
                var hashTotal = 0UL;
                var totalCredits = 0L;
                var invalidBankAccounts = 0;

                // Header
                var invariantCulture = System.Globalization.CultureInfo.InvariantCulture;

                var otherPartyParticulars = GetSystemSetting(Plugin, "DirectDebitOtherPartyParticulars", FallbackOtherPartyParticulars).Replace(",", " ");
                var bulkImportFlag = GetSystemSetting(Plugin, "DirectDebitBulkImportFlag", FallbackBulkImportFlag);

                var batchDate = batch.CustomFieldValues.GetValue("DirectDebitBatchDate", DateTime.Today);
                if (batchDate < DateTime.Today) batchDate = DateTime.Today;

                var batchDateInBnzFormat = batchDate.ToString("yyMMdd", invariantCulture);
                var todayInBnzFormat = DateTime.Now.ToString("yyMMdd", invariantCulture);

                f.WriteLine("1,{0},,,{1},6,{2},{3},{4}", authority, ourBankAccountNo, batchDateInBnzFormat, todayInBnzFormat, bulkImportFlag);
                foreach (CashBookTransaction tranLine in batch.CashBookTransactions)
                {
                    if (tranLine.HomeAmount != 0m)
                    {
                        // '
                        // ' Make customisations to the fields to use here.
                        // ' Formatting is dictated by BNZ and performed later.
                        // '

                        // max 20 characters
                        var ourName = manager.Licencing.CompanyName.Replace(",", " ").Replace(" Limited", " Ltd", StringComparison.OrdinalIgnoreCase);

                        // max 12 characters
                        var ourReference = batch.BatchNo.Replace(",", " ");

                        // max 12 characters
                        var ourCode = tranLine.DebtorCreditorAccountNo.Replace(",", " ");

                        // max 12 characters
                        var ourParticulars = tranLine.DebtorCreditorAccountName.Replace(",", " ");

                        // max 20 characters
                        var otherPartyName = tranLine.DebtorCreditorAccountName.Replace(",", " ");

                        // max 12 characters
                        var otherPartyReference = batch.BatchNo.Replace(",", " ");

                        // max 12 characters
                        var otherPartyCode = tranLine.DebtorCreditorAccountNo.Replace(",", " ");

                        recordCount += 1;
                        var thisAmountInCents = (long)Math.Round(tranLine.HomeAmount * 100m);
                        totalCredits += thisAmountInCents;

                        string parsedBankAccount;
                        var message = "";

                        if (tranLine.DebtorCreditorUsesFX || !localCurrencies.Contains(tranLine.FXCurrencyCode))
                        {
                            parsedBankAccount = tranLine.BankAccountNo;
                            message = "ERROR: FX Debtor/Transaction not supported";
                        }
                        else
                        {
                            if (this.ValidateBankAccounts)
                            {
                                try
                                {
                                    parsedBankAccount = BankAccountValidation.ParseBankAccountNumber(tranLine.BankAccountNo);
                                }
                                catch (Exception ex)
                                {
                                    message = string.Format("WARNING: Bank account failed validation: {0}", tranLine.BankAccountNo);
                                    invalidBankAccounts++;

                                    // fallback in case it is the validation that is wrong.
                                    parsedBankAccount = tranLine.BankAccountNo.Replace("-", "").Replace(" ", "");
                                }
                            }
                            else
                            {
                                // no validation, but we'll still strip punctuation.
                                parsedBankAccount = tranLine.BankAccountNo.Replace("-", "").Replace(" ", "");
                            }
                            hashTotal += ulong.Parse(parsedBankAccount.Mid(2, 11));
                        }

                        // 1  - N(1) - Always the number 2 = Transaction record
                        f.Write("2");

                        // 2  -N(16) - Other party bank account number 
                        f.Write(','); f.Write(parsedBankAccount);

                        // 3  - N(2) - Transaction Code. Always use the number 00 for Direct Debit payments
                        f.Write(",00");

                        // 4  - N(12) - Transaction Amount in cents
                        f.Write(','); f.Write(thisAmountInCents);

                        // 5  - A (20) - Other Party Name. Mandatory field.
                        f.Write(','); f.Write(otherPartyName.Left(20));

                        // 6  - A (12) - Other Party Reference. Optional field.
                        f.Write(','); f.Write(otherPartyReference.Left(12));

                        // 7  - A (12) - Other Party Code. Optional field.
                        f.Write(','); f.Write(otherPartyCode.Left(12));

                        // 8  - Spare field, leave blank.
                        f.Write(",");

                        // 9  - A (12) - Other Party Particulars.Optional field.
                        f.Write(','); f.Write(otherPartyParticulars.Left(12));

                        // 10 - A(20) Our Name. Mandatory field.  Will be displayed on the bank statement of the party receiving the funds. Can contain different From Names for each transaction.
                        f.Write(','); f.Write(ourName.Left(20));

                        // 11 - A (12) - Our Code. Optional field.
                        f.Write(','); f.Write(ourCode.Left(12));

                        // 12 - A (12) - Our Reference. Optional field.
                        f.Write(','); f.Write(ourReference.Left(12));

                        // 13 - A (12) - Our Particulars. Optional field.
                        f.Write(','); f.Write(ourParticulars.Left(12));

                        if (!string.IsNullOrWhiteSpace(message))
                        {
                            f.Write(",!!! " + message);
                        }

                        f.WriteLine();
                    }
                }

                // hash must be zero-padded to 11 digits.
                hashTotal %= 100000000000; // limit to 11 digits.
                var outputHash = hashTotal.ToString().PadLeft(11, '0');

                f.WriteLine("3,{0},{1},{2}", totalCredits, recordCount, outputHash);

                f.Close();

                var exportedDate = batch.CustomFieldValues.get_ItemFromSettingName("DirectDebitExportedDate");
                if (exportedDate != null)
                {
                    exportedDate.SetValue(DateTime.Today.ToString("s"));
                }

                var exportedBy = batch.CustomFieldValues.get_ItemFromSettingName("DirectDebitExportedBy");
                if (exportedBy != null)
                {
                    exportedBy.SetValue(manager.Staff.FullName);
                }

                var exportFileName = batch.CustomFieldValues.get_ItemFromSettingName("DirectDebitFileName");
                if (exportFileName != null)
                {
                    exportFileName.SetValue(fileName);
                }

                batch.Save();
                batch.Read(batch.RecID);


                if (invalidBankAccounts != 0)
                {
                    WF.MessageBox.Show(batch.Client.Form, string.Format("{0} Saved with {1} invalid bank account number{2}.", fileName, invalidBankAccounts, invalidBankAccounts == 1 ? "" : "s"), "Direct Debit File Saved");
                }
                else
                {
                    WF.MessageBox.Show(batch.Client.Form, fileName + " Saved.", "Direct Debit File Saved");
                }
            }

            catch (Exception ex)
            {
                WF.MessageBox.Show(batch.Client.Form, "Error saving " + fileName + ": " + ex.Message, "Direct Debit File Save Error");
            }
        }

        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void SetupBeforeHandlers(IJiwaForm JiwaForm, Plugin Plugin)
        {
        }

        public void Setup(IJiwaForm JiwaForm, Plugin Plugin)
        {
            var cbForm = JiwaForm as frmCashBookReceipts;

            if (cbForm == null)
            {
                return; // not a cashbook form
            }

            AddGenerateDdButton(cbForm, Plugin);

            AddExportDdButton(cbForm, Plugin);

            AddBankSetupButton(cbForm);

            SetupCustomFieldHandlers(cbForm);
        }

        private static void SetupCustomFieldHandlers(frmCashBookReceipts cbForm)
        {
            cbForm.CashBook.CustomFieldValues.Changed += (item, e) =>
            {
                if (cbForm.CashBook.Activated)
                {
                    return;
                }

                if (string.Compare(item.CustomField.PluginCustomField.Name, "DirectDebitBatchDate", StringComparison.OrdinalIgnoreCase) == 0)
                {
                    DateTime newDate;
                    if (DateTime.TryParse(item.Contents, out newDate))
                    {
                        foreach (CashBookTransaction line in cbForm.CashBook.CashBookTransactions)
                        {
                            line.TranDate = newDate;
                            line.TransactionDueDate = newDate;
                        }
                    }
                }
            };
        }

        internal readonly static string[] localCurrencies = new[] { "NZD", "" };

        private const string _bankSetupCaption = "Setup bank details";

        private const string _bankSetupKey = "AERP_BankSetup";

        private const string _directDebitExportCaption = "Generate NZD Payment File";

        private const string _directDebitExportKey = "AERP_BNZDirectDebitExport";

        private const string _directDebitGenerateCaption = "Create NZD Direct Debit Batch";

        private const string _directDebitGenerateKey = "AERP_BNZDirectDebitGenerate";

        private void AddBankSetupButton(frmCashBookReceipts cbForm)
        {
            var setupBanksButton = cbForm.UltraToolbarsManager1
            .AddNewToolbarButton(
                cbForm.UltraToolbarsManager1.AddNewToolbarGroup("Utilities", "Bank", "Bank", 1),
                _bankSetupKey,
                _bankSetupCaption,
                RibbonToolSize.Normal,
                UiHelpers.BankIcon32,
                UiHelpers.BankIcon16);

            cbForm.UltraToolbarsManager1.ToolClick += (s, e) =>
            {
                if (cbForm.InPermissionMode || (e.Tool.Key != _bankSetupKey))
                {
                    return;
                }
                var bankSetupDialog = cbForm.Manager.DialogFactory.CreateDialog<frmChequeNumbers>(cbForm.Form);
                bankSetupDialog.ShowDialog(cbForm.Form);
            };
        }

        /// <summary>
        /// add export direct debit button to toolbar
        /// </summary>
        /// <param name="cbForm"></param>
        private void AddExportDdButton(frmCashBookReceipts cbForm, Plugin Plugin)
        {
            UserGroup.AccessLevels permissions = cbForm.Manager.Staff.GetAbstractPermission("JiwaFinancials.Jiwa.JiwaCashBookUI.frmCashBook", "ExtractDirectDebitBatch");
            if (permissions == JiwaFinancials.Jiwa.JiwaApplication.Security.UserGroup.AccessLevels.Allow)
            {
                var exportDirectDebitsButton = cbForm.UltraToolbarsManager1
                    .AddNewToolbarButton(
                        cbForm.UltraToolbarsManager1.AddNewToolbarGroup("Main", "BNZ", "BNZ", 1),
                        _directDebitExportKey,
                        _directDebitExportCaption,
                        RibbonToolSize.Normal,
                        UiHelpers.LogoLarge,
                        UiHelpers.LogoMedium);

                //
                // only allow export of batch if there are no changes to the current batch
                // and the current batch has been activated.
                //
                cbForm.CashBook.ReadEnd += (s, e) => exportDirectDebitsButton.SharedProps.Enabled = true;

                cbForm.CashBook.PropertyChanged += (s, e) => exportDirectDebitsButton.SharedProps.Enabled = false;

                cbForm.CashBook.SaveEnd += (s, e) => exportDirectDebitsButton.SharedProps.Enabled = true;

                cbForm.UltraToolbarsManager1.ToolClick += (s, e) =>
                {
                    if (cbForm.InPermissionMode || (e.Tool.Key != _directDebitExportKey))
                    {
                        return;
                    }

                    ExportDirectDebitBatch(cbForm, Plugin);
                };
            }
        }

        private void AddGenerateDdButton(frmCashBookReceipts cbForm, Plugin Plugin)
        {
            // add generate direct debit button to toolbar
            var permissions = cbForm.Manager.Staff.GetAbstractPermission("JiwaFinancials.Jiwa.JiwaCashBookUI.frmCashBook", "CreateDirectDebitBatch");
            if (permissions == JiwaFinancials.Jiwa.JiwaApplication.Security.UserGroup.AccessLevels.Allow)
            {
                var generateDirectDebitsButton = cbForm.UltraToolbarsManager1
                    .AddNewToolbarButton(
                        cbForm.UltraToolbarsManager1.AddNewToolbarGroup("Main", "BNZ", "BNZ", 1),
                        _directDebitGenerateKey,
                        _directDebitGenerateCaption,
                        RibbonToolSize.Normal,
                        UiHelpers.LogoLarge,
                        UiHelpers.LogoMedium);

                // only allow creation of batch if there are no changes
                cbForm.CashBook.ReadEnd += (s, e) => generateDirectDebitsButton.SharedProps.Enabled = true;

                cbForm.CashBook.PropertyChanged += (s, e) => generateDirectDebitsButton.SharedProps.Enabled = false;

                cbForm.CashBook.SaveEnd += (s, e) => generateDirectDebitsButton.SharedProps.Enabled = true;

                cbForm.UltraToolbarsManager1.ToolClick += (s, e) =>
                {
                    if (cbForm.InPermissionMode || (e.Tool.Key != _directDebitGenerateKey))
                    {
                        return;
                    }

                    GenerateDirectDebitBatch(cbForm, Plugin);
                };
            }
        }

        private void ExportDirectDebitBatch(frmCashBookReceipts cbForm, Plugin Plugin)
        {
            string defaultFolder = FallbackBnzUploadFolder;

            var setting = Plugin.SystemSettingCollection.Cast<SystemSetting>()
                .FirstOrDefault(ss => string.Equals(ss.IDKey, "DirectDebitDefaultFolder", StringComparison.OrdinalIgnoreCase));

            if (setting != null && Directory.Exists(setting.Contents))
            {
                defaultFolder = setting.Contents;
            }

            var fd = new WF.SaveFileDialog()
            {
                AddExtension = true,
                AutoUpgradeEnabled = true,
                CheckPathExists = true,
                DefaultExt = "TXT",
                FileName = string.Format("DirectDebit_{0}_{1:yyyyMMdd_HHmm}.txt", cbForm.CashBook.BatchNo, DateTime.Now),
                Filter = "Text files(*.txt)|*.txt|AFI files (*.afi)|*.afi|All files(*.*)|*.*",
                InitialDirectory = defaultFolder,
                OverwritePrompt = true,
                RestoreDirectory = true,
                Title = "Save iB4B Direct Debit upload file",
            };

            if (fd.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            var fileName = fd.FileName;
            if (string.IsNullOrWhiteSpace(fileName))
            {
                return;
            }

            SaveBnzDirectDebitFile(Plugin, cbForm.CashBook, fileName);
        }

        private string GetSystemSetting(Plugin Plugin, string name, string fallback)
        {
            var setting = Plugin.SystemSettingCollection.Cast<SystemSetting>().FirstOrDefault(ss => string.Equals(ss.IDKey, name, StringComparison.OrdinalIgnoreCase));

            if (setting == null || string.IsNullOrEmpty(setting.Contents))
            {
                return fallback;
            }
            return setting.Contents;
        }

        private int GetSystemSetting(Plugin Plugin, string name, int fallback)
        {
            var setting = Plugin.SystemSettingCollection.Cast<SystemSetting>().FirstOrDefault(ss => string.Equals(ss.IDKey, name, StringComparison.OrdinalIgnoreCase));

            int result;
            if (setting == null || !int.TryParse(setting.Contents, out result))
            {
                result = fallback;
            }
            return result;
        }

        private void GenerateDirectDebitBatch(frmCashBookReceipts cbForm, Plugin Plugin)
        {
            if (WF.MessageBox.Show("Create a new direct debit batch?", "Direct Debit Batch Creation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
            {
                return;
            }

            Plugin.SystemSettingCollection.Read(); // refresh in case of changes.
            int maximumBatchSize = GetSystemSetting(Plugin, "DirectDebitMaximumBatchSize", FallbackMaximumDirectDebitBatchSize);
            int minimumDays = GetSystemSetting(Plugin, "DirectDebitMinimumDays", FallbackMinimumAgeOfTransactionInDays);
            int maximumDays = GetSystemSetting(Plugin, "DirectDebitMaximumDays", FallbackMaximumAgeOfTransactionInDays);

            const string sql = "dbo.AERP_GetDirectDebitCandidatesXml";

            using (var cmd = new SqlCommand(sql, cbForm.Manager.Database.SQLConnection)
            {
                CommandText = sql,
                CommandType = CommandType.StoredProcedure,
            })
            {
                cmd.Parameters.AddWithValue("@onOrAfterDate", DateTime.Today.AddDays(-maximumDays));
                cmd.Parameters.AddWithValue("@onOrBeforeDate", DateTime.Today.AddDays(-minimumDays));
                cmd.Parameters.AddWithValue("@maximumBatchSize", maximumBatchSize);

                try
                {
                    string results = (string)cmd.ExecuteScalar();
                    if (results != null)
                    {
                        var paymentBatch = cbForm.CashBook;
                        paymentBatch.CreateNew();
                        paymentBatch.Deserialise(results);
                        paymentBatch.Save();
                        paymentBatch.Read(paymentBatch.RecID);

                        foreach (CashBookTransaction line in paymentBatch.CashBookTransactions)
                        {
                            // the stored procedure will store a list of allocations in the reference field.
                            // the field is limited to 250 characters, so there is a practical limit of about
                            // 10 allocations that can be made this way.
                            var references = line.Reference.Split(';');
                            if (references.Length > 0)
                            {
                                foreach (string reference in references)
                                {
                                    string debtorTransactionKey = string.Empty;
                                    paymentBatch.AddDebtorTransaction(reference, ref debtorTransactionKey);

                                    if (!string.IsNullOrWhiteSpace(debtorTransactionKey))
                                    {
                                        var dbt = paymentBatch.DebtorTransactions[debtorTransactionKey];
                                        paymentBatch.AddAllocation(line.RecID, debtorTransactionKey, dbt.FXUnAllocatedAmount, CashBook.CashBookAllocationTypes.e_CashBookAllocationTypeNormal);
                                    }
                                }
                                line.Reference = ""; // these keys are not interesting after the allocations are done.
                            }
                        }

                        var batchDate = paymentBatch.CustomFieldValues.get_ItemFromSettingName("DirectDebitGeneratedDate");
                        if (batchDate != null)
                        {
                            batchDate.SetValue(DateTime.Today.ToString("s"));
                        }

                        var generatedBy = paymentBatch.CustomFieldValues.get_ItemFromSettingName("DirectDebitGeneratedBy");
                        if (generatedBy != null)
                        {
                            generatedBy.SetValue(paymentBatch.Manager.Staff.FullName);
                        }

                        paymentBatch.Save();
                        paymentBatch.Read(paymentBatch.RecID);
                    }
                }
                catch (Exception ex)
                {
                    WF.MessageBox.Show(string.Format("{0}", ex), "Error loading batch");
                    // throw new ClientCancelledException("Error loading direct debit batch", ex);
                }
            }
        }

    }

    #region "BusinessLogicPlugin"
    public class BusinessLogicPlugin : System.MarshalByRefObject, IJiwaBusinessLogicPlugin
    {

        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void Setup(IJiwaBusinessLogic JiwaBusinessLogic, Plugin Plugin)
        {
        }
    }
    #endregion

    #region "ApplicationManagerPlugin"
    public class ApplicationManagerPlugin : System.MarshalByRefObject, IJiwaApplicationManagerPlugin
    {

        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void Setup(Plugin Plugin)
        {
        }
    }
    #endregion

    #region "CustomFieldPlugin"
    public class CustomFieldPlugin : System.MarshalByRefObject, IJiwaCustomFieldPlugin
    {
        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void FormatCell(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
            var cb = BusinessLogicHost as CashBook;
            if (cb == null)
            {
                return;
            }

            if (string.Compare(CustomField.PluginCustomField.Name, "DirectDebitBatchDate", StringComparison.OrdinalIgnoreCase) == 0)
            {
                GridObject.ActiveSheet.Cells[Row, Col].Locked = cb.Activated;
            }
            else if (CustomField.PluginCustomField.Name.StartsWith("DirectDebit", StringComparison.OrdinalIgnoreCase))
            {
                GridObject.ActiveSheet.Cells[Row, Col].Locked = true;
            }
        }

        public void ReadData(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Row, IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
        }

        public void ButtonClicked(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
        }
    }
    #endregion

    #region "LineCustomFieldPlugin"
    public class LineCustomFieldPlugin : System.MarshalByRefObject, IJiwaLineCustomFieldPlugin
    {
        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void FormatCell(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
        }

        public void ReadData(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Row, IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
        }

        public void ButtonClicked(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, CustomFieldValue CustomFieldValue)
        {
        }
    }
    #endregion

    #region "SystemSettingPlugin"
    public class SystemSettingPlugin : System.MarshalByRefObject, IJiwaSystemSettingPlugin
    {
        public override object InitializeLifetimeService()
        {
            // returning null here will prevent the lease manager
            // from deleting the Object.
            return null;
        }

        public void FormatCell(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting)
        {
        }

        public void ReadData(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting)
        {
        }

        public void ButtonClicked(IJiwaBusinessLogic BusinessLogicHost, JiwaGrid GridObject, IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting)
        {
        }
    }
    #endregion

    #region "ScheduledExecutionPlugin"
    public class ScheduledExecutionPlugin : System.MarshalByRefObject, IJiwaScheduledExecutionPlugin
    {
        public void Execute(Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule)
        {
            lock (Manager.CriticalSectionFlag)
            {
                // place processing code in here
            }
        }

        public void OnServiceStart(Plugin Plugin)
        {
        }

        public void OnServiceStopping(Plugin Plugin)
        {
        }
    }
    #endregion

    #region "Extensions"
    public static class Strings
    {
        public static string Left(this string str, int length)
        {
            if (length <= 0) { throw new ArgumentOutOfRangeException("length"); }
            return length >= str.Length ? str : str.Substring(0, length);
        }

        public static string Right(this string str, int length)
        {
            if (length <= 0) { throw new ArgumentOutOfRangeException("length"); }
            return length >= str.Length ? str : str.Substring(str.Length - length);
        }

        public static string Mid(this string str, int start, int length)
        {
            if (start < 0) { throw new ArgumentOutOfRangeException("start"); }
            if (length <= 0) { throw new ArgumentOutOfRangeException("length"); }
            return start + length >= str.Length ? str.Substring(start) : str.Substring(start, length);
        }

        /// <summary>
        /// Returns a new string in which all occurrences of a specified string in the current instance are replaced with another 
        /// specified string according the type of search to use for the specified string.
        /// </summary>
        /// <remarks>
        /// <p>thanks to https://stackoverflow.com/questions/6275980/string-replace-ignoring-case </p>
        /// </remarks>
        /// <param name="str">The string performing the replace method.</param>
        /// <param name="oldValue">The string to be replaced.</param>
        /// <param name="newValue">The string replace all occurrences of <paramref name="oldValue"/>. 
        /// If <paramref name="newValue"/> is <c>null</c> or empty, than all occurrences of <paramref name="oldValue"/> will be removed from the <paramref name="str"/>.</param>
        /// <param name="comparisonType">One of the enumeration values that specifies the rules for the search.</param>
        /// <returns>A string that is equivalent to the current string except that all instances of <paramref name="oldValue"/> are replaced with <paramref name="newValue"/>. 
        /// If <paramref name="oldValue"/> is not found in the current instance, the method returns the current instance unchanged.</returns>
        [DebuggerStepThrough]
        public static string Replace(this string str,
            string oldValue, string newValue,
            StringComparison comparisonType)
        {

            // not quite the same as standard string.Replace, which will throw on str == null.
            if ((str == null) || (str.Length == 0))
            {
                return str;
            }

            // not quite the same as standard string.Replace.
            if (string.IsNullOrEmpty(oldValue)) // note: WhiteSpace would be valid.
            {
                throw new ArgumentException("oldValue", "oldValue may not be null or empty");
            }

            // Prepare string builder for storing the processed string.
            StringBuilder resultStringBuilder = new StringBuilder(str.Length);

            // Analyze the replacement: replace or remove.
            bool replacementIsEmpty = string.IsNullOrEmpty(newValue);

            // Replace all values.
            const int valueNotFound = -1;
            int foundAt;
            int startIndex = 0;
            while ((foundAt = str.IndexOf(oldValue, startIndex, comparisonType)) != valueNotFound)
            {
                // Append all characters until the found replacement.
                int keepLength = foundAt - startIndex;
                if (keepLength != 0)
                {
                    resultStringBuilder.Append(str, startIndex, keepLength);
                }

                // Process the replacement.
                if (!replacementIsEmpty)
                {
                    resultStringBuilder.Append(newValue);
                }

                // Prepare start index for the next search.
                // This needed to prevent infinite loop, otherwise method always start search 
                // from the start of the string. For example: if an oldValue == "EXAMPLE", newValue == "example"
                // and comparisonType == "any ignore case" will conquer to replacing:
                // "EXAMPLE" to "example" to "example" to "example" ? infinite loop.
                startIndex = foundAt + oldValue.Length;
                if (startIndex == str.Length)
                {
                    // It is end of the input string: no more space for the next search.
                    // The input string ends with an <oldValue> that has already been replaced. 
                    // Therefore, the string builder with the result is complete and no further action is required.
                    return resultStringBuilder.ToString();
                }
            }

            // Append the last part to the result.
            resultStringBuilder.Append(str, startIndex, str.Length - startIndex);

            return resultStringBuilder.ToString();
        }
    }
    #endregion

    #region "UI Helpers"

    public static class UiHelpers
    {
        // Stripe Logo in Base64. Because as at Jiwa 7.2.1, there is no convenient way to embed resources into a plugin :(
        const string LogoLargeB64 = @"
iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAMAAACdt4HsAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAzUExURQAvayZBXtuZI15cTPqoGT9NVnxsQh8+YbuK
Lpx7OAMxbAMxbQc0bww5cgEwawo3cAEva2MBScwAAAAJcEhZcwAADsIAAA7CARUoSoAAAAEOSURBVFhH7ZbLEsIgDEURIrS+//9rpfSqsVZvwJUOZxNqJJ3CmUxc5zfY
IDbjEVsJssWqEf9lgSASsWwiiciAdSXJT+T9ImUV8LudNO+e8S0HkQbsbj6GW4Wm1xfiXGDEow1tLk5BF+BiK3OzAzLmIvoeqdjaXC9DcmmUp5rsPJS5wZfDT1HKY4GK
rc29f3p81GQ3Ssz9lCbmGsQm5hrEJuYaxCbmGsQm5nKx8Znv/kHS5ZJfzFWQdGbFXA1Jr5urIOnMirkaku78L302oS2cUD2b7BDz1tK4p+ZTNZvsETNts8kBccLQwl85
IhYMLXzJCRHUzyZnREBbOIG38CUXREBbOIG3cEJv4Z0qnLsCluoIBF8PBcsAAAAASUVORK5CYII=
";
        private static readonly SD.Image logoLarge = SD.Image.FromStream(new MemoryStream(Convert.FromBase64String(LogoLargeB64)) { Position = 0 });

        public static SD.Image LogoLarge
        {
            get
            {
                return logoLarge;
            }
        }

        const string LogoMediumB64 = @"
iVBORw0KGgoAAAANSUhEUgAAACAAAAAgBAMAAACBVGfHAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAbUExURQAvawQxaf6qGJN2OvSlGwEvagMwaQAvagIw
ahfkyiQAAAAJcEhZcwAADsIAAA7CARUoSoAAAABrSURBVCjPY6AAMKILMKELGKHxlZSUUAWYnQzRjEBRIMDAYMwEoSFAAWqpAkw/mMEKpNmg2pUUkGkGBhNlARSaASYB
o5kNFFBoOAhgYGegCAigC6BZAHQ1Bwof4WoYgLsaBtAVYLiaqoCBAQDhYgb1P2te9wAAAABJRU5ErkJggg==
";

        private static readonly SD.Image logMedium = SD.Image.FromStream(new MemoryStream(Convert.FromBase64String(LogoMediumB64)) { Position = 0 });

        public static SD.Image LogoMedium
        {
            get
            {
                return logMedium;
            }
        }

        const string LogoBase64Tiny = @"
iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAA8UExURQAvawEvawEwagAubAAtbAEwawAua/+yEgIw
agAocP+zEQAqbgQvawYxaggzaAAncAQwagIwbAgxagIxagej3vcAAAAJcEhZcwAADsMAAA7DAcdvqGQAAABzSURBVChTdY7bDsMwCENNLk26dmu7/f+/zhhU7WVHijAW
xCCwUi1lUPlaSKcvwGDNoWm1Ygx3hK0qd+9kE6UAjxjXVsfcKPc23XEbYMLzpYADpxzml7Z0aaH0sXIp7+g8kx/eh9qlD9/R/WEyycd++GQFvuM0Ab9/GZpHAAAAAElF
TkSuQmCC
";

        private static readonly SD.Image logoTiny = SD.Image.FromStream(new MemoryStream(Convert.FromBase64String(LogoBase64Tiny)) { Position = 0 });

        public static SD.Image LogoTiny
        {
            get
            {
                return logoTiny;
            }
        }

        const string BankIcon16Base64 = @"
iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAtUExURR0dHUlJSQAAALa2tgYGBv////7+/pCQkHR0
dJycnPf39wMDA6SkpK+vrwAAANX2GMkAAAAPdFJOU///////////////////ANTcmKEAAAAJcEhZcwAACxMAAAsTAQCanBgAAABVSURBVChTXc/bFgARCEDRajTMrf//
XCGNnLc2KwvIFgiEGuDSAPKOAImIDU4dc8lElwG3mVXmDoVyM5cf0n7jsR2vgTdf8b4BSx3stDcA7aOCHUIiFavpBWesjU+XAAAAAElFTkSuQmCC
";

        private static readonly SD.Image bankIcon16 = SD.Image.FromStream(new MemoryStream(Convert.FromBase64String(BankIcon16Base64)) { Position = 0 });

        public static SD.Image BankIcon16
        {
            get
            {
                return bankIcon16;
            }
        }


        const string BankIcon32Base64 = @"
iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAMAAABEpIrGAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAtUExURYaGhgAAAElJSf///2hoaPv7+/7+/gICAvLy
8v39/ff392xsbEdHR4eHhwAAAAPgukYAAAAPdFJOU///////////////////ANTcmKEAAAAJcEhZcwAACxMAAAsTAQCanBgAAAC2SURBVDhPpZNZEoNACAURTIxZ5v7H
zSOQ2dFKpf1RbHkMVVI6AQIdYMIS8hU4oAgypRbWCa3goRWnAjJ+EpiIP3UWXKPAdLnC2MQPKL1AeBRsjFnvCCvohnTB3pvRCky3HRHIN5DRHZPljrYIBzuEvoML1kGF
sEM0QxaiU7iADAN7GAQ8L5uOOd3kqp9pudAJXq34X+iGfAy0wpRKCMhCSBGeE7LwUsF/1YoikOperdCqCUek9AZ/axOXsYJA0gAAAABJRU5ErkJggg==
";

        private static readonly SD.Image bankIcon32 = SD.Image.FromStream(new MemoryStream(Convert.FromBase64String(BankIcon32Base64)) { Position = 0 });

        public static SD.Image BankIcon32
        {
            get
            {
                return bankIcon32;
            }
        }




        /// <summary>
        /// Change the icon for a button.
        /// </summary>
        /// <param name="button"></param>
        /// <param name="icon"></param>
        public static void ChangeButtonIcon(this ButtonTool button, SD.Image icon)
        {
            button.SharedProps.AppearancesLarge.Appearance.Image = icon;
            button.SharedProps.AppearancesSmall.Appearance.Image = icon;
        }

        public static ButtonTool AddNewToolbarButton(this UltraToolbarsManager toolBar, RibbonGroup group, string key, string caption, RibbonToolSize preferredSize, SD.Image largeImage, SD.Image smallImage)
        {
            var newButton = new ButtonTool(key);
            newButton.SharedProps.Caption = caption;
            newButton.SharedProps.AppearancesLarge.Appearance.Image = largeImage;
            newButton.SharedProps.AppearancesSmall.Appearance.Image = smallImage;

            toolBar.Tools.Add(newButton);

            var toolInstance = group.Tools.AddTool(key);
            toolInstance.InstanceProps.MinimumSizeOnRibbon = RibbonToolSize.Normal;
            toolInstance.InstanceProps.PreferredSizeOnRibbon = preferredSize;

            return newButton;
        }

        public static RibbonGroup AddNewToolbarGroup(this UltraToolbarsManager toolBar, string tabKey, string groupKey, string groupCaption, int insertAt)
        {
            RibbonGroup newGroup;
            RibbonTab ribbonTab;
            try
            {
                // if this fails, we need a new toolbar
                ribbonTab = toolBar.Ribbon.Tabs[tabKey];
            }
            catch (Exception)
            {
                ribbonTab = toolBar.Ribbon.Tabs.Add(tabKey);
                ribbonTab.Visible = true;
            }

            try
            {
                // if this fails, it's almost certainly because the group doesn't exist, and we need to add it.
                newGroup = ribbonTab.Groups[groupKey];
            }
            catch (Exception)
            {
                if (insertAt == -1)
                {
                    newGroup = ribbonTab.Groups.Add(groupKey);
                }
                else
                {
                    newGroup = ribbonTab.Groups.Insert(insertAt, groupKey);
                }
                newGroup.Caption = groupCaption;
                newGroup.Visible = true;
            }

            return newGroup;
        }
    }
    #endregion

}

namespace Aerp.Cashbook
{
    #region "Bank helper functions"

    public static class JiwaBankHelpers
    {

        public static clsBankAccount GetBankAccount(this Manager manager, string glLedgerId)
        {
            var bankDetails = manager.BusinessLogicFactory.CreateBusinessLogic<clsBankDetails>(null);
            bankDetails.ReadRecord(); // will actually read them all..

            var result = bankDetails.BankAccounts.Cast<clsBankAccount>().FirstOrDefault(b => b.GLLedgerID == glLedgerId);
            return result;
        }

    }
    static class BankAccountValidation
    {

        /// <summary>
        /// Because we're compiling with an older version of the compiler, these need to be in the constructor,
        /// they won't work in the declaration.
        /// </summary>
        static BankAccountValidation()
        {
            Algorithms = new Dictionary<char, Algorithm>() {
                { 'A', new Algorithm('A', 11, new int[18] { 0, 0, 6, 3, 7, 9, 0, 0, 10, 5, 8, 4, 2, 1, 0, 0, 0, 0 }) },
                { 'B', new Algorithm('B', 11, new int[18] { 0, 0, 0, 0, 0, 0, 0, 0, 10, 5, 8, 4, 2, 1, 0, 0, 0, 0 }) },
                { 'C', new Algorithm('C', 11, new int[18] { 3, 7, 0, 0, 0, 0, 9, 1, 10, 5, 3, 4, 2, 1, 0, 0, 0, 0 }) },
                { 'D', new Algorithm('D', 11, new int[18] { 0, 0, 0, 0, 0, 0, 0, 7, 06, 5, 4, 3, 2, 1, 0, 0, 0, 0 }) },
                { 'E', new Algorithm('E', 11, new int[18] { 0, 0, 0, 0, 0, 0, 0, 0, 00, 0, 5, 4, 3, 2, 0, 0, 0, 1 }) },
                { 'F', new Algorithm('F', 10, new int[18] { 0, 0, 0, 0, 0, 0, 0, 1, 07, 3, 1, 7, 3, 1, 0, 0, 0, 0 }) },
                { 'G', new Algorithm('G', 10, new int[18] { 0, 0, 0, 0, 0, 0, 0, 1, 03, 7, 1, 3, 7, 1, 0, 3, 7, 1 }) },
                { 'X', new Algorithm('X', 01, new int[18] { 0, 0, 0, 0, 0, 0, 0, 0, 00, 0, 0, 0, 0, 0, 0, 0, 0, 0 }) },
            };

            BankParameterData = new Dictionary<uint, BankParameters>() {
                { 1, new BankParameters(1, 'A', new[] { new BranchRange(1, 999), new BranchRange(1100, 1199), new BranchRange(1800, 1899)}) },
                { 2, new BankParameters(2, 'A', new[] { new BranchRange(1, 999), new BranchRange(1200, 1299) }) },
                { 3, new BankParameters(3, 'A', new[] { new BranchRange(1, 999), new BranchRange(1300, 1399), new BranchRange(1500, 1599), new BranchRange(1700, 1799), new BranchRange(1900, 1999) })},
                { 6, new BankParameters(6, 'A', new[] { new BranchRange(1,999), new BranchRange(1400, 1499) }) },
                { 8, new BankParameters(8, 'D', new[] { new BranchRange(6500, 6599) }) },
                { 9, new BankParameters(9, 'E', new[] { new BranchRange(0, 0) }) },
                { 11, new BankParameters(11, 'A', new[] { new BranchRange(5000, 6499), new BranchRange(6600, 8999) }) },
                { 12, new BankParameters(12, 'A', new[] { new BranchRange(3000, 3299), new BranchRange(3400, 3499), new BranchRange(3600, 3699) }) },
                { 13, new BankParameters(13, 'A', new[] { new BranchRange(4900, 4999) }) },
                { 14, new BankParameters(14, 'A', new[] { new BranchRange(4700, 4799) }) },
                { 15, new BankParameters(15, 'A', new[] { new BranchRange(3900, 3999) }) },
                { 16, new BankParameters(16, 'A', new[] { new BranchRange(4400, 4499) }) },
                { 17, new BankParameters(17, 'A', new[] { new BranchRange(3300, 3399) }) },
                { 18, new BankParameters(18, 'A', new[] { new BranchRange(3500, 3599) }) },
                { 19, new BankParameters(19, 'A', new[] { new BranchRange(4600, 4649) }) },
                { 20, new BankParameters(20, 'A', new[] { new BranchRange(4100, 4199) }) },
                { 21, new BankParameters(21, 'A', new[] { new BranchRange(4800, 4899) }) },
                { 22, new BankParameters(22, 'A', new[] { new BranchRange(4000, 4049) }) },
                { 23, new BankParameters(23, 'A', new[] { new BranchRange(3700, 3799) }) },
                { 24, new BankParameters(24, 'A', new[] { new BranchRange(4300, 4349) }) },
                { 25, new BankParameters(25, 'F', new[] { new BranchRange(2500, 2599) }) },
                { 26, new BankParameters(26, 'G', new[] { new BranchRange(2600, 2699) }) },
                { 27, new BankParameters(27, 'A', new[] { new BranchRange(3800, 3849) }) },
                { 28, new BankParameters(28, 'G', new[] { new BranchRange(2100, 2149) }) },
                { 29, new BankParameters(29, 'G', new[] { new BranchRange(2150, 2299) }) },
                { 30, new BankParameters(30, 'A', new[] { new BranchRange(2900, 2949) }) },
                { 31, new BankParameters(31, 'X', new[] { new BranchRange(2800, 2849) }) },
                { 33, new BankParameters(33, 'F', new[] { new BranchRange(6700, 6799) }) },
                { 35, new BankParameters(35, 'A', new[] { new BranchRange(2400, 2499) }) },
                { 38, new BankParameters(38, 'A', new[] { new BranchRange(9000, 9499) }) } };
        }

        private static Dictionary<char, Algorithm> Algorithms { get; set; }

        // Data from IRD guidelines, last updated 2016.
        private static Dictionary<uint, BankParameters> BankParameterData { get; set; }

        /// <summary>
        /// formats are for BNZ. Other banks may require different formats.
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public static string ParseBankAccountNumber(string value)
        {
            // Strip all spaces and hyphens before proceeding.
            value = value.Replace(" ", "").Replace("-", "");

            string[] parts;
            if (value.Length == 18)
            {
                // extra long style - 2-4-8-4
                parts = new string[4];
                parts[0] = value.Substring(0, 2);
                parts[1] = value.Substring(2, 4);
                parts[2] = value.Substring(6, 8);
                parts[3] = value.Substring(14, 4);
            }
            else if (value.Length == 17)
            {
                // long style - 2-4-8-3
                parts = new string[4];
                parts[0] = value.Substring(0, 2);
                parts[1] = value.Substring(2, 4);
                parts[2] = value.Substring(6, 8);
                parts[3] = value.Substring(14, 3);
            }
            else if (value.Length == 16)
            {
                // intermediate style - 2-4-7-3
                parts = new string[4];
                parts[0] = value.Substring(0, 2);
                parts[1] = value.Substring(2, 4);
                parts[2] = value.Substring(6, 7);
                parts[3] = value.Substring(13, 3);
            }
            else if (value.Length == 15)
            {
                // normal style - 2-4-7-2
                parts = new string[4];
                parts[0] = value.Substring(0, 2);
                parts[1] = value.Substring(2, 4);
                parts[2] = value.Substring(6, 7);
                parts[3] = value.Substring(13, 2);
            }
            else
            {
                // dunno!
                throw new ArgumentException("Unsupported or missing bank account", value);
            }

            var numericParts = new uint[] { uint.Parse(parts[0]), uint.Parse(parts[1]), uint.Parse(parts[2]), uint.Parse(parts[3]) };

            // won't do anything except spit the dummy on an error.
            ValidateAccountNumber(numericParts);

            return string.Format("{0:00}{1:0000}{2:0000000}{3:000}", numericParts[0], numericParts[1], numericParts[2], numericParts[3]);
        }

        private static void ValidateAccountNumber(uint[] parts)
        {
            var bankId = parts[0];
            var branchId = parts[1];
            var branchAccount = parts[2];
            var accountSuffix = parts[3];

            if (!BankParameterData.Keys.Contains(bankId))
            {
                throw new ArgumentException("Unknown bank id");
            }

            if (!(from BranchRange in BankParameterData[bankId].Branches
                  where branchId >= BranchRange.From && branchId <= BranchRange.To
                  select BranchRange).Any())
            {
                throw new ArgumentException("Unknown branch number");
            }

            if (branchAccount < 0 || branchAccount > 99999999)
            {
                throw new ArgumentException("Account number invalid");
            }

            if (accountSuffix < 0 || accountSuffix > 999)
            {
                throw new ArgumentException("Account suffix invalid");
            }

            // get digits. Creating a string isn't the most efficient, but the alternative of doing this by splitting out the individual digits would be just mental.
            var canonical = string.Format("{0:00}{1:0000}{2:00000000}{3:0000}", bankId, branchId, branchAccount, accountSuffix);

            var digits = new int[18];
            for (var i = 0; i <= 17; i++)
                digits[i] = canonical[i] - '0';

            char algorithmKey = BankParameterData[bankId].Algorithm;
            if (algorithmKey == 'A' && branchAccount >= 990000)
            {
                algorithmKey = 'B';
            }

            var algorithm = Algorithms[algorithmKey];

            var weights = algorithm.WeightDigits;
            var sum = 0L;

            if (algorithmKey != 'E' && algorithmKey != 'G')
            {
                for (var index = 0; index <= 17; index++)
                    sum += digits[index] * weights[index];
            }
            else
            {
                // no current banks actually use this algorithm, but it is here for completeness, because it's listed in IRD's documentation.
                for (var index = 0; index <= 17; index++)
                {
                    var a = digits[index] * weights[index];
                    // the result could be two digits, but we want only 1, which we get by adding the two digits. Twice.
                    // when you add them first time, the result could still be > 10, so they will need to be added again.
                    while (a > 10)
                    {
                        // add the digits
                        a = (a % 10) + (a / 10);
                    }

                    sum += a;
                }
            }

            if (sum % algorithm.Modulo != 0L)
            {
                throw new ArgumentException("Bank account failed checksum calculation");
            }
        }

        private struct Algorithm
        {

            public char Key;

            public int Modulo;

            public int[] WeightDigits;

            public Algorithm(char key, int modulo, int[] weightDigits)
            {
                this.Key = key;
                this.Modulo = modulo;
                this.WeightDigits = weightDigits;
            }

        }

        private struct BankParameters
        {

            public uint BankNumber;

            public char Algorithm;

            public BranchRange[] Branches;

            public BankParameters(uint bankNumber, char algorithm, BranchRange[] branchRanges)
            {
                this.BankNumber = bankNumber;
                this.Algorithm = algorithm;
                this.Branches = branchRanges;
            }

        }

        private struct BranchRange
        {

            public uint From;

            public uint To;

            public BranchRange(uint from, uint to)
            {
                this.From = from;
                this.To = to;
            }

        }

    }
    #endregion 
}

Report CSharp 87f7f796-b3d5-4563-a369-44588ab29cc1 Cash Book Receipts JiwaFinancials.Jiwa.JiwaCashBookUI.frmCashBookReceipts 0a708480-5b34-456f-a09e-21516cd13118 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Jiwa\Jiwa 7\JiwaApplication.dll 4e69d26e-5bb9-4549-9941-39ffd3157a15 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 95726ab6-0204-4763-8975-13668f49f6c1 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll 132d4698-0cf5-47fa-a90b-b1591d2bca25 Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll 36235549-d1fe-4a9a-b41c-ede10d49d920 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll b75a4359-4154-460b-8219-f8e2fcfd60d1 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Jiwa\Jiwa 7\JiwaODBC.dll 0946014d-766a-418e-9e26-7117c291c8ef System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll 77a88358-2137-4048-a04c-218045e154ae System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll 256d12c1-7775-49e0-9366-b8e65ee3189a System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll bb34f5f8-8c05-4e9e-b552-1d8a3785d329 System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 77a568ee-837c-4356-b5a3-3543c4b865a1 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Jiwa\Jiwa 7\JiwaServiceModel.dll eef85aa6-3c73-40e1-9e6a-9ef778acc26e Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll db8614f6-460d-41e8-9d3a-76e022828a4d Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll 7e23d150-ad31-4932-83da-a76846d998ff Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.v13.1.dll 75325ec8-4d2c-466d-8c4f-499874822f22 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Smo.dll 5cd88963-6670-4b95-8971-054a88b25189 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll e277406e-0e96-44f9-8c29-903845fbc219 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll b16f9e49-0ef3-4b3f-adeb-2a7a7c6c8269 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll 2150f76a-61ed-48d0-af8e-e43094fc3af6 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Jiwa\Jiwa 7\FarPoint.Win.Spread.dll 51ac348b-d39d-4a84-81b1-2116b7ba95a5 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll 1fdcace1-b545-4ec8-ba2a-dbc3c6caea37 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Shared.v13.1.dll 854675c1-d6df-44f6-922e-88815ba67f4c Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll a64c8db9-30d8-494a-a21b-df759643761f Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll f5cb6570-4fd9-452b-85ca-8b975ef2e26c Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll 627d42f2-b865-4f9c-901e-51fbd449a256 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 0daa39f5-9ac1-406d-ab08-b54555273827 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Jiwa\Jiwa 7\ServiceStack.dll 04b531bd-4608-4232-94a8-344c07a5406a System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll d981986c-3d81-418a-8e23-135a21fc59f2 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Jiwa\Jiwa 7\JiwaEncryption.dll 37d2b42b-4777-479a-abc4-747dfa0429aa Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll d3b577e3-3926-44e9-a71b-d5b7a734f6af Microsoft.SqlServer.Dac, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Dac.dll ef9a1f20-fac6-4747-a962-901067690030 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll ce0292ea-f4ee-42f8-b95d-00acc79242e1 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Jiwa\Jiwa 7\JiwaLib.dll dbd44d56-135c-4579-be45-722741b60473 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Jiwa\Jiwa 7\Microsoft.ApplicationInsights.dll ce2ebbfe-39a6-4cdb-b369-48d0195ae5de ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Jiwa\Jiwa 7\ServiceStack.Text.dll 8b841c97-1033-492e-b275-fd0bf34701aa System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 7c7e2114-4dbc-4e49-835f-b59d03f6e76b FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Jiwa\Jiwa 7\FarPoint.Win.dll 9635c19e-26d8-47d9-9077-a2e937fe87e8 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Jiwa\Jiwa 7\ServiceStack.Interfaces.dll 449b6406-253d-4dda-9414-9dff4406869d ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Jiwa\Jiwa 7\ServiceStack.Server.dll e99bc07b-c53e-4041-8774-94e0f4b595fc ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Jiwa\Jiwa 7\ServiceStack.OrmLite.dll 0f8d7320-7409-44dc-bf04-8fc79fb2348d JiwaCashBook, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBook.dll C:\Jiwa\Jiwa 7\JiwaCashBook.dll 2f61001c-b7b7-4e01-9650-78bbd200e959 JiwaCashBookUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBookUI.dll C:\Jiwa\Jiwa 7\JiwaCashBookUI.dll 38775804-35aa-4706-81f9-4909ac66ce3c JiwaDebtors, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtors.dll C:\Jiwa\Jiwa 7\JiwaDebtors.dll fcd8ed82-c612-49b4-8d8c-9330ecaaa347 JiwaDebtorsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorsUI.dll C:\Jiwa\Jiwa 7\JiwaDebtorsUI.dll 0870f7bf-0af4-4943-a677-c80a12dc9001 JiwaBankDetails, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBankDetails.dll C:\Jiwa\Jiwa 7\JiwaBankDetails.dll 642b856e-034c-4daf-9a11-0612eee91c03 JiwaBankDetailsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBankDetailsUI.dll C:\Jiwa\Jiwa 7\JiwaBankDetailsUI.dll e58f6cbb-b5eb-494a-b168-89fdcb269ef7 DirectDebitBatchDate Date to process D/D batch 1 Date Cash Book 0aeb9395-a50d-47c7-8cae-2c647915d922 DirectDebitGeneratedBy User who generated batch 2 Text Cash Book 9857278a-64a2-40dc-b516-222fa38186bb DirectDebitGeneratedDate Date batch was generated 3 Date Cash Book a52a10dd-675c-4551-9ebf-70e5f1056465 DirectDebitExportedDate Date batch was exported 4 Date Cash Book f6c0e08a-a865-42dd-81aa-30dbf0fd4ea3 DirectDebitExportedBy User who exported batch 5 Text Cash Book e32fbb9d-e075-4089-8a70-a28983583125 DirectDebitFileName Name of exported Direct Debit file 6 Text Cash Book 0829e0a5faaa474297d4 DirectDebitDefaultFolder Default folder for Direct Debit upload files 1 Text C:\TEMP\BNZ C:\TEMP\BNZ c2171bbd28eb48b8b7dc DirectDebitMaximumBatchSize Maximum number of direct debits in a single batch 2 Integer 100 100 a09ab6b3c17447079d77 DirectDebitMinimumDays Minimum age (in days) for a transaction to be included in a batch 3 Integer 10 10 65a3be7d4af4443cb184 DirectDebitMaximumDays Maximum age (in days) for a transaction to be included in a batch 4 Integer 180 180 9962527bdc3946a4ba93 DirectDebitOtherPartyParticulars Text for Other Party Particulars. Limit of 12 characters 5 Text Payer Name Payer Name aca8a7423d044a16ad5c DirectDebitBulkImportFlag Flag for level of detail in bank statements. See iB4B documentation. Default is blank. 6 Text 428b2e5f-23a0-4d52-9535-3bdb2bfbc043 2023-05-28T02:08:52.59 1 c5c35bf7-52f4-4461-8ef8-7474a44e63c4 2023-05-28T02:08:52.59 2 b2b99db9-671e-4796-a8ec-247d7726523f 2023-05-28T02:08:52.593 3 d463741d-973c-4212-bf12-7258c1e18028 2023-05-28T02:08:52.593 4 a350a484-0e85-4c1b-b1eb-4ef30871b101 2023-05-28T02:08:52.593 5