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);
}