package LOGIC;

import javax.sql.DataSource;

import org.apache.struts.upload.FormFile;

import COMMON.ReturnValue;
import COMMON.SystemConstants;
import DB.GBS_TPresentation_DB;

/**
 * GBS_PresentationsubActionLogic implements SystemConstants 
 * created on 11-08-2004
 * @author mxx
 * @version  1.0
 */

public class GBS_PresentationsubActionLogic implements SystemConstants {
	private DataSource datasource = null;

/**
 * method GBS_PresentationsubActionLogic 
 * @param datasource
 * @return
 * @throws Exception
 */	
	public GBS_PresentationsubActionLogic(DataSource datasource) {
	  this.datasource = datasource;
	}
/**
 * method getPresentationByKey 
 * @param strCustomerId
 * @param strRfpNo
 * @param strLineNo
 * @return ReturnValue
 * @throws Exception
 */	
	
	public ReturnValue getPresentationByKey(String strCustomerId,
											String strRfpNo ,
											String strLineNo) throws Exception {
		GBS_TPresentation_DB tPresentation_DB = new GBS_TPresentation_DB(this.datasource);
		ReturnValue returnValue = tPresentation_DB.selPresentationByKey(strCustomerId,strRfpNo,strLineNo);
		return  returnValue;
	}
/**
 * method insertPresentation 
 * @param strCustomerId
 * @param strRfpNo
 * @param strListener
 * @param strTitle
 * @param strPresentationDate
 * @param strPresentationBy
 * @param strCreateUser
 * @param attachmentFile
 * @return ReturnValue
 * @throws Exception
 */

public ReturnValue insertPresentation(
	String strCustomerId,
	String strRfpNo,
	String strListener,
	String strTitle,
	String strPresentationDate,
	String strPresentationBy,
	String strCreateUser,
	FormFile attachmentFile)
	throws Exception {
	GBS_TPresentation_DB tPresentation_DB = new GBS_TPresentation_DB(this.datasource);
	return tPresentation_DB.insertPresentation(
		strCustomerId,
		strRfpNo,
		strListener,
		strTitle,
		strPresentationDate,
		strPresentationBy,
		strCreateUser,
		attachmentFile);

}
	
/**
 * method updatePresentation 
 * @param strCustomerId
 * @param strRfpNo
 * @param strLineNo
 * @param strTitle
 * @param strPresentationDate
 * @param strPresentationBy
 * @param strCreateUser
 * @param attachmentFile
 * @param FileDelete
 * @return ReturnValue
 * @throws Exception
 */	
	public ReturnValue updatePresentation( String strCustomerId,
								String strRfpNo,
								String strLineNo,
								String strTitle,
								String strPresentationDate,
								String strPresentationBy,
								String strListener,
								String strUpdateUser,
							    FormFile attachmentFile,
								boolean FileDelete) throws Exception {
		//byte[] data = null;
		int ret = 0;
		ReturnValue returnValue;
		GBS_TPresentation_DB tPresentation_DB = new GBS_TPresentation_DB(this.datasource);	
		
		returnValue = tPresentation_DB.updatePresentation(	strCustomerId,
															strRfpNo,
															strLineNo,
															strTitle,
															strPresentationDate,
															strPresentationBy,
															strListener,
															strUpdateUser,
															attachmentFile,
															FileDelete);
		
		return returnValue;
	}
	
		
/**
 * method deletePresentation 
 * @param strCustomerId
 * @param strRfpNo
 * @param strLineNo
 * @return ReturnValue
 * @throws Exception
 */	
	public ReturnValue deletePresentation(	String strCustomerId,
											String strRfpNo,
											String strLineNo) throws Exception {
		GBS_TPresentation_DB tPresentation_DB = new GBS_TPresentation_DB(this.datasource);	
		return tPresentation_DB.deletePresentation(strCustomerId,strRfpNo,strLineNo);
	}
}