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 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 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 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 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 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 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 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 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;
}
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;
}
