Example usage for org.hibernate.criterion DetachedCriteria add

List of usage examples for org.hibernate.criterion DetachedCriteria add

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void addEmployeeGroupMap(String employeeId, String groupId) throws ExceptionWrapper {
    try {//from w  w  w.  j  a  v a  2s  . c  o m

        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeId.trim())));
        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        criteria = DetachedCriteria.forClass(Groups.class);
        criteria.add(Restrictions.eq("groupId", Integer.valueOf(groupId.trim())));
        Groups groups = (Groups) hibernateTemplate.findByCriteria(criteria).get(0);

        Employeegroupmap employeegroupmap = new Employeegroupmap(employee, groups);
        hibernateTemplate.save(employeegroupmap);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeegroupmap> getEmployeegroupmapByEmployeeID(String employeeId) throws ExceptionWrapper {
    ArrayList<Employeegroupmap> employeegroupmapArrayList = new ArrayList<Employeegroupmap>();
    try {//from   w  ww . j  av a2 s .c  o m
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeegroupmap.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("groups", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeegroupmapArrayList.add((Employeegroupmap) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeegroupmapArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void addEmployeeLicenseMap(String employeeId, String licenseId) throws ExceptionWrapper {
    try {/*from ww w. ja v a 2s  .c o  m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeId.trim())));
        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        criteria = DetachedCriteria.forClass(Licensemaster.class);
        criteria.add(Restrictions.eq("licenseTypeId", Long.valueOf(licenseId.trim())));
        Licensemaster licensemaster = (Licensemaster) hibernateTemplate.findByCriteria(criteria).get(0);
        Employeelicensemapping employeelicensemapping = new Employeelicensemapping(employee, licensemaster);
        hibernateTemplate.save(employeelicensemapping);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeelicensemapping> getEmployeeLicenseMapByEmployeeId(String employeeId)
        throws ExceptionWrapper {
    ArrayList<Employeelicensemapping> employeelicensemappingArrayList = new ArrayList<Employeelicensemapping>();
    try {/*  w  w  w.ja v a2 s  .  c  o m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeelicensemapping.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("licensemaster", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeelicensemappingArrayList.add((Employeelicensemapping) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeelicensemappingArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void updateEmployee(EmployeeBO employeeBO) throws ExceptionWrapper {
    try {/*  w  w  w. ja v  a  2s . c o m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeBO.getEmployeeId())));
        criteria.setFetchMode("employeelicensemappings", FetchMode.JOIN);
        criteria.setFetchMode("employeegroupmaps", FetchMode.JOIN);
        criteria.setFetchMode("employeerolemappings", FetchMode.JOIN);

        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        employee.setEmail(employeeBO.getEmail());
        employee.setEmployeeName(employeeBO.getEmployeeName());
        employee.setEmployeeUid(employeeBO.getEmployeeUid());
        employee.setJobTitle(employeeBO.getJobTitle());
        employee.setMobileNumber(employeeBO.getMobileNumber());
        employee.setManager(employeeBO.getManager());
        employee.setManagerEmail(employeeBO.getManagerEmail());
        //employee.setExtensionNum(employeeBO.getExtensionNum());
        //employee.setWorkspace(employeeBO.getWorkspace());
        employee.setIsActive(employeeBO.isActive());
        hibernateTemplate.update(employee);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public LinkedHashMap<Long, EmployeeBO> getAllEmployeesByTemplate() throws ExceptionWrapper {
    LinkedHashMap<Long, EmployeeBO> employeeLinkedHashMap = new LinkedHashMap<Long, EmployeeBO>();

    try {// www .  j a va2 s  .  c  om
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("isActive", true));
        criteria.addOrder(Order.asc("employeeName"));

        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Employee employee = (Employee) item;
            EmployeeBO employeeBO = new EmployeeBO(employee);

            //Get the group information for the employee
            for (Object obj : employee.getEmployeegroupmaps()) {
                Employeegroupmap employeegroupmap = (Employeegroupmap) obj;
                employeegroupmap = hibernateTemplate.get(Employeegroupmap.class,
                        employeegroupmap.getEmployeeGroupMappingId());
                GroupBO groupBO = new GroupBO(employeegroupmap.getGroups());
                employeeBO.getGroups().add(groupBO);
            }
            //==================================================================================================================
            //Get the license info for the employee
            for (Object obj : employee.getEmployeelicensemappings()) {
                Employeelicensemapping employeelicensemapping = (Employeelicensemapping) obj;
                LicenseBO licenseBO = new LicenseBO(employeelicensemapping.getLicensemaster());
                employeeBO.getLicenses().add(licenseBO);
            }
            //==================================================================================================================
            employeeLinkedHashMap.put(Long.valueOf(employee.getEmployeeId()), employeeBO);
        }

    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeeLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public LinkedHashMap<String, Imagenowlicenses> getAllImageNowLicensesByRequestor(String employeeUID)
        throws ExceptionWrapper {
    LinkedHashMap<String, Imagenowlicenses> imagenowlicensesLinkedHashMap = new LinkedHashMap<String, Imagenowlicenses>();
    try {/*from   ww w .j  a v a  2  s  .  c  o  m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.add(Restrictions.eq("emp.employeeUid", employeeUID));
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Imagenowlicenses imagenowlicenses = (Imagenowlicenses) item;
            imagenowlicensesLinkedHashMap.put(imagenowlicenses.getImageNowLicenseRequestId(), imagenowlicenses);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return imagenowlicensesLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public Imagenowlicenses getAllImageNowLicensesByRequestId(String requestId) throws ExceptionWrapper {

    try {/*from w w  w  . j  a v  a2 s.  co m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.add(Restrictions.eq("imageNowLicenseRequestId", requestId.trim()));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);

        return (Imagenowlicenses) hibernateTemplate.findByCriteria(criteria).get(0);

    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public void addImageNowLicense(Imagenowlicenses imagenowlicenses, String groupRequestedFor,
        String employeeUIDWhoRequestedLicense) throws ExceptionWrapper {
    try {//from   w w w. j a va2  s. com
        //Get The Group Info
        DetachedCriteria criteria = DetachedCriteria.forClass(Groups.class);
        criteria.add(Restrictions.eq("groupId", Integer.valueOf(groupRequestedFor)));
        imagenowlicenses.setGroups((Groups) hibernateTemplate.findByCriteria(criteria).get(0));
        criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeUid", employeeUIDWhoRequestedLicense.trim()));
        imagenowlicenses.setEmployeeByRequestedByEmployeeId(
                (Employee) hibernateTemplate.findByCriteria(criteria).get(0));
        hibernateTemplate.save(imagenowlicenses);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public void updateImageNowLicense(Imagenowlicenses imagenowlicenses, String providerEmpUID)
        throws ExceptionWrapper {
    try {//  w w  w .j a va 2s .c o  m
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeUid", providerEmpUID.trim()));
        imagenowlicenses.setEmployeeByProvidedByEmployeeId(
                (Employee) hibernateTemplate.findByCriteria(criteria).get(0));
        hibernateTemplate.update(imagenowlicenses);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}