org.generationcp.middleware.dao.ProjectActivityDAO.java Source code

Introduction

Here is the source code for org.generationcp.middleware.dao.ProjectActivityDAO.java

Source

/*******************************************************************************
 * Copyright (c) 2012, All Rights Reserved.
 *
 * Generation Challenge Programme (GCP)
 *
 *
 * This software is licensed for use under the terms of the GNU General Public License (http://bit.ly/8Ztv8M) and the provisions of Part F
 * of the Generation Challenge Programme Amended Consortium Agreement (http://bit.ly/KQX1nL)
 *
 *******************************************************************************/

package org.generationcp.middleware.dao;

import java.math.BigInteger;
import java.util.ArrayList;
import java.util.List;

import org.generationcp.middleware.exceptions.MiddlewareQueryException;
import org.generationcp.middleware.pojos.workbench.Project;
import org.generationcp.middleware.pojos.workbench.ProjectActivity;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

/**
 * DAO class for {@link ProjectActivity}.
 *
 * @author Joyce Avestro
 *
 */
public class ProjectActivityDAO extends GenericDAO<ProjectActivity, Integer> {

    /**
     * Returns a list of {@link ProjectActivity} records by project id.
     *
     * @param projectId the project id
     * @param start the first row to retrieve
     * @param numOfRows the number of rows to retrieve
     * @return the list of {@link ProjectActivity} records
     * @throws MiddlewareQueryException the MiddlewareQueryException
     */
    @SuppressWarnings("unchecked")
    public List<ProjectActivity> getByProjectId(Long projectId, int start, int numOfRows)
            throws MiddlewareQueryException {
        List<ProjectActivity> toReturn = new ArrayList<ProjectActivity>();
        try {
            if (projectId != null) {
                Criteria criteria = this.getSession().createCriteria(ProjectActivity.class);
                Project p = new Project();
                p.setProjectId(projectId);
                criteria.add(Restrictions.eq("project", p));
                criteria.setFirstResult(start);
                criteria.setMaxResults(numOfRows);
                criteria.addOrder(Order.desc("createdAt"));
                toReturn = criteria.list();
            }
        } catch (HibernateException e) {
            this.logAndThrowException("Error with getByProjectId(projectId=" + projectId
                    + ") query from ProjectActivity " + e.getMessage(), e);
        }
        return toReturn;
    }

    /**
     * Returns the number of {@link ProjectActivity} records by project id.
     *
     * @param projectId the project id
     * @return the number of {@link ProjectActivity} records
     * @throws MiddlewareQueryException the MiddlewareQueryException
     */
    public long countByProjectId(Long projectId) throws MiddlewareQueryException {
        try {
            if (projectId != null) {
                SQLQuery query = this.getSession().createSQLQuery(ProjectActivity.COUNT_ACTIVITIES_BY_PROJECT_ID);
                query.setParameter("projectId", projectId.intValue());
                BigInteger result = (BigInteger) query.uniqueResult();
                return result.longValue();
            }
        } catch (HibernateException e) {
            this.logAndThrowException("Error with countByProjectId(projectId=" + projectId
                    + ") query from ProjectActivity " + e.getMessage(), e);
        }
        return 0;
    }
}