public Cursor getCursor() {
try {
super.open();
return super.db.query(
TABLE_NAME, Episode.columns, null, null, null, null, Episodes.DEFAULT_SORT_ORDER);
} catch (SQLException e) {
return null;
}
}
public void excludeEpisodesBd(long serieId) {
String where = "id_serie = " + serieId;
try {
super.open();
db.delete(TABLE_NAME, where, null);
} catch (SQLException e) {
Log.e("SeriesManager", "Error trying to exclude Episode: " + e.toString());
} finally {
super.close();
}
}
public void addEpisode(Episode episode, Serie serie) {
try {
super.open();
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());
db.insert(TABLE_NAME, null, values);
} catch (SQLException e) {
Log.e("SeriesManager", "Error trying to include Episode: " + e.toString());
} finally {
super.close();
}
}
public void updateEpisode(Episode episode, Serie serie) {
try {
String where = "pk_id = " + episode.getId();
super.open();
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());
db.update(TABLE_NAME, values, where, null);
} catch (SQLException e) {
Log.e("SeriesManager", "Error trying to update Episode: " + e.toString());
} finally {
super.close();
}
}
