public void addContact(Contact contact) { if (TextUtils.isEmpty(contact.getContactNumber())) { contact.setContactNumber(contact.getUserId()); } ContentValues contentValues = prepareContactValues(contact); dbHelper.getWritableDatabase().insert(CONTACT, null, contentValues); dbHelper.close(); }
public void updateContact(Contact contact) { ContentValues contentValues = prepareContactValues(contact); dbHelper .getWritableDatabase() .update( CONTACT, contentValues, MobiComDatabaseHelper.USERID + "=?", new String[] {contact.getUserId()}); dbHelper.close(); }
/** * Form a single contact from cursor * * @param cursor * @return */ public Contact getContact(Cursor cursor) { Contact contact = new Contact(); contact.setFullName(cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.FULL_NAME))); contact.setUserId(cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.USERID))); contact.setLocalImageUrl( cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.CONTACT_IMAGE_LOCAL_URI))); contact.setImageURL( cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.CONTACT_IMAGE_URL))); String contactNumber = cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.CONTACT_NO)); if (TextUtils.isEmpty(contactNumber)) { contact.setContactNumber( cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.USERID))); } else { contact.setContactNumber( cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.CONTACT_NO))); } contact.setApplicationId( cursor.getString(cursor.getColumnIndex(MobiComDatabaseHelper.APPLICATION_ID))); Long connected = cursor.getLong(cursor.getColumnIndex(MobiComDatabaseHelper.CONNECTED)); contact.setConnected(connected != 0 && connected.intValue() == 1); contact.setLastSeenAt( cursor.getLong(cursor.getColumnIndex(MobiComDatabaseHelper.LAST_SEEN_AT_TIME))); contact.processContactNumbers(context); return contact; }
public void deleteContact(Contact contact) { deleteContactById(contact.getUserId()); }
public ContentValues prepareContactValues(Contact contact) { ContentValues contentValues = new ContentValues(); if (!TextUtils.isEmpty(contact.getFullName())) { contentValues.put(MobiComDatabaseHelper.FULL_NAME, contact.getFullName()); } contentValues.put(MobiComDatabaseHelper.CONTACT_NO, contact.getContactNumber()); if (!TextUtils.isEmpty(contact.getImageURL())) { contentValues.put(MobiComDatabaseHelper.CONTACT_IMAGE_URL, contact.getImageURL()); } if (!TextUtils.isEmpty(contact.getLocalImageUrl())) { contentValues.put(MobiComDatabaseHelper.CONTACT_IMAGE_LOCAL_URI, contact.getLocalImageUrl()); } contentValues.put(MobiComDatabaseHelper.USERID, contact.getUserId()); if (!TextUtils.isEmpty(contact.getEmailId())) { contentValues.put(MobiComDatabaseHelper.EMAIL, contact.getEmailId()); } if (!TextUtils.isEmpty(contact.getApplicationId())) { contentValues.put(MobiComDatabaseHelper.APPLICATION_ID, contact.getApplicationId()); } contentValues.put(MobiComDatabaseHelper.CONNECTED, contact.isConnected() ? 1 : 0); if (contact.getLastSeenAt() != 0) { contentValues.put(MobiComDatabaseHelper.LAST_SEEN_AT_TIME, contact.getLastSeenAt()); } return contentValues; }