/*
* This file is part of LibrePlan
*
* Copyright (C) 2009-2010 Fundación para o Fomento da Calidade Industrial e
* Desenvolvemento Tecnolóxico de Galicia
* Copyright (C) 2010-2011 Igalia, S.L.
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program 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 Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package org.libreplan.business.users.daos;
import java.util.Collections;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.libreplan.business.common.daos.GenericDAOHibernate;
import org.libreplan.business.common.exceptions.InstanceNotFoundException;
import org.libreplan.business.common.exceptions.ValidationException;
import org.libreplan.business.users.entities.OrderAuthorization;
import org.libreplan.business.users.entities.Profile;
import org.libreplan.business.users.entities.ProfileOrderAuthorization;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
/**
* Hibernate DAO for the <code>Profile</code> entity.
*
* @author Jacobo Aragunde Perez <jaragunde@igalia.com>
* @author Diego Pino García <dpino@igalia.com>
*/
@Repository
public class ProfileDAO extends GenericDAOHibernate<Profile, Long> implements
IProfileDAO {
@Override
public boolean existsByProfileName(String profileName) {
try {
findByProfileName(profileName);
return true;
}
catch (InstanceNotFoundException e) {
return false;
}
}
@Override
@Transactional(readOnly = true, propagation = Propagation.REQUIRES_NEW)
public boolean existsByProfileNameAnotherTransaction(String profileName) {
return existsByProfileName(profileName);
}
@Override
@Transactional(readOnly = true)
public Profile findByProfileName(String profileName)
throws InstanceNotFoundException{
Criteria c = getSession().createCriteria(Profile.class);
c.add(Restrictions.eq("profileName", profileName).ignoreCase());
Profile profile = (Profile) c.uniqueResult();
if (profile == null) {
throw new InstanceNotFoundException(profileName,
Profile.class.getName());
} else {
return profile;
}
}
@Override
@Transactional(readOnly = true, propagation = Propagation.REQUIRES_NEW)
public Profile findByProfileNameAnotherTransaction(String profileName)
throws InstanceNotFoundException {
return findByProfileName(profileName);
}
@Override
public List<OrderAuthorization> getOrderAuthorizationsByProfile(Profile profile) {
List orderAuthorizations = getSession()
.createCriteria(ProfileOrderAuthorization.class)
.add(Restrictions.eq("profile", profile)).list();
return orderAuthorizations;
}
@Override
public void checkHasUsers(Profile profile) throws ValidationException {
// Query against a collection of elements
// http://community.jboss.org/message/353859#353859
Query query = getSession().createQuery(
"FROM User user JOIN user.profiles up WHERE up IN (:profiles)");
query.setParameterList("profiles", Collections.singleton(profile));
if (!query.list().isEmpty()) {
throw ValidationException
.invalidValueException(
"Cannot delete profile. It is being used at this moment by some users.",
profile);
}
}
@Override
@Transactional(readOnly = true)
public Profile findByProfileNameLoadingRoles(String profileName)
throws InstanceNotFoundException {
Profile profile = findByProfileName(profileName);
profile.getRoles().size();
return profile;
}
@Override
public List<Profile> listSorted() {
Criteria c = getSession().createCriteria(Profile.class).addOrder(
Order.asc("profileName"));
return c.list();
}
}