Controller
/*ingresar nueva categoria*/
public void createCategory() {
FacesContext context = FacesContext.getCurrentInstance();
CategoryDao dao = new CategoryDao();
if (dao.create(cat)) {
RequestContext.getCurrentInstance().execute("PF('Wnew').hide();");
RequestContext.getCurrentInstance().execute("newCategory();");
context.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "EXITO", "Categoria guardada"));
} else {
context.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "ERROR", "No se pudo gaurdar la categoria"));
}
}
//BUSCAR CATEGORIA
public void find(int id) {
CategoryDao dao = new CategoryDao();
cat = dao.find(id);
}
/*actualizar una categoria*/
public void editCategory() {
FacesContext context = FacesContext.getCurrentInstance();
CategoryDao dao = new CategoryDao();
if (dao.edit(cat)) {
RequestContext.getCurrentInstance().execute("PF('Wedit').hide();");
context.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "EXITO", "Categoria actualizada"));
} else {
context.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "ERROR", "No se pudo actualizada categoria"));
}
}
//LISTA DE CATEGORIA POR ID
private List<ViewProductCategory> listInventory;
public List<ViewProductCategory> getListInventory() {
InventoryCategoryListDao dao = new InventoryCategoryListDao();
return dao.findAllByCategory(idCategory);
}
DAO
public class CategoryDao {
EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();
/*método para listar las categorias*/
public List<DboCategory> finAll() {
Query query = em.createNamedQuery("DboCategory.findAll");
return query.getResultList();
}
/*buscar categoria por ID*/
public DboCategory find(int id) {
return em.find(DboCategory.class, id);
}
/*gaurdar una categoria*/
public boolean create(DboCategory c) {
boolean flag = false;
try {
em.getTransaction().begin();
em.persist(c);
em.getTransaction().commit();
flag = true;
} catch (Exception e) {
em.getTransaction().rollback();
} finally {
em.close();
}
return flag;
}
/* EDITAR CATEGORIA */
public boolean edit(DboCategory c) {
boolean flag = false;
try {
em.getTransaction().begin();
em.merge(c);
em.getTransaction().commit();
flag = true;
} catch (Exception e) {
em.getTransaction().rollback();
} finally {
em.close();
}
return flag;
}
/*eliminar una categoria*/
public boolean remove(int id) {
boolean flag = false;
try {
em.getTransaction().begin();
em.remove(em.find(DboCategory.class, id));
em.getTransaction().commit();
flag = true;
} catch (Exception e) {
em.getTransaction().rollback();
} finally {
em.close();
}
return flag;
}
}
jpaUtil
public class JPAUtil {
private static final String PERSISTENCE_UNIT_NAME = "misePU";
private static EntityManagerFactory factory;
public static EntityManagerFactory getEntityManagerFactory() {
if (factory == null) {
factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
}
return factory;
}
}
