package com.flight.dao.impl;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.flight.dao.FlightDao;
import com.flight.entity.Airports;
import com.flight.entity.FlightTickets;
import com.flight.entity.Flights;

public class FlightDaoImpl extends HibernateDaoSupport implements FlightDao{

	public List<Flights> findAllSearch(DetachedCriteria dc) {
		// TODO Auto-generated method stub
		return dc.getExecutableCriteria(getHibernateTemplate()
				.getSessionFactory()
				.openSession()).list();
	}

	public FlightTickets findIdByFlightTicketsInfo(final int id) {
		// TODO Auto-generated method stub
		return (FlightTickets) getHibernateTemplate().execute(new HibernateCallback() {
			
			public Object doInHibernate(Session session) throws HibernateException,
					SQLException {
				// TODO Auto-generated method stub
				return session.createQuery("from FlightTickets where id=:id")
						.setParameter("id", id)
						.uniqueResult();
			}
		});
	}

	public Airports findIdByAirportsInfo(final int id) {
		// TODO Auto-generated method stub
		return (Airports) getHibernateTemplate().execute(new HibernateCallback() {
			
			public Object doInHibernate(Session session) throws HibernateException,
					SQLException {
				// TODO Auto-generated method stub
				return session.createQuery("from Airports where id=:id")
						.setParameter("id", id)
						.uniqueResult();
			}
		});
	}

	public List<Flights> findAllflight() {
		// TODO Auto-generated method stub
		return getHibernateTemplate().find("from Flights");
	}

}