private void updateParentQuery(QueryServiceHelperBean helperBean) { if (helperBean.getDn().getParentDiscrepancyNote() == null) return; DiscrepancyNote itemParentNote = discrepancyNoteDao.findByDiscrepancyNoteId( helperBean.getDn().getParentDiscrepancyNote().getDiscrepancyNoteId()); itemParentNote.setResolutionStatus(helperBean.getResStatus()); discrepancyNoteDao.saveOrUpdate(itemParentNote); }
private void saveQueryItemDatamap(QueryServiceHelperBean helperBean) { // Create Mapping for new Discrepancy Note DnItemDataMapId dnItemDataMapId = new DnItemDataMapId(); dnItemDataMapId.setDiscrepancyNoteId(helperBean.getDn().getDiscrepancyNoteId()); dnItemDataMapId.setItemDataId(helperBean.getItemData().getItemDataId()); dnItemDataMapId.setStudySubjectId(helperBean.getContainer().getSubject().getStudySubjectId()); dnItemDataMapId.setColumnName("value"); DnItemDataMap mapping = new DnItemDataMap(); mapping.setDnItemDataMapId(dnItemDataMapId); mapping.setItemData(helperBean.getItemData()); mapping.setStudySubject(helperBean.getContainer().getSubject()); mapping.setActivated(false); mapping.setDiscrepancyNote(helperBean.getDn()); dnItemDataMapDao.saveOrUpdate(mapping); // updateParentQuery(helperBean); }
private void prepareEmail(QueryServiceHelperBean helperBean) throws Exception { StringBuffer message = new StringBuffer(); message.append( MessageFormat.format( respage.getString("mailDNHeader"), helperBean.getUserAccount().getFirstName(), helperBean.getUserAccount().getLastName())); message.append( "<A HREF='" + SQLInitServlet.getField("sysURL.base") + "ViewNotes?module=submit&listNotes_f_discrepancyNoteBean.user="******"&listNotes_f_entityName=" + helperBean.getParentElementName() + "'>" + SQLInitServlet.getField("sysURL.base") + "</A><BR/>"); message.append(respage.getString("you_received_this_from")); message.append(respage.getString("email_body_separator")); message.append(respage.getString("disc_note_info")); message.append(respage.getString("email_body_separator")); message.append( MessageFormat.format( respage.getString("mailDNParameters1"), helperBean.getDn().getDescription(), helperBean.getDn().getDetailedNotes(), helperBean.getUserAccount().getUserName())); message.append(respage.getString("email_body_separator")); message.append(respage.getString("entity_information")); message.append(respage.getString("email_body_separator")); message.append( MessageFormat.format( respage.getString("mailDNParameters2"), helperBean.getDn().getStudy().getName(), helperBean.getDn().getDescription())); if (!("studySub".equalsIgnoreCase(helperBean.getDn().getEntityType()) || "subject".equalsIgnoreCase(helperBean.getDn().getEntityType()))) { message.append( MessageFormat.format( respage.getString("mailDNParameters3"), helperBean.getContainer().getStudyEvent().getStudyEventDefinition().getName())); if (!"studyEvent".equalsIgnoreCase(helperBean.getDn().getEntityType())) { message.append( MessageFormat.format( respage.getString("mailDNParameters4"), helperBean.getContainer().getCrfVersion().getCrf().getName())); if (!"eventCrf".equalsIgnoreCase(helperBean.getDn().getEntityType())) { message.append( MessageFormat.format( respage.getString("mailDNParameters6"), helperBean.getParentElementName())); } } } message.append(respage.getString("email_body_separator")); message.append( MessageFormat.format( respage.getString("mailDNThanks"), helperBean.getDn().getStudy().getName())); message.append(respage.getString("email_body_separator")); message.append(respage.getString("disclaimer")); message.append(respage.getString("email_body_separator")); message.append(respage.getString("email_footer")); String subject = MessageFormat.format( respage.getString("mailDNSubject"), helperBean.getDn().getStudy().getName(), helperBean.getParentElementName()); String emailBodyString = message.toString(); try { sendEmail(helperBean.getUserAccount().getEmail().trim(), subject, emailBodyString, true); } catch (Exception e) { logger.error(e.getMessage()); throw e; } }