@SuppressWarnings("unchecked")
 @Override
 public List<Cotizacion> obtenerCotizacionCliente(Cliente cli) {
   Session session = HibernateUtil.getSessionFactory().openSession();
   Query q = session.createQuery("from Cotizacion as c where cliente.dni=:dni ");
   q.setInteger("dni", cli.getDni());
   return q.list();
 }
  @Override
  public void update(Cotizacion c) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    session.beginTransaction();

    session.update(c);

    session.flush();
    session.getTransaction().commit();
    session.close();
  }
  @Override
  public Cotizacion findById(Integer id) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    String hql = "from Cotizacion c where c.id = :id";
    Query query = session.createQuery(hql);
    query.setParameter("id", id);

    Cotizacion c = (Cotizacion) query.uniqueResult();
    session.close();
    return c;
  }