Esempio n. 1
0
 protected void processEditModel(
     String actionCode, String actionObject, HttpServletRequest request) throws SQLException {
   WorkCenterMgr workCenterMgr = (WorkCenterMgr) this.getManagerFromSession(request);
   workCenterMgr.setFunctionMode(Constant.UPDATE);
   String key = actionCode.split("-")[2];
   if (actionObject.equals("WorkCenter")) {
     WorkCenter workCenter =
         (WorkCenter)
             Utility.getObject(workCenterMgr.getCurrentWorkCenterMeta().getWorkCenterList(), key);
     workCenterMgr.setCurrentWorkCenter(workCenter);
   } else if (actionObject.equals("WorkerGroup")) {
     WorkerGroup workerGroup =
         (WorkerGroup)
             Utility.getObject(
                 workCenterMgr.getCurrentWorkerGroupMeta().getWorkerGroupList(), key);
     workCenterMgr.setCurrentWorkerGroup(workerGroup);
   } else if (actionObject.equals("Worker")) {
     Worker worker =
         (Worker)
             Utility.getObject(workCenterMgr.getCurrentWorkerGroupMeta().getWorkerList(), key);
     workCenterMgr.setCurrentWorker(worker);
     workCenterMgr
         .getCurrentWorkerGroupMeta()
         .refreshDepartment(worker.getEmployee().getEmployeeId());
     worker.setDepartment(
         (SelectionOption)
             Utility.getObject(
                 workCenterMgr.getCurrentWorkerGroupMeta().getDepartmentList(),
                 worker.getDepartment().getAttributeId()));
   }
 }
Esempio n. 2
0
 protected void processSelectModel(
     String actionCode, String actionObject, HttpServletRequest request) throws SQLException {
   WorkCenterMgr workCenterMgr = (WorkCenterMgr) this.getManagerFromSession(request);
   String serial = actionCode.split("-")[2];
   if (actionObject.equals("Employee")) {
     Employee employee =
         (Employee)
             Utility.getObject(
                 workCenterMgr.getFindMeta(workCenterMgr.getFoundMode()).getFindList(), serial);
     if (workCenterMgr.getEntryMode().equals(Constant.WORKER_GROUP)) {
       workCenterMgr.getCurrentWorkerGroup().setLeader(employee);
     } else if (workCenterMgr.getEntryMode().equals(Constant.CREATE_WORKER)) {
       workCenterMgr.getCurrentWorker().setEmployee(employee);
       workCenterMgr.getCurrentWorkerGroupMeta().refreshDepartment(employee.getEmployeeId());
     }
   } else if (actionObject.equals("WorkerGroup")) {
     WorkerGroup workerGroup =
         (WorkerGroup)
             Utility.getObject(
                 workCenterMgr.getFindMeta(workCenterMgr.getFoundMode()).getFindList(), serial);
     workCenterMgr.getCurrentWorker().setWorkerGroup(workerGroup);
   } else if (actionObject.equals("Worker")) {
     Worker worker =
         (Worker)
             Utility.getObject(
                 workCenterMgr.getFindMeta(workCenterMgr.getFoundMode()).getFindList(), serial);
     workCenterMgr.getCurrentWorking().setWorker(worker);
     workCenterMgr.getCurrentWorking().getWorkingDetailList().clear();
   } else if (actionObject.equals("Assignment")) {
     WorkingAssignment workingAssignment =
         (WorkingAssignment)
             Utility.getObject(
                 workCenterMgr.getFindMeta(workCenterMgr.getFoundMode()).getFindList(), serial);
     if (workingAssignment != null && !workCenterMgr.getCurrentWorking().isSelected(serial)) {
       WorkingDetail workingDetail = new WorkingDetail();
       workingDetail.setWorkingAssignment(workingAssignment);
       workingDetail.setSheetQty(workingAssignment.getAssignmentQty());
       workCenterMgr.getCurrentWorking().getWorkingDetailList().add(workingDetail);
       workCenterMgr.getCurrentWorking().setDetailListRowNo();
     }
   } else if (actionObject.equals("Working")) {
     Working working =
         (Working)
             Utility.getObject(
                 workCenterMgr.getFindMeta(workCenterMgr.getFoundMode()).getFindList(), serial);
     workCenterMgr.setCurrentWorking(working);
     workCenterMgr.getCurrentWorking().populateWorkingDetailList();
     WorkingDetail workingDetail =
         (WorkingDetail)
             ((LinkedList) workCenterMgr.getCurrentWorking().getWorkingDetailList()).getFirst();
     workCenterMgr
         .getCurrentWorking()
         .populateWorker(workCenterMgr, workingDetail.getWorkingAssignment().getWorkerId());
   }
 }
 private void setHttpRequestStockPlace(HttpServletRequest request, OutMgr outMgr) {
   outMgr.setCurrentInventoryPlace(request.getParameter("place"));
   outMgr.setLocationPlace(
       (LocationPlace)
           Utility.getObject(
               outMgr.getStockPlaceMeta().getStockPlaceList(), request.getParameter("place")));
 }
