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;
}