public void UpdateAllType() { if (IsSaved()) { // update serie ContentValues values = new ContentValues(); values.put(SeriesContract.SeriesEntry.COLUMN_TYPE, type); MyApplication.getContext() .getContentResolver() .update( SeriesContract.SeriesEntry.CONTENT_URI, values, SeriesContract.SeriesEntry.COLUMN_ID + "=?", new String[] {id}); // update episodes values = new ContentValues(); int viewed = 0; if (type == VIEWED) viewed = 1; values.put(SeriesContract.EpisodesEntry.COLUMN_VIEWED, viewed); MyApplication.getContext() .getContentResolver() .update( SeriesContract.EpisodesEntry.CONTENT_URI, values, SeriesContract.EpisodesEntry.COLUMN_SERIE_ID + "=?", new String[] {id}); for (Episode episode : episodes) { episode.setViewed(viewed); } } }
public void LoadEpisodes() { if (id.equals("")) return; Cursor data = MyApplication.getContext() .getContentResolver() .query( SeriesContract.EpisodesEntry.CONTENT_URI, EPISODES_COLUMNS, SeriesContract.EpisodesEntry.COLUMN_SERIE_ID + " = ?", new String[] {id}, null); episodes = new ArrayList<>(); while (data.moveToNext()) { Episode myEpisode = new Episode(); myEpisode.set_id(COL__ID); myEpisode.setSerie_id(data.getString(COLUMN_SERIE_ID)); myEpisode.setSeason_id(data.getString(COLUMN_SEASON_ID)); myEpisode.setEpisode_id(data.getString(COLUMN_EPISODE_ID)); myEpisode.setSeason_number(data.getInt(COLUMN_SEASON_NUMBER)); myEpisode.setEpisode_number(data.getInt(COLUMN_EPISODE_NUMBER)); myEpisode.setName(data.getString(COLUMN_NAME)); myEpisode.setDate(data.getString(COLUMN_DATE)); myEpisode.setOverview(data.getString(COLUMN_OVERVIEW)); myEpisode.setRating(data.getString(COLUMN_RATING)); myEpisode.setVotes(data.getString(COLUMN_VOTES)); myEpisode.setImage_url(data.getString(COLUMN_IMAGE_URL)); myEpisode.setViewed(data.getInt(COLUMN_VIEWED)); episodes.add(myEpisode); } data.close(); }