/*
 * Copyright (C) 2003 Erik Swenson - erik@oreports.com
 * 
 * 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 (at your option)
 * any later version.
 * 
 * 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 reserved 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.
 *  
 */

package org.efs.openreports.providers.impl;

import java.util.List;

import org.apache.log4j.Logger;
import org.efs.openreports.objects.ReportChart;
import org.efs.openreports.providers.ChartProvider;
import org.efs.openreports.providers.HibernateProvider;
import org.efs.openreports.providers.ProviderException;
import org.efs.openreports.util.ConstraintException;
import org.efs.openreports.util.LocalStrings;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

public class ChartProviderImpl
	implements ChartProvider
{
	protected static Logger log =
		Logger.getLogger(ChartProviderImpl.class.getName());
	
	private HibernateProvider hibernateProvider;
	
	public ChartProviderImpl(HibernateProvider hibernateProvider) throws ProviderException
	{		
		this.hibernateProvider = hibernateProvider;
		log.info("Created");
	}

	public ReportChart getReportChart(Integer id)
		throws ProviderException
	{
		return (ReportChart) hibernateProvider.load(ReportChart.class, id);
	}
	
	public ReportChart getReportChart(String name)
		throws ProviderException
	{
		Session session = null;
		
		try
		{
			session = hibernateProvider.openSession();
			
			Criteria criteria = session.createCriteria(ReportChart.class);
			criteria.add(Restrictions.eq("name", name));
			
			return (ReportChart) criteria.uniqueResult();
		}
		catch (HibernateException he)
		{
			throw new ProviderException(he);
		}
		finally
		{
			hibernateProvider.closeSession(session);
		}
	}
	
	@SuppressWarnings("unchecked")
	public List<ReportChart> getReportCharts() throws ProviderException
	{
		String fromClause =
			"from org.efs.openreports.objects.ReportChart reportChart order by reportChart.name ";
		
		return (List<ReportChart>) hibernateProvider.query(fromClause);
	}
	
	public ReportChart insertReportChart(ReportChart reportChart)
		throws ProviderException
	{
		return (ReportChart) hibernateProvider.save(reportChart);
	}
	
	public void updateReportChart(ReportChart reportChart)
		throws ProviderException
	{
		hibernateProvider.update(reportChart);
	}
	
	public void deleteReportChart(ReportChart reportChart)
		throws ProviderException
	{
		try
		{
			hibernateProvider.delete(reportChart);
		}
		catch (ConstraintException ce)
		{
			throw new ProviderException(LocalStrings.ERROR_CHART_DELETION);
		}
	}	
}