public String getCargoPackType() {
   String packType = null;
   if (!CollectionUtils.isNullEmpty(cargoPackList)) {
     for (ETCargoPackVO cargoPackVO : cargoPackList) {
       if (packType != null && !packType.equals(cargoPackVO.getPackageType())) {
         return "PCS";
       }
       packType = cargoPackVO.getPackageType();
       ;
     }
   }
   return packType;
 }
  private void insertLabelFields(List<RELabelFields> fieldsList, Connection conn, long setupSeqId)
      throws Exception {
    PreparedStatement labelPstmt = null;
    PreparedStatement keysPstmt = null;
    long labelFieldSeqId = 0;
    String labelQuery = null;
    String keysQuery = null;
    try {
      deleteLabelFieldsAndLang(conn, setupSeqId);
      if (!CollectionUtils.isNullEmpty(fieldsList)) {
        labelQuery =
            "INSERT INTO LABEL_FIELDS(ID,SERVICE_ID,FIELD_ID,VO_FIELD_NAME,VO_FIELD_TYPE,LABEL_TYPE,REMARKS,STATUS) VALUES(?,?,?,?,?,?,?,?)";
        keysQuery =
            "INSERT INTO LABEL_FIELDS_SHORTCUTKEYS(ID,FIELD_ID,SHORTCUT_KEY) VALUES(LABEL_FIELD_SHORTCUT_ID_SEQ.NEXTVAL,?,?)";
        labelPstmt = conn.prepareStatement(labelQuery);
        keysPstmt = conn.prepareStatement(keysQuery);
        for (RELabelFields labelFields : fieldsList) {
          labelPstmt.clearParameters();
          keysPstmt.clearParameters();
          if (!TagLibStringUtility.isNullEmpty(labelFields.getLabelId())) {
            labelFieldSeqId = QueryBuilderUtil.generateSeqNo("LABEL_FIELDS_ID_SEQ", conn);
            labelFields.setLabelSeqId(labelFieldSeqId);
            labelPstmt.setLong(1, labelFieldSeqId);
            labelPstmt.setLong(2, setupSeqId);
            labelPstmt.setString(3, labelFields.getLabelId());
            labelPstmt.setString(4, labelFields.getVoFieldName());
            labelPstmt.setString(5, labelFields.getVoFieldType());
            labelPstmt.setString(6, labelFields.getLabelType());
            labelPstmt.setString(7, labelFields.getRemarks());
            labelPstmt.setString(8, labelFields.getStatus());
            labelPstmt.executeUpdate();

            keysPstmt.setLong(1, labelFieldSeqId);
            keysPstmt.setString(2, labelFields.getShortCutKey());
            keysPstmt.executeUpdate();
          }
        }
      }
    } finally {
      labelQuery = null;
      TagLibConnectionUtil.closePreparedStatement(labelPstmt);
    }
  }
 private void insertLabelFieldLang(
     List<RELabelFields> fieldsList,
     Map<String, Map<String, String>> langWiseFieldDescMap,
     Connection conn,
     long setupSeqId)
     throws Exception {
   PreparedStatement fieldPstmt = null;
   String fieldLanguage = null;
   Map<String, String> labelDescMap = null;
   String lang = null;
   try {
     if (!CollectionUtils.isNullEmpty(fieldsList)) {
       fieldLanguage =
           "INSERT INTO LABEL_FIELD_LANGUAGE(ID, LABEL_ID, LANGUAGE_ID, LABEL_DESCRIPTION) VALUES(LABEL_FIELD_LANGUAGE_ID_SEQ.NEXTVAL,?,?,?)";
       fieldPstmt = conn.prepareStatement(fieldLanguage);
       Iterator<String> langKey = langWiseFieldDescMap.keySet().iterator();
       while (langKey.hasNext()) {
         lang = langKey.next();
         labelDescMap = langWiseFieldDescMap.get(lang);
         for (RELabelFields labelFields : fieldsList) {
           fieldPstmt.clearParameters();
           String labelId = labelFields.getLabelId();
           String desc = labelDescMap.get(labelFields.getLabelId());
           if (!TagLibStringUtility.isNullEmpty(labelId)
               && !TagLibStringUtility.isNullEmpty(desc)) {
             fieldPstmt.setLong(1, labelFields.getLabelSeqId());
             fieldPstmt.setString(2, lang);
             fieldPstmt.setString(3, desc);
             fieldPstmt.executeUpdate();
           }
         }
       }
     }
   } finally {
     fieldLanguage = null;
     labelDescMap = null;
     lang = null;
     TagLibConnectionUtil.closePreparedStatement(fieldPstmt);
   }
 }
 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;
 }