public boolean create(UserModel user) { boolean createSuccessful = false; if (!checkIfExists(user)) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(fieldObjectFullName, user.getFullName()); values.put(fieldObjectPhone, user.getPhone()); values.put(fieldTotalQuestions, user.getTotalQuestions()); values.put(fieldNumberRightAnswers, user.getNumsRightAnswers()); values.put(fieldNumberCompletedQuestion, user.getTotalCompletedQuestions()); values.put(fieldIsCompleted, user.getIsCompleted()); createSuccessful = db.insert(tableName, null, values) > 0; if (createSuccessful) { Log.v(TAG, user.getFullName() + " created."); } db.close(); } return createSuccessful; }
public boolean checkIfExists(UserModel user) { boolean recordExists = false; SQLiteDatabase db = this.getWritableDatabase(); String sql = ""; sql += "SELECT " + fieldObjectId + " FROM " + tableName; sql += " WHERE full_name LIKE '%" + user.getFullName() + "%'"; sql += " AND phone = '" + user.getPhone() + "'"; Cursor cursor = db.rawQuery(sql, null); if (cursor != null) { if (cursor.getCount() > 0) { recordExists = true; } } cursor.close(); db.close(); return recordExists; }