@GlobalDBOpenCloseAndUserPrivilages public Map getUserTypeSize( Session session, HttpServletRequest request, HttpServletResponse response, String LoggedInRegion, String LoggedInUser) { Map resultMap = new HashMap(); String isAccountModule = "No"; Map financialYearMap = new LinkedHashMap(); financialYearMap.put("0", "--Select--"); UserViewModel userObj = (UserViewModel) request.getSession(false).getAttribute("userDetails"); Criteria rcCriteria = session.createCriteria(Useroperatingrights.class); rcCriteria.add(Restrictions.sqlRestriction("userid = '" + userObj.getUserid() + "'")); rcCriteria.add(Restrictions.sqlRestriction("accessright is true")); rcCriteria.addOrder(Order.asc("usertypeid")); List rcList = rcCriteria.list(); resultMap.put("typesize", rcList.size()); Criteria fyearsCriteria = session.createCriteria(Accountingyear.class); List fyearsList = fyearsCriteria.list(); if (fyearsList.size() > 0) { for (int i = 0; i < fyearsList.size(); i++) { Accountingyear accountingyearObj = (Accountingyear) fyearsList.get(i); financialYearMap.put( accountingyearObj.getId(), (accountingyearObj.getStartyear() + "-" + accountingyearObj.getEndyear())); } } resultMap.put("financialYearMap", financialYearMap); if (rcList.size() == 1) { Useroperatingrights useroperatingrightsObj = (Useroperatingrights) rcList.get(0); Criteria privileageCriteria = session.createCriteria(Menuprivilages.class); privileageCriteria.add( Restrictions.sqlRestriction("usertype = " + useroperatingrightsObj.getUsertypeid())); privileageCriteria.add(Restrictions.sqlRestriction("accessright is true")); List privileageList = privileageCriteria.list(); if (privileageList.size() > 0) { for (int j = 0; j < privileageList.size(); j++) { Menuprivilages menuprivilagesObj = (Menuprivilages) privileageList.get(j); // // System.out.println("menuprivilagesObj.getMenumaster().getGrouptype()==" + // menuprivilagesObj.getMenumaster().getGrouptype()); if (menuprivilagesObj.getMenumaster().getGrouptype() == null) { } else if (menuprivilagesObj.getMenumaster().getGrouptype() == 'A') { isAccountModule = "Yes"; break; } } } } resultMap.put("isAccountModule", isAccountModule); return resultMap; }