@Override
public String get() throws Exception {
if (this.checkpermission("get")) {
int id = ParameterCook.prepareId(oRequest);
String data = null;
Connection oConnection = null;
ConnectionInterface oDataConnectionSource = null;
try {
oDataConnectionSource = getSourceConnection();
oConnection = oDataConnectionSource.newConnection();
EstadoDao oEstadoDao = new EstadoDao(oConnection);
EstadoBean oEstadoBean = new EstadoBean(id);
oEstadoBean = oEstadoDao.get(oEstadoBean, AppConfigurationHelper.getJsonDepth());
Gson gson = AppConfigurationHelper.getGson();
data = JsonMessage.getJson("200", AppConfigurationHelper.getGson().toJson(oEstadoBean));
} catch (Exception ex) {
ExceptionBooster.boost(
new Exception(this.getClass().getName() + ":get ERROR: " + ex.getMessage()));
} finally {
if (oConnection != null) {
oConnection.close();
}
if (oDataConnectionSource != null) {
oDataConnectionSource.disposeConnection();
}
}
return data;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}
@Override
public String getcount() throws Exception {
if (this.checkpermission("getcount")) {
String data = null;
ArrayList<FilterBeanHelper> alFilter = ParameterCook.prepareFilter(oRequest);
Connection oConnection = null;
ConnectionInterface oDataConnectionSource = null;
try {
oDataConnectionSource = getSourceConnection();
oConnection = oDataConnectionSource.newConnection();
EstadoDao oEstadoDao = new EstadoDao(oConnection);
data = JsonMessage.getJson("200", Integer.toString(oEstadoDao.getCount(alFilter)));
} catch (Exception ex) {
ExceptionBooster.boost(
new Exception(this.getClass().getName() + ":getCount ERROR: " + ex.getMessage()));
} finally {
if (oConnection != null) {
oConnection.close();
}
if (oDataConnectionSource != null) {
oDataConnectionSource.disposeConnection();
}
}
return data;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}
@Override
public String remove() throws Exception {
if (this.checkpermission("remove")) {
Integer id = ParameterCook.prepareId(oRequest);
String resultado = null;
Connection oConnection = null;
ConnectionInterface oDataConnectionSource = null;
try {
oDataConnectionSource = getSourceConnection();
oConnection = oDataConnectionSource.newConnection();
oConnection.setAutoCommit(false);
EstadoDao oEstadoDao = new EstadoDao(oConnection);
resultado = JsonMessage.getJson("200", (String) oEstadoDao.remove(id).toString());
oConnection.commit();
} catch (Exception ex) {
if (oConnection != null) {
oConnection.rollback();
}
ExceptionBooster.boost(
new Exception(this.getClass().getName() + ":remove ERROR: " + ex.getMessage()));
} finally {
if (oConnection != null) {
oConnection.close();
}
if (oDataConnectionSource != null) {
oDataConnectionSource.disposeConnection();
}
}
return resultado;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}
@Override
public String getpage() throws Exception {
if (this.checkpermission("getpage")) {
int intRegsPerPag = ParameterCook.prepareRpp(oRequest);
int intPage = ParameterCook.preparePage(oRequest);
ArrayList<FilterBeanHelper> alFilter = ParameterCook.prepareFilter(oRequest);
HashMap<String, String> hmOrder = ParameterCook.prepareOrder(oRequest);
String data = null;
Connection oConnection = null;
ConnectionInterface oDataConnectionSource = null;
try {
oDataConnectionSource = getSourceConnection();
oConnection = oDataConnectionSource.newConnection();
EstadoDao oEstadoDao = new EstadoDao(oConnection);
List<EstadoBean> arrBeans =
oEstadoDao.getPage(
intRegsPerPag, intPage, alFilter, hmOrder, AppConfigurationHelper.getJsonDepth());
data = JsonMessage.getJson("200", AppConfigurationHelper.getGson().toJson(arrBeans));
} catch (Exception ex) {
ExceptionBooster.boost(
new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
} finally {
if (oConnection != null) {
oConnection.close();
}
if (oDataConnectionSource != null) {
oDataConnectionSource.disposeConnection();
}
}
return data;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}
@Override
public String set() throws Exception {
if (this.checkpermission("set")) {
String jason = ParameterCook.prepareJson(oRequest);
String resultado = null;
Connection oConnection = null;
ConnectionInterface oDataConnectionSource = null;
try {
oDataConnectionSource = getSourceConnection();
oConnection = oDataConnectionSource.newConnection();
oConnection.setAutoCommit(false);
EstadoDao oEstadoDao = new EstadoDao(oConnection);
EstadoBean oEstadoBean = new EstadoBean();
oEstadoBean = AppConfigurationHelper.getGson().fromJson(jason, oEstadoBean.getClass());
if (oEstadoBean != null) {
Integer iResult = oEstadoDao.set(oEstadoBean);
if (iResult >= 1) {
resultado = JsonMessage.getJson("200", iResult.toString());
} else {
resultado = JsonMessage.getJson("500", "Error during registry set");
}
} else {
resultado = JsonMessage.getJson("500", "Error during registry set");
}
oConnection.commit();
} catch (Exception ex) {
if (oConnection != null) {
oConnection.rollback();
}
ExceptionBooster.boost(
new Exception(this.getClass().getName() + ":set ERROR: " + ex.getMessage()));
} finally {
if (oConnection != null) {
oConnection.close();
}
if (oDataConnectionSource != null) {
oDataConnectionSource.disposeConnection();
}
}
return resultado;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}
@Override
public String getaggregateviewsome() throws Exception {
if (this.checkpermission("getaggregateviewsome")) {
String data = null;
try {
String page = this.getpage();
String pages = this.getpages();
String registers = this.getcount();
data =
"{" + "\"page\":" + page + ",\"pages\":" + pages + ",\"registers\":" + registers + "}";
data = JsonMessage.getJson("200", data);
} catch (Exception ex) {
ExceptionBooster.boost(
new Exception(
this.getClass().getName() + ":getAggregateViewSome ERROR: " + ex.getMessage()));
}
return data;
} else {
return JsonMessage.getJsonMsg("401", "Unauthorized");
}
}