au.org.theark.lims.model.dao.BioTransactionDao.java Source code

Introduction

Here is the source code for au.org.theark.lims.model.dao.BioTransactionDao.java

Source

/*******************************************************************************
 * Copyright (c) 2011  University of Western Australia. All rights reserved.
 * 
 * This file is part of The Ark.
 * 
 * The Ark is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 * 
 * The Ark 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 General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package au.org.theark.lims.model.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Repository;

import au.org.theark.core.dao.HibernateSessionDao;
import au.org.theark.core.exception.ArkSystemException;
import au.org.theark.core.exception.EntityNotFoundException;
import au.org.theark.core.model.lims.entity.AccessRequest;
import au.org.theark.core.model.lims.entity.BioTransaction;
import au.org.theark.core.model.lims.entity.BioTransactionStatus;
import au.org.theark.core.model.lims.entity.Biospecimen;
import au.org.theark.core.model.lims.entity.TreatmentType;

@SuppressWarnings("unchecked")
@Repository("bioTransactionDao")
public class BioTransactionDao extends HibernateSessionDao implements IBioTransactionDao {
    public BioTransaction getBioTransaction(Long id) throws EntityNotFoundException, ArkSystemException {
        Criteria criteria = getSession().createCriteria(BioTransaction.class);
        criteria.add(Restrictions.eq("id", id));

        BioTransaction bioTransaction = (BioTransaction) criteria.uniqueResult();
        if (bioTransaction.getId() == null) {
            throw new EntityNotFoundException("The entity with id" + id.toString() + " cannot be found.");
        }

        return bioTransaction;
    }

    private Criteria buildBioTransactionCriteria(BioTransaction bioTransaction) {
        Criteria criteria = getSession().createCriteria(BioTransaction.class);
        // All transactions must operate on a given biospecimen
        criteria.add(Restrictions.eq("biospecimen", bioTransaction.getBiospecimen()));

        return criteria;
    }

    public long getBioTransactionCount(BioTransaction bioTransaction) {
        // Handle for biospecimen not in context
        if (bioTransaction.getBiospecimen() == null) {
            return 0L;
        }
        Criteria criteria = buildBioTransactionCriteria(bioTransaction);
        criteria.setProjection(Projections.rowCount());

        return (Long) criteria.uniqueResult();
    }

    public List<BioTransaction> searchPageableBioTransactions(BioTransaction bioTransaction, int first, int count) {
        // Handle for biospecimen not in context
        if (bioTransaction.getBiospecimen() == null) {
            return new ArrayList<BioTransaction>(0);
        }
        Criteria criteria = buildBioTransactionCriteria(bioTransaction);
        // sort by most recent first
        criteria.addOrder(Order.desc("transactionDate"));
        criteria.addOrder(Order.desc("id"));
        // support pageable results list
        criteria.setFirstResult(first);
        criteria.setMaxResults(count);

        List<BioTransaction> list = criteria.list();
        return list;
    }

    public void createBioTransaction(BioTransaction bioTransaction) {
        getSession().save(bioTransaction);
    }

    public void deleteBioTransaction(BioTransaction bioTransaction) {
        getSession().delete(bioTransaction);
    }

    public void updateBioTransaction(BioTransaction biospecimen) {
        getSession().update(biospecimen);
    }

    public List<TreatmentType> getTreatmentTypes() {
        Criteria criteria = getSession().createCriteria(TreatmentType.class);
        List<TreatmentType> list = criteria.list();
        return list;
    }

    public List<BioTransactionStatus> getBioTransactionStatusChoices() {
        Criteria criteria = getSession().createCriteria(BioTransactionStatus.class);
        // remove Initial Quantity status choice because this is reserved
        criteria.add(
                Restrictions.ne("name", au.org.theark.lims.web.Constants.BIOTRANSACTION_STATUS_INITIAL_QUANTITY));
        return criteria.list();
    }

    public BioTransactionStatus getBioTransactionStatusByName(String statusName) {
        Criteria criteria = getSession().createCriteria(BioTransactionStatus.class);
        criteria.add(Restrictions.eq("name", statusName));
        BioTransactionStatus result = (BioTransactionStatus) criteria.uniqueResult();
        return result;
    }

    public List<AccessRequest> getAccessRequests() {
        Criteria criteria = getSession().createCriteria(AccessRequest.class);
        return criteria.list();
    }

    public List<BioTransaction> getAllBiotransactionForBiospecimen(Biospecimen biospecimen) {
        Criteria criteria = getSession().createCriteria(BioTransaction.class);
        criteria.add(Restrictions.eq("biospecimen", biospecimen));
        List<BioTransaction> result = (List<BioTransaction>) criteria.list();
        return result;
    }
}