//method to transer fund public TransferFunds GetCreditingAccountBalance(int accountNumber) { TransferFunds transferFunds = new TransferFunds(); SqlCommand cmd = new SqlCommand("SELECT * from Accounts WHERE AccountNumber = @an", OpenCon()); cmd.Parameters.AddWithValue("@an", accountNumber.ToString()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { transferFunds.Balance = decimal.Parse(dr["InitialBalance"].ToString()); } CloseCon(); return(transferFunds); }
//method to get account dettail to transfer fund public TransferFunds GetAccountDetails(int accountId) { TransferFunds trans = new TransferFunds(); SqlCommand cmd = new SqlCommand("SELECT * from Accounts WHERE AccountId = @id", OpenCon()); cmd.Parameters.AddWithValue("@id", accountId); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { trans.AccountNumber = int.Parse(dr["AccountNumber"].ToString()); trans.Balance = decimal.Parse(dr["InitialBalance"].ToString()); trans.Overdraft = decimal.Parse(dr["Overdraft"].ToString()); } CloseCon(); return(trans); }