/* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {

    Map incomingRequest = (Map) object;

    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    String icHeader = (String) incomingRequest.get("ShipTo_icHeader");
    String icLine = (String) incomingRequest.get("ShipTo_icLine");
    if (icLine == null) {
      icLine = "0";
    }

    String queryString = "from ShipTo as s where s.id.icHeader = ? AND s.id.icLine = ?";

    BigDecimal bdHeader = new BigDecimal(icHeader);
    BigDecimal bdLine = new BigDecimal(icLine);

    List result =
        dbs.query(
            queryString,
            new Object[] {bdHeader, bdLine},
            new Type[] {Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL});

    this.setStatus(dbs.getStatus());

    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String icRecHeaderString = (String) incomingRequest.get("InspectionMte_icRecHeader");
      BigDecimal icRecHeader = new BigDecimal(icRecHeaderString);
      String icRecLineString = (String) incomingRequest.get("InspectionMte_icRecLine");
      BigDecimal icRecLine = new BigDecimal(icRecLineString);
      String keySequenceString = (String) incomingRequest.get("InspectionMte_keySequence");
      BigDecimal keySequence = new BigDecimal(keySequenceString);

      String queryString =
          "from InspectionMte as InspectionMte where InspectionMte.id.icRecHeader = ? and InspectionMte.id.icRecLine = ? and InspectionMte.id.keySequence = ? ";
      List resultList =
          dbs.query(
              queryString,
              new Object[] {
                icRecHeader, icRecLine, keySequence,
              },
              new Type[] {Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }
      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String icCodeString = (String) incomingRequest.get("InvBinLocHistory_icCode");
      BigDecimal icCode = new BigDecimal(icCodeString);

      String queryString =
          "from InvBinLocHistory as InvBinLocHistory where InvBinLocHistory.id.icCode = ? ";
      List resultList =
          dbs.query(
              queryString,
              new Object[] {
                icCode,
              },
              new Type[] {Hibernate.BIG_DECIMAL});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }
      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public static void main(String[] args) throws Exception {
    try {
      DBSession dbs = new DBSession("PURIDIOM");
      InvoiceLineAdd test = new InvoiceLineAdd();
      Map incomingRequest = new HashMap();

      InvoiceLine invoiceLine = new InvoiceLine();

      dbs.startTransaction();

      incomingRequest.put("dbsession", dbs);
      incomingRequest.put("organizationId", "PURIDIOM");
      incomingRequest.put("userId", "SYSADM");
      incomingRequest.put("invoiceLine", invoiceLine);

      invoiceLine = (InvoiceLine) test.executeTask(incomingRequest);
      if (dbs.getStatus() == Status.SUCCEEDED) {
        System.out.println("InvoiceLineAddTest SUCCESS");
        dbs.commit();
      }

      System.out.println(incomingRequest);
      System.out.println("InvoiceLineAddTest COMPLETE");
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {

    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");

      String department = (String) incomingRequest.get("RequisitionHeader_departmentCode");

      String queryString = "from DepartmentBuyer as d where d.id.departmentCode = ? ";

      List resultList =
          dbs.query(queryString, new Object[] {department}, new Type[] {Hibernate.STRING});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      // Always use host database configuration for this table
      DBSession dbs = new DBSession("host");
      String mailId = (String) incomingRequest.get("HostUser_mailId");

      mailId = Utility.ckNull(mailId).toLowerCase();

      String queryString = "from HostUser as HostUser where HostUser.mailId = ? ";
      List resultList =
          dbs.query(
              queryString,
              new Object[] {
                mailId,
              },
              new Type[] {Hibernate.STRING});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }
      this.setStatus(dbs.getStatus());

      dbs.close();
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String icHeaderHistoryString = (String) incomingRequest.get("InvItem_icHeaderHistory");
      BigDecimal icHeaderHistory = new BigDecimal(0);
      if (!HiltonUtility.isEmpty(icHeaderHistoryString)) {
        icHeaderHistory = new BigDecimal(icHeaderHistoryString);
      }

      String queryString = "from InvItem as InvItem where InvItem.icHeaderHistory = ? ";
      List resultList =
          dbs.query(
              queryString, new Object[] {icHeaderHistory}, new Type[] {Hibernate.BIG_DECIMAL});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }
      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      PoHeader poHeader = (PoHeader) incomingRequest.get("poHeader");
      if (poHeader != null) {

        String queryString =
            "from InvoiceHeader as InvoiceHeader where InvoiceHeader.icPoHeader = ? and InvoiceHeader.invoiceNumber<>'N/A' order by InvoiceHeader.invoiceDate";
        List resultList =
            dbs.query(
                queryString,
                new Object[] {poHeader.getIcPoHeader()},
                new Type[] {Hibernate.BIG_DECIMAL});
        result = resultList;
      } else {
        Log.error(
            this, "IcPoHeader was empty.  InvoiceHeaderRetrieveByOrder could not be executed.");
      }

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public static void main(String[] args) throws Exception {
    try {
      DBSession dbs = new DBSession("PURIDIOM");
      VendorInsuranceDeleteById test = new VendorInsuranceDeleteById();
      Map incomingRequest = new HashMap();

      dbs.startTransaction();

      incomingRequest.put("dbsession", dbs);
      incomingRequest.put("organizationId", "PURIDIOM");
      incomingRequest.put("userId", "SYSADM");
      incomingRequest.put("VendorInsurance_contNumber", "1");

      test.executeTask(incomingRequest);
      if (dbs.getStatus() == Status.SUCCEEDED) {
        System.out.println("VendorInsuranceDeleteByIdTest SUCCESS");
        dbs.commit();
      }

      System.out.println(incomingRequest);
      System.out.println("VendorInsuranceDeleteByIdTest COMPLETE");
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    List result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String itemNumber = (String) incomingRequest.get("InvFormProduct_itemNumber");
      if (Utility.isEmpty(itemNumber)) {
        throw new Exception(
            "InvFormProduct_itemNumber cannot be empty.  InvFormProduct could not be retrieved.");
      }

      String queryString =
          "from InvFormProduct as InvFormProduct where InvFormProduct.id.itemNumber = ? ";
      result =
          dbs.query(
              queryString,
              new Object[] {
                itemNumber,
              },
              new Type[] {Hibernate.STRING});

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object ret = null;
    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String icRfqHeader = (String) incomingRequest.get("RfqVendor_icRfqHeader");
      if (icRfqHeader == null) {
        icRfqHeader = (String) incomingRequest.get("RfqHeader_icRfqHeader");
      }
      StringBuffer queryString =
          new StringBuffer(
              "from RfqVendor as rfqvendor where rfqvendor.id.icRfqHeader = "
                  + icRfqHeader
                  + " AND rfqvendor.id.vendorId IN (SELECT RfqLine.vendorAwarded FROM RfqLine RfqLine WHERE RfqLine.icRfqHeader = "
                  + icRfqHeader
                  + ")");
      queryString.append(" order by rfqvendor.id.vendorId ASC");

      List result = dbs.query(queryString.toString());
      ret = result;

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw new TsaException("Awarded Vendors List couls not be retrieved. " + e.getMessage(), e);
    }
    return ret;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      if (incomingRequest.containsKey("RfqNote_icHeader")
          && incomingRequest.containsKey("RfqNote_icLine")) {
        DBSession dbs = (DBSession) incomingRequest.get("dbsession");
        String icHeader = (String) incomingRequest.get("RfqNote_icHeader");
        String icLine = (String) incomingRequest.get("RfqNote_icLine");
        StringBuffer queryString =
            new StringBuffer(
                "from RfqNote as rfqnote where rfqnote.id.icHeader = '"
                    + icHeader
                    + "' and rfqnote.id.icLine = '"
                    + icLine
                    + "'");

        result = dbs.query(queryString.toString());
        this.setStatus(dbs.getStatus());
      } else {
        throw new Exception("The value for RfqNote_icHeader and RfqNote_icLine must be set.");
      }
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    String id = (String) incomingRequest.get("BomRouting_stageId");
    String seq = "01";
    if (incomingRequest.containsKey("BomRouting_icMethod")) {
      BigDecimal icMethod = new BigDecimal((String) incomingRequest.get("BomRouting_icMethod"));
      String sql =
          "Select MAX(bomRouting.stageId) from BomRouting as bomRouting "
              + "Where bomRouting.icMethod = ?";

      List resultList = dbs.query(sql, new Object[] {icMethod}, new Type[] {Hibernate.BIG_DECIMAL});

      if (resultList != null && resultList.size() > 0) {
        if (resultList.get(0) != null) {
          seq = resultList.get(0).toString().substring(0, 2);
          seq = Integer.toString(Integer.parseInt(seq) + 1);
          if (seq.length() < 2) seq = "0" + seq;
        }
      } else {
        seq = "01";
      }
      id = seq + "-" + id;
    }

    this.setStatus(dbs.getStatus());
    return id;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    Object result = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String icRfqHeaderString = (String) incomingRequest.get("RfqVendor_icRfqHeader");
      BigDecimal icRfqHeader = new BigDecimal(icRfqHeaderString);
      String vendorId = (String) incomingRequest.get("RfqVendor_vendorId");

      String queryString =
          "from RfqVendor as rfqVendor where rfqVendor.id.icRfqHeader = ? and rfqVendor.id.vendorId = ?";
      List resultList =
          dbs.query(
              queryString,
              new Object[] {
                icRfqHeader, vendorId,
              },
              new Type[] {Hibernate.BIG_DECIMAL, Hibernate.STRING});

      if (resultList != null && resultList.size() > 0) {
        result = resultList.get(0);
      }
      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return result;
  }
  /**
   * Method executeTask.
   *
   * @param object
   *     <p>incomingRequest
   */
  public Object executeTask(Object object) throws Exception {
    Object ret = null;
    try {
      Map incomingRequest = (Map) object;
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String AssetCost_tagNumber = (String) incomingRequest.get("AssetCost_tagNumber");

      if (Utility.isEmpty(AssetCost_tagNumber)) {
        AssetCost_tagNumber = (String) incomingRequest.get("Asset_tagNumber");
      }

      String sql =
          "Select MAX(AssetCost.id.sequenceNo) from AssetCost AssetCost Where AssetCost.id.tagNumber = ?";
      List resultList =
          dbs.query(sql, new Object[] {AssetCost_tagNumber}, new Type[] {Hibernate.STRING});

      if (resultList != null && resultList.size() > 0) {
        ret = resultList.get(0);
        if (ret == null) {
          ret = new BigDecimal(0);
        }
      } else {
        ret = new BigDecimal(0);
      }
      this.setStatus(Status.SUCCEEDED);

    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw new TsaException(this.getName(), e);
    }
    return ret;
  }
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {

    Map incomingRequest = (Map) object;
    Object result = null;

    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    String icHeader = (String) incomingRequest.get("RfqLine_icRfqHeader");
    // String lineNumber = (String) incomingRequest.get("RfqLine_rfqLine");
    String lineNumber = (String) incomingRequest.get("lineToRetrieve");
    BigDecimal bdHeader = new BigDecimal(icHeader);
    BigDecimal bdNumber = new BigDecimal(lineNumber);

    String queryString = "select b from RfqLine as b where b.icRfqHeader = ? AND b.rfqLine = ?";

    List resultList =
        dbs.query(
            queryString,
            new Object[] {bdHeader, bdNumber},
            new Type[] {Hibernate.BIG_DECIMAL, Hibernate.BIG_DECIMAL});

    if (resultList != null && resultList.size() > 0) {
      result = resultList.get(0);
    }

    this.setStatus(dbs.getStatus());

    return result;
  }
  public Object executeTask(Object object) throws Exception {
    StringBuffer query = new StringBuffer();
    Object result = null;
    Map incomingRequest = (Map) object;
    try {

      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      BrowseObject b = (BrowseObject) incomingRequest.get("browseObject");
      String organizationId = (String) incomingRequest.get("organizationId");
      String userTimeZone = (String) incomingRequest.get("userTimeZone");
      String userDateFormat = (String) incomingRequest.get("userDateFormat");
      String sqlWhere = (String) incomingRequest.get("sqlWhere");
      List dateArguments = new ArrayList();

      if (Utility.isEmpty(userDateFormat)) {
        userDateFormat =
            PropertiesManager.getInstance(organizationId)
                .getProperty("MISC", "DATEFORMAT", "MM-dd-yyyy");
      }

      sqlWhere =
          ReportDates.dateWhereClauseDecoder(
              sqlWhere, dateArguments, organizationId, userTimeZone, userDateFormat);

      if (Utility.isEmpty(sqlWhere)) {
        sqlWhere = "";
      }
      String sqlSelect = b.getSqlSelect();

      query.append(sqlSelect);
      query.append(" from " + b.getSqlFrom());
      query.append(" " + sqlWhere);
      Log.debug(this, incomingRequest.get("userId") + " - query: " + query.toString());

      long start = System.currentTimeMillis();
      System.out.println("Report Query: " + query.toString());
      List list = dbs.query(query.toString(), dateArguments.toArray(), b.getMaxRows());
      long end = System.currentTimeMillis();
      Log.error(
          this,
          "It took "
              + ((end - start) / 1000)
              + " seconds to execute the query: "
              + query.toString());
      Log.debug(this, incomingRequest.get("userId") + " - dbs.query COMPLETE.");

      result = list;

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      incomingRequest.put("failed", Boolean.TRUE);
      Log.error(
          this,
          "Error executing Report Query: " + query.toString() + " -Exception: " + e.getMessage());
      e.printStackTrace();

      this.setStatus(Status.FAILED);
    }
    return result;
  }
 public Object executeTask(Object object) throws Exception {
   Map incomingRequest = (Map) object;
   DBSession dbs = (DBSession) incomingRequest.get("dbsession");
   String queryString = "from AssetService as assetService";
   List result = dbs.query(queryString);
   this.setStatus(dbs.getStatus());
   return result;
 }
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    CatalogItem catalogItem = new CatalogItem();
    CatalogItemValues.setValues(object, catalogItem);
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");

    dbs.delete(catalogItem);

    this.setStatus(dbs.getStatus());

    return catalogItem;
  }
 public Object executeTask(Object object) throws Exception {
   Map incomingRequest = (Map) object;
   DBSession dbs = (DBSession) incomingRequest.get("dbsession");
   SecurityGroup securityGroup = (SecurityGroup) incomingRequest.get("securityGroup");
   if (securityGroup == null) {
     securityGroup = new SecurityGroup();
   }
   SecurityGroupSetValuesPK setValues = new SecurityGroupSetValuesPK();
   setValues.setValues(incomingRequest, securityGroup);
   dbs.delete(securityGroup);
   this.setStatus(dbs.getStatus());
   return securityGroup;
 }
 public Object executeTask(Object object) throws Exception {
   Map incomingRequest = (Map) object;
   DBSession dbs = (DBSession) incomingRequest.get("dbsession");
   AutoGen autoGen = (AutoGen) incomingRequest.get("autoGen");
   if (autoGen == null) {
     autoGen = new AutoGen();
   }
   AutoGenSetValuesPK setValues = new AutoGenSetValuesPK();
   setValues.setValues(incomingRequest, autoGen);
   dbs.delete(autoGen);
   this.setStatus(dbs.getStatus());
   return autoGen;
 }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    UserProfile userProfile = (UserProfile) incomingRequest.get("userProfile");
    if (userProfile == null) {
      userProfile = new UserProfile();
      String userId = (String) incomingRequest.get("UserProfile_userId");
      userProfile.setUserId(userId);
    }

    dbs.delete(userProfile);
    this.setStatus(dbs.getStatus());
    return userProfile;
  }
  public Object executeTask(Object object) throws Exception {
    Object result = null;
    Map incomingRequest = (Map) object;

    PoHeader poHeader = (PoHeader) incomingRequest.get("poHeader");
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    BigDecimal icPoHeader = poHeader.getIcPoHeader();
    String queryString =
        "select sum(invoiceLine.quantity) from InvoiceLine as invoiceLine where invoiceLine.icPoHeader= ? group by invoiceLine.lineNumber order by invoiceLine.lineNumber";
    result = dbs.query(queryString, icPoHeader, Hibernate.BIG_DECIMAL);

    this.setStatus(dbs.getStatus());
    return result;
  }
