/** Creates a new discrepancy note */
public EntityBean create(EntityBean eb) {
DiscrepancyNoteBean sb = (DiscrepancyNoteBean) eb;
HashMap variables = new HashMap();
HashMap nullVars = new HashMap();
// INSERT INTO discrepancy_note
// (description, discrepancy_note_type_id ,
// resolution_status_id , detailed_notes , date_created,
// owner_id, parent_dn_id)
// VALUES (?,?,?,?,now(),?,?)
variables.put(new Integer(1), sb.getDescription());
variables.put(new Integer(2), new Integer(sb.getDiscrepancyNoteTypeId()));
variables.put(new Integer(3), new Integer(sb.getResolutionStatusId()));
variables.put(new Integer(4), sb.getDetailedNotes());
variables.put(new Integer(5), new Integer(sb.getOwner().getId()));
if (sb.getParentDnId() == 0) {
nullVars.put(new Integer(6), new Integer(Types.INTEGER));
variables.put(new Integer(6), null);
} else {
variables.put(new Integer(6), new Integer(sb.getParentDnId()));
}
variables.put(new Integer(7), sb.getEntityType());
variables.put(new Integer(8), new Integer(sb.getStudyId()));
this.executeWithPK(digester.getQuery("create"), variables, nullVars);
if (isQuerySuccessful()) {
sb.setId(getLatestPK());
}
return sb;
}
/** getEntityFromHashMap, the method that gets the object from the database query. */
public Object getEntityFromHashMap(HashMap hm) {
DiscrepancyNoteBean eb = new DiscrepancyNoteBean();
Date dateCreated = (Date) hm.get("date_created");
Integer ownerId = (Integer) hm.get("owner_id");
eb.setCreatedDate(dateCreated);
eb.setOwnerId(ownerId.intValue());
// discrepancy_note_id serial NOT NULL,
// description varchar(255),
// discrepancy_note_type_id numeric,
// resolution_status_id numeric,
// detailed_notes varchar(1000),
// date_created date,
// owner_id numeric,
// parent_dn_id numeric,
eb.setId(selectInt(hm, "discrepancy_note_id"));
eb.setDescription((String) hm.get("description"));
eb.setDiscrepancyNoteTypeId(((Integer) hm.get("discrepancy_note_type_id")).intValue());
eb.setResolutionStatusId(((Integer) hm.get("resolution_status_id")).intValue());
eb.setParentDnId(((Integer) hm.get("parent_dn_id")).intValue());
eb.setDetailedNotes((String) hm.get("detailed_notes"));
eb.setEntityType((String) hm.get("entity_type"));
eb.setDisType(DiscrepancyNoteType.get(eb.getDiscrepancyNoteTypeId()));
eb.setResStatus(ResolutionStatus.get(eb.getResolutionStatusId()));
eb.setStudyId(selectInt(hm, "study_id"));
return eb;
}
