Package com.tcs.hrr.domain

Examples of com.tcs.hrr.domain.Requirement


          .getAllRequirementIds();
      for (int i = 0; i < idsDB.size(); i++) {
        if (idsExcel.contains(idsDB.get(i))) {
          continue;
        } else {
          Requirement re = (Requirement) this.requirementDAO
              .findByRequirementId(idsDB).get(i);
          re.setStatus(Constant.REQUIREMENT_STATUS_CLOSED);
          this.updateRequirement(re);
        }
      }

      for (int i = 1; i <= sheet.getLastRowNum(); i++) {
        Requirement re = this.findRequirementByRequirementid(sheet
            .getRow(i).getCell(2).getStringCellValue());
        // New requirement
        if (re == null) {
          System.out.println("row i: " + sheet.getRow(i));
          Requirement newRe = createRequiement(sheet.getRow(i));
          newRe.setCreateDate(new Date());
          // Set requirement status to open
          newRe.setRequirementStatus((RequirementStatus) (this.requirementStatusDAO
              .findByValue(Constant.REQUIREMENT_STATUS_OPEN)
              .get(0)));
          newRe.setStatus(Constant.REQUIREMENT_STATUS_OPEN);
          this.saveRequirement(newRe);
        } else {
          Requirement updateRe = createRequiement(sheet.getRow(i));
          updateRe.setCreateBy(re.getCreateBy());
          updateRe.setCreateDate(re.getCreateDate());
          updateRe.setUpdateDate(new Date());
          updateRe.setRequirementHrrId(re.getRequirementHrrId());

          updateRe.setRequirementStatus((RequirementStatus) (this.requirementStatusDAO
              .findByValue(Constant.REQUIREMENT_STATUS_PROPOSED)
              .get(0)));
          updateRe.setStatus(Constant.REQUIREMENT_STATUS_PROPOSED);
          this.updateRequirement(updateRe);
        }
      }
    } catch (FileNotFoundException e) {
      e.printStackTrace();
View Full Code Here


    this.requirementDAO.findByRequirementId(requirementId);
    return null;
  }

  private Requirement createRequiement(HSSFRow row) {
    Requirement requirement = new Requirement();
    int cellIndex = 1;
    HSSFCell cell = row.getCell(cellIndex++);
    requirement.setRequestId(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRequirementId(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setIou(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCustomerGroup(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCustomer(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setLocation(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setKeyResource(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCompetencyArea(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setFocusArea(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setSubFocusArea(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCompetencySubArea(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCompetencySubArea1(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCompetencySubArea2(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCompetencySubArea3(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setProficiency(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setExperience(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setResumeStatus(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRole(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setTotalExp(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRealization(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCurrency(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setStartDate(cell.getDateCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setEndDate(cell.getDateCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRemarks(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setSutiabelCandidate(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setPrefferedStaffSource(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setPrefferedDesignation(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setLocationDetail(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCity(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setCountry(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setStaffReason(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setWonno(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setProjectType(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setWorkSectorOnsite(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setWorkSectorOffsite(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRequestEmpId(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRequestEmpName(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setResumeRejectNo(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRequirementType(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRmgEmpNo(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRmgEmpName(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setRequestCreatedOn(cell.getDateCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setGrsStatus(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setReassignHistory(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setBaCompname(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setGrsEmpId(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setGrsEmpName(cell.getStringCellValue());

    cell = row.getCell(cellIndex++);
    requirement.setHorizontal(cell.getStringCellValue());

    return requirement;
  }
View Full Code Here

  }

  public Requirement findById(java.lang.Integer id) {
    log.debug("getting Requirement instance with id: " + id);
    try {
      Requirement instance = (Requirement) getHibernateTemplate().get(
          "com.tcs.hrr.domain.Requirement", id);
      return instance;
    } catch (RuntimeException re) {
      log.error("get failed", re);
      throw re;
View Full Code Here

  }

  public Requirement merge(Requirement detachedInstance) {
    log.debug("merging Requirement instance");
    try {
      Requirement result = (Requirement) getHibernateTemplate().merge(
          detachedInstance);
      log.debug("merge successful");
      return result;
    } catch (RuntimeException re) {
      log.error("merge failed", re);
View Full Code Here

  }

  @Test
  public void testSave() {
    RequirementDAO rd = (RequirementDAO)ctx.getBean("requirementDao");
    Requirement re = new Requirement() ;
    re.setRequestId("3008806");
    re.setRequirementId("3123296");
    re.setIou("GE1-Parent");
    re.setCustomerGroup("Group Client - GE");
    re.setCustomer("GE ENERGY");
    re.setLocation("Onsite");
    rd.save(re);
    System.out.println("testSave getRequirementHrrId="+re.getRequirementHrrId());
  }
View Full Code Here

TOP

Related Classes of com.tcs.hrr.domain.Requirement

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.