public static List<ShoppingCartInfo> getEventOrders(int eventId)
			throws HibernateException {
		List<ShoppingCartInfo> shoppingCartInfoList = null;
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		try {
			// Begin unit of work
			session.beginTransaction();

			Calendar calendar = new GregorianCalendar();

			String hql = "select o,o.orderFood from OrderInfo as o where o.orderStatus>0"
					+ " and DAYOFMONTH(o.createDate)="
					+ calendar.get(Calendar.DAY_OF_MONTH)
					+ " and MONTH(o.createDate)="
					+ (calendar.get(Calendar.MONTH) + 1)
					+ " and YEAR(o.createDate)="
					+ calendar.get(Calendar.YEAR)
					+ " and o.eventId=" + eventId;

			Query query = session.createQuery(hql);

			@SuppressWarnings("unchecked")
			List<Object[]> orders = query.list();

			if (orders.size() > 0) {
				shoppingCartInfoList = new ArrayList<ShoppingCartInfo>();
				for (int i = 0; i < orders.size(); i++) {
					Object[] orderInfo = orders.get(i);
					OrderInfo orderEntity = (OrderInfo) orderInfo[0];
					FoodInfo foodEntity = (FoodInfo) orderInfo[1];
					ShoppingCartInfo cartInfo = new ShoppingCartInfo();
					cartInfo.setOrderInfo(new OrderInfo(
							orderEntity.getUserId(), orderEntity.getFoodId(),
							orderEntity.getFoodCount(), orderEntity
									.getEventId(),
							orderEntity.getOrderStatus(), orderEntity
									.getCreateDate()));
					cartInfo.setFoodInfo(foodEntity);
					cartInfo.setOrderTotalPrice();
					shoppingCartInfoList.add(cartInfo);
				}
			}

			// End of task work
			session.getTransaction().commit();
		} catch (HibernateException hex) {
			logger.error(hex.toString());
			HibernateUtil.getSessionFactory().getCurrentSession()
					.getTransaction().rollback();
		} catch (Exception ex) {
			logger.error(ex.toString());
			HibernateUtil.getSessionFactory().getCurrentSession()
					.getTransaction().rollback();
		}
		return shoppingCartInfoList;
	}