Exemple #24
0
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");

    Catalog catalog = new Catalog();

    CatalogSetValues catalogValues = new CatalogSetValues();
    incomingRequest.put("catalog", catalog);
    catalog = (Catalog) catalogValues.executeTask(incomingRequest);

    dbs.add(catalog);
    this.setStatus(dbs.getStatus());

    return catalog;
  }
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {

    Map incomingRequest = (Map) object;
    String section = "%DEFAULTS";

    DBSession dbs = (DBSession) incomingRequest.get("dbsession");
    String queryString = "from Property as prop where prop.id.section like ?";

    List result = dbs.query(queryString, section, Hibernate.STRING);

    // List result = dbs.query(queryString) ;
    this.setStatus(dbs.getStatus());

    return result;
  }
Exemple #26
0
  /* (non-Javadoc)
   * @see com.tsagate.foundation.processengine.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {
    Object ret = "";
    try {
      Map incomingRequest = (Map) object;

      String organizationId = (String) incomingRequest.get("organizationId");
      String path =
          DictionaryManager.getInstance("host", organizationId).getProperty("reportsPath", "");
      String reportName = (String) incomingRequest.get("reportName");

      Map parameters = new HashMap();
      parameters.put("reportTitle", "Requisition Line Report");
      String userId = (String) incomingRequest.get("userId");
      parameters.put("userId", userId);
      DBSession session = (DBSession) incomingRequest.get("dbsession");
      Connection con = session.getSqlConnection();

      String filePath = path + reportName + ".jasper";
      // JasperDesign jasperDesign = JasperManager.loadXmlDesign(filePath);
      // JasperReport jasperReport = JasperManager.compileReport(jasperDesign);
      JasperReport jasperReport = JasperManager.loadReport(filePath);
      JasperPrint jasperPrint = JasperManager.fillReport(jasperReport, parameters, con);

      // JasperCompileManager.compileReportToFile(filePath);
      // filePath = path + "requisition-line.jasper";
      // JasperFillManager.fillReportToFile(filePath, parameters, con);

      // filePath = path + "requisitionLine.pdf";
      // JasperExportManager.exportReportToPdfFile(filePath);

      // You can use JasperPrint to create PDF
      UniqueKeyGenerator ukg = UniqueKeyGenerator.getInstance();
      String nameIt = ukg.getUniqueKey().toString();
      filePath =
          DictionaryManager.getInstance("host", organizationId).getProperty("reportsOut", "")
              + nameIt
              + ".pdf";
      JasperManager.printReportToPdfFile(jasperPrint, filePath);
      ret = nameIt + ".pdf";
      this.setStatus(Status.SUCCEEDED);
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw new TsaException(this.getName(), e);
    }
    return ret;
  }
  /* (non-Javadoc)
   * @see com.tsagate.puridiom.process.ITask#executeTask(java.lang.Object)
   */
  public Object executeTask(Object object) throws Exception {

    Map incomingRequest = (Map) object;
    DBSession dbs = (DBSession) incomingRequest.get("dbsession");

    String queryString =
        "from HistoryLog as hst where hst.icHeaderHistory = ? and (hst.doctype like '%H' or hst.doctype = 'REQ') order by hst.icHistory ASC";

    String icHeaderHistory = (String) incomingRequest.get("HistoryLog_icHeaderHistory");
    BigDecimal bdHeaderHistory = new BigDecimal(icHeaderHistory);

    List result =
        dbs.query(queryString, new Object[] {bdHeaderHistory}, new Type[] {Hibernate.BIG_DECIMAL});

    this.setStatus(dbs.getStatus());
    return result;
  }
  public Object executeTask(Object object) throws Exception {
    Map incomingRequest = (Map) object;
    List resultList = null;

    try {
      DBSession dbs = (DBSession) incomingRequest.get("dbsession");
      String budgetId = (String) incomingRequest.get("BudgetCenter_budgetId");

      String queryString = "from BudgetCenter BudgetCenter where BudgetCenter.id = ? ";
      resultList = dbs.query(queryString, new Object[] {budgetId}, new Type[] {Hibernate.STRING});

      this.setStatus(dbs.getStatus());
    } catch (Exception e) {
      this.setStatus(Status.FAILED);
      throw e;
    }
    return resultList;
  }
  public static void main(String[] args) throws Exception {
    try {
      DBSession dbs = new DBSession("HILTON");
      BomReferenceRetrieveById test = new BomReferenceRetrieveById();
      Map incomingRequest = new HashMap();

      incomingRequest.put("dbsession", dbs);
      incomingRequest.put("organizationId", "HILTON");
      incomingRequest.put("userId", "SYSADM");

      System.out.println("Database Status: " + dbs.getStatus());

      BomReference bomReference = (BomReference) test.executeTask(incomingRequest);

      System.out.println("BomReference: " + bomReference.toString());
      System.out.println("BomReferenceRetrieveByIdTest COMPLETE");
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) throws Exception {
    try {
      DBSession dbs = new DBSession("PURIDIOM");
      CountryRetrieveById test = new CountryRetrieveById();
      Map incomingRequest = new HashMap();

      incomingRequest.put("dbsession", dbs);
      incomingRequest.put("organizationId", "PURIDIOM");
      incomingRequest.put("userId", "SYSADM");

      System.out.println("Database Status: " + dbs.getStatus());

      Country country = (Country) test.executeTask(incomingRequest);

      System.out.println("Country: " + country.toString());
      System.out.println("CountryRetrieveByIdTest COMPLETE");
    } catch (Exception e) {
      e.printStackTrace();
    }
  }