Esempio n. 4
0
  public int doStartTag() throws JspException {

    rouMgr = (RouMgr) pageContext.getSession().getAttribute("rouMgr");
    pageContext.setAttribute("entryMode", rouMgr.getEntryMode());
    pageContext.setAttribute("functionMode", rouMgr.getFunctionMode());
    if (listType.equals("ItemRoutingList")) {
      pageContext.setAttribute(
          "list", Utility.getListHtmlItem(rouMgr.getItemMeta().getItemRoutingList()));
    } else if (listType.equals("ItemList")) {
      pageContext.setAttribute("list", Utility.getListHtmlItem(rouMgr.getItemMeta().getItemList()));
    } else if (listType.equals("ProcessList")) {
      pageContext.setAttribute(
          "list", Utility.getListHtmlItem(rouMgr.getRoutingMeta().getProcessList()));
    } else if (listType.equals("copyRoutingList")) {
      pageContext.setAttribute(
          "list", Utility.getListHtmlItem(rouMgr.getItemMeta().getCopyRoutingList()));
    }
    return Tag.EVAL_BODY_INCLUDE;
  }
Esempio n. 5
0
  private void setHttpRequestWorkCenter(HttpServletRequest request, WorkCenterMgr workCenterMgr) {
    WorkCenter workCenter = workCenterMgr.getCurrentWorkCenter();

    workCenter.setWorkCenterCode(request.getParameter("workCenterCode"));
    workCenter.setWorkCenterName(request.getParameter("workCenterName"));
    workCenter.setWorkCenterDescription(request.getParameter("workCenterDescription"));
    workCenter.setFactoryLocation(
        (SelectionOption)
            Utility.getObject(
                workCenterMgr.getCurrentWorkCenterMeta().getFindFactoryList(),
                request.getParameter("factoryList")));
  }
Esempio n. 6
0
 private void setHttpParameterWorker(HttpServletRequest request, WorkCenterMgr workCenterMgr) {
   Worker worker = workCenterMgr.getCurrentWorker();
   worker.setWorkerNo(request.getParameter("workerNo"));
   if (request.getParameter("isDisable") != null
       && request.getParameter("isDisable").equals("Y")) {
     worker.setDisable(true);
   } else {
     worker.setDisable(false);
   }
   worker.setDepartment(
       (SelectionOption)
           Utility.getObject(
               workCenterMgr.getCurrentWorkerGroupMeta().getDepartmentList(),
               request.getParameter("departmentList")));
 }
Esempio n. 7
0
 private void setHttpParameterWorkerGroup(
     HttpServletRequest request, WorkCenterMgr workCenterMgr) {
   WorkerGroup workerGroup = workCenterMgr.getCurrentWorkerGroup();
   workerGroup.setWorkerGroupCode(request.getParameter("workerGroupCode"));
   workerGroup.setWorkerGroupName(request.getParameter("workerGroupName"));
   workerGroup.setWorkerGroupDescription(request.getParameter("description"));
   workerGroup.setFactoryLocation(
       (SelectionOption)
           Utility.getObject(
               workCenterMgr.getCurrentWorkCenterMeta().getFindFactoryList(),
               request.getParameter("factoryList")));
   if (request.getParameter("isDisable") != null
       && request.getParameter("isDisable").equals("Y")) {
     workerGroup.setIsDisable(true);
   } else {
     workerGroup.setIsDisable(false);
   }
 }
