/*
* (non-Javadoc)
* @see com.csit.dao.CompetitionPhotoDAO#getTotalCount(com.csit.model.CompetitionPhoto)
*/
@Override
public Long getTotalCount(CompetitionPhoto model) {
Criteria criteria = getCurrentSession().createCriteria(CompetitionPhoto.class);
if (model != null
&& model.getCompetition() != null
&& model.getCompetition().getCompetitionId() != null) {
criteria.add(Restrictions.eq("competition", model.getCompetition()));
}
if (StringUtils.isNotEmpty(model.getPhotoType())) {
criteria.add(Restrictions.eq("photoType", model.getPhotoType()));
}
criteria.setProjection(Projections.rowCount());
return new Long(criteria.uniqueResult().toString());
}
/*
* (non-Javadoc)
* @see com.csit.dao.CompetitionPhotoDAO#query(com.csit.model.CompetitionPhoto, java.lang.Integer, java.lang.Integer)
*/
@SuppressWarnings("unchecked")
@Override
public List<CompetitionPhoto> query(CompetitionPhoto model, Integer page, Integer rows) {
Criteria criteria = getCurrentSession().createCriteria(CompetitionPhoto.class);
if (model != null
&& model.getCompetition() != null
&& model.getCompetition().getCompetitionId() != null) {
criteria.add(Restrictions.eq("competition", model.getCompetition()));
}
if (StringUtils.isNotEmpty(model.getPhotoType())) {
criteria.add(Restrictions.eq("photoType", model.getPhotoType()));
}
criteria.setFirstResult(PageUtil.getPageBegin(page, rows));
criteria.setMaxResults(rows);
criteria.addOrder(Order.desc("array"));
return criteria.list();
}
