public boolean existTrackingAreaCubiclesForTrackingArea(Integer trackAreaId,DomainFactory factory) { if( trackAreaId == null) return false; StringBuffer hql = new StringBuffer(); //List only Emergency Department hql.append(" select t1_1 from TrackingAreaCubicles as t1_1 left join t1_1.trackingArea as t2_1 where (t2_1.id = :trackareaid)"); List<?> trackingList = factory.find(hql.toString(), new String[]{"trackareaid"}, new Object[]{trackAreaId}); if( trackingList != null && trackingList.size() > 0) { TrackingAreaCubiclesVoCollection tempColl = TrackingAreaCubiclesVoAssembler.createTrackingAreaCubiclesVoCollectionFromTrackingAreaCubicles(trackingList); if( tempColl != null && tempColl.size() > 0) return true; else return false; } return false; }
public TrackingAreaCubiclesVo getTrackingAreaCubicles(TrackingAreaRefVo trackingAreaRef) { if( trackingAreaRef == null ) return null; DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(); hql.append("select t1_1 from TrackingAreaCubicles as t1_1 left join t1_1.trackingArea as t2_1 where (t2_1.id = :trackingAreaId) "); List list = factory.find(hql.toString(), new String[] {"trackingAreaId"}, new Object[] {trackingAreaRef.getID_TrackingArea()}); if( list != null && list.size() > 0) { TrackingAreaCubiclesVoCollection tempColl = TrackingAreaCubiclesVoAssembler.createTrackingAreaCubiclesVoCollectionFromTrackingAreaCubicles(list); if( tempColl != null ) return tempColl.get(0); } return null; }