public int editProduct(Myshopee_ProductTO productTO) throws Exception {
Myshopee_Product product = new Myshopee_Product();
product.setProductId(productTO.getProductId());
product.setProductName(productTO.getProductName());
product.setQtyInStock(productTO.getQtyInStock());
product.setPricePerUnit(productTO.getPricePerUnit());
product.setCategory(productTO.getCategory());
product.setAssociated_points(productTO.getAssociatedPoints());
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
EntityManager em = null;
int productId = 0;
try {
em = emf.createEntityManager();
em.getTransaction().begin();
em.merge(product);
em.getTransaction().commit();
productId = product.getProductId();
return productId;
} catch (Exception e) {
ErrorLogger.logError(this.getClass().getName(), "getProductFromId", e.getMessage());
throw e;
} finally {
if (em != null) em.close();
}
}
// Description : Method to add Product
public int addProduct(Myshopee_ProductTO productTO) {
Myshopee_Product product = new Myshopee_Product();
product.setProductName(productTO.getProductName());
product.setQtyInStock(productTO.getQtyInStock());
product.setPricePerUnit(productTO.getPricePerUnit());
product.setAssociated_points(productTO.getAssociatedPoints());
product.setCategory(productTO.getCategory());
EntityManager em = null;
try {
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
em = emf.createEntityManager();
em.getTransaction().begin();
em.persist(product);
em.getTransaction().commit();
return product.getProductId();
} finally {
if (em != null) {
em.close();
}
}
}