@Override
 public String getpages() throws Exception {
   if (this.checkpermission("getpages")) {
     int intRegsPerPag = ParameterCook.prepareRpp(oRequest);
     ArrayList<FilterBeanHelper> alFilter = ParameterCook.prepareFilter(oRequest);
     String data = null;
     Connection oConnection = null;
     ConnectionInterface oDataConnectionSource = null;
     try {
       oDataConnectionSource = getSourceConnection();
       oConnection = oDataConnectionSource.newConnection();
       EstadoDao oEstadoDao = new EstadoDao(oConnection);
       data =
           JsonMessage.getJson(
               "200", Integer.toString(oEstadoDao.getPages(intRegsPerPag, alFilter)));
     } catch (Exception ex) {
       ExceptionBooster.boost(
           new Exception(this.getClass().getName() + ":getPages ERROR: " + ex.getMessage()));
     } finally {
       if (oConnection != null) {
         oConnection.close();
       }
       if (oDataConnectionSource != null) {
         oDataConnectionSource.disposeConnection();
       }
     }
     return data;
   } else {
     return JsonMessage.getJsonMsg("401", "Unauthorized");
   }
 }