public boolean insertChangeRequest(ChangesOfProjectPlan changeRequest) {
   try {
     SessionFactory sessfac = HibernateUtil.getSessionFactory();
     session = sessfac.openSession();
     tx = session.beginTransaction();
     session.save(changeRequest);
     tx.commit();
     sessfac.close();
   } catch (Exception e) {
     log.error("Insert ko duoc");
     log.error(e.getMessage());
     return false;
   }
   log.error("Insert ngon");
   return true;
 }
  public List<ChangesOfProjectPlan> getProjectChangeRequestList(Project project) {
    try {
      SessionFactory sessionfactory = HibernateUtil.getSessionFactory();
      session = sessionfactory.openSession();
      session.beginTransaction();
      String hql = "From ChangesOfProjectPlan where project = :projectId";
      Query query = session.createQuery(hql);
      query.setParameter("projectId", project);
      List<ChangesOfProjectPlan> changeRequestList = query.list();
      session.getTransaction().commit();
      return changeRequestList;

    } catch (Exception e) {
      log.error(e.getMessage());
    }
    return null;
  }
  public Ncconstant getChangeRequestStatus(String Id) {
    try {
      SessionFactory sessionfactory = HibernateUtil.getSessionFactory();
      session = sessionfactory.openSession();
      session.beginTransaction();
      String hql = "From Ncconstant where constantid = :constantid";
      Query query = session.createQuery(hql);
      query.setParameter("constantid", new BigDecimal(Id));
      Ncconstant status = (Ncconstant) query.uniqueResult();
      session.flush();
      session.getTransaction().commit();
      return status;

    } catch (Exception e) {
      log.error(e.getMessage());
    }
    return null;
  }
  public List<Ncconstant> getStatusList() {
    try {
      SessionFactory sessionfactory = HibernateUtil.getSessionFactory();
      session = sessionfactory.openSession();
      session.beginTransaction();
      String hql = "From Ncconstant where type = :stype";
      Query query = session.createQuery(hql);
      query.setParameter("stype", "Status");
      List<Ncconstant> statusList = query.list();
      session.flush();
      session.getTransaction().commit();
      log.error("Issue Status Count : " + statusList.size());
      return statusList;

    } catch (Exception e) {
      log.error(e.getMessage());
    }
    return null;
  }