// get single Incident
public Incident getIncident(long incident_id) {
Incident anIncident = new Incident();
db = dbHelper.getReadableDatabase();
String selectQuery = "SELECT * FROM " + Constants.TABLE_INCIDENT + " WHERE Id = " + incident_id;
Log.e(LOG, selectQuery);
// Cursor c = db.rawQuery(selectQuery, null);
Cursor c =
db.query(
Constants.TABLE_INCIDENT, // a. table
new String[] {
"Id",
"IncidentTypeId",
"CreatedByContactId",
"IncidentDate",
"Description",
"InitialAction",
"Reportable"
}, // b. column names
" Id = ?", // c. selections
new String[] {String.valueOf(incident_id)}, // d. selections args
null, // e. group by
null, // f. having
null, // g. order by
null);
// if (c != null)
// c.moveToFirst();
if (c.moveToFirst()) {
anIncident.setId(c.getInt(c.getColumnIndex("Id")));
anIncident.setIncidentType(
incidentType_dao.getIncidentType(c.getInt(c.getColumnIndex("IncidentTypeId"))));
anIncident.setCreatedBy(contact_dao.getContact(c.getColumnIndex("CreatedByContactId")));
anIncident.setIncidentDate(
DateTimeHelper.parseFromISO8601(c.getString(c.getColumnIndex("IncidentDate"))));
anIncident.setDescription((c.getString(c.getColumnIndex("Description"))));
anIncident.setInitialAction((c.getString(c.getColumnIndex("InitialAction"))));
anIncident.setReportable(c.getInt(c.getColumnIndex("Reportable")) > 0);
anIncident.setNotifyContacts(getAllNotifyContactsForIncident(incident_id));
anIncident.setAttachments(getAllAttachmentsForIncident(incident_id));
}
c.close();
return anIncident;
}
