public List<User> getAllUser() {
    List<User> userList = new ArrayList<User>();
    // Select All Query
    String selectQuery = "SELECT  * FROM " + TABLE_USER;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
      do {
        User user = new User();
        user.setPassword(cursor.getString(0));
        user.setToken(cursor.getString(1));
        user.setUserId(Integer.parseInt(cursor.getString(2)));
        user.setUsername(cursor.getString(3));
        user.setDateCreated(cursor.getString(4));
        user.setFirstName(cursor.getString(5));
        user.setLastName(cursor.getString(6));
        user.setGender(cursor.getString(7));
        // Adding user to list
        userList.add(user);
      } while (cursor.moveToNext());
    }

    // return user list
    return userList;
  }
  // Getting All Users
  public List<User> getAllUsers(int page) {
    List<User> userList = new ArrayList<User>();
    // Select All Query
    // String selectQuery = "SELECT * FROM " + TABLE_USER;

    SQLiteDatabase db = this.getWritableDatabase();
    // Cursor cursor = db.rawQuery(selectQuery, null);

    Cursor cursor =
        db.query(
            TABLE_USER,
            null,
            null,
            null,
            null,
            null,
            null,
            ((page - 1) * PAGE_SIZE) + ", " + PAGE_SIZE);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
      do {
        User user = new User();
        user.setUserId(Integer.parseInt(cursor.getString(0)));
        user.setUsername(cursor.getString(1));
        user.setPassword(cursor.getString(2));
        user.setToken(cursor.getString(3));
        user.setFirstName(cursor.getString(5));
        user.setLastName(cursor.getString(6));
        user.setGender(cursor.getString(7));
        user.setStatus(cursor.getString(8));
        // Adding person to list
        userList.add(user);
      } while (cursor.moveToNext());
    }

    cursor.close();

    // return person list
    return userList;
  }