protected override string GenerateBankFileHeader()
{
string[] bankFileHeader = new string[11];
bankFileHeader[0] = "H";
bankFileHeader[1] = m_ClientCode.PadRight(10).Substring(0, 10);
bankFileHeader[2] = m_MyProductCode.PadRight(10).Substring(0, 10);
bankFileHeader[3] = string.Empty.PadRight(1);
bankFileHeader[4] = m_PaymentProduct.PadRight(10);
bankFileHeader[5] = AccountNo.PadRight(20).Substring(0, 20);
bankFileHeader[6] = ValueDate.ToString("ddMMyyyy");
bankFileHeader[7] = "ACH".PadRight(20).Substring(0, 20);
bankFileHeader[8] = string.Empty.PadLeft(40, ' ');
bankFileHeader[9] = string.Empty.PadLeft(20, ' ');
bankFileHeader[10] = string.Empty.PadLeft(2085, ' ');
string bankFileHeaderData = string.Join(FIELD_DELIMITER, bankFileHeader);
if (bankFileHeaderData.Length != 2225)
{
throw (new Exception("Incorrect Header Length:" + bankFileHeaderData.Length));
}
return(bankFileHeaderData);
}
// Return a string suitable for writing the customer information to the customers.txt
// file.
public string ToFileString()
{
// Round the charge amount to two decimal places, but do not include a "$" in
// the text file.
return(AccountNo.ToString() + "," + CustomerName + "," + CustomerType + ","
+ ChargeAmount.ToString("0.##"));
}
public override int GetHashCode()
{
unchecked
{
int result = (AccountNo != null ? AccountNo.GetHashCode() : 0);
result = (result * 397) ^ (ClientId != null ? ClientId.GetHashCode() : 0);
result = (result * 397) ^ Balance.GetHashCode();
result = (result * 397) ^ LastUpdatedDate.GetHashCode();
return(result);
}
}
public BankAccountEdit()
{
InitializeComponent();
Bank = new BankAccount();
Cust = new Customer();
AccountNo.Enabled = true;
Interest.Enabled = true;
OpenDate.Enabled = true;
Info.Text = "Enter Account #. then any fields may be changed";
AccountNo.Focus();
}
public Account GetAccount(AccountNo accountNo)
{
try
{
return _repository.Single(x => x.AccountNo == accountNo);
}
catch (InvalidOperationException)
{
return null;
}
}
//*************************************************************************************************************//
public CustomerEdit( )
//*************************************************************************************************************//
{
InitializeComponent( );
Cust = new Customer( );
Bank = new BankAccount( );
act1.ReadOnly = false;
act2.ReadOnly = false;
act3.ReadOnly = false;
act4.ReadOnly = false;
AccountNo.Focus( );
}
protected override string GenerateBankFileDetail(GenericBankFileDetail bankFileDetail)
{
EBankList banklist = new EBankList();
banklist.BankCode = bankFileDetail.BankCode;
if (EBankList.db.select(dbConn, banklist))
{
BankName = banklist.BankName;
}
string[] bankFileDetailRecord = new string[45];
bankFileDetailRecord[0] = "TRN";
bankFileDetailRecord[1] = "PAYROL"; // PAYROL - Hong Kong Payroll ACH Payment (AUTOPAY)
//bankFileDetailRecord[2] = "omit";.Substring(0, 3)
bankFileDetailRecord[4] = "6055"; // 6055 - BOA Hong Kong, HK
bankFileDetailRecord[5] = AccountNo.PadRight(31).Substring(0, 31).TrimEnd();
//bankFileDetailRecord[6] = "";//bankFileDetail.BranchCode;//.Substring(0, 9);
bankFileDetailRecord[7] = "HKD";
bankFileDetailRecord[8] = "PAY"; // PAY - Payment
bankFileDetailRecord[9] = "D"; // D - Payment Only
//bankFileDetailRecord[10] = FIELD_POSTINGINDICATOR;//.Substring(0, 1);
//bankFileDetailRecord[11] = "";//.Substring(0, 16);
//bankFileDetailRecord[12] = FIELD_PRIORITYINDICATOR;//.Substring(0, 1);
bankFileDetailRecord[13] = AppUtils.ServerDateTime().ToString("MMddHHmmss") + TransactionID.ToString("000000");
//bankFileDetailRecord[14] = "";//.Substring(0, 2);
bankFileDetailRecord[15] = AccountHolderName.ToUpper().PadRight(35).Substring(0, 35).Trim();
//bankFileDetailRecord[16] = "";.Substring(0, 15);
bankFileDetailRecord[17] = PostalAddress1.PadRight(35).Substring(0, 35).Trim();
bankFileDetailRecord[18] = PostalAddress2.PadRight(35).Substring(0, 35).Trim();
bankFileDetailRecord[19] = PostalCityName.PadRight(30).Substring(0, 30).Trim();
bankFileDetailRecord[22] = "HK";
bankFileDetailRecord[23] = bankFileDetail.EmpName.ToUpper().PadRight(70).Substring(0, 70).Trim();
//bankFileDetailRecord[25] = "ADDRESS LINE 1"+" " ";
//bankFileDetailRecord[27] = "HONG KONG";
bankFileDetailRecord[30] = "HK";
bankFileDetailRecord[31] = bankFileDetail.ValueDate.ToString("yyyyMMdd");
bankFileDetailRecord[33] = "HKD";
bankFileDetailRecord[34] = bankFileDetail.Amount.ToString("0.00");
bankFileDetailRecord[37] = BankName.ToUpper().PadRight(33).Substring(0, 33).Trim();
bankFileDetailRecord[39] = bankFileDetail.BankCode.PadRight(3).Substring(0, 3) + bankFileDetail.BranchCode.PadRight(3).Substring(0, 3);
bankFileDetailRecord[41] = bankFileDetail.AccountNo.PadRight(9).Substring(0, 9).Trim();
bankFileDetailRecord[43] = "HONG KONG";
bankFileDetailRecord[44] = "HK";
string bankFileDetailData = "\"" + String.Join(FIELD_DELIMITER, bankFileDetailRecord) + "\"";
bankFileDetailData = bankFileDetailData.Replace("\"\"", string.Empty);
//if (bankFileDetailData.Length > 715)
// throw (new Exception("Incorrect Detail Length of Payment for " + bankFileDetail.EmpBankAccountHolderName + ":" + bankFileDetailData.Length));
return(bankFileDetailData);
}
public void edit_account(string acc_no)
{
try
{
EditAccountLink.Click();
AccountNo.SendKeys(acc_no);
Submit.Click();
}
catch (Exception e)
{
Console.WriteLine(e);
TakeScreenshot.takeScreenshotAs(driver, "edit_account");
}
}
/// <summary>
/// Deletes a user account via accountNo. An exception is thrown is account no is not found
/// </summary>
/// <param name="accountNo">AccountNo of the account to delete</param>
public void DeleteAccount(AccountNo accountNo)
{
if (accountNo == null)
{
throw new ArgumentNullException();
}
IAccount account = _accountRepository.GetAccount(accountNo);
if (account == null)
{
throw new InvalidOperationException("Account not found");
}
// First we close the account and perform any validation/cleanup
account.CloseAccount();
_accountRepository.Delete(accountNo);
}
protected override string GenerateBankFileHeader()
{
string[] bankFileHeader = new string[5];
bankFileHeader[0] = m_BatchID.PadRight(5).Substring(0, 5).Trim();
bankFileHeader[1] = ((int)m_TransactionType).ToString("00");
string companyAccountNo = BankCode.PadRight(3).Substring(0, 3) + "-" + BranchCode.PadRight(3).Substring(0, 3) + "-" + AccountNo.PadRight(9).Substring(0, 9).Trim();
bankFileHeader[2] = companyAccountNo;
bankFileHeader[3] = AccountHolderName.PadRight(20).Substring(0, 20);
bankFileHeader[4] = m_BatchName;
string bankFileHeaderData = "\"" + string.Join(FIELD_DELIMITER, bankFileHeader) + "\"";
//if (bankFileHeaderDetail.Length != 83)
// throw new Exception("Incorrect Bank File Header Length:\r\n" + bankFileHeaderDetail);
return(bankFileHeaderData);
}
//*************************************************************************************************************************************************//
// Find the customer record
private void findbank_Click_1(object sender, EventArgs e)
//*************************************************************************************************************************************************//
{
accno = AccountNo.Text;
if (accno == "")
{
MessageBox.Show("You MUST enter a valid Bank Account number. They start at 1050000", "A/C number entry Error");
// lots of work to prefill # and put cursor at end of it with text
// unselected. so user can just start typing numbers
AccountNo.Text = "123";
AccountNo.Focus();
AccountNo.SelectionLength = 0;
AccountNo.SelectionStart = AccountNo.Text.Length;
return;
}
if (Convert.ToInt32(accno) < 1050000)
{
MessageBox.Show("Invalid Entry - The Bank Account numbers start at 105000.", "File number entry Error");
return;
}
// housekeeping
allbankaccounts.Items.Clear();
// Now get the bank account for this customer
//Now we know the "main" Bank Account # anyway to read details of
try
{
Bank = Search.FindBankObjectfromBankNo(accno);
if (Bank == null)
{
MessageBox.Show("There was a problem finding the BankAccount # " + accno + " you entered...\n Please try again ! ", "File Access problem"); return;
}
}
catch
{
MessageBox.Show("There was a problem finding the BankAccount file " + accno, "File Access problem");
return;
}
Custno.Text = Bank.CustAccountNumber.ToString();
AccountBalance.Text = Bank.Balance.ToString();
Interest.Text = Bank.InterestRate.ToString();
OpenDate.Text = Bank.DateOpened.ToShortDateString();
if (Bank.Status == 0)
{
status.Text = "**Closed**";
}
else if (Bank.Status == 1)
{
status.Text = "Active";
}
else if (Bank.Status == 2)
{
status.Text = "Suspended";
}
try
{
Cust = Customer.GetCustomerAccount(Bank.CustAccountNumber.ToString());
if (Cust == null)
{
MessageBox.Show("Unable to find the Customer Record from LinkedList", "Database system ERROR");
button1_Click_1(sender, e); // Clear the data form the screen
return;
}
}
catch
{
new Exception(" Unable to load Customer account in bankaccountedit.cs, Line 55");
}
int typevalue = 0;
for (int i = 0; i < 4; i++)
{
if (Cust.accountnums[i] > 0)
{
typevalue = Cust.accounttypes[i];
string output = Cust.accountnums[i].ToString() + "\t" + typevalue.ToString();
allbankaccounts.Items.Add(output);
}
}
/* if ( Cust . accountnums [ i ] . ToString ( ) == AccountNo . Text )
* {
* // got the matching account
* // load thre combo of bank accounts
* if ( Cust . accountnums [i ] > 0 )
* {
* typevalue = Cust . accounttypes [ i ];
* string output = Cust . accountnums [ 0 ] . ToString ( ) + "\t" + typevalue . ToString ( );
* allbankaccounts . Items . Add ( output );
* }
* /*
* if ( Cust . accountnums [ 1 ] > 0 )
* {
* typevalue = Cust . accounttypes [ 1 ];
* string output = Cust . accountnums [ 1 ] . ToString ( ) + "\t" + typevalue . ToString ( );
* allbankaccounts . Items . Add ( output );
* }
* if ( Cust . accountnums [ 2 ] > 0 )
* {
* typevalue = Cust . accounttypes [ 2 ];
* string output = Cust . accountnums [ 2 ] . ToString ( ) + "\t" + typevalue . ToString ( );
* allbankaccounts . Items . Add ( output );
* }
* if ( Cust . accountnums [ 3 ] > 0 )
* {
* typevalue = Cust . accounttypes [ 3 ];
* string output = Cust . accountnums [ 3 ] . ToString ( ) + "\t" + typevalue . ToString ( );
* allbankaccounts . Items . Add ( output );
* }
*
* }
*/
AccountType.SelectedIndex = typevalue - 1;
allbankaccounts.SelectedItem = 1;
allbankaccounts.SelectedIndex = 0;// Text = allbankaccounts. SelectedItem. ToString ( );
SaveBankButton.Enabled = true;
button1.Enabled = true;
Exit.Enabled = true;
// fill out ALL the fields
// Customer first
fname.Text = Cust.FirstName;
lname.Text = Cust.LastName;
day.Text = Cust.DOB.Day.ToString();
month.Text = Cust.DOB.Month.ToString();
year.Text = Cust.DOB.Year.ToString();
day.Text = Cust.DOB.Day.ToString();
month.Text = Cust.DOB.Month.ToString();
year.Text = Cust.DOB.Year.ToString();
fname.Text = Cust.FirstName;
lname.Text = Cust.LastName;
addr1.Text = Cust.Address1;
addr2.Text = Cust.Address2;
town.Text = Cust.Town;
county.Text = Cust.County;
postcode.Text = Cust.PostCode;
phone.Text = Cust.PhoneNumber;
mobile.Text = Cust.MobileNumber;
/* // Bank account fields //
* internal Int32 BankAccountNumber = 0; // Secondary key
* internal Int32 CustAccountNumber = 0; // major key
* internal Int16 AccountType = 0; // minor key
* internal decimal Balance = 0.00;
* internal DateTime DateOpened;
* internal DateTime DateClosed;// We do not fill this out.
* internal decimal InterestRate = 3.75; // Default value only
* internal Int16 Status = 1; // Status can be 0-Closed, 1- Active, 2-Suspended
*/
}
/// <summary>
/// Gets an Account for a given user and account No.
/// </summary>
/// <param name="accountNo">Account No of the account</param>
/// <returns>IAccount object or null if account is not found</returns>
public IAccount GetAccount(AccountNo accountNo)
{
try
{
return _accountRepository.GetAccount(accountNo);
}
catch
{
return null;
}
}
/// <summary>
/// Withdraws funds from an account using a known account number
/// </summary>
/// <param name="accountNo">Number of the account from which the funds will be withdrawn</param>
/// <param name="amount">Amount to withdraw</param>
/// <returns>Current balance after withdrawal</returns>
public Money WithdrawFunds(AccountNo accountNo, Money amount)
{
if (accountNo == null || amount == null)
{
throw new ArgumentNullException();
}
Account account = _accountRepository.GetAccount(accountNo);
account.WithdrawFunds(amount);
_accountRepository.Update(account);
return account.Balance;
}
public void check_Reset(string acc_no)
{
EditAccountLink.Click();
AccountNo.SendKeys(acc_no);
Reset.Click();
}
public override String ToString()
{
return(AccountNo.ToString());
}
public override string ToString()
{
return(AccountNo.ToString() + " - " + LastName + ", " + FirstName);
}
public override string ActualBankFileName()
{
return(BranchCode.PadRight(3).Substring(0, 3) + AccountNo.PadRight(5).Substring(0, 5) + BankFileExtension());
}
public void Delete(AccountNo accountNo)
{
Account account = _repository.Single(x => x.AccountNo == accountNo);
_repository.Delete(account);
}
// Return a string suitable for displaying the customer information to the screen.
public override string ToString()
{
// The charge amount can be displayed to the screen using the currency format.
return(AccountNo.ToString() + "\t" + CustomerName + "\t" + CustomerType + "\t"
+ ChargeAmount.ToString("c"));
}
private string Validate(string propertyName)
{
// Return error message if there is error on else return empty or null string
string validationMessage = string.Empty;
if (_firstLoad)
{
return(validationMessage);
}
switch (propertyName)
{
case "Details": // property name
if (string.IsNullOrWhiteSpace(Details))
{
validationMessage = "No Details Available";
}
break;
case "Name": // property name
if (string.IsNullOrWhiteSpace(Name))
{
validationMessage = "No Details Available";
}
break;
case "MemberFather": // property name
if (string.IsNullOrWhiteSpace(Name))
{
validationMessage = "No Details Available";
}
break;
case "MemberMother": // property name
if (string.IsNullOrWhiteSpace(Name))
{
validationMessage = "No Details Available";
}
break;
case "AccountNo":
if (!int.TryParse(AccountNo.ToString(), out uselessParseInt))
{
validationMessage = "Only Digits Are Allowed";
}
break;
case "Deposit":
if (!double.TryParse(Deposit.ToString(), out uselessParse))
{
validationMessage = "Only Digits Are Allowed";
}
break;
case "Withdraw":
if (!double.TryParse(Withdraw.ToString(), out uselessParse))
{
validationMessage = "Only Digits Are Allowed";
}
break;
}
return(validationMessage);
}
public string ToFileString()
{
return(AccountNo.ToString() + "/" + CustomerName + "/" + CustomerType.ToString() + "/" + ChargeAmount.ToString());
}
}//public void ButtonReset_Click()
/// <summary>ButtonOpen_Click().</summary>
public void ButtonOpen_Click
(
Object sender,
EventArgs e
)
{
StringBuilder sb = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbDataReader oleDbDataReader = null;
string medicalRecordPatientNo = null;
string accountNo = null;
bool databaseSelect = false;
try
{
medicalRecordPatientNo = MedicalRecordPatientNo.Trim();
accountNo = AccountNo.Trim();
if
(
medicalRecordPatientNo == string.Empty || medicalRecordPatientNo == null ||
accountNo == string.Empty || accountNo == null
)
{
Feedback = "Required columns Medical record patient No and Account No";
return;
}
sb = new StringBuilder();
sb.AppendFormat
(
CoreDataRecordSelect,
medicalRecordPatientNo,
accountNo
);
oleDbConnection = new OleDbConnection
(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
serverMapPath + @"\" + AccessDatabaseFileName +
";Persist Security Info=False"
);
oleDbConnection.Open();
oleDbCommand = new OleDbCommand( sb.ToString(), oleDbConnection);
oleDbDataReader = oleDbCommand.ExecuteReader();
databaseSelect = false;
while(oleDbDataReader.Read())
{
MedicalRecordPatientNo = oleDbDataReader.GetString(0);
AccountNo = oleDbDataReader.GetString(1);
AltMRN = oleDbDataReader.GetString(2);
NameLast = oleDbDataReader.GetString(3);
NameFirst = oleDbDataReader.GetString(4);
/*
UtilityDebug.Write(string.Format("medicalRecordPatientNo: {0}", medicalRecordPatientNo));
UtilityDebug.Write(string.Format("account: {0}", accountNo));
*/
databaseSelect = true;
}
//close the reader
oleDbDataReader.Close();
if ( databaseSelect == false )
{
Feedback = "Record Not Found";
UtilityDebug.Write("Record Not Found");
}
}
catch ( Exception exception )
{
UtilityDebug.Write(string.Format("Exception: {0}", exception.Message));
}//catch
finally
{
if (oleDbConnection.State == System.Data.ConnectionState.Open)
{
oleDbConnection.Close();
}//if (oleDbConnection.State == System.Data.ConnectionState.Open)
}//finally
}//public void ButtonOpen_Click()
protected override string GenerateBankFileFooter()
{
string[] bankFileFooter = new string[7];
bankFileFooter[0] = "CI";
bankFileFooter[1] = BankCode.PadRight(3).Substring(0, 3) + BranchCode.PadRight(3).Substring(0, 3) + AccountNo.PadRight(8).Substring(0, 8);
bankFileFooter[2] = this.AccountHolderName.ToUpper().PadRight(50).Substring(0, 50);
if (FileType == FileTypeEnum.Autopay)
{
bankFileFooter[3] = "CR";
bankFileFooter[4] = ValueDate.ToString("yyyyMMdd");
bankFileFooter[5] = RecordCount.ToString("00000");
bankFileFooter[6] = TotalAmount.ToString("0.00").PadLeft(12);
string bankFileFooterData = string.Join(FIELD_DELIMITER, bankFileFooter);
if (bankFileFooterData.Length != 93)
{
throw (new Exception("Incorrect Detail Length of Payment for Footer"));
}
return(bankFileFooterData);
}
else
{
bankFileFooter[3] = ValueDate.ToString("yyyyMMdd");
bankFileFooter[4] = RecordCount.ToString("00000");
bankFileFooter[5] = TotalAmount.ToString("0.00").PadLeft(12);
bankFileFooter[6] = string.Empty.PadLeft(7);
string bankFileFooterData = string.Join(FIELD_DELIMITER, bankFileFooter);
if (bankFileFooterData.Length != 98)
{
throw (new Exception("Incorrect Detail Length of Payment for Footer"));
}
return(bankFileFooterData);
}
}
public override string ToString() // overrides system method for CustormerDB->savecustomers()
{
return(AccountNo.ToString() + "," + CustomerName + "," + CustomerType + "," + ChargeAmount.ToString());
}
