public Audit getAudit(long id) {
SQLiteDatabase db = this.getReadableDatabase();
String selectQuery = "SELECT * FROM " + TABLE_AUDITS + " WHERE " + KEY_ID + " = " + id;
Log.e(LOG, selectQuery);
Cursor c = db.rawQuery(selectQuery, null);
if (c != null) c.moveToFirst();
Audit pd = new Audit();
pd.setId(c.getInt(c.getColumnIndex(KEY_ID)));
pd.setName(c.getString(c.getColumnIndex(KEY_NAME)));
pd.setScore((c.getInt(c.getColumnIndex(KEY_SCORE))));
pd.setStore_id((c.getInt(c.getColumnIndex(KEY_STORY_ID))));
return pd;
}
/**
* .Return List Audits
*
* @return
*/
public List<Audit> getAllAudits() {
List<Audit> audit = new ArrayList<Audit>();
String selectQuery = "SELECT * FROM " + TABLE_AUDITS;
Log.e(LOG, selectQuery);
SQLiteDatabase db = this.getReadableDatabase();
Cursor c = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (c.moveToFirst()) {
do {
Audit pd = new Audit();
pd.setId(c.getInt((c.getColumnIndex(KEY_ID))));
pd.setName((c.getString(c.getColumnIndex(KEY_NAME))));
pd.setStore_id((c.getInt(c.getColumnIndex(KEY_STORY_ID))));
pd.setScore((c.getLong(c.getColumnIndex(KEY_SCORE))));
// adding to todo list
audit.add(pd);
} while (c.moveToNext());
}
return audit;
}
