@SuppressWarnings("unchecked")
private String checkForUniqueRTT(EventRTTEventVoCollection rttColl) {
ArrayList<String> names = new ArrayList<String>();
ArrayList<Serializable> values = new ArrayList<Serializable>();
DomainFactory factory = getDomainFactory();
StringBuffer ids = new StringBuffer();
StringBuffer exclude = new StringBuffer();
String errors = new String();
exclude.append(rttColl.get(0).getEvent().getID_Event());
for (int i = 0; i < rttColl.size(); i++) {
if (rttColl.get(i).getStatus().equals(PreActiveActiveInactiveStatus.ACTIVE)) {
ids.append(rttColl.get(i).getRTTEvent().getID_RTTEvent());
if (i < rttColl.size() - 1
&& rttColl.get(rttColl.size() - 1) != null
&& rttColl.get(rttColl.size() - 1).getStatusIsNotNull()
&& !rttColl
.get(rttColl.size() - 1)
.getStatus()
.equals(PreActiveActiveInactiveStatus.INACTIVE)) {
ids.append(" , ");
}
}
}
if (ids.length() == 0) return null;
names.add("id_status");
values.add(PreActiveActiveInactiveStatus.ACTIVE.getID());
List rtt =
factory.find(
"select exRTT.event.name, exRTT.event.status, provider.systemName, exRTT.id, rtt.name from EventRTTEvent as exRTT left join exRTT.event as event left join exRTT.rTTEvent as rtt left join rtt.providerSystem as provider left join event.status as status where rtt.id in ("
+ ids
+ ") and event.id <> "
+ exclude
+ " and status.id = :id_status ",
names,
values);
Iterator rttEvent = rtt.iterator();
while (rttEvent.hasNext()) {
Object[] obj = (Object[]) rttEvent.next();
errors +=
("RTT status event "
+ ((String) obj[2]).toUpperCase()
+ " , "
+ ((String) obj[4]).toUpperCase()
+ " is already linked to event "
+ ((String) obj[0]).toUpperCase()
+ "\n");
}
return errors;
}
private void saveRTT(
EventVo event,
EventRTTEventVoCollection rttToBeAdded,
EventRTTEventVoCollection rttToBeDeteled,
DomainFactory factory,
Event domainRecord)
throws StaleObjectException, ForeignKeyViolationException {
// Save RTT
if (rttToBeAdded != null) {
for (int j = 0; j < rttToBeAdded.size(); j++) {
EventRTTEvent domainRTT =
EventRTTEventVoAssembler.extractEventRTTEvent(factory, rttToBeAdded.get(j));
RTTEvent rttEvent = (RTTEvent) domainRTT.getRTTEvent();
;
rttEvent.setUpperName(rttEvent.getName());
domainRTT.setEvent(domainRecord);
if (domainRTT.getStatus().equals(getDomLookup(PreActiveActiveInactiveStatus.ACTIVE))
&& domainRTT.getActivatedDateTime() == null) {
domainRTT.setStatus(getDomLookup(PreActiveActiveInactiveStatus.ACTIVE));
domainRTT.setActivatedBy(getUser());
domainRTT.setActivatedDateTime(new Date());
} else if (domainRTT
.getStatus()
.equals(getDomLookup(PreActiveActiveInactiveStatus.INACTIVE))
&& domainRTT.getInactivatedDateTime() == null) {
if (domainRTT.getInactivatedBy() == null) {
domainRTT.setInactivatedBy(getUser());
domainRTT.setInactivatedDateTime(new Date());
}
}
factory.save(domainRTT);
}
}
if (rttToBeDeteled != null) {
for (int j = 0; j < rttToBeDeteled.size(); j++) {
EventRTTEvent domainRTT =
EventRTTEventVoAssembler.extractEventRTTEvent(factory, rttToBeDeteled.get(j));
factory.delete(domainRTT);
}
}
}