/*

  * Copyright 2005-2007 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 org.apache.ojb.broker.query.Criteria;

 import org.apache.ojb.broker.query.QueryByCriteria;

 import org.kuali.rice.kew.notes.Attachment;

 import org.kuali.rice.kew.notes.Note;

 import org.kuali.rice.kew.notes.dao.NoteDAO;

 import org.springmodules.orm.ojb.support.PersistenceBrokerDaoSupport;

 public class NoteDAOOjbImpl extends PersistenceBrokerDaoSupport implements NoteDAO {

     public Note getNoteByNoteId(Long noteId) {

         Criteria crit = new Criteria();

         crit.addEqualTo("noteId", noteId);

         return (Note) this.getPersistenceBrokerTemplate().getObjectByQuery(new QueryByCriteria(Note.class, crit));          

     }

     public List getNotesByRouteHeaderId(Long routeHeaderId) {

         Criteria crit = new Criteria();

         crit.addEqualTo("routeHeaderId", routeHeaderId);

         QueryByCriteria query = new QueryByCriteria(Note.class, crit);

         query.addOrderByAscending("noteId");

         return (List) this.getPersistenceBrokerTemplate().getCollectionByQuery(query);        

     }

     public void saveNote(Note note) {

             this.getPersistenceBrokerTemplate().store(note);    

     }

     public void deleteNote(Note note) {

         Criteria crit = new Criteria();

         crit.addEqualTo("noteId", note.getNoteId());

         this.getPersistenceBrokerTemplate().deleteByQuery(new QueryByCriteria(Note.class, crit));

     }

     public void deleteAttachment(Attachment attachment) {

             Criteria crit = new Criteria();

             crit.addEqualTo("attachmentId", attachment.getAttachmentId());

             this.getPersistenceBrokerTemplate().deleteByQuery(new QueryByCriteria(Attachment.class, crit));

     }

     public Attachment findAttachment(Long attachmentId) {

             Criteria crit = new Criteria();

             crit.addEqualTo("attachmentId", attachmentId);

             return (Attachment)this.getPersistenceBrokerTemplate().getObjectByQuery(new QueryByCriteria(Attachment.class, crit));

     }

 }