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