public List<Tarefa> selecionarTodos() throws ParseException {
List<Tarefa> lista = new ArrayList<Tarefa>();
// Abrir o banco de dados para leitura
db = helper.getReadableDatabase();
// Obter os dados da tabela
Cursor cursor = db.query("tarefa", null, null, null, null, null, "dataLembrete");
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
String auxData;
// Inserir dados do cursos na lista instanciada anteriormente
if (cursor.moveToFirst()) {
do {
Tarefa Tarefa = new Tarefa();
Tarefa.setId(cursor.getInt(cursor.getColumnIndex("id")));
Tarefa.setDescricao(cursor.getString(cursor.getColumnIndex("descricao")));
auxData = String.valueOf(cursor.getInt(cursor.getColumnIndex("dataLimite")));
System.out.println(auxData + auxData.length());
if (!auxData.equals("")
&& !auxData.equals(null)
&& !auxData.isEmpty()
&& !auxData.equals("0")) {
if (auxData.length() == 7) {
auxData = "0" + auxData;
}
auxData =
auxData.subSequence(0, 2).toString().concat("/")
+ auxData.subSequence(2, 4).toString().concat("/")
+ auxData.subSequence(4, 8).toString();
System.out.println(auxData + " teste");
Tarefa.setDataLimite(sdf.parse(auxData));
}
System.out.println("passou");
auxData = "";
auxData = String.valueOf(cursor.getLong(cursor.getColumnIndex("dataLembrete")));
if (!auxData.equals("")
&& !auxData.equals(null)
&& !auxData.isEmpty()
&& !auxData.equals("0")) {
if (auxData.length() == 7) {
auxData = "0" + auxData;
}
auxData =
auxData.subSequence(0, 2).toString().concat("/")
+ auxData.subSequence(2, 4).toString().concat("/")
+ auxData.subSequence(4, 8).toString();
Tarefa.setDataLembrete(sdf.parse(auxData));
}
auxData = "";
auxData = String.valueOf(cursor.getLong(cursor.getColumnIndex("dataRealizacao")));
if (!auxData.equals("")
&& !auxData.equals(null)
&& !auxData.isEmpty()
&& !auxData.equals("0")) {
if (auxData.length() == 7) {
auxData = "0" + auxData;
}
auxData =
auxData.subSequence(0, 2).toString().concat("/")
+ auxData.subSequence(2, 4).toString().concat("/")
+ auxData.subSequence(4, 8).toString();
Tarefa.setDataRealizacao(sdf.parse(auxData));
}
auxData = "";
Tarefa.setStatus(cursor.getString(cursor.getColumnIndex("status")));
Tarefa.setUsername(cursor.getString(cursor.getColumnIndex("username")));
Tarefa.setIdCategoria(cursor.getInt(cursor.getColumnIndex("idCategoria")));
lista.add(Tarefa);
} while (cursor.moveToNext());
}
cursor.close();
db.close();
helper.close();
return lista;
}
