public void updateRequestHandler(String[] parameters) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.updateUserDetails(parameters); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public ResultSet getRequestHandler(String User) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { return (ResultSet) sql.authRequest(User); } catch (Exception e) { e.printStackTrace(); } return null; }
public void deleteTransaction(String[] rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.deleteTransactions(rID); } catch (Exception e) { e.printStackTrace(); } }
public ResultSet getTransactionHandler(String status, int critical, String payment) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { return (ResultSet) sql.authTransaction(status, critical, payment); } catch (Exception e) { e.printStackTrace(); } return null; }
public void updateTransactions(String rStatus, String[] rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.updateTransactionData(rStatus, rID); } catch (Exception e) { e.printStackTrace(); } }
public ResultSet getModDelHandler(String modifyStatus, String payment, int critical) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { return (ResultSet) sql.modifyDeleteTransaction(modifyStatus, payment, critical); } catch (Exception e) { e.printStackTrace(); } return null; }
public void declineRequestHandler(String newvalue, String columnname, String user) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.declineRequestDatabase(newvalue, columnname, user); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public void modifyTransaction(String[] rID, String status) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.modifyTransactions(rID, status); } catch (Exception e) { e.printStackTrace(); } }
public void rejectTransaction(String rStatus, double balance, String[] rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.rejectTransactions(rStatus, balance, rID); } catch (Exception e) { e.printStackTrace(); } }
public void requestModifyHandler( String user, String parameter, String parametertype, String usertype) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.insertintoRequestDatabase(user, parameter, parametertype, usertype); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public Double getSourceBalance(String accountNumber) { double result = 0.0; try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { result = sql.getBalanceSourceAccount(accountNumber); } catch (Exception e) { e.printStackTrace(); } return result; }
public Boolean checkAccountNumber(String accountNumber) { Boolean result = true; try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { result = sql.checkValidAccount(accountNumber); } catch (Exception e) { e.printStackTrace(); } return result; }
public Boolean checkSameSource(String[] rID) { boolean result = false; try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { result = sql.checkSameSourceAccountNumber(rID); } catch (Exception e) { e.printStackTrace(); } return result; }
public ResultSet checkRequestStatus(String rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { return (ResultSet) sql.checkStatus(rID); } catch (Exception e) { e.printStackTrace(); } return null; }
public Double getBalance(String[] rID) { double result = 0.0; try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { result = sql.getBalanceAmount(rID); } catch (Exception e) { e.printStackTrace(); } return result; }
public void approveModifySourceTransaction( Double newAmount, String rStatus, double balance, String[] rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.approveModifySourceTransactions(newAmount, rStatus, balance, rID); } catch (Exception e) { e.printStackTrace(); } }
public void deleteRequestHandler(String userName, String accountnumber) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.deleteUserDetails(userName, accountnumber); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public ArrayList<String> checkStatusOfId(String[] rID) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } ArrayList<String> status = new ArrayList<String>(); try { status = sql.checkStatus(rID); } catch (Exception e) { e.printStackTrace(); } return status; }
public String getSourceAccount(String rID) { String result = ""; try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { result = sql.getSourceAccountNumber(rID); } catch (Exception e) { e.printStackTrace(); } return result; }
public Object updateaccountrequest(String username, String manager, String Accountnumber) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.insertAccountChangeRequest(username, manager, Accountnumber); sql.close(); } catch (Exception e) { e.printStackTrace(); } return null; }
public void updateCountHandler(int count, String Username) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.updatecountDatabase(count, Username); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public void setloggedin(String Username) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { sql.setisloggeddb(Username); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
public Object requestManagers() { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { Object obj = null; obj = (Object) sql.readSystemManagers(); sql.close(); return obj; } catch (Exception e) { e.printStackTrace(); } return null; }
public ResultSet requestCountHandler() { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { ResultSet obj = null; obj = (ResultSet) sql.countRequestDatabase(); sql.close(); return obj; } catch (Exception e) { e.printStackTrace(); } return null; }
public Object viewRequestHandler(String Manager) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { Object obj = null; obj = sql.viewRequestDatabase(Manager); sql.close(); return obj; } catch (Exception e) { e.printStackTrace(); } return null; }
public Object requestHandler(String userName, String parameterType) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { Object obj = null; obj = (Object) sql.readModifyUser(userName, parameterType); sql.close(); return obj; } catch (Exception e) { e.printStackTrace(); } return null; }
public Object getaccounttypeHandler(String username, String accountnumber) { try { sql.getConnection(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { Object obj = null; obj = sql.readAccountType(username, accountnumber); sql.close(); return obj; } catch (Exception e) { e.printStackTrace(); } return null; }