public TeamDetails getTeam(String salesRepuserId) { TeamDetails objTeamDetails = new TeamDetails(); try { UserDAO objUserDAO = new UserDAO(); RolesDAO objRolesDAO = new RolesDAO(); UsersVO objSalesRep = objUserDAO.getUsers(salesRepuserId); String roleName = objRolesDAO.getRoleName(objSalesRep.getUserId()); UsersVO objSalesManager = null; if (roleName.equals("SALES REP")) { if (objSalesRep != null) { objSalesManager = objSalesRep.getParentUser(); } objTeamDetails.setSalesRep(objSalesRep); objTeamDetails.setSalesManager(objSalesManager); objTeamDetails.setPricingAnalyst(objSalesManager.getParentUser()); } else if (roleName.equals("SALES MANAGER")) { objTeamDetails.setSalesRep(objSalesRep); objTeamDetails.setSalesManager(objSalesRep); objSalesManager = objSalesRep; objTeamDetails.setPricingAnalyst(objSalesManager.getParentUser()); } else { objTeamDetails.setSalesRep(objSalesRep); objTeamDetails.setSalesManager(objSalesRep); objTeamDetails.setPricingAnalyst(objSalesRep); } } catch (Exception e) { e.printStackTrace(); } return objTeamDetails; }
public boolean deleteUser(UsersVO usersVO) throws SQLException { boolean updateResult = false; Criteria objCriteria = null; Session objSession = null; List prcCustList = null; System.out.println("Inside User delete method"); try { logger.info("DELETING THE USER"); objSession = HibernateUtil.getSession(); objSession.beginTransaction(); objCriteria = objSession.createCriteria(ProspectiveCustomerVO.class); objCriteria.add(Restrictions.eq("salesRep.userId", usersVO.getUserId())); prcCustList = objCriteria.list(); System.out.println("List Size :" + prcCustList.size()); if (prcCustList.size() == 0) { System.out.println("Before Deleting UserGroup"); objSession .createQuery( "delete from UserGroupVO as userGroupVo where userGroupVo.userVo.userId = ?") .setString(0, usersVO.getUserId()) .executeUpdate(); System.out.println("after Deleting UserGroup and before Deleting User"); objSession.delete(usersVO); System.out.println("after Deleting User"); updateResult = true; } else { throw new PricingException("USER INUSE"); } objSession.getTransaction().commit(); logger.info("USER IS DELETED"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING DELETE A USER", e); e.printStackTrace(); objSession.getTransaction().rollback(); throw new HibernateException(""); } catch (Exception e) { logger.error("GENERAL EXCEPTION DURING DELETE A USER", e); e.printStackTrace(); throw new SQLException(); } finally { if (objSession != null) { objSession.close(); } } return updateResult; }
public static void main(String args[]) throws Exception { UserDAO usersDAO = new UserDAO(); List lstResults = usersDAO.getChildPersons("rep", true); Iterator ite = lstResults.iterator(); while (ite.hasNext()) { UsersVO objUsersVO = (UsersVO) ite.next(); System.out.println(objUsersVO.getUserId()); } }
public boolean updateUser(UsersVO userVO, RolesVO objRolesVO) { boolean updateResult = false; Session objSession = null; try { logger.info("UPDATING THE USER"); objSession = HibernateUtil.getSession(); objSession.beginTransaction(); if (BuildConfig.DMODE) System.out.println("userVO:" + userVO.getUserId()); userVO.setPassword(this.encrypt(userVO.getPassword())); objSession.saveOrUpdate(userVO); updateResult = true; objSession.getTransaction().commit(); if (objRolesVO != null) { // To update the Role for that user objSession.beginTransaction(); objSession .createQuery( "delete from UserGroupVO as userGroupVo where userGroupVo.userVo.userId = ?") .setString(0, userVO.getUserId()) .executeUpdate(); UserGroupVO objUserGroupVO = new UserGroupVO(); objUserGroupVO.setUserVo(userVO); objUserGroupVO.setRole(objRolesVO); objSession.save(objUserGroupVO); objSession.getTransaction().commit(); } logger.info("USER IS UPDATED"); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING UPDATE THE USER", e); objSession.getTransaction().rollback(); e.printStackTrace(); } finally { if (objSession != null) { objSession.close(); } } return updateResult; }
public boolean addUsers(UsersVO usersVO, RolesVO objRolesVO) throws ConstraintViolationException, HibernateException { boolean addResult = false; Session objSession = null; try { logger.info("ADDING A NEW USER"); objSession = HibernateUtil.getSession(); // To save the user objSession.beginTransaction(); usersVO.setPassword(this.encrypt(usersVO.getPassword())); objSession.save(usersVO); objSession.getTransaction().commit(); // To save the Role for that user objSession.beginTransaction(); UserGroupVO objUserGroupVO = new UserGroupVO(); objUserGroupVO.setUserVo(usersVO); objUserGroupVO.setRole(objRolesVO); objSession.save(objUserGroupVO); objSession.getTransaction().commit(); addResult = true; logger.info("NEW USER ADDED"); } catch (ConstraintViolationException e) { logger.error("CONSTRAINT VIOLATION EXCEPTION DURING ADD A NEW USER", e); objSession.getTransaction().rollback(); throw new ConstraintViolationException( "User Id already exist", new SQLException(), usersVO.getUserId()); } catch (HibernateException e) { logger.error("HIBERNATE EXCEPTION DURING ADD A NEW USER", e); objSession.getTransaction().rollback(); e.printStackTrace(); throw new HibernateException("User does not saved."); } finally { if (objSession != null) { objSession.close(); } } return addResult; }