package org.video.dao;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.video.vo.Person;

public class PersonDao implements Serializable {
	private Session session;
	public PersonDao() {
		session = HibernateUtil.getSessionFactory().getCurrentSession();
	}
	
	public void storePerson(Person p) {
        session.beginTransaction();
        session.save(p);        
        session.getTransaction().commit();
	}
	
	public void createAndStorePerson(String name, String lastname) {
        session.beginTransaction();
        Person p = new Person();
        p.setName(name);
        p.setLastname(lastname);
        session.save(p);        
        session.getTransaction().commit();
    }
	
	public Person findPerson(String lastName, String name) {
		session.beginTransaction();
		
        Person cats = (Person) session.createCriteria(Person.class)
        .add( Restrictions.like("lastname", lastName) )
        .add( Restrictions.like("name", name) )
        .uniqueResult();
        
        session.getTransaction().commit();
        
        return cats;
    }
	
	public List<Person> getAllPerson() {
		session.beginTransaction();   
		Criteria crit = session.createCriteria(Person.class);
		crit.setMaxResults(50);
		List cats = crit.list();
		session.getTransaction().commit(); 
		return cats;
	}
    public void update(Person p){
        session.beginTransaction();      
        session.update(p);        
        session.getTransaction().commit();        
      }
    
	public void deletePerson(Person p) {
		session.beginTransaction();
		session.delete(p);
		session.getTransaction().commit();
	}
}