For reasons that I am not going to go in to, oh wait, yeah I am 🙂 we needed to do some basic validation against back account details (CRS692/E) added in to M3.

We store our supplier bank account numbers in M3 and when a payment proposal is generated, we will extract the proposal with an in-house written application which will output a text file that can be submitted to our bank.

The problem we have is that a user can make a mistake and not key in the correct number of values for the bank account and we’d end up in the situation where we can’t change the payment proposal and we can’t submit our batch file, the good part is that as long as we have the correct number of characters for a bank account, then even it is wrong we can submit it to the bank and THEN it will reject it. This means that the batch file has to be manually keyed in to our banking software – not fun and somewhat error prone.

So to protect our staff from themselves and unspeakable horrors of rekeying batches a script was born.

The script is very primitive, it will count the number of characters for each of the bank account fields and if they don’t match it will change the background colour of the textbox to orange (and green for those textboxes that have the correct number of characters), then it will cancel the users save attempt.

Anyways, enough with the chitchat…

import System;
import System.Windows;
import System.Windows.Controls;
import MForms;

package MForms.JScript
{
	class ValidateBankDetails_000
	{
		var giicInstanceController : IInstanceController = null;    // this is where we will store the IInstanceController to make it available to the rest of the class
		var ggrdContentGrid : Grid = null;                          // this is the Grid that we get passed by the Init()

		public function Init(element: Object, args: Object, controller : Object, debug : Object)
		{
			giicInstanceController = controller;
			ggrdContentGrid = controller.RenderEngine.Content;
			

			giicInstanceController.add_Requesting(OnRequesting);
		}
		
		
		public function OnRequesting(sender: Object, e: CancelRequestEventArgs)
		{
			try
			{
				if(e.CommandType == MNEProtocol.CommandTypeKey)     // we're looking for a key event
				{
					if(e.CommandValue == MNEProtocol.KeyEnter)      // specifically we're looking the enter key event
					{
						if(true == giicInstanceController.RenderEngine.PanelHeader.EndsWith("CRS692/E"))   // are we on panel E?
						{
							if(false == validBankAccount())         // is the bank account valid?
							{
								e.Cancel = true;                    // it wasn't valid so cancel the request
							}
						}
					}
					else if( (e.CommandValue == MNEProtocol.KeyF3) || (e.CommandValue == MNEProtocol.KeyF03))
					{
						giicInstanceController.remove_Requesting(OnRequesting);
					}
				}
			}
			catch(ex)
			{
			    MessageBox.Show(ex.message);
			}
		}
		
        // this is the heart of the class
        // we will turn the background textbox to green
        // if we have a semi-valid account
        // If we know that we don't have the correct number
        // of characters then we set the background to orange
        // and we cancel the saving of the information
		public function validBankAccount()
		{
			var bResult : boolean = false;
			try
			{
				var bError : boolean = false;       // this is where we keep track of if there is an error
				
				var bBankOK : boolean = false;
				var bBranchOK : boolean = false;
				var bAccountOK : boolean = false;
				var bSuffixOK : boolean = false;
				
                // our bank accounts are set up with 4 compontents
				var tbBank : TextBox = ScriptUtil.FindChild(ggrdContentGrid, "W1BF02");
				var tbBranch : TextBox = ScriptUtil.FindChild(ggrdContentGrid, "W2BF04");
				var tbAccount : TextBox = ScriptUtil.FindChild(ggrdContentGrid, "W3BF07");
				var tbSuffix : TextBox = ScriptUtil.FindChild(ggrdContentGrid, "W4BF03");
				
				var strError : String = null;
				
                // in our world, our bank is two characters
				if(false == String.IsNullOrEmpty(tbBank.Text))
				{
					if(tbBank.Text.Length != 2)
					{
						strError = "Bank is incorrect";
						tbBank.Background = System.Windows.Media.Brushes.Orange;
						bError = true;
					}
					else
					{
						bBankOK = true;
					}
				}
				else bBankOK = true;
				
				if(true == bBankOK)
				{
					tbBank.Background = System.Windows.Media.Brushes.LightGreen;
				}
				
                // 4 characters for the branch
				if(false == String.IsNullOrEmpty(tbBranch.Text))
				{
					if(tbBranch.Text.Length != 4)
					{
						tbBranch.Background = System.Windows.Media.Brushes.Orange;
						bError = true;
					}
					else
					{
						bBranchOK = true;
					}
				}
				else bBranchOK = true;
				
				if(true == bBranchOK)
				{
					tbBranch.Background = System.Windows.Media.Brushes.LightGreen;
				}
				
                // 7 characters for the account
				if(false == String.IsNullOrEmpty(tbAccount.Text))
				{
					if(tbAccount.Text.Length != 7)
					{
						tbAccount.Background = System.Windows.Media.Brushes.Orange;
						bError = true;
					}
					else bAccountOK = true;
				}
				else bAccountOK = true;
				
				if(true == bAccountOK)
				{
					tbAccount.Background = System.Windows.Media.Brushes.LightGreen;
				}
				
                // three characters for the suffix
				if(false == String.IsNullOrEmpty(tbSuffix.Text))
				{
					if(tbSuffix.Text.Length != 3)
					{
						tbSuffix.Background = System.Windows.Media.Brushes.Orange;
						bError = true;
					}
					else bSuffixOK = true;
				}
				else bSuffixOK = true;
				
				if(true == bSuffixOK)
				{
					tbSuffix.Background = System.Windows.Media.Brushes.LightGreen;
				}
				
				if( (false == bSuffixOK) && (false == bAccountOK) && (false == bBranchOK) && (false == bBankOK) )
				{
				}
				else bResult = true;

			}
			catch(ex)
			{
				MessageBox.Show("Error validating the bank account");
			}
			if(true == bError)
			{
                // cancel the save
				bResult = false;
				MessageBox.Show("Sorry, but you haven't entered the account number correctly");
			}
			return(bResult);
		}
	}
}