@SuppressWarnings("unchecked")
public UserCollectionVO getAllUsers() throws Exception {
logger.debug("inside getAllUsers: in UserDAOImpl");
UserCollectionVO allUsers = new UserCollectionVO();
List<UserVO> usersList = null;
usersList = getHibernateTemplate().find("from UserVO u order by lastUpdatedDate desc");
if (usersList != null) {
allUsers.addAll(usersList);
}
return allUsers;
}
@SuppressWarnings("unchecked")
public UserCollectionVO getUsersByPartialUserName(String partialUserName) throws Exception {
logger.debug("inside getUsersByPartialUserName: in UserDAOImpl");
UserCollectionVO users = new UserCollectionVO();
List<UserVO> usersList =
getHibernateTemplate()
.find("from UserVO u where u.userName like '%" + partialUserName + "%'");
if (usersList != null) {
users.addAll(usersList);
}
return users;
}
@SuppressWarnings("unchecked")
public UserCollectionVO getUsersByUserType(UserType type) throws Exception {
logger.debug("inside getUsersByType: in UserDAOImpl");
UserCollectionVO users = new UserCollectionVO();
List<UserVO> usersList = null;
usersList =
getHibernateTemplate()
.find(
"from UserVO u where u.userType ="
+ Integer.parseInt(type.ordinal() + "")
+ " order by lastUpdatedDate");
if (usersList != null) {
users.addAll(usersList);
}
return users;
}
@SuppressWarnings("unchecked")
public UserCollectionVO searchUsers(UserVO user) throws Exception {
logger.debug("inside searchUsers: in UserDAOImpl");
UserCollectionVO searchedUsers = new UserCollectionVO();
List<UserVO> userList = null;
Session session = null;
try {
session = getSession();
Criteria criteria = session.createCriteria(UserVO.class, "user");
if (StringUtils.isNotEmpty(user.getUserName())) {
logger.debug("userName search");
criteria.add(Restrictions.eq("userName", user.getUserName()));
}
if (StringUtils.isNotEmpty(user.getLastName())) {
logger.debug("Last Name search");
criteria.add(Restrictions.eq("lastName", user.getLastName()));
}
if (StringUtils.isNotEmpty(user.getFirstName())) {
logger.debug("First Name search");
criteria.add(Restrictions.eq("firstName", user.getFirstName()));
}
if (user.getUserType() != null) {
logger.debug("User Type search");
criteria.add(Restrictions.eq("userType", user.getUserType()));
}
if (user.getUserStatus() != null) {
logger.debug("User Status search");
criteria.add(Restrictions.eq("userStatus", user.getUserStatus()));
}
criteria.addOrder(Order.desc("lastUpdatedDate"));
userList = criteria.list();
} catch (Exception e) {
logger.error(e.getMessage());
// System.out.println(e.getMessage());
} finally {
session.flush();
session.close();
}
if (userList != null) {
logger.debug("userList.size()=" + userList.size());
searchedUsers.addAll(userList);
}
return searchedUsers;
}