public void updateEpisodes(Serie serie) {
try {
super.open();
for (Episode episode : serie.getEpisodes()) {
String where = "pk_id = " + episode.getId();
ContentValues values = new ContentValues();
values.put("id_serie", serie.getId());
values.put("name", episode.getName());
values.put("season", episode.getSeason());
values.put("number", episode.getNumber());
if (episode.getId() == 0) {
db.insert(TABLE_NAME, null, values);
} else {
db.update(TABLE_NAME, values, where, null);
}
}
} catch (SQLException e) {
Log.e("SeriesManager", "Error trying to update Episodes: " + e.toString());
} finally {
super.close();
}
}
