private void RefreshTvSeasonLibrary() { Logger.Instance().Log("FrontView+", "Start Refresh : TvSeasons"); var res = _remote.VideoLibrary.GetTvSeasons(); Logger.Instance().Log("FrontView+", "Remote TvSeasons : " + res.Count); //Below should be empty as everything deleted before running so what is the point/at least initialises _database.SetBulkInsert(true); _database.BeginTransaction(); _database.DeleteRemoteTvSeasons(_remoteInfo.Id); var oldData = _database.GetTvSeason(_remoteInfo.Id); var notfound = true; foreach (var apiTvSeason in res) { notfound = true; // long oldFavorite = 0; foreach (var show in oldData) { if (show.IdShow == apiTvSeason.IdShow && apiTvSeason.SeasonNumber == show.SeasonNumber) { notfound = false; Logger.Instance().LogDump("FrontView+", "Refresh: TV Seasons : Season Already Exisits: Seasons Id Show.Name: " + show.Show + " show.Idshow ID:" + show.IdShow + " apiTvEpisode.Id:" + apiTvSeason.IdShow + " SeasonNumber:" + apiTvSeason.SeasonNumber + " show.SeasonNumber:" + show.SeasonNumber); } } if (notfound == true) { Logger.Instance().LogDump("FrontView+", "Refresh: TV Seasons :nserting TV Season :Show Name:" + apiTvSeason.Show + ": ShowID:" + apiTvSeason.IdShow + " Season Number:" + apiTvSeason.SeasonNumber + " Episode Count:" + apiTvSeason.EpisodeCount + " Hash " + apiTvSeason.Hash); var tvSeason = new Yatse2TvSeason(apiTvSeason) { IdRemote = _remoteInfo.Id }; _database.InsertTvSeason(tvSeason); oldData = _database.GetTvSeason(_remoteInfo.Id); } } _database.CommitTransaction(); _database.SetBulkInsert(false); Logger.Instance().Log("FrontView+", "End Refresh : TvSeasons"); }
private void QuickRefreshTvSeasonLibrary() { Logger.Instance().Log("FrontView+", "Start Quick Refresh : TvSeasons"); var res = _remote.VideoLibrary.GetTvSeasonsRefresh(); Logger.Instance().Log("FrontView+", "Remote Quick Refresh TvSeasons : " + res.Count); var oldData = _database.GetTvSeason(_remoteInfo.Id); _database.SetBulkInsert(true); _database.BeginTransaction(); //_database.DeleteRemoteTvSeasons(_remoteInfo.Id); var notfound = true; foreach (var apiTvSeason in res) { notfound = true; foreach (var show in oldData) { if (show.IdShow == apiTvSeason.IdShow && apiTvSeason.SeasonNumber == show.SeasonNumber) { notfound = false; Logger.Instance().Log("FrontView+", "Season Already Exisits: Seasons Id Show.Name: " +show.Show + " show.Idshow ID:" + show.IdShow + " apiTvEpisode.Id:" + apiTvSeason.IdShow+" SeasonNumber:"+apiTvSeason.SeasonNumber+" show.SeasonNumber:"+show.SeasonNumber); } } if (notfound == true) { Logger.Instance().Log("FrontView+", "Inserting TV Season :Show Name:"+apiTvSeason.Show+": ShowID:"+apiTvSeason.IdShow+" Season Number:" +apiTvSeason.SeasonNumber +" Episode Count:"+apiTvSeason.EpisodeCount +" Hash "+apiTvSeason.Hash); var tvSeason = new Yatse2TvSeason(apiTvSeason) { IdRemote = _remoteInfo.Id }; _database.InsertTvSeason(tvSeason); oldData = _database.GetTvSeason(_remoteInfo.Id); } } _database.CommitTransaction(); _database.SetBulkInsert(false); Logger.Instance().Log("FrontView+", "End Quick Refresh : TvSeasons"); }
public bool UpdateTvSeason(Yatse2TvSeason season) { if (season == null) return false; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"UPDATE `TvShows` SET IdRemote = ?,IdShow = ?,SeasonNumber = ?,EpisodeCount = ?,Hash = ?,Thumb = ?,Fanart = ?,IsFavorite = ?, Show = ? WHERE Id = @Id;"; sqlCmd.Parameters.AddWithValue("a1", season.IdRemote); sqlCmd.Parameters.AddWithValue("a2", season.IdShow); sqlCmd.Parameters.AddWithValue("a3", season.SeasonNumber); sqlCmd.Parameters.AddWithValue("a4", season.EpisodeCount); sqlCmd.Parameters.AddWithValue("a5", season.Hash); sqlCmd.Parameters.AddWithValue("a6", season.Thumb); sqlCmd.Parameters.AddWithValue("a7", season.Fanart); sqlCmd.Parameters.AddWithValue("a8", season.IsFavorite); sqlCmd.Parameters.AddWithValue("a9", season.Show); sqlCmd.Parameters.AddWithValue("@Id", season.Id); return Query(sqlCmd); }
private Collection<Yatse2TvSeason> QueryTvSeason(SQLiteCommand query) { var tvSeasons = new Collection<Yatse2TvSeason>(); if (!_connected) return tvSeasons; try { LogQuery(query); var sqldReader = query.ExecuteReader(); while (sqldReader.Read()) { var episode = new Yatse2TvSeason { Id = GetLong(sqldReader, "Id"), IdRemote = GetLong(sqldReader, "IdRemote"), IdShow = GetLong(sqldReader, "IdShow"), SeasonNumber = GetLong(sqldReader, "SeasonNumber"), EpisodeCount = GetLong(sqldReader, "EpisodeCount"), Hash = GetString(sqldReader, "Hash"), Thumb = GetString(sqldReader, "Thumb"), Fanart = GetString(sqldReader, "Fanart"), IsFavorite = GetLong(sqldReader, "IsFavorite"), Show = GetString(sqldReader, "Show") }; tvSeasons.Add(episode); } sqldReader.Dispose(); query.Dispose(); } catch (SQLiteException e) { Log(e.Message); } return tvSeasons; }
public long InsertTvSeason(Yatse2TvSeason season) { if (season == null) return 0; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"INSERT INTO `TvSeasons` ( IdRemote ,IdShow,SeasonNumber,EpisodeCount,Hash,Thumb,Fanart,IsFavorite,Show ) VALUES ( ?,?,?,?,?,?,?,?,?);"; sqlCmd.Parameters.AddWithValue("a1", season.IdRemote); sqlCmd.Parameters.AddWithValue("a2", season.IdShow); sqlCmd.Parameters.AddWithValue("a3", season.SeasonNumber); sqlCmd.Parameters.AddWithValue("a4", season.EpisodeCount); sqlCmd.Parameters.AddWithValue("a5", season.Hash); sqlCmd.Parameters.AddWithValue("a6", season.Thumb); sqlCmd.Parameters.AddWithValue("a7", season.Fanart); sqlCmd.Parameters.AddWithValue("a8", season.IsFavorite); sqlCmd.Parameters.AddWithValue("a9", season.Show); return QueryInsert(sqlCmd); }