public static List<Email> getAll() { DataBaseHelper dataBaseHelper = DataBaseHelper.getIstance(); SQLiteDatabase db = dataBaseHelper.getReadableDatabase(); Cursor cursor = db.query( EmailContract.TABLE, EmailContract.COLUNS, null, null, null, null, EmailContract.ID); List<Email> values = EmailContract.getEmails(cursor); db.close(); dataBaseHelper.close(); return values; }
public static List<Email> getAllByContact(Long idcontact) { DataBaseHelper dataBaseHelper = DataBaseHelper.getIstance(); SQLiteDatabase db = dataBaseHelper.getReadableDatabase(); String where = EmailContract.CONTACTID + " = ? "; String[] params = {idcontact.toString()}; Cursor cursor = db.query( EmailContract.TABLE, EmailContract.COLUNS, where, params, null, null, EmailContract.ID); List<Email> values = EmailContract.getEmails(cursor); db.close(); dataBaseHelper.close(); return values; }
public static void save(Email email) { DataBaseHelper dataBaseHelper = DataBaseHelper.getIstance(); SQLiteDatabase db = dataBaseHelper.getWritableDatabase(); ContentValues values = EmailContract.getContentValues(email); if (email.getId() == null) { db.insert(EmailContract.TABLE, null, values); } else { String where = EmailContract.ID + " = ? "; String[] params = {email.getId().toString()}; db.update(EmailContract.TABLE, values, where, params); } db.close(); dataBaseHelper.close(); }