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;
}
