/**
* Obtains report group Id of dashboard from database.
*
* @return
*/
public static int getDashboardReportGroupID() {
lastAccessed = System.currentTimeMillis();
ResultSetWrapper rsw = null;
SqlReader sqlReader = new SqlReader(false);
int reportGroupID = -1;
try {
String sqlQuery = "select reportgroupid from tblreportgroup where description = 'Dashboard'";
rsw = sqlReader.getInstanceResultSetWrapper(sqlQuery);
if (rsw.next()) {
reportGroupID = rsw.getInt("reportgroupid");
}
} catch (SQLException se) {
CyberoamLogger.repLog.error(
"SQLException ->getDashboardGroupID() -> ReportGroupBean: " + se, se);
} catch (Exception e) {
CyberoamLogger.repLog.error("Exception ->getDashboardGroupID() -> ReportGroupBean: " + e, e);
} finally {
try {
sqlReader.close();
rsw.close();
} catch (Exception e) {
}
}
return reportGroupID;
}
/**
* Checks for duplicate report group based on title of report group.
*
* @return
*/
public int checkForDuplicate() {
lastAccessed = System.currentTimeMillis();
String sqlQuery = null;
int retStatus = -1;
ResultSetWrapper rsw = null;
SqlReader sqlReader = null;
try {
sqlReader = new SqlReader(false);
sqlQuery =
"select count(*) as count from tblreportgroup where title="
+ StringMaker.makeString(getTitle());
rsw = sqlReader.getInstanceResultSetWrapper(sqlQuery, 120);
if (rsw.next() && rsw.getInt("count") > 0) {
retStatus = -4;
}
CyberoamLogger.appLog.error(
"Exception->checkForDuplicate()->ReportGroupBean->retStatus: " + retStatus);
} catch (Exception e) {
CyberoamLogger.appLog.error("Exception->checkForDuplicate()->ReportGroupBean->: " + e);
return -4;
} finally {
try {
rsw.close();
sqlReader.close();
} catch (Exception e) {
}
}
return retStatus;
}
/**
* Obtains instance of report group by {@link ResultSetWrapper}.
*
* @param rsw
* @return
*/
public static ReportGroupBean getBeanByResultSetWrapper(ResultSetWrapper rsw) {
ReportGroupBean reportGroupBean = new ReportGroupBean();
try {
reportGroupBean.setReportGroupId(rsw.getInt("reportgroupid"));
reportGroupBean.setTitle(rsw.getString("title"));
reportGroupBean.setDescription(rsw.getString("description"));
reportGroupBean.setInputParams(rsw.getString("inputparams"));
reportGroupBean.setGroupType(rsw.getInt("grouptype"));
reportGroupBean.setMenuOrder(rsw.getDouble("menuorder"));
reportGroupBean.setCategoryId(rsw.getInt("categoryid"));
} catch (Exception e) {
CyberoamLogger.repLog.error(
"Exception->getBeanByResultSetWrapper()->ReportGroupBean: " + e, e);
}
return reportGroupBean;
}