Esempio n. 8
0
 protected void processDeleteModel(
     String actionCode, String actionObject, HttpServletRequest request) throws SQLException {
   WorkCenterMgr workCenterMgr = (WorkCenterMgr) this.getManagerFromSession(request);
   if (actionObject.equals("Assignment")) {
     String key = actionCode.split("-")[2];
     this.setHttpParameterWorking(request, workCenterMgr);
     WorkingDetail workingDetail =
         (WorkingDetail)
             Utility.getObject(workCenterMgr.getCurrentWorking().getWorkingDetailList(), key);
     workCenterMgr.getCurrentWorking().getWorkingDetailList().remove(workingDetail);
     workCenterMgr.getCurrentWorking().setDetailListRowNo();
   } else if (actionObject.equals("Working")) {
     workCenterMgr.setFunctionMode(Constant.DELETE);
     workCenterMgr
         .getCurrentWorking()
         .saveStatus(workCenterMgr.getFunctionMode(), this.getLogin(request));
   }
 }
Esempio n. 9
0
  public void populateResultSet(MVCMgr mvcMgr, ResultSet rs) throws Exception {
    if (rs != null) {
      if (mvcMgr.getFoundMode().equals(Constant.FIND_VENDOR)) {
        while (rs.next()) {
          PoVendor vendor = new PoVendor();
          vendor.setVendorId(Decoder.convertGetString(rs.getString(26)));
          vendor.setVendorCode(Decoder.convertGetString(rs.getString(1)));
          vendor.setVendorName(Decoder.convertGetString(rs.getString(2)));
          vendor.setAddress(Decoder.convertGetString(rs.getString(3)));
          vendor.setPresident(Decoder.convertGetString(rs.getString(4)));
          vendor.setWebsite(Decoder.convertGetString(rs.getString(5)));
          vendor.setCreditLine(Decoder.convertGetString(rs.getString(14)));
          vendor.setTurnover(Decoder.convertGetString(rs.getString(15)));
          vendor.setEmployeeNum(Decoder.convertGetString(rs.getString(16)));
          vendor.setEstablishedYear(Decoder.convertGetString(rs.getString(17)));
          vendor.setMajorMarket(Decoder.convertGetString(rs.getString(18)));
          vendor.setImportPercentage(Decoder.convertGetString(rs.getString(19)));
          vendor.setExportPercentage(Decoder.convertGetString(rs.getString(20)));
          vendor.setGroupCompany(Decoder.convertGetString(rs.getString(21)));
          vendor.setTotalCapacity(Decoder.convertGetString(rs.getString(22)));
          vendor.setConclusion(Decoder.convertGetString(rs.getString(23)));
          vendor.setPaymentTerm(
              (PaymentTerm)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPaymentTermList(),
                      Decoder.convertGetString(rs.getString(27))));
          vendor.setVat(
              (VAT)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getVatList(),
                      Decoder.convertGetString(rs.getString(28))));
          vendor.setPoType(
              (SelectionOption)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPoTypeList(),
                      Decoder.convertGetString(rs.getString(29))));
          vendor.setDeliveryTerm(
              (DeliveryTerm)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getDeliveryTermList(),
                      rs.getString(30)));
          vendor.setMajorSupplier(rs.getString(31) != null && rs.getString(31).equals("Y"));
          this.getFindList().add(vendor);
        }
      } else if (mvcMgr.getFoundMode().equals(Constant.FIND_CONTACT)) {
        while (rs.next()) {
          PoVendorContact contact = new PoVendorContact();
          contact.setContactId(Decoder.convertGetString(rs.getString(1)));
          contact.setContactCode(Decoder.convertGetString(rs.getString(2)));
          contact.setContactPersonName(Decoder.convertGetString(rs.getString(3)));
          contact.setMobile(Decoder.convertGetString(rs.getString(4)));
          contact.setEmail(Decoder.convertGetString(rs.getString(5)));
          contact.setFactoryCode(Decoder.convertGetString(rs.getString(7)));
          contact.setAddress(Decoder.convertGetString(rs.getString(8)));
          contact.setMobile(Decoder.convertGetString(rs.getString(9)));
          contact.setFax(Decoder.convertGetString(rs.getString(10)));
          contact.setPoType(
              (SelectionOption)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPoTypeList(),
                      Decoder.convertGetString(rs.getString(11))));
          this.getFindList().add(contact);
        }
      } else if (mvcMgr.getFoundMode().equals(Constant.FIND_PO_PART)) {
        while (rs.next()) {
          PoPurchaseRequestDetail purchaseRequestDetail = new PoPurchaseRequestDetail();
          purchaseRequestDetail.setPrDetailId(rs.getString(1));
          purchaseRequestDetail.setPrId(Decoder.convertGetString(rs.getString(2)));
          purchaseRequestDetail.setPrNo(Decoder.convertGetString(rs.getString(2)));
          purchaseRequestDetail.setRequestQty(Decoder.convertGetString(rs.getString(3)));
          purchaseRequestDetail.setRequestDate(Decoder.convertGetString(rs.getString(4)));
          purchaseRequestDetail.setRemark(Decoder.convertGetString(rs.getString(5)));
          purchaseRequestDetail.setCreatedBy(Decoder.convertGetString(rs.getString(18)));
          purchaseRequestDetail.setPartTypeCode(Decoder.convertGetString(rs.getString(19)));
          purchaseRequestDetail.setVpnCode(Decoder.convertGetString(rs.getString(20)));
          purchaseRequestDetail.setVpnName(Decoder.convertGetString(rs.getString(21)));
          Quote quote = new Quote();
          quote.setQuoteUnitPrice(Decoder.convertGetString(rs.getString(16)));
          Currency currency = new Currency();
          currency.setAttributeId(Decoder.convertGetString(rs.getString(17)));
          currency.setAttributeCode(Decoder.convertGetString(rs.getString(17)));
          currency.setAttributeName(Decoder.convertGetString(rs.getString(17)));
          quote.setCurrency(currency);
          purchaseRequestDetail.setQuote(quote);

          PoPart part = new PoPart(Decoder.convertGetString(rs.getString(12)));
          part.setPnId(Decoder.convertGetString(rs.getString(7)));
          part.setPnCode(Decoder.convertGetString(rs.getString(8)));
          part.setPnName(Decoder.convertGetString(rs.getString(9)));
          part.setPartFullName(Decoder.convertGetString(rs.getString(10)));
          part.setPrimaryUnitOfMeasure(
              new UOM(
                  Decoder.convertGetString(rs.getString(13)),
                  Decoder.convertGetString(rs.getString(14)),
                  Decoder.convertGetString(rs.getString(15))));
          PartType partType = new PartType();
          partType.setAttributeId(Decoder.convertGetString(rs.getString(19)));
          partType.setAttributeCode(Decoder.convertGetString(rs.getString(22)));
          partType.setAttributeName(Decoder.convertGetString(rs.getString(23)));
          part.setPartType(partType);
          purchaseRequestDetail.setPart(part);
          this.getFindList().add(purchaseRequestDetail);
        }
      } else if (mvcMgr.getFoundMode().equals(Constant.FIND_PART)
          || mvcMgr.getFoundMode().equals(Constant.FIND_FOC_PART)) {
        while (rs.next()) {
          PoPart part = new PoPart(Decoder.convertGetString(rs.getString(7)));

          part.setPnId(Decoder.convertGetString(rs.getString(1)));
          part.setPnCode(Decoder.convertGetString(rs.getString(2)));
          part.setPartName(Decoder.convertGetString(rs.getString(3)));
          part.setPartFullName(Decoder.convertGetString(rs.getString(4)));
          part.setCompleteName(Decoder.convertGetString(rs.getString(5)));
          part.setPnDescription(Decoder.convertGetString(rs.getString(6)));
          part.setStdPurchaseUnitPrice(Decoder.convertGetString(rs.getString(8)));
          part.setPurchaseLeadTime(Decoder.convertGetString(rs.getString(9)));
          UOM uom = new UOM();
          uom.setAttributeId(Decoder.convertGetString(rs.getString(10)));
          uom.setAttributeCode(Decoder.convertGetString(rs.getString(11)));
          uom.setAttributeName(Decoder.convertGetString(rs.getString(12)));
          part.setPrimaryUnitOfMeasure(uom);
          PartType partType = new PartType();
          partType.setAttributeId(Decoder.convertGetString(rs.getString(13)));
          partType.setAttributeCode(Decoder.convertGetString(rs.getString(14)));
          partType.setAttributeName(Decoder.convertGetString(rs.getString(15)));
          part.setPartType(partType);
          part.getLocation().setAttributeId(Decoder.convertGetString(rs.getString(16)));
          part.setVpnCode(Decoder.convertGetString(rs.getString(17)));
          part.setVpnName(Decoder.convertGetString(rs.getString(18)));
          this.getFindList().add(part);
        }
      } else if (mvcMgr.getFoundMode().equals(Constant.FIND_PO)
          || mvcMgr.getFoundMode().equals(Constant.FIND_PO_COPY)) {
        while (rs.next()) {
          PurchaseOrder purchaseOrder = new PurchaseOrder();
          PoVendorContact contact = new PoVendorContact();
          PoVendor vendor = new PoVendor();
          purchaseOrder.setPoNo(Decoder.convertGetString(rs.getString(1)));
          vendor.setVendorId(Decoder.convertGetString(rs.getString(2)));
          contact.setContactId(Decoder.convertGetString(rs.getString(3)));
          purchaseOrder.setBillToSelfSite(
              (SelfSite)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getSelfSiteList(), rs.getString(4)));
          purchaseOrder.setShipToSelfSite(
              (SelfSite)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getSelfSiteList(), rs.getString(5)));
          purchaseOrder.setCurrency(
              (Currency)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getCurrencyList(), rs.getString(6)));
          purchaseOrder.setPoTotalAmount(rs.getString(8));
          purchaseOrder.setDeliveryTerm(
              (DeliveryTerm)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getDeliveryTermList(),
                      rs.getString(9)));
          purchaseOrder.setDeliveryDate(Decoder.convertGetString(rs.getString(10)));
          purchaseOrder.setRemark(Decoder.convertGetString(rs.getString(11)));
          purchaseOrder.setShippingMark(Decoder.convertGetString(rs.getString(12)));
          purchaseOrder.setPoStatus(
              (PoStatus)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPoStatusList(), rs.getString(13)));
          purchaseOrder.setCreationDate(Decoder.convertGetString(rs.getString(14)));
          purchaseOrder.setCreatedBy(Decoder.convertGetString(rs.getString(15)));
          purchaseOrder.setModifiedReason(Decoder.convertGetString(rs.getString(17)));
          vendor.setVendorName(Decoder.convertGetString(rs.getString(19)));
          contact.setContactPersonName(Decoder.convertGetString(rs.getString(20)));
          contact.setAddress(Decoder.convertGetString(rs.getString(21)));
          contact.setMobile(Decoder.convertGetString(rs.getString(22)));
          contact.setFax(Decoder.convertGetString(rs.getString(23)));
          contact.setEmail(Decoder.convertGetString(rs.getString(24)));
          purchaseOrder.setPoType(
              (SelectionOption)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPoTypeList(), rs.getString(25)));
          purchaseOrder.setPoCategory(
              (PoCategory)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getPoCategoryList(),
                      rs.getString(26)));
          purchaseOrder.setPoRefNo(Decoder.convertGetString(rs.getString(27)));
          //                    purchaseOrder.setRevision(rs.getInt(27));
          vendor.setVendorCode(rs.getString(28));
          purchaseOrder.setVat(
              (VAT)
                  Utility.getObject(
                      ((PoMgr) mvcMgr).getPurchaseOrderMeta().getVatList(), rs.getString(29)));
          //
          // purchaseOrder.setIsSuspense(Decoder.convertGetString(rs.getString(30)).equals("Y") ?
          // true : false);
          purchaseOrder.setDiscountTotalPrice(Decoder.convertGetString(rs.getString(30)));
          purchaseOrder.setRevision(Decoder.convertGetString(rs.getString(31)));
          vendor.setCurrentPoContact(contact);
          purchaseOrder.setVendor(vendor);
          if (((PoMgr) mvcMgr).getEntryMode().equals(Constant.VIEW_STATUS)) {
            purchaseOrder.setFlag("Y");
          }
          vendor.setMajorSupplier(rs.getString(32) != null && rs.getString(32).equals("Y"));
          this.getFindList().add(purchaseOrder);
        }
      }
    }
  }
