Example #1
0
  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;
  }
Example #2
0
  public Integer updateUserInfo(UserModel user, Integer userId) {
    SQLiteDatabase db = this.getWritableDatabase();
    Integer updateOk;
    Integer returnStatus;

    ContentValues values = new ContentValues();

    values.put(fieldTotalQuestions, user.getTotalQuestions());
    values.put(fieldNumberRightAnswers, user.getNumsRightAnswers());
    values.put(fieldNumberCompletedQuestion, user.getTotalCompletedQuestions());
    values.put(fieldIsCompleted, user.getIsCompleted());
    updateOk =
        db.update(
            tableName, values, String.format("%s = ?", "id"), new String[] {userId.toString()});
    if (updateOk > 0) {
      returnStatus = AppConstant.UPDATE_DATA_SUCCESS;
    } else {
      returnStatus = AppConstant.UPDATE_DATA_FAILED;
    }
    return returnStatus;
  }