public static List<Task> getAll() {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
SQLiteDatabase db = databaseHelper.getReadableDatabase();
Cursor cursor =
db.query(TaskContract.TABLE, TaskContract.COLUMNS, null, null, null, null, TaskContract.ID);
List<Task> values = TaskContract.getTasks(cursor);
db.close();
databaseHelper.close();
return values;
}
public static long getTaskByWebId(long webId) {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
SQLiteDatabase db = databaseHelper.getReadableDatabase();
String where = TaskContract.IDWEB + " = ? ";
String[] params = {String.valueOf(webId)};
Cursor cursor =
db.query(TaskContract.TABLE, TaskContract.COLUMNS, where, params, null, null, null);
long idWebRetorno = TaskContract.getTask(cursor).get_id();
db.close();
databaseHelper.close();
return idWebRetorno;
}
public static Label getLabelByTaskId(long id) {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
SQLiteDatabase db = databaseHelper.getReadableDatabase();
String where = TaskContract._ID + " = ? ";
String[] params = {String.valueOf(id)};
Cursor cursor =
db.query(TaskContract.TABLE, TaskContract.COLUMNS, where, params, null, null, null);
Label label = TaskContract.getTask(cursor).getLabel();
db.close();
databaseHelper.close();
return label;
}
