private void RefreshTvEpisodesLibrary() { Logger.Instance().Log("FrontView+", "Start Refresh : TvEpisodes"); var res = _remote.VideoLibrary.GetTvEpisodes(); Logger.Instance().Log("FrontView+", "Remote TvEpisodes : " + res.Count); var oldData = _database.GetTvEpisodeFavorites(_remoteInfo.Id); _database.SetBulkInsert(true); _database.BeginTransaction(); _database.DeleteRemoteTvEpisodes(_remoteInfo.Id); foreach (var apiTvEpisode in res) { long oldFavorite = 0; foreach (var episode in oldData) { if (episode.IdEpisode == apiTvEpisode.IdEpisode) oldFavorite = episode.IsFavorite; } var tvEpisode = new Yatse2TvEpisode(apiTvEpisode) {IdRemote = _remoteInfo.Id, IsFavorite = oldFavorite}; _database.InsertTvEpisode(tvEpisode); } _database.CommitTransaction(); _database.SetBulkInsert(false); Logger.Instance().Log("FrontView+", "End Refresh : TvEpisodes"); }
/** private void RefreshTvSeasonLibrary() { Logger.Instance().Log("FrontView+", "Start Refresh : TvSeasons"); var res = _remote.VideoLibrary.GetTvSeasons(); Logger.Instance().Log("FrontView+", "Remote TvSeasons : " + res.Count); var oldData = _database.GetTvSeasonFavorites(_remoteInfo.Id); _database.SetBulkInsert(true); _database.BeginTransaction(); _database.DeleteRemoteTvSeasons(_remoteInfo.Id); foreach (var apiTvSeason in res) { long oldFavorite = 0; foreach (var show in oldData) { if (show.IdShow == apiTvSeason.IdShow) oldFavorite = show.IsFavorite; } var tvSeason = new Yatse2TvSeason(apiTvSeason) {IdRemote = _remoteInfo.Id, IsFavorite = oldFavorite}; _database.InsertTvSeason(tvSeason); } _database.CommitTransaction(); _database.SetBulkInsert(false); Logger.Instance().Log("FrontView+", "End Refresh : TvSeasons"); } */ private void QuickRefreshTvEpisodesLibrary() { Logger.Instance().Log("FrontView+", "Start QUICK Refresh : TvEpisodes"); var res = _remote.VideoLibrary.GetTvEpisodesRefresh(); Logger.Instance().Log("FrontView+", "Remote QUICK REFRESH TvEpisodes : " + res.Count); var oldData = _database.GetTvEpisode(_remoteInfo.Id); _database.SetBulkInsert(true); _database.BeginTransaction(); // _database.DeleteRemoteTvEpisodes(_remoteInfo.Id); var notfound = true; foreach (var apiTvEpisode in res) { notfound = true; foreach (var episode in oldData) { if (episode.IdEpisode == apiTvEpisode.IdEpisode) { notfound = false; Logger.Instance().Log("FrontView+", "Episode IDomovie ID" + episode.IdEpisode + " apiTvEpisode.Id:" + apiTvEpisode.IdEpisode); } } if (notfound == true) { Logger.Instance().Log("FrontView+", "Inserting TVEpisode:"+apiTvEpisode.ShowTitle+": Episode ID"+apiTvEpisode.IdEpisode +" Id Show:"+apiTvEpisode.IdShow); var tvEpisode = new Yatse2TvEpisode(apiTvEpisode) { IdRemote = _remoteInfo.Id }; _database.InsertTvEpisode(tvEpisode); } } _database.CommitTransaction(); _database.SetBulkInsert(false); Logger.Instance().Log("FrontView+", "End QUICK Refresh : TvEpisodes"); }
public long InsertTvEpisode(Yatse2TvEpisode episode) { if (episode == null) return 0; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"INSERT INTO `TvEpisodes` ( IdRemote ,IdEpisode,IdFile,IdShow,Title,ShowTitle,Rating,Plot,Director,Date,Mpaa,Studio,Season,Episode,FileName,Path,PlayCount,Hash,Thumb,Fanart,IsStack,IsFavorite ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);"; sqlCmd.Parameters.AddWithValue("a1", episode.IdRemote); sqlCmd.Parameters.AddWithValue("a2", episode.IdEpisode); sqlCmd.Parameters.AddWithValue("a3", episode.IdFile); sqlCmd.Parameters.AddWithValue("a4", episode.IdShow); sqlCmd.Parameters.AddWithValue("a5", episode.Title); sqlCmd.Parameters.AddWithValue("a6", episode.ShowTitle); sqlCmd.Parameters.AddWithValue("a7", episode.Rating); sqlCmd.Parameters.AddWithValue("a8", episode.Plot); sqlCmd.Parameters.AddWithValue("a9", episode.Director); sqlCmd.Parameters.AddWithValue("a10", episode.Date); sqlCmd.Parameters.AddWithValue("a11", episode.Mpaa); sqlCmd.Parameters.AddWithValue("a12", episode.Studio); sqlCmd.Parameters.AddWithValue("a13", episode.Season); sqlCmd.Parameters.AddWithValue("a14", episode.Episode); sqlCmd.Parameters.AddWithValue("a15", episode.FileName); sqlCmd.Parameters.AddWithValue("a16", episode.Path); sqlCmd.Parameters.AddWithValue("a17", episode.PlayCount); sqlCmd.Parameters.AddWithValue("a18", episode.Hash); sqlCmd.Parameters.AddWithValue("a19", episode.Thumb); sqlCmd.Parameters.AddWithValue("a20", episode.Fanart); sqlCmd.Parameters.AddWithValue("a21", episode.IsStack); sqlCmd.Parameters.AddWithValue("a22", episode.IsFavorite); return QueryInsert(sqlCmd); }
public bool UpdateTvEpisode(Yatse2TvEpisode episode) { if (episode == null) return false; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"UPDATE `TvEpisodes` SET IdRemote = ?,IdEpisode = ?,IdFile = ?,IdShow = ?,Title = ?,ShowTitle = ?,Rating = ?,Plot = ?,Director = ?,Date = ?,Mpaa = ?,Studio = ?,Season = ?,Episode = ?,FileName = ?,Path = ?,PlayCount = ?,Hash = ?,Thumb = ?,Fanart = ?,IsStack = ?,IsFavorite = ? WHERE Id = @Id;"; sqlCmd.Parameters.AddWithValue("a1", episode.IdRemote); sqlCmd.Parameters.AddWithValue("a2", episode.IdEpisode); sqlCmd.Parameters.AddWithValue("a3", episode.IdFile); sqlCmd.Parameters.AddWithValue("a4", episode.IdShow); sqlCmd.Parameters.AddWithValue("a5", episode.Title); sqlCmd.Parameters.AddWithValue("a6", episode.ShowTitle); sqlCmd.Parameters.AddWithValue("a7", episode.Rating); sqlCmd.Parameters.AddWithValue("a8", episode.Plot); sqlCmd.Parameters.AddWithValue("a9", episode.Director); sqlCmd.Parameters.AddWithValue("a10", episode.Date); sqlCmd.Parameters.AddWithValue("a11", episode.Mpaa); sqlCmd.Parameters.AddWithValue("a12", episode.Studio); sqlCmd.Parameters.AddWithValue("a13", episode.Season); sqlCmd.Parameters.AddWithValue("a14", episode.Episode); sqlCmd.Parameters.AddWithValue("a15", episode.FileName); sqlCmd.Parameters.AddWithValue("a16", episode.Path); sqlCmd.Parameters.AddWithValue("a17", episode.PlayCount); sqlCmd.Parameters.AddWithValue("a18", episode.Hash); sqlCmd.Parameters.AddWithValue("a19", episode.Thumb); sqlCmd.Parameters.AddWithValue("a20", episode.Fanart); sqlCmd.Parameters.AddWithValue("a21", episode.IsStack); sqlCmd.Parameters.AddWithValue("a22", episode.IsFavorite); sqlCmd.Parameters.AddWithValue("@Id", episode.Id); return Query(sqlCmd); }
private Collection<Yatse2TvEpisode> QueryTvEpisode(SQLiteCommand query) { var tvEpisodes = new Collection<Yatse2TvEpisode>(); if (!_connected) return tvEpisodes; try { LogQuery(query); var sqldReader = query.ExecuteReader(); while (sqldReader.Read()) { var episode = new Yatse2TvEpisode { Id = GetLong(sqldReader, "Id"), IdRemote = GetLong(sqldReader, "IdRemote"), IdEpisode = GetLong(sqldReader, "IdEpisode"), IdFile = GetLong(sqldReader, "IdFile"), IdShow = GetLong(sqldReader, "IdShow"), Title = GetString(sqldReader, "Title"), ShowTitle = GetString(sqldReader, "ShowTitle"), Rating = GetString(sqldReader, "Rating"), Plot = GetString(sqldReader, "Plot"), Director = GetString(sqldReader, "Director"), Date = GetString(sqldReader, "Date"), Mpaa = GetString(sqldReader, "Mpaa"), Studio = GetString(sqldReader, "Studio"), Season = GetLong(sqldReader, "Season"), Episode = GetLong(sqldReader, "Episode"), FileName = GetString(sqldReader, "FileName"), Path = GetString(sqldReader, "Path"), PlayCount = GetLong(sqldReader, "PlayCount"), Hash = GetString(sqldReader, "Hash"), Thumb = GetString(sqldReader, "Thumb"), Fanart = GetString(sqldReader, "Fanart"), IsStack = GetLong(sqldReader, "IsStack"), IsFavorite = GetLong(sqldReader, "IsFavorite") }; tvEpisodes.Add(episode); } sqldReader.Dispose(); query.Dispose(); } catch (SQLiteException e) { Log(e.Message); } return tvEpisodes; }