public void insertSerie(int id, String name, String overview) { SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = "INSERT OR REPLACE INTO series (id, name, overview) VALUES( @id, @name, @overview )"; cmd.Parameters.Add(new SQLiteParameter("@id", id)); cmd.Parameters.Add(new SQLiteParameter("@name", name)); cmd.Parameters.Add(new SQLiteParameter("@overview", overview)); SQLiteDatabase db = getDb(); db.ExecuteNonQuery(cmd); }
public void insertEpisode(int id, int seriesId, String name, String overview, int episodeNumber, int seasonNumber, int firstAired, Boolean seen) { SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = "INSERT OR REPLACE INTO episodes (id, seriesid, name, overview, episode, season, firstaired, seen)" + "VALUES(@id, @seriesid, @name, @overview, @episode, @season, @firstaired, @seen)"; cmd.Parameters.Add(new SQLiteParameter("@id", id)); cmd.Parameters.Add(new SQLiteParameter("@seriesid", seriesId)); cmd.Parameters.Add(new SQLiteParameter("@name", name)); cmd.Parameters.Add(new SQLiteParameter("@overview", overview)); cmd.Parameters.Add(new SQLiteParameter("@episode", episodeNumber)); cmd.Parameters.Add(new SQLiteParameter("@season", seasonNumber)); cmd.Parameters.Add(new SQLiteParameter("@firstaired", firstAired)); cmd.Parameters.Add(new SQLiteParameter("@seen", seen)); SQLiteDatabase db = getDb(); db.ExecuteNonQuery(cmd); }