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;
}
