de.powerstaff.business.dao.hibernate.ProjectDAOHibernateImpl.java Source code

Introduction

Here is the source code for de.powerstaff.business.dao.hibernate.ProjectDAOHibernateImpl.java

Source

/**
 * Mogwai PowerStaff. Copyright (C) 2002 The Mogwai Project.
 *
 * This library is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Lesser General Public License as published by the Free
 * Software Foundation; either version 2.1 of the License, or (at your option)
 * any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this library; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
 */
package de.powerstaff.business.dao.hibernate;

import de.powerstaff.business.dao.GenericSearchResult;
import de.powerstaff.business.dao.ProjectDAO;
import de.powerstaff.business.entity.*;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
import java.util.Vector;

public class ProjectDAOHibernateImpl extends NavigatingDAOHibernateImpl<Project> implements ProjectDAO {

    @Override
    protected Project createNew() {
        return new Project();
    }

    @Override
    protected Class getEntityClass() {
        return Project.class;
    }

    public List<GenericSearchResult> performQBESearch(Project aObject, int aMaxSearchResult) {

        String[] theProperties = new String[] { "projectNumber", "startDate", "duration", "descriptionShort",
                "status", "+customer", "+partner" };

        String[] theSearchProperties = new String[] { "entryDate", "projectNumber", "workplace", "startDate",
                "duration", "descriptionShort", "descriptionLong" };

        String[] theOrderByProperties = new String[] { "projectNumber" };

        return performQBESearch(aObject, theProperties, theSearchProperties, theOrderByProperties, MATCH_LIKE,
                aMaxSearchResult);
    }

    public Project findByPrimaryKey(Long aProjectID) {
        return getHibernateTemplate().get(Project.class, aProjectID);
    }

    public List<Project> getActiveProjects() {
        return (List<Project>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session aSession) throws SQLException {

                List<Project> theResult = new Vector<Project>();

                Criteria theCriteria = aSession.createCriteria(Project.class);
                theCriteria.add(Restrictions.eq("visibleOnWebSite", Boolean.TRUE));
                theResult.addAll(theCriteria.list());

                return theResult;
            }

        });
    }

    @Override
    public Collection<? extends ProjectPositionStatus> getAvailablePositionStatus() {
        return (Collection<ProjectPositionStatus>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session aSession) throws SQLException {

                List<ProjectPositionStatus> theResult = new Vector<ProjectPositionStatus>();

                Criteria theCriteria = aSession.createCriteria(ProjectPositionStatus.class);
                theResult.addAll(theCriteria.list());

                return theResult;
            }

        });
    }

    @Override
    public Collection<SavedProfileSearch> getSavedSearchesFor(final Project aProject) {
        return (Collection<SavedProfileSearch>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session aSession) {

                Criteria theCriteria = aSession.createCriteria(SavedProfileSearch.class);
                theCriteria.add(Restrictions.eq("project", aProject));
                theCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
                return theCriteria.list();
            }
        });
    }

    @Override
    public List<Project> findProjectsFor(final Customer aCustomer) {
        return (List<Project>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session aSession) {

                Criteria theCriteria = aSession.createCriteria(Project.class);
                theCriteria.add(Restrictions.eq("customer", aCustomer));
                theCriteria.addOrder(Order.asc("projectNumber"));
                theCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
                return theCriteria.list();
            }
        });
    }

    @Override
    public List<Project> findProjectsFor(final Partner aPartner) {
        return (List<Project>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session aSession) {

                Criteria theCriteria = aSession.createCriteria(Project.class);
                theCriteria.add(Restrictions.eq("partner", aPartner));
                theCriteria.addOrder(Order.asc("projectNumber"));
                theCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
                return theCriteria.list();
            }
        });
    }
}