/*

  * Copyright 2005-2008 The Kuali Foundation

  *

  *

  * Licensed under the Educational Community License, Version 2.0 (the "License");

  * you may not use this file except in compliance with the License.

  * You may obtain a copy of the License at

  *

  * http://www.opensource.org/licenses/ecl2.php

  *

  * Unless required by applicable law or agreed to in writing, software

  * distributed under the License is distributed on an "AS IS" BASIS,

  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

  * See the License for the specific language governing permissions and

  * limitations under the License.

  */

 package org.kuali.rice.kew.useroptions.dao.impl;

 import org.kuali.rice.core.api.resourceloader.GlobalResourceLoader;

 import org.kuali.rice.core.api.util.RiceConstants;

 import org.kuali.rice.core.framework.persistence.platform.DatabasePlatform;

 import org.kuali.rice.kew.useroptions.UserOptions;

 import org.kuali.rice.kew.useroptions.dao.UserOptionsDAO;

 import javax.persistence.EntityManager;

 import javax.persistence.PersistenceContext;

 import java.util.ArrayList;

 import java.util.Collection;

 import java.util.List;

 public class UserOptionsDaoJpaImpl implements UserOptionsDAO {

     @PersistenceContext

     private EntityManager entityManager;

         public Long getNewOptionIdForActionList() {

         return getPlatform().getNextValSQL("KREW_ACTN_LIST_OPTN_S", entityManager);

     }

         protected DatabasePlatform getPlatform() {

             return (DatabasePlatform) GlobalResourceLoader.getService(RiceConstants.DB_PLATFORM);

     }

     public List findByUserQualified(String principalId, String likeString) {

         return new ArrayList(entityManager.createNamedQuery("UserOptions.FindByUserQualified").setParameter("workflowId", principalId).setParameter("optionId", likeString).getResultList());

     }

     public void deleteByUserQualified(String principalId, String likeString) {

         List<UserOptions> userOptions = (List<UserOptions>) entityManager.createNamedQuery("UserOptions.FindByUserQualified").setParameter("workflowId", principalId).setParameter("optionId", likeString).getResultList();

         for (UserOptions uo : userOptions) {

             entityManager.remove(uo);

         }

     }

     public Collection findByWorkflowUser(String principalId) {

         return entityManager.createNamedQuery("UserOptions.FindByWorkflowId").setParameter("workflowId", principalId).getResultList();

     }

     public void save(UserOptions userOptions) {

         if (userOptions.getOptionId() == null) {

             entityManager.persist(userOptions);

         } else {

             entityManager.merge(userOptions);

         }

     }

     public void save(Collection<UserOptions> userOptions) {

             if (userOptions != null) for (UserOptions option : userOptions) {

                         save(option);

                 }

     }

     public void deleteUserOptions(UserOptions userOptions) {

         UserOptions reattatched = entityManager.merge(userOptions);

         entityManager.remove(reattatched);

     }

     public UserOptions findByOptionId(String optionId, String principalId) {

         return (UserOptions) entityManager.createNamedQuery("UserOptions.FindByOptionId").setParameter("optionId", optionId).setParameter("workflowId", principalId).getSingleResult();

     }

     public Collection findByOptionValue(String optionId, String optionValue) {

         return entityManager.createNamedQuery("UserOptions.FindByOptionValue").setParameter("optionId", optionId).setParameter("optionValue", optionValue).getResultList();

     }

     public EntityManager getEntityManager() {

         return this.entityManager;

     }

     public void setEntityManager(EntityManager entityManager) {

         this.entityManager = entityManager;

     }

 }