/*
    * 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.notes.dao.impl;
  
  import java.util.List;
  
  import javax.persistence.EntityManager;
  import javax.persistence.PersistenceContext;
  import javax.persistence.Query;
  
  import org.kuali.rice.core.util.OrmUtils;
  import org.kuali.rice.kew.notes.Attachment;
  import org.kuali.rice.kew.notes.Note;
  import org.kuali.rice.kew.notes.dao.NoteDAO;
  
  
  public class NoteDAOJpaImpl implements NoteDAO {
  
  	@PersistenceContext(unitName="kew-unit")
  	EntityManager entityManager;
  	
      public Note getNoteByNoteId(Long noteId) {
      	Query query = entityManager.createNamedQuery("KewNote.FindNoteByNoteId");
      	query.setParameter("noteId", noteId);
          return (Note) query.getSingleResult();          
      }
  
      public List getNotesByRouteHeaderId(Long routeHeaderId) {
      	Query query = entityManager.createNamedQuery("KewNote.FindNoteByRouteHeaderId");
      	query.setParameter("routeHeaderId", routeHeaderId);
          return (List) query.getResultList();        
      }
      
      public void saveNote(Note note) {
      	if (note.getNoteId() == null){
      		entityManager.persist(note);
      	} else {
      		entityManager.merge(note);
      	}
      }
  
      public void deleteNote(Note note) {
      	Note n = getNoteByNoteId(note.getNoteId());
      	OrmUtils.merge(entityManager, n);
      	entityManager.remove(n);
      }
     
      public void deleteAttachment(Attachment attachment) {
      	Attachment a = findAttachment(attachment.getAttachmentId());
      	entityManager.remove(a);
      }
  
  	
      public Attachment findAttachment(Long attachmentId) {
      	Query query = entityManager.createNamedQuery("Attachment.FindAttachmentById");
      	query.setParameter("attachmentId", attachmentId);
      	return (Attachment)query.getSingleResult();
      }
  
      public EntityManager getEntityManager() {
          return this.entityManager;
      }
  
      public void setEntityManager(EntityManager entityManager) {
          this.entityManager = entityManager;
      }
  
  }