package com.dao;

import java.util.List;
import java.util.Set;

import org.hibernate.*;

import com.hibernate.HibernateUtils;
import com.model.Users;

public class UserDaoImple implements UserDao {

	public Users getUserById(int id) {
		Session session = HibernateUtils.getSession();
		session.beginTransaction();
		Users user = (Users)session.load(Users.class, id);
		session.getTransaction().commit();
		HibernateUtils.closeSession();
		return user;
	}

	@SuppressWarnings("unchecked")
	public Users getUserByName(String name) {
		Session session = HibernateUtils.getSession();
		session.beginTransaction();
		Users user = null;
		List list =  session.createQuery("from Users WHERE name=?")
		                     .setParameter(0, name)
		                     .list();
	
			if(list.size() != 0) user = (Users)list.get(0);
			
		session.getTransaction().commit();
		HibernateUtils.closeSession();
		
		return user;
	}

	public Set getMessagesByUsername(String name) {
		Session session = HibernateUtils.getSession();
		session.beginTransaction();
		Set set;
		Users user = null;
		List list =  session.createQuery("from Users WHERE name=?")
		                     .setParameter(0, name)
		                     .list();
	
			if(list.size() != 0) user = (Users)list.get(0);
			set = user.getMessages();
		session.getTransaction().commit();
		HibernateUtils.closeSession();
		
		return set;
	}

}