private CustomSeriesListDTO convertHibernateObjectToCustomSeriesListDTO(
List<CustomSeriesList> daos) {
List<CustomSeriesListDTO> returnList = new ArrayList<CustomSeriesListDTO>();
// if (daos != null) {
// this should contain only 1 record for customSeriesList
for (int i = 0; i < daos.size(); i++) {
CustomSeriesListDTO dto = new CustomSeriesListDTO();
CustomSeriesList series = (CustomSeriesList) daos.get(0);
Set<CustomSeriesListAttribute> children = series.getCustomSeriesListAttributes();
List<String> seriesUidsList = new ArrayList<String>();
for (Iterator<CustomSeriesListAttribute> iter = children.iterator(); iter.hasNext(); ) {
CustomSeriesListAttribute attr = iter.next();
String seriesInstanceUid = attr.getSeriesInstanceUid();
seriesUidsList.add(seriesInstanceUid);
}
dto.setName(series.getName());
dto.setComment(series.getComment());
dto.setHyperlink(series.getHyperlink());
dto.setDate(series.getCustomSeriesListTimestamp());
dto.setId(series.getId());
dto.setSeriesInstanceUIDs(seriesUidsList);
dto.setUserName(series.getUserName());
returnList.add(dto);
}
/*} else {
throw new Exception("No record found the query.");
}*/
return returnList.get(0);
}
private List<CustomSeriesListDTO> convertHibernateObjectToCustomSeriesListDTOList(
List<CustomSeriesList> daos) {
List<CustomSeriesListDTO> returnList = new ArrayList<CustomSeriesListDTO>();
if (daos != null) {
for (CustomSeriesList dataRow : daos) {
Date d = dataRow.getCustomSeriesListTimestamp();
CustomSeriesListDTO dto = new CustomSeriesListDTO();
dto.setName(dataRow.getName());
dto.setComment(dataRow.getComment());
dto.setHyperlink((String) dataRow.getHyperlink());
dto.setDate(d);
dto.setId(dataRow.getId());
dto.setUserName(dataRow.getUserName());
Set<CustomSeriesListAttribute> children = dataRow.getCustomSeriesListAttributes();
List<String> seriesUidsList = new ArrayList<String>();
for (Iterator<CustomSeriesListAttribute> iter = children.iterator(); iter.hasNext(); ) {
CustomSeriesListAttribute attr = iter.next();
String seriesInstanceUid = attr.getSeriesInstanceUid();
seriesUidsList.add(seriesInstanceUid);
}
dto.setSeriesInstanceUIDs(seriesUidsList);
returnList.add(dto);
}
}
return returnList;
}
private List<CustomSeriesListAttributeDTO> convertHibernateObjectToCustomSeriesListAttributeDTO(
List<CustomSeriesListAttribute> daos) {
List<CustomSeriesListAttributeDTO> returnList = new ArrayList<CustomSeriesListAttributeDTO>();
if (daos != null) {
// this should contain only 1 record for customSeriesList
for (int i = 0; i < daos.size(); i++) {
CustomSeriesListAttribute rowData = daos.get(i);
CustomSeriesListAttributeDTO dto =
new CustomSeriesListAttributeDTO(rowData.getId(), rowData.getSeriesInstanceUid());
returnList.add(dto);
}
} /* else {
throw new Exception("No record found for the query.");
}*/
return returnList;
}
/**
* insert a new record for the custom series list
*
* @param customList
*/
@Transactional(propagation = Propagation.REQUIRED)
public long insert(CustomSeriesListDTO customList, String username) throws DataAccessException {
CustomSeriesList seriesList = new CustomSeriesList();
seriesList.setName(customList.getName());
seriesList.setComment(customList.getComment());
seriesList.setHyperlink(customList.getHyperlink());
seriesList.setUserName(username);
seriesList.setCustomSeriesListTimestamp(new Date());
List<String> seriesUids = customList.getSeriesInstanceUIDs();
for (String seriesInstanceUid : seriesUids) {
CustomSeriesListAttribute attr = new CustomSeriesListAttribute();
attr.setSeriesInstanceUid(seriesInstanceUid);
seriesList.addChild(attr);
}
getHibernateTemplate().saveOrUpdate(seriesList);
return seriesList.getId();
}
/** update database with data in the dto */
@Transactional(propagation = Propagation.REQUIRED)
public long update(CustomSeriesListDTO editList, String userName, Boolean updatedSeries)
throws DataAccessException {
CustomSeriesList seriesList = new CustomSeriesList();
seriesList.setName(editList.getName());
seriesList.setComment(editList.getComment());
seriesList.setHyperlink(editList.getHyperlink());
seriesList.setId(editList.getId());
seriesList.setCustomSeriesListTimestamp(new Date());
seriesList.setUserName(userName);
List<CustomSeriesListAttributeDTO> attributeDtos = editList.getSeriesInstanceUidsList();
if (updatedSeries) {
logger.debug("updatedSeries = " + updatedSeries + " ... delete then insert... ");
CustomSeriesList existingList =
(CustomSeriesList) getHibernateTemplate().load(CustomSeriesList.class, editList.getId());
Set<CustomSeriesListAttribute> children = existingList.getCustomSeriesListAttributes();
logger.debug("total children to delete: " + children.size());
existingList.getCustomSeriesListAttributes().removeAll(children);
for (Iterator<CustomSeriesListAttribute> itr = children.iterator(); itr.hasNext(); ) {
getHibernateTemplate().delete((CustomSeriesListAttribute) itr.next());
}
getHibernateTemplate().flush();
existingList.setName(editList.getName());
existingList.setComment(editList.getComment());
existingList.setHyperlink(editList.getHyperlink());
existingList.setCustomSeriesListTimestamp(new Date());
existingList.setUserName(userName);
for (CustomSeriesListAttributeDTO dto : attributeDtos) {
CustomSeriesListAttribute attr = new CustomSeriesListAttribute();
attr.setSeriesInstanceUid(dto.getSeriesInstanceUid());
attr.setCustomSeriesListPkId(existingList.getId());
existingList.addChild(attr);
}
getHibernateTemplate().update(existingList);
} else {
logger.debug("updatedSeries = " + updatedSeries + " ... updating..");
getHibernateTemplate().update(seriesList);
}
return 1L;
}
