/**
   * Displays available Service level and offers .
   *
   * @param service_level
   * @param enterprise_id
   * @param enterprise_name
   */
  public static void publishOffersPerMarket(
      final String service_level, final Integer enterprise_id, final String enterprise_name) {
    Logger.info(" -----------------INSIDE PRODUCER publishOffersPerMarket()------");
    String user = session.get("username");
    Logger.info(
        "Enterprise id "
            + enterprise_id
            + " Service_level "
            + service_level
            + " Enterprise_name "
            + enterprise_name);
    if (user != null) {
      List<OfferPurchased> resultSet = ProducerDAO.getSubscribedOffersGroupByServiceLevels();
      List<Offer> resultSet1 = ProducerDAO.getSubscribedOffers(service_level);
      List<Offer> resultSet4 = ProducerDAO.getSubscribedOffers1(service_level);

      Logger.info("Resultset for service levels : " + resultSet);
      Logger.info("Resultset1 for VDC offers  : " + resultSet1);
      Logger.info("Resultset4 offers published : " + resultSet4);
      Logger.info(" ---------------------EXITING PRODUCER publishOffersPerMarket()------");
      render(
          "/MarketEnable/publishOfferBack.html",
          resultSet,
          resultSet1,
          resultSet4,
          user,
          enterprise_id,
          enterprise_name);
    } else {
      flash.error("You are not connected.Please Login");
      Login.login_page();
    }
  }
  private void fillDbTables() throws Exception {
    for (Category cat : categories) categoryDAO.create(cat);

    for (Producer p : producers) producerDAO.create(p);

    Long idProducer = producerDAO.getByName("Apple").getId();
    Long idCategory = categoryDAO.getByName("Tablet").getId();

    commodity.setIdProducer(idProducer);
    commodity.setIdCategory(idCategory);
    commodityDAO.create(commodity);
    commodity = commodityDAO.getByName("Ipad4");

    commodityView.setIdCommodity(commodity.getId());
  }
  /**
   * Publish offers per enterprise.
   *
   * @param enterprise_id
   * @param enterprise_name
   */
  public static void publishMarket(final Integer enterprise_id, final String enterprise_name) {
    Logger.info("------------------------- INSIDE publishMarket()-----------------");
    Logger.info("Enterprise_id " + enterprise_id + "Enterprise_name " + enterprise_name);
    String user = session.get("username");
    if (user != null) {
      List<MKT_Configuration> resultSet1 = MarketDAO.getMKTConfiguration(enterprise_id);

      /*
       * check if market is enabled. Publish offers only if market is
       * enabled
       */
      if (resultSet1.size() > 0) {
        List<OfferPurchased> resultSet = ProducerDAO.getSubscribedOffersGroupByServiceLevels();
        Logger.info("ResultSet " + resultSet.size());
        Logger.info("------------------------- EXITING publishMarket()-----------------");
        render(enterprise_id, enterprise_name, resultSet, user);
      } else {
        flash.error(" To continue configure the Market ");
        enable(enterprise_id, enterprise_name);
      }
    } else {
      flash.error("You are not connected.Please Login");
      Login.login_page();
    }
  }