private boolean validateLabelMaster(RELabelSetupMainDetails labelTypeMaster) throws Exception {
Connection con = null;
MessagesUtil msgUtil = null;
String scrIdChek = null;
try {
con = TagLibConnectionUtil.getConnection();
msgUtil = new MessagesUtil();
if ("ADD".equals(labelTypeMaster.getOperation())) {
scrIdChek = "SELECT 'X' FROM SOFTWARE_SERVICES SR WHERE SR.SCREEN_ID = ?";
if (QueryBuilderUtil.isRecordExits(con, scrIdChek, labelTypeMaster.getScrnId())) {
msgUtil.put(
TagLibConstants.ERROR_LEVEL,
"Screen Id already Exists--> " + labelTypeMaster.getScrnId());
}
}
if (msgUtil.isEmpty()) {
return true;
} else {
labelTypeMaster.setErrMsgs(msgUtil.getErrMsgs());
labelTypeMaster.setSucessMsgs(msgUtil.getSucessMsgs());
return false;
}
} finally {
TagLibConnectionUtil.closeConnection(con);
msgUtil = null;
scrIdChek = null;
}
}
public RELabelSetupMainDetails insertLabelMaster(RELabelSetupMainDetails mainDetails)
throws Exception {
Connection connection = null;
PreparedStatement pstmt = null;
String insertQuery = "";
long labelSeqId = 0;
try {
if (validateLabelMaster(mainDetails)) {
connection = TagLibConnectionUtil.getConnection();
connection.setAutoCommit(false);
labelSeqId = QueryBuilderUtil.generateSeqNo("SOFTWARE_SERVICES_ID_SEQ", connection);
insertQuery =
"INSERT INTO SOFTWARE_SERVICES(ID,SCREEN_ID,DESCRIPTION,JSP_NAME,VO_CLASS, "
+ "HANDLER_CLASS,REMARKS,STATUS) VALUES (?,?,?,?,?,?,?,?)";
pstmt = connection.prepareStatement(insertQuery);
pstmt.setLong(1, labelSeqId);
pstmt.setString(2, mainDetails.getScrnId());
pstmt.setString(3, mainDetails.getDesc());
pstmt.setString(4, mainDetails.getJspName());
pstmt.setString(5, mainDetails.getVoClass());
pstmt.setString(6, mainDetails.getHandlerClass());
pstmt.setString(7, mainDetails.getRemarks());
pstmt.setString(8, mainDetails.getStatus());
pstmt.executeUpdate();
insertLabelFields(mainDetails.getFieldsList(), connection, labelSeqId);
insertLabelFieldLang(
mainDetails.getFieldsList(),
mainDetails.getLangWiseFieldDescMap(),
connection,
labelSeqId);
connection.commit();
}
} catch (Exception e) {
connection.rollback();
throw e;
} finally {
TagLibConnectionUtil.closePreparedStatement(pstmt);
TagLibConnectionUtil.closeConnection(connection);
}
return mainDetails;
}
public RELabelSetupMainDetails loadLabelSetupMainDetails(String setupSeqId) throws Exception {
String FETCH_QRY =
"SELECT ID,SCREEN_ID,DESCRIPTION,JSP_NAME,VO_CLASS,HANDLER_CLASS, REMARKS, STATUS FROM SOFTWARE_SERVICES WHERE ID=?";
String LABEL_QUERY =
"SELECT LF.ID,LF.FIELD_ID, LF.LABEL_TYPE, LF.VO_FIELD_TYPE, LF.REMARKS, LF.STATUS, LF.VO_FIELD_NAME, "
+ "(SELECT T4.SHORTCUT_KEY FROM LABEL_FIELDS_SHORTCUTKEYS T4 WHERE T4.FIELD_ID = LF.ID AND ROWNUM = 1) SHORTCUT_KEY "
+ "FROM LABEL_FIELDS LF WHERE LF.SERVICE_ID=?";
Connection con = null;
PreparedStatement pstmt = null;
PreparedStatement labelpstmt = null;
ResultSet rs = null;
ResultSet labelRs = null;
RELabelSetupMainDetails mainDetails = null;
RELabelFields labelFields = null;
List<RELabelFields> labelList = null;
try {
con = TagLibConnectionUtil.getConnection();
labelFields = new RELabelFields();
mainDetails = new RELabelSetupMainDetails();
mainDetails.setLang("ENGLISH");
pstmt = con.prepareStatement(FETCH_QRY);
labelpstmt = con.prepareStatement(LABEL_QUERY);
pstmt.setString(1, setupSeqId);
rs = pstmt.executeQuery();
if (rs.next()) {
mainDetails.setSeqId(rs.getLong("ID"));
mainDetails.setScrnId(rs.getString("SCREEN_ID"));
mainDetails.setDesc(rs.getString("DESCRIPTION"));
mainDetails.setJspName(rs.getString("JSP_NAME"));
mainDetails.setVoClass(rs.getString("VO_CLASS"));
mainDetails.setHandlerClass(rs.getString("HANDLER_CLASS"));
mainDetails.setRemarks(rs.getString("REMARKS"));
mainDetails.setStatus(rs.getString("STATUS"));
labelpstmt.setString(1, setupSeqId);
labelRs = labelpstmt.executeQuery();
labelList = new ArrayList<RELabelFields>();
while (labelRs.next()) {
labelFields = new RELabelFields();
labelFields.setLabelSeqId(labelRs.getLong("ID"));
labelFields.setLabelId(labelRs.getString("FIELD_ID"));
labelFields.setLabelType(labelRs.getString("LABEL_TYPE"));
labelFields.setVoFieldName(labelRs.getString("VO_FIELD_NAME"));
labelFields.setVoFieldType(labelRs.getString("VO_FIELD_TYPE"));
labelFields.setShortCutKey(labelRs.getString("SHORTCUT_KEY"));
labelFields.setLabelType(labelRs.getString("LABEL_TYPE"));
;
labelFields.setStatus(labelRs.getString("STATUS"));
labelFields.setRemarks(labelRs.getString("REMARKS"));
labelList.add(labelFields);
}
if (CollectionUtils.isNullEmpty(labelList)) {
labelFields = new RELabelFields();
labelList.add(labelFields);
}
mainDetails.setFieldsList(labelList);
mainDetails.setLangWiseFieldDescMap(getLangWiseFieldDescMap(mainDetails.getSeqId(), con));
}
} finally {
TagLibConnectionUtil.closePreparedStatement(pstmt, rs);
TagLibConnectionUtil.closePreparedStatement(labelpstmt, labelRs);
TagLibConnectionUtil.closeConnection(con);
}
return mainDetails;
}
public RELabelSetupMainDetails updateLabelMaster(RELabelSetupMainDetails labelTypeMaster)
throws Exception {
Connection connection = null;
PreparedStatement pstmt = null;
String updateQuery = "";
try {
connection = TagLibConnectionUtil.getConnection();
connection.setAutoCommit(false);
updateQuery =
"UPDATE SOFTWARE_SERVICES SET SCREEN_ID=?,DESCRIPTION=?,JSP_NAME=?, VO_CLASS=?,HANDLER_CLASS=?,REMARKS=?,STATUS=? WHERE ID =? ";
pstmt = connection.prepareStatement(updateQuery);
pstmt.setString(1, labelTypeMaster.getScrnId());
pstmt.setString(2, labelTypeMaster.getDesc());
pstmt.setString(3, labelTypeMaster.getJspName());
pstmt.setString(4, labelTypeMaster.getVoClass());
pstmt.setString(5, labelTypeMaster.getHandlerClass());
pstmt.setString(6, labelTypeMaster.getRemarks());
pstmt.setString(7, labelTypeMaster.getStatus());
pstmt.setLong(8, labelTypeMaster.getSeqId());
pstmt.executeUpdate();
insertLabelFields(labelTypeMaster.getFieldsList(), connection, labelTypeMaster.getSeqId());
insertLabelFieldLang(
labelTypeMaster.getFieldsList(),
labelTypeMaster.getLangWiseFieldDescMap(),
connection,
labelTypeMaster.getSeqId());
connection.commit();
} catch (Exception e) {
connection.rollback();
e.printStackTrace();
throw e;
} finally {
TagLibConnectionUtil.closePreparedStatement(pstmt);
TagLibConnectionUtil.closeConnection(connection);
}
return labelTypeMaster;
}
