/*
 * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/AttachmentDAO.java,v 1.4 2004/04/30 03:38:17 drjavanomous Exp $
 * $Author: drjavanomous $
 * $Revision: 1.4 $
 * $Date: 2004/04/30 03:38:17 $
 *
 * ====================================================================
 *
 * Copyright (C) 2002-2004 by MyVietnam.net
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or any later version.
 *
 * All copyright notices regarding mvnForum MUST remain intact
 * in the scripts and in the outputted HTML.
 * The "powered by" text/logo with a link back to
 * http://www.mvnForum.com and http://www.MyVietnam.net in the
 * footer of the pages MUST remain visible when the pages
 * are viewed on the internet or intranet.
 *
 * 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 * Support can be obtained from support forums at:
 * http://www.mvnForum.com/mvnforum/index
 *
 * Correspondence and Marketing Questions can be sent to:
 * info@MyVietnam.net
 *
 * @author: Minh Nguyen  minhnn@MyVietnam.net
 */
package com.mvnforum.db;

import java.sql.Timestamp;
import java.util.Collection;

import net.myvietnam.mvncore.exception.AssertionException;
import net.myvietnam.mvncore.exception.CreateException;
import net.myvietnam.mvncore.exception.DatabaseException;
import net.myvietnam.mvncore.exception.ObjectNotFoundException;
import net.myvietnam.mvncore.exception.ForeignKeyNotFoundException;

public interface AttachmentDAO {

    public static final String TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "Attachment";

    public void create(int postID, int memberID, String attachFilename,
                        int attachFileSize, String attachMimeType, String attachDesc,
                        String attachCreationIP, Timestamp attachCreationDate, Timestamp attachModifiedDate,
                        int attachDownloadCount, int attachOption, int attachStatus)
         throws CreateException, DatabaseException, ForeignKeyNotFoundException;

    public int createAttachment(int postID, int memberID, String attachFilename,
                         int attachFileSize, String attachMimeType, String attachDesc,
                         String attachCreationIP, Timestamp attachCreationDate, Timestamp attachModifiedDate,
                         int attachDownloadCount, int attachOption, int attachStatus)
                         throws CreateException, DatabaseException, ForeignKeyNotFoundException, ObjectNotFoundException;

    public void delete(int attachID)
         throws DatabaseException, ObjectNotFoundException;

    public AttachmentBean getBean(int attachID)
         throws ObjectNotFoundException, DatabaseException;

     public Collection getBeans()
         throws DatabaseException;

     public int getNumberOfBeans()
         throws AssertionException, DatabaseException;

     public int getNumberOfBeans_inPost(int postID)
         throws AssertionException, DatabaseException;

     public void delete_inPost(int postID)
         throws DatabaseException;

     public Collection getBeans_inPost(int postID)
         throws DatabaseException;

     public Collection getBeans_inThread(int threadID)
         throws DatabaseException;

     public Collection getBeans_inForum(int forumID)
         throws DatabaseException;

     public void increaseDownloadCount(int attachID)
         throws DatabaseException, ObjectNotFoundException;

}