.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();