@Override
public String deactivateRequirement(Requirement requirement) {
SqlSession sqlSession = getSqlSessionFactory().openSession();
try {
RequirementMapper requirementMapper = sqlSession.getMapper(RequirementMapper.class);
if (requirementMapper.checkIfExistingRequirement(requirement) > 0) {
requirementMapper.deactivateRequirement(requirement);
sqlSession.commit();
System.out.println(requirement.getRequirementId());
return "success";
}
return "failed-does-not-exist";
} catch (Exception e) {
e.printStackTrace();
sqlSession.rollback();
} finally {
sqlSession.close();
}
return "failed-database";
}