Esempio n. 10
0
  // refresh Quotation Contact List
  public void populateQuotationContact(
      String quotationId, int quotationRevision, QuotationMgr quotationMgr) throws SQLException {

    this.getContactList().clear();

    Connection conn = null;
    conn = com.cynosure.common.sql.OracleGate.getConnection();
    StringBuffer sql = new StringBuffer();

    sql.append(" SELECT MC.COUNTRY_CODE, MC.COUNTRY_NAME, MC.DESCRIPTION, ");
    sql.append("        MCS.SITE_CODE,  MCS.SITE_NAME, MCS.ADDRESS,");
    sql.append("        MCS.PHONE,  MCS.FAX, MCS.MAIN_OFFICE, ");
    sql.append("        MCC.CONTACT_CODE, MCC.CUSTOMER_CODE, MCC.CONTACT_PERSON, ");
    sql.append("        MCC.DEP, MCC.TITLE, MCC.EMAIL,  ");
    sql.append("        MCC.PHONE, MCC.EXT, MCC.DECISION_MAKER, ");
    sql.append("        MCC.DESCRIPTION, MC.COUNTRY_ID, MCS.SITE_ID, ");
    sql.append("        MCC.CONTACT_ID, NVL(OQQV.PAYMENT_TERM_ID, '0') ");
    sql.append(" FROM MOD_CUST_CONTACT MCC, ");
    sql.append("      MOD_CUST_SITE MCS, ");
    sql.append("      MOD_COUNTRY MC, ");
    sql.append("      OM_QUOTE_QUOTE_REV OQQV ");
    sql.append(" WHERE OQQV.QUOTATION_ID = :1 ");
    sql.append(" AND   OQQV.QUOTATION_REV = :2  ");
    sql.append(" AND   MCC.CUSTOMER_ID = OQQV.CUSTOMER_ID ");
    sql.append(" AND   MCC.CONTACT_ID = OQQV.CONTACT_ID ");
    sql.append(" AND   MCS.CUSTOMER_ID = MCC.CUSTOMER_ID ");
    sql.append(" AND   MCS.SITE_ID = MCC.SITE_ID ");
    sql.append(" AND   MC.COUNTRY_ID = MCS.COUNTRY_ID ");

    DeBug.print(sql.toString());
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
      pstmt = conn.prepareStatement(sql.toString());
      pstmt.setString(1, Decoder.convertSetString(quotationId));
      pstmt.setInt(2, quotationRevision);

      rs = pstmt.executeQuery();
      if (rs.next()) {

        Country country = new Country();
        country.setAttributeId(Decoder.convertGetString(String.valueOf(rs.getLong(20))));
        country.setAttributeCode(Decoder.convertGetString(rs.getString(1)));
        country.setAttributeName(Decoder.convertGetString(rs.getString(2)));
        country.setDescription(Decoder.convertGetString(rs.getString(3)));
        Site site = new Site();
        site.setSiteId(Decoder.convertGetString(String.valueOf(rs.getLong(21))));
        site.setSiteCode(Decoder.convertGetString(rs.getString(4)));
        site.setSiteName(Decoder.convertGetString(rs.getString(5)));
        site.setAddress(Decoder.convertGetString(rs.getString(6)));
        site.setPhone(Decoder.convertGetString(rs.getString(7)));
        site.setFax(Decoder.convertGetString(rs.getString(8)));
        site.setSelectedSiteType(Decoder.convertGetString(rs.getString(9)));

        site.setCountry(country);

        Contact contact = new Contact();
        contact.setContactId(Decoder.convertGetString(String.valueOf(rs.getLong(22))));
        contact.setContactCode(Decoder.convertGetString(rs.getString(10)));
        contact.setContactPersonName(Decoder.convertGetString(rs.getString(12)));
        contact.setDepartment(Decoder.convertGetString(rs.getString(13)));
        contact.setTitle(Decoder.convertGetString(rs.getString(14)));
        contact.setPhone(Decoder.convertGetString(rs.getString(16)));
        contact.setExt(Decoder.convertGetString(rs.getString(17)));
        contact.setEmail(Decoder.convertGetString(rs.getString(15)));
        contact.setIsDecisionMaker(
            Decoder.convertGetString(rs.getString(18)) != null
                    && Decoder.convertGetString(rs.getString(18)).equals("Y")
                ? true
                : false);
        contact.setDescription(Decoder.convertGetString(rs.getString(19)));

        if (rs.getString(23) != null && !rs.getString(23).equals("")) {
          this.setPaymentTerm(
              (SelectionOption)
                  Utility.getObject(
                      quotationMgr.getCurrentQoutationFormMeta().getPaymentTermList(),
                      rs.getString(23)));
        }

        contact.setSite(site);
        this.setCurrentContact(contact);
      }
    } finally {
      if (conn != null) {
        OracleGate.freeConnection(conn);
      }
      try {
        if (pstmt != null) {
          pstmt.close();
        }
        pstmt = null;
        rs.close();
        rs = null;
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }