@Override public void deleteExternalApplication(Long id) throws CvqModelException, CvqObjectNotFoundException { ExternalApplication ea = getExternalApplicationById(id); if (ea.getExternalHomeFolders() != null) { // List<ExternalAccountItem> externalAccountItems = // paymentService.getAllExternalAccountItems(); // for (ExternalAccountItem eai : externalAccountItems) { // if // (eai.getExternalServiceSpecificDataByKey(ExternalServiceUtils.EXTERNAL_APPLICATION_ID_KEY).equals(String.valueOf(ea.getId()))) { // externalAccountItems.remove(eai); // eai.setExternalServiceSpecificData(null); // genericDAO.delete(eai); // } // } for (ExternalHomeFolder externalHomeFolder : ea.getExternalHomeFolders()) { externalHomeFolderService.deleteHomeFolderMappings( ea.getLabel(), externalHomeFolderService .getHomeFolderMapping(ea.getLabel(), externalHomeFolder.getExternalId()) .getHomeFolderId()); genericDAO.delete(externalHomeFolder); } ea.setExternalHomeFolders(null); } genericDAO.delete(ea); }
/* External Individual Id Last Name First Name External Family Account Id Address Is Responsible Email Phone */ @Override public Map<String, Integer> importHomeFolders(Long externalApplicationId, byte[] csvDatas) throws CvqModelException, CvqObjectNotFoundException { ExternalHomeFolder ehf; ExternalIndividual ei; ExternalApplication ea = getExternalApplicationById(externalApplicationId); Boolean created = false; Map<String, Integer> report = new HashMap<String, Integer>(); report.put("created", 0); report.put("updated", 0); try { CSVReader csvReader = new CSVReader(new StringReader(new String(csvDatas)), ',', '"', 1); for (Object o : csvReader.readAll()) { String[] line = (String[]) o; ehf = genericDAO .simpleSelect(ExternalHomeFolder.class) .and("externalId", line[3]) .and("externalApplication", ea) .unique(); if (ehf == null) { ehf = new ExternalHomeFolder(line[3], ea, line[4]); ea.getExternalHomeFolders().add(ehf); genericDAO.create(ehf); modifyExternalApplication(ea); report.put("created", report.get("created") + 1); created = true; } ei = genericDAO .simpleSelect(ExternalIndividual.class) .and("externalId", line[0]) .and("externalHomeFolder", ehf) .unique(); if (ei == null) { ei = new ExternalIndividual( line[0], line[1], line[2], line[6], line[7], "1".equals(line[5]) ? true : false); ei.setExternalHomeFolder(ehf); ehf.getIndividuals().add(ei); if (ei.isResponsible()) ehf.setAddress(line[4]); genericDAO.create(ei); genericDAO.update(ehf); if (!created) report.put("updated", report.get("updated") + 1); } else if (!ei.getLastName().equals(line[1]) || !ei.getFirstName().equals(line[2]) || (!ehf.getAddress().equals(StringUtils.upperCase(line[4])) && ei.isResponsible())) { ei.setLastName(line[1]); ei.setFirstName(line[2]); if (ei.isResponsible()) ehf.setAddress(line[4]); genericDAO.update(ei); genericDAO.update(ehf); report.put("updated", report.get("updated") + 1); } HibernateUtil.getSession().flush(); } } catch (Exception e) { logger.error(e.getMessage()); e.printStackTrace(); HibernateUtil.getSession().getTransaction().rollback(); throw new CvqModelException("external.error.csvImport"); } return report; }