package com.emis.model.store.hibernate;

import java.util.List;
import java.util.HashSet;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.emis.dbservice.hibernate.HibernateService;

public class ClientUtil {
	
	public static boolean insert(Client client) {
		Session session = null;
		Transaction transaction = null;
		boolean b = false;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			client.setStoreins(new HashSet());
			client.setStoreouts(new HashSet());
			session.save(client);
			transaction.commit();
			b = true;
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			b = false;
		} catch (Exception e) {
			e.printStackTrace();
			b = false;
		} finally {
			HibernateService.closeSession(session);
		}
		return b;
	}
	
	public static boolean update(String id,Client client) {
		Session session = null;
		Transaction transaction = null;
		boolean b = false;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			Client c = new Client();
			session.load(c, id);
			c.setAddress(client.getAddress());
			c.setFax(client.getFax());
			c.setName(client.getName());
			c.setPhone(client.getPhone());
			c.setRemarks(client.getRemarks());
			c.setType(client.getType());
			c.setZip(client.getZip());
			transaction.commit();
			b = true;
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			b = false;
		} catch (Exception e) {
			e.printStackTrace();
			b = false;
		} finally {
			HibernateService.closeSession(session);
		}
		return b;
	}
	
	public static List findAll() {
		Session session = null;
		Transaction transaction = null;
		java.util.List list = null;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			list = session.createQuery("from Client").list();
			transaction.commit();
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			list = null;
		} catch (Exception e) {
			e.printStackTrace();
			list = null;
		} finally {
			HibernateService.closeSession(session);
		}
		return list;
	}
	
	public static List findAll(String filter) {
		Session session = null;
		Transaction transaction = null;
		List list = null;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			list = session.createQuery("from Client where "+filter).list();
			transaction.commit();
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			list = null;
		} catch (Exception e) {
			e.printStackTrace();
			list = null;
		} finally {
			HibernateService.closeSession(session);
		}
		return list;
	}
	
	public static Client find(String id) {
		Client client = null;
		Session session = null;
		Transaction transaction = null;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			client = new Client();
			session.load(client, id);
			transaction.commit();
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			client = null;
		} catch (Exception e) {
			e.printStackTrace();
			client = null;
		} finally {
			HibernateService.closeSession(session);
		}
		return client;
	}
	
	public static boolean delete(String id) {
		Client client = null;
		Session session = null;
		Transaction transaction = null;
		boolean b = false;
		try {
			session = HibernateService.getSession();
			transaction = session.beginTransaction();
			client = new Client();
			session.load(client, id);
			client.getStoreins().clear();
			client.getStoreouts().clear();
			session.delete(client);
			transaction.commit();
			b = true;
		} catch (HibernateException he) {
			he.printStackTrace();
			HibernateService.rollbackTransaction(transaction);
			b = false;
		} catch (Exception e) {
			e.printStackTrace();
			b = false;
		} finally {
			HibernateService.closeSession(session);
		}
		return b;
	}
	
	 public static boolean addStoreins(String id, Storein storein) {
		 Session session = null;
		 Transaction transaction = null;
		 boolean b = false;
		 try {
			 session = HibernateService.getSession();
			 transaction = session.beginTransaction();
			 Client client = new Client();
			 session.load(client, id);
			 storein.setClient(client);
			 session.update(client);
			 transaction.commit();
			 b = true;
		 } catch (HibernateException he) {
			 he.printStackTrace();
			 HibernateService.rollbackTransaction(transaction);
			 b = false;
		 } catch (Exception e) {
			 e.printStackTrace();
			 b = false;
		 } finally {
			 HibernateService.closeSession(session);
		 } 
		 return b;
	 }
	 
	 public static boolean addStoreouts(String id, Storeout storeout) {
	        Transaction transaction = null;
	        Session session = null;
	        boolean b = false;
	        try {
	            session = HibernateService.getSession();
	            transaction = session.beginTransaction();
	            Client client = new Client();
	            session.load(client, id);
	            storeout.setClient(client);
	            session.update(client);
	            transaction.commit();
	            b = true;
	        } catch (HibernateException he) {
	            he.printStackTrace();
	            HibernateService.rollbackTransaction(transaction);
	            b = false;
	        } catch (Exception e) {
	            e.printStackTrace();
	            b = false;
	        } finally {
	            HibernateService.closeSession(session);    
	        }
	        return b;
	    }
}