private void RefreshTvShowLibrary()
{
Logger.Instance().Log("FrontView+", "Start Refresh : TvShows");
var res = _remote.VideoLibrary.GetTvShows();
Logger.Instance().Log("FrontView+", "Remote TvShows : " + res.Count);
var oldData = _database.GetTvShowFavorites(_remoteInfo.Id);
_database.SetBulkInsert(true);
_database.BeginTransaction();
_database.DeleteRemoteTvShows(_remoteInfo.Id);
foreach (var apiTvShow in res)
{
long oldFavorite = 0;
foreach (var show in oldData)
{
if (show.IdShow == apiTvShow.IdShow)
oldFavorite = show.IsFavorite;
}
var tvShow = new Yatse2TvShow(apiTvShow) {IdRemote = _remoteInfo.Id, IsFavorite = oldFavorite};
_database.InsertTvShow(tvShow);
}
_database.CommitTransaction();
_database.SetBulkInsert(false);
Logger.Instance().Log("FrontView+", "End Refresh : TvShows");
}
private void QuickRefreshTvShowLibrary()
{
Logger.Instance().Log("FrontView+", "Start Quick Refresh : TvShows");
var res = _remote.VideoLibrary.GetTvShowsRefresh();
Logger.Instance().Log("FrontView+", "Remote Quick Refresh TvShows : " + res.Count);
var oldData = _database.GetTvShow(_remoteInfo.Id);
_database.SetBulkInsert(true);
_database.BeginTransaction();
// _database.DeleteRemoteTvShows(_remoteInfo.Id);
var notfound = true;
/**
foreach (var apiTvShow in res)
{
Logger.Instance().Log("FrontView+", "res Data:" + apiTvShow.Title);
}
foreach (var show in oldData)
{
Logger.Instance().Log("FrontView+", "oldData Data:" + show.Title);
}
*/
foreach (var apiTvShow in res)
{
notfound = true;
foreach (var show in oldData)
{
// Logger.Instance().Log("FrontView+", "In Loop: oldData ShowName :" + show.Title);
if (show.IdShow == apiTvShow.IdShow)
{
notfound = false;
Logger.Instance().Log("FrontView+", "Quick Shows Check Id - Show Exists:" +show.Title +" - show.Idshow ID:" + show.IdShow + " apiTVShow.IdShow:" + apiTvShow.IdShow);
break;
}
}
if (notfound == true)
{
Logger.Instance().Log("FrontView+", "Inserting TV Show :Show Name:" + apiTvShow.Title + ":ShowID:" + apiTvShow.IdShow);
var tvShow = new Yatse2TvShow(apiTvShow) { IdRemote = _remoteInfo.Id };
_database.InsertTvShow(tvShow);
}
}
_database.CommitTransaction();
_database.SetBulkInsert(false);
Logger.Instance().Log("FrontView+", "End Quick Refresh : TvShows");
}
public long InsertTvShow(Yatse2TvShow show)
{
if (show == null)
return 0;
var sqlCmd = _dbConnection.CreateCommand();
sqlCmd.CommandText =
@"INSERT INTO `TvShows` ( IdRemote ,IdShow,IdScraper,Title,Plot,Premiered,Rating,Genre,Mpaa,Studio,Path,TotalCount,Hash,Thumb,Fanart,IsFavorite,Banner,Logo )
VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
sqlCmd.Parameters.AddWithValue("a1", show.IdRemote);
sqlCmd.Parameters.AddWithValue("a2", show.IdShow);
sqlCmd.Parameters.AddWithValue("a3", show.IdScraper);
sqlCmd.Parameters.AddWithValue("a4", show.Title);
sqlCmd.Parameters.AddWithValue("a5", show.Plot);
sqlCmd.Parameters.AddWithValue("a6", show.Premiered);
sqlCmd.Parameters.AddWithValue("a7", show.Rating);
sqlCmd.Parameters.AddWithValue("a8", show.Genre);
sqlCmd.Parameters.AddWithValue("a9", show.Mpaa);
sqlCmd.Parameters.AddWithValue("a10", show.Studio);
sqlCmd.Parameters.AddWithValue("a11", show.Path);
sqlCmd.Parameters.AddWithValue("a12", show.TotalCount);
sqlCmd.Parameters.AddWithValue("a13", show.Hash);
sqlCmd.Parameters.AddWithValue("a14", show.Thumb);
sqlCmd.Parameters.AddWithValue("a15", show.Fanart);
sqlCmd.Parameters.AddWithValue("a16", show.IsFavorite);
sqlCmd.Parameters.AddWithValue("a17", show.Banner);
sqlCmd.Parameters.AddWithValue("a18", show.Logo);
return QueryInsert(sqlCmd);
}
public bool UpdateTvShow(Yatse2TvShow show)
{
if (show == null)
return false;
var sqlCmd = _dbConnection.CreateCommand();
sqlCmd.CommandText =
@"UPDATE `TvShows` SET IdRemote = ?,IdShow = ?,IdScraper = ?,Title = ?,Plot = ?,Premiered = ?,Rating = ?,Genre = ?,Mpaa = ?,Studio = ?,Path = ?,TotalCount = ?,Hash = ?,Thumb = ?,Fanart = ?,IsFavorite = ?, Banner = ?, Logo = ? WHERE Id = @Id;";
sqlCmd.Parameters.AddWithValue("a1", show.IdRemote);
sqlCmd.Parameters.AddWithValue("a2", show.IdShow);
sqlCmd.Parameters.AddWithValue("a3", show.IdScraper);
sqlCmd.Parameters.AddWithValue("a4", show.Title);
sqlCmd.Parameters.AddWithValue("a5", show.Plot);
sqlCmd.Parameters.AddWithValue("a6", show.Premiered);
sqlCmd.Parameters.AddWithValue("a7", show.Rating);
sqlCmd.Parameters.AddWithValue("a8", show.Genre);
sqlCmd.Parameters.AddWithValue("a9", show.Mpaa);
sqlCmd.Parameters.AddWithValue("a10", show.Studio);
sqlCmd.Parameters.AddWithValue("a11", show.Path);
sqlCmd.Parameters.AddWithValue("a12", show.TotalCount);
sqlCmd.Parameters.AddWithValue("a13", show.Hash);
sqlCmd.Parameters.AddWithValue("a14", show.Thumb);
sqlCmd.Parameters.AddWithValue("a15", show.Fanart);
sqlCmd.Parameters.AddWithValue("a16", show.IsFavorite);
sqlCmd.Parameters.AddWithValue("a17", show.Banner);
sqlCmd.Parameters.AddWithValue("a18", show.Logo);
sqlCmd.Parameters.AddWithValue("@Id", show.Id);
return Query(sqlCmd);
}
private Collection<Yatse2TvShow> QueryTvShow(SQLiteCommand query)
{
var tvShows = new Collection<Yatse2TvShow>();
if (!_connected) return tvShows;
try
{
LogQuery(query);
var sqldReader = query.ExecuteReader();
while (sqldReader.Read())
{
var movie = new Yatse2TvShow
{
Id = GetLong(sqldReader, "Id"),
IdRemote = GetLong(sqldReader, "IdRemote"),
IdShow = GetLong(sqldReader, "IdShow"),
IdScraper = GetString(sqldReader, "IdScraper"),
Title = GetString(sqldReader, "Title"),
Plot = GetString(sqldReader, "Plot"),
Premiered = GetString(sqldReader, "Premiered"),
Rating = GetString(sqldReader, "Rating"),
Genre = GetString(sqldReader, "Genre"),
Mpaa = GetString(sqldReader, "Mpaa"),
Studio = GetString(sqldReader, "Studio"),
Path = GetString(sqldReader, "Path"),
TotalCount = GetLong(sqldReader, "TotalCount"),
Hash = GetString(sqldReader, "Hash"),
Thumb = GetString(sqldReader, "Thumb"),
Fanart = GetString(sqldReader, "Fanart"),
IsFavorite = GetLong(sqldReader, "IsFavorite"),
Banner = GetString(sqldReader, "Banner"),
Logo = GetString(sqldReader, "Logo")
};
tvShows.Add(movie);
Log("SQL DATA::: Title:" + GetString(sqldReader, "Title") + "ID" + GetLong(sqldReader, "IdShow") + "Premiere:"+ GetString(sqldReader, "Premiered") +"Date: "+GetString(sqldReader, "Date"));
}
sqldReader.Dispose();
query.Dispose();
}
catch (SQLiteException e)
{
Log(e.Message);
}
return tvShows;
}