public List<Myshopee_ProductTO> getProductList() {
EntityManager em = null;
try {
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
List<Myshopee_Product> list = new ArrayList<Myshopee_Product>();
List<Myshopee_ProductTO> list1 = new ArrayList<Myshopee_ProductTO>();
em = emf.createEntityManager();
Query query = em.createQuery("select p from Myshopee_Product p");
list = query.getResultList();
for (int index = 0; index < list.size(); index++) {
Myshopee_Product product = new Myshopee_Product();
Myshopee_ProductTO productTO = new Myshopee_ProductTO();
product = (Myshopee_Product) list.get(index);
productTO.setProductId(product.getProductId());
productTO.setProductName(product.getProductName());
productTO.setAssociatedPoints(productTO.getAssociatedPoints());
productTO.setQtyInStock(product.getQtyInStock());
productTO.setCategory(product.getCategory());
productTO.setPricePerUnit(product.getPricePerUnit());
list1.add(productTO);
}
return list1;
} finally {
if (em != null) em.close();
}
}
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();
}
}
public Myshopee_ProductTO getProductFromId(int productId) throws Exception {
EntityManager em = null;
try {
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
em = emf.createEntityManager();
Myshopee_Product product = new Myshopee_Product();
Myshopee_ProductTO productTO = new Myshopee_ProductTO();
product = em.find(Myshopee_Product.class, productId);
if (product != null) {
productTO.setProductId(product.getProductId());
productTO.setProductName(product.getProductName());
productTO.setAssociatedPoints(productTO.getAssociatedPoints());
productTO.setQtyInStock(product.getQtyInStock());
productTO.setCategory(product.getCategory());
productTO.setPricePerUnit(product.getPricePerUnit());
return productTO;
} else {
throw new ProductNotFoundException();
}
} 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();
}
}
}
public List<Myshopee_ProductTO> getProductsFromCategory(char category)
throws NoProductInCategoryException, Exception {
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
EntityManager em = null;
List<Myshopee_ProductTO> productTOList = new ArrayList<Myshopee_ProductTO>();
try {
em = emf.createEntityManager();
Query query = em.createQuery("select p from Myshopee_Product p where p.category = ?1");
query.setParameter(1, category);
List<Object> productList = query.getResultList();
if (productList == null || productList.isEmpty()) {
throw new NoProductInCategoryException();
}
for (Object object : productList) {
Myshopee_Product product = (Myshopee_Product) object;
Myshopee_ProductTO productTO = new Myshopee_ProductTO();
productTO.setProductId(product.getProductId());
productTO.setProductName(product.getProductName());
productTO.setAssociatedPoints(product.getAssociated_points());
productTO.setQtyInStock(product.getQtyInStock());
productTO.setPricePerUnit(product.getPricePerUnit());
productTO.setCategory(product.getCategory());
// adding to the list of productTO
productTOList.add(productTO);
}
} catch (NoProductInCategoryException e) {
ErrorLogger.logError(this.getClass().getName(), "getProductsFromCategory", e.getMessage());
throw e;
} catch (Exception e) {
ErrorLogger.logError(this.getClass().getName(), "getProductsFromCategory", e.getMessage());
throw e;
} finally {
if (em != null) {
em.close();
}
}
return productTOList;
}
@SuppressWarnings("unchecked")
public List<Myshopee_ProductTO> getProductFromCategory(char category) throws Exception {
EntityManager em = null;
try {
EntityManagerFactory emf = Persistence.createEntityManagerFactory("Group4");
List<Myshopee_Product> list = new ArrayList<Myshopee_Product>();
List<Myshopee_ProductTO> list1 = new ArrayList<Myshopee_ProductTO>();
em = emf.createEntityManager();
Query query = em.createQuery("select p from Myshopee_Product p where p.category=?1");
query.setParameter(1, category);
list = query.getResultList();
if (list.size() != 0) {
for (int index = 0; index < list.size(); index++) {
Myshopee_Product product = new Myshopee_Product();
Myshopee_ProductTO productTO = new Myshopee_ProductTO();
product = (Myshopee_Product) list.get(index);
productTO.setProductId(product.getProductId());
productTO.setProductName(product.getProductName());
productTO.setAssociatedPoints(productTO.getAssociatedPoints());
productTO.setQtyInStock(product.getQtyInStock());
productTO.setCategory(product.getCategory());
productTO.setPricePerUnit(product.getPricePerUnit());
list1.add(productTO);
}
return list1;
} else {
throw new NoProductInCategoryException();
}
} catch (NoProductInCategoryException e) {
ErrorLogger.logError(this.getClass().getName(), "getProductFromCategory", e.getMessage());
throw e;
} catch (Exception e) {
ErrorLogger.logError(this.getClass().getName(), "getProductFromCategory", e.getMessage());
throw e;
} finally {
if (em != null) em.close();
}
}