autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java Source code

Introduction

Here is the source code for autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package autoancillarieslimited.hiberate.dao;

import autoancillarieslimited.hiberate.entities.PurchaseOrder;
import autoancillarieslimited.hiberate.util.HibernateUtil;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 *
 * @author Duc
 */
public class PurchaseOrderDAO extends AbstractDao<PurchaseOrder> {

    private static PurchaseOrderDAO INSTANCE;

    public static PurchaseOrderDAO getInstance() {
        if (INSTANCE == null) {
            INSTANCE = new PurchaseOrderDAO();
        }
        return INSTANCE;
    }

    private static int pageSize = 10;

    public List<PurchaseOrder> getListByIDCustomer(int id) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session
                    .createQuery("from PurchaseOrder where ID_Customer like '" + id + "' ORDER BY dateOrder DESC")
                    .list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDCustomer(int id, String dateFrom, String dateTo) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder where ID_Customer like '" + id + "' AND Date_Order >='"
                    + dateFrom + "' AND Date_Order <='" + dateTo + "'  ORDER BY dateOrder DESC").list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDCustomer(int id, String dateFrom, String dateTo, String status) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder where ID_Customer like '" + id + "' AND Status like '"
                    + status + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo
                    + "' ORDER BY dateOrder DESC").list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDCustomer(int id, String status) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery(
                    "from PurchaseOrder where ID_Customer like '" + id + "' AND Status like '" + status + "'")
                    .list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDWarehouse(int id) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder where ID_Warehouse like '" + id + "'").list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String dateFrom, String dateTo, String status) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session
                    .createQuery("from PurchaseOrder where ID_Warehouse like '" + id_wh + "' AND Status like '"
                            + status + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                    .list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String status) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery(
                    "from PurchaseOrder where ID_Warehouse like '" + id_wh + "' AND Status like '" + status + "'")
                    .list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String dateFrom, String dateTo) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder where ID_Warehouse like '" + id_wh
                    + "'  AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'").list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }
    //admin

    public List<PurchaseOrder> getListByAdmin(int pageNumber) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder").setFirstResult((pageNumber - 1) * pageSize)
                    .setMaxResults(pageSize).list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, String status, String warehouse,
            int pageNumber) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session
                    .createQuery("from PurchaseOrder where ID_Warehouse like '" + warehouse + "' AND Status like '"
                            + status + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                    .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByAdmin(String status, int pageNumber) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session.createQuery("from PurchaseOrder where Status like '" + status + "'")
                    .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, String warehouse, int pageNumber) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session
                    .createQuery("from PurchaseOrder where ID_Warehouse like '" + warehouse + "' AND Date_Order >='"
                            + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                    .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, int pageNumber) {
        List<PurchaseOrder> set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            set = session
                    .createQuery("from PurchaseOrder where Date_Order >='" + dateFrom + "' AND Date_Order <='"
                            + dateTo + "'")
                    .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return set;
    }

    public Long getCountOrder(String dateFrom, String dateTo, String status, String warehouse) {
        Long set = null;
        Session session = null;
        Transaction beginTransaction = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            beginTransaction = session.beginTransaction();
            if (dateFrom != null && dateTo != null && !dateFrom.equals("") && !dateTo.equals("") && status != null
                    && warehouse != null && !warehouse.equals("all")) {
                set = (Long) session.createQuery("select count(*) from PurchaseOrder where ID_Warehouse like '"
                        + warehouse + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo
                        + "' AND Status like '" + status + "'").uniqueResult();
            } else {
                if (dateFrom != null && dateTo != null && !dateFrom.equals("") && !dateTo.equals("")
                        && status != null) {
                    if (Integer.parseInt(status) != -1) {
                        set = (Long) session
                                .createQuery("select count(*) from PurchaseOrder where Date_Order >='" + dateFrom
                                        + "' AND Date_Order <='" + dateTo + "' AND Status like '" + status + "'")
                                .uniqueResult();
                    } else {
                        set = (Long) session.createQuery("select count(*) from PurchaseOrder where Date_Order >='"
                                + dateFrom + "' AND Date_Order <='" + dateTo + "'").uniqueResult();
                    }
                } else {
                    set = (Long) session.createQuery("select count(*) from PurchaseOrder").uniqueResult();
                }
            }
            session.flush();
            session.clear();
            session.getTransaction().commit();
        } catch (HibernateException ex) {
            ex.printStackTrace();
            if (beginTransaction != null) {
                beginTransaction.rollback();
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        long countPage = set / pageSize;
        if (set % pageSize > 0) {
            countPage++;
        }
        return countPage;
    }
}