/// <summary> /// Gets the IdentityBank given the bank Id /// </summary> /// <param name="bankId"></param> /// <returns></returns> public IdentityAccountNumber GetAccount(string accountNumber) { var accountdetail = GetAccountDetail(accountNumber); IdentityAccountNumber account = null; if (accountdetail != null) { account = new IdentityAccountNumber(accountdetail["Id"], accountNumber, accountdetail["AccountName"], accountdetail["AccountBranch"]); } return(account); }
/// <summary> /// Inserts a new Account Number in the accountnumbers table /// </summary> /// <param name="AccountNumber">The account's detail</param> /// <returns></returns> public int Insert(IdentityAccountNumber accountno) { string commandText = "Insert into accountnumbers (Id, AccountNumber, AccountName, AccountBranch) values (@id, @accountNumber, @accountname, @accountbranch)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", accountno.Id); parameters.Add("@accountNumber", accountno.AccountNumber); parameters.Add("@accountName", accountno.AccountName); parameters.Add("@accountbranch", accountno.AccountBranch); return(_database.Execute(commandText, parameters)); }