Example usage for org.hibernate Criteria add

Introduction

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

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public long getBiospecimenCustomFieldDataCount(Biospecimen biospecimenCriteria, ArkFunction arkFunction) {
    Criteria criteria = getSession().createCriteria(CustomFieldDisplay.class);
    criteria.createAlias("customField", "cfield");

    // Allow child studies to inherit parent defined custom fields
    List studyList = new ArrayList();
    studyList.add(biospecimenCriteria.getStudy());
    if (biospecimenCriteria.getStudy().getParentStudy() != null
            && biospecimenCriteria.getStudy().getParentStudy() != biospecimenCriteria.getStudy()) {
        studyList.add(biospecimenCriteria.getStudy().getParentStudy());
    }//from w ww . ja v a2s .c  o  m

    criteria.add(Restrictions.in("cfield.study", studyList));
    criteria.add(Restrictions.eq("cfield.arkFunction", arkFunction));
    criteria.setProjection(Projections.rowCount());
    return (Long) criteria.uniqueResult();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public Double getQuantityAvailable(Biospecimen biospecimen) {
    Criteria criteria = getSession().createCriteria(BioTransaction.class);
    criteria.add(Restrictions.eq("biospecimen", biospecimen));
    criteria.setProjection(Projections.sum("quantity"));
    Double sum = (Double) criteria.uniqueResult();
    return sum;//from w ww.  j a v  a 2  s  . co  m
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public BiospecimenUidTemplate getBiospecimenUidTemplate(Study study) {
    Criteria criteria = getSession().createCriteria(BiospecimenUidTemplate.class);
    criteria.add(Restrictions.eq("study", study));
    BiospecimenUidTemplate biospecimenUidTemplate = (BiospecimenUidTemplate) criteria.uniqueResult();
    return biospecimenUidTemplate;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

protected BiospecimenUidSequence getBiospecimenUidSequence(Study study) {
    // Stateless sessions should be used to avoid locking the record for future update
    // by getSession(), which relies on the "open session filter" mechanism
    StatelessSession session = getStatelessSession();
    Criteria criteria = session.createCriteria(BiospecimenUidSequence.class);
    criteria.add(Restrictions.eq(Constants.SUBJECTUIDSEQ_STUDYNAMEID, study.getName()));
    criteria.setMaxResults(1);//w  ww  . j a  v  a  2 s . c o  m
    BiospecimenUidSequence result = (BiospecimenUidSequence) criteria.uniqueResult();
    session.close();
    return result;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public boolean studyHasBiospecimens(Study study) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("study", study));
    criteria.setProjection(Projections.count("id"));
    Long count = (Long) criteria.uniqueResult();
    return count > 0;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public BioSampletype getBioSampleTypeByName(String name) {
    Criteria criteria = getSession().createCriteria(BioSampletype.class);
    criteria.add(Restrictions.eq("name", name));
    return (BioSampletype) criteria.uniqueResult();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public TreatmentType getTreatmentTypeByName(String name) {
    Criteria criteria = getSession().createCriteria(TreatmentType.class);
    criteria.add(Restrictions.eq("name", name));
    return (TreatmentType) criteria.uniqueResult();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public Unit getUnitByName(String name) {
    Criteria criteria = getSession().createCriteria(Unit.class);
    criteria.add(Restrictions.eq("name", name));
    return (Unit) criteria.uniqueResult();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public List<Biospecimen> getBiospecimenByBioCollection(BioCollection bioCollection) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("bioCollection", bioCollection));
    return criteria.list();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public Biospecimen getBiospecimenByUid(String biospecimenUid, final Study study) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("biospecimenUid", biospecimenUid));
    if (study != null) {
        criteria.add(Restrictions.eq("study", study));
    }/*from   w w  w  .j  a v  a  2  s.  c om*/
    return (Biospecimen) criteria.uniqueResult();
}