public HashMap getAllUsers( Filter filterUserId, int userTypeId, String parentTypeId, String sortBy, boolean ascending, int startIndex, int displayCount) { Criteria objCriteria = null; Session objSession = null; Integer totRecordCount = null; List objList = null; HashMap hmResult = new HashMap(); try { logger.info("GETING ALL USERS"); objSession = HibernateUtil.getSession(); objCriteria = objSession.createCriteria(UsersVO.class); if (filterUserId != null) { objCriteria.add( Restrictions.like( filterUserId.getFieldName(), filterUserId.getFieldValue(), (MatchMode) HibernateUtil.htMatchCase.get(filterUserId.getSpecialFunction()))); } if (userTypeId != 0) { objCriteria.add(Restrictions.eq("userTypes.userTypeId", new Integer(userTypeId))); } if (parentTypeId.length() > 0) { objCriteria.add(Restrictions.like("parentUser.userId", parentTypeId, MatchMode.EXACT)); } totRecordCount = new Integer(objCriteria.list().size()); if (ascending) { objCriteria.addOrder(Order.asc(sortBy)); } else { objCriteria.addOrder(Order.desc(sortBy)); } objCriteria.setFirstResult(startIndex); objCriteria.setMaxResults(displayCount); objList = objCriteria.list(); hmResult.put("TotalRecordCount", totRecordCount); hmResult.put("Records", objList); logger.info("GOT ALL USERS"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING GET ALL USERS", e); e.printStackTrace(); } finally { if (objSession != null) { objSession.close(); } } return hmResult; }
public HashMap getAllRateCodes( Filter rateCode, Filter filtRateClass, int tdspId, String sortBy, boolean ascending, int startIndex, int displayCount) { /** * Requires - Modifies - Effects - * * @throws - */ Criteria objCriteria = null; Session objSession = null; Integer totRecordCount = null; List objList = null; HashMap hmResult = new HashMap(); try { logger.info("GETTING ALL RATE CODES"); objSession = HibernateUtil.getSession(); objCriteria = objSession.createCriteria(RateCodesVO.class); if (rateCode != null) { objCriteria.add( Restrictions.like( rateCode.getFieldName(), rateCode.getFieldValue(), (MatchMode) HibernateUtil.htMatchCase.get(rateCode.getSpecialFunction()))); } if (filtRateClass != null) { objCriteria.add( Restrictions.like( filtRateClass.getFieldName(), filtRateClass.getFieldValue(), (MatchMode) HibernateUtil.htMatchCase.get(filtRateClass.getSpecialFunction()))); } if (tdspId != 0) { objCriteria.add(Restrictions.eq("tdsp.tdspIdentifier", new Integer(tdspId))); } totRecordCount = new Integer(objCriteria.list().size()); if (ascending) { objCriteria.addOrder(Order.asc(sortBy)); } else { objCriteria.addOrder(Order.desc(sortBy)); } objCriteria.setFirstResult(startIndex); objCriteria.setMaxResults(displayCount); objList = objCriteria.list(); Iterator itr = objList.iterator(); List resultList = new ArrayList(); TDSPRateCodesDetails objTDSPRateCodesDetails = null; while (itr.hasNext()) { RateCodesVO objRateCodesVO = (RateCodesVO) itr.next(); objTDSPRateCodesDetails = new TDSPRateCodesDetails(); objTDSPRateCodesDetails.setRateCode(objRateCodesVO.getRateCode()); objTDSPRateCodesDetails.setRateClass(objRateCodesVO.getRateClass()); objTDSPRateCodesDetails.setDescription(objRateCodesVO.getDescription()); TDSPRateCodesVO objTDSPRateCodesVO = (TDSPRateCodesVO) objSession.get( TDSPRateCodesVO.class, new Integer(objRateCodesVO.getRateCodeIdentifier())); objTDSPRateCodesDetails.setMeterCategory(objTDSPRateCodesVO.getMeterCategory()); objTDSPRateCodesDetails.setServiceVoltage(objTDSPRateCodesVO.getServiceVoltage()); objTDSPRateCodesDetails.setScudPercentage(objTDSPRateCodesVO.getScudPercentage()); resultList.add(objTDSPRateCodesDetails); } hmResult.put("TotalRecordCount", totRecordCount); hmResult.put("Records", resultList); logger.info("GOT ALL RATE CODES"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING GET ALL RATE CODES", e); e.printStackTrace(); } finally { if (objSession != null) { objSession.close(); } } return hmResult; }