// updates the order item status on how many delivered or not
public Boolean updateOrderItemStatus(int orderitemId, String status) {
Boolean flag = false;
try {
Session session1 = HibernateUtil.getSessionFactory().openSession();
Transaction tx1 = session1.beginTransaction();
OrderItem orderitem = (OrderItem) session1.get(OrderItem.class, orderitemId);
orderitem.setItemStatus(status);
session1.update(orderitem);
flag = true;
tx1.commit();
session1.close();
} catch (Exception e) {
e.printStackTrace();
}
return flag;
}
// updates the details of an order item
public void updateItem(String status, Float cost, int oid) {
try {
Session session1 = HibernateUtil.getSessionFactory().openSession();
Transaction tx1 = session1.beginTransaction();
OrderItem oi1 = (OrderItem) session1.get(OrderItem.class, oid);
oi1.setItemStatus(status);
Book book = oi1.getBook();
int bookId = book.getProductId();
Book book1 = (Book) session1.get(Book.class, bookId);
session1.update(oi1);
session1.update(book1);
tx1.commit();
close();
} catch (Exception e) {
e.printStackTrace();
}
}