protected new void FetchData(SQLiteMonDataReader reader)
{
base.FetchData(reader);
int filepathOrdinal = reader.GetOrdinal("filepath");
this.Status = (DownloadStatus)reader.GetInt32(reader.GetOrdinal("status"));
if (this.Status == DownloadStatus.Errored)
{
this.ErrorType = (Provider.ErrorType)reader.GetInt32(reader.GetOrdinal("errortype"));
if (this.ErrorType != Provider.ErrorType.UnknownError)
{
this.ErrorDetails = reader.GetString(reader.GetOrdinal("errordetails"));
}
}
if (!reader.IsDBNull(filepathOrdinal))
{
this.DownloadPath = reader.GetString(filepathOrdinal);
}
this.PlayCount = reader.GetInt32(reader.GetOrdinal("playcount"));
}
protected void FetchData(SQLiteMonDataReader reader)
{
int descriptionOrdinal = reader.GetOrdinal("description");
int latestdownloadOrdinal = reader.GetOrdinal("latestdownload");
this.Progid = reader.GetInt32(reader.GetOrdinal("progid"));
this.Name = reader.GetString(reader.GetOrdinal("name"));
if (!reader.IsDBNull(descriptionOrdinal))
{
this.Description = reader.GetString(descriptionOrdinal);
}
this.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
Guid pluginId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
Provider provider = Provider.GetFromId(pluginId);
if (provider != null)
{
this.ProviderName = provider.Name;
}
else
{
this.ProviderName = "<missing>";
}
if (!reader.IsDBNull(latestdownloadOrdinal))
{
this.LatestDownload = reader.GetDateTime(latestdownloadOrdinal);
}
}
protected void FetchData(SQLiteMonDataReader reader)
{
int descriptionOrdinal = reader.GetOrdinal("description");
int durationOrdinal = reader.GetOrdinal("duration");
int imageOrdinal = reader.GetOrdinal("image");
this.Epid = reader.GetInt32(reader.GetOrdinal("epid"));
this.Progid = reader.GetInt32(reader.GetOrdinal("progid"));
this.Date = reader.GetDateTime(reader.GetOrdinal("date"));
this.Name = reader.GetString(reader.GetOrdinal("name"));
if (!reader.IsDBNull(descriptionOrdinal))
{
this.Description = reader.GetString(descriptionOrdinal);
}
if (!reader.IsDBNull(durationOrdinal))
{
this.Duration = reader.GetInt32(durationOrdinal);
}
this.AutoDownload = reader.GetInt32(reader.GetOrdinal("autodownload")) == 1;
if (!reader.IsDBNull(imageOrdinal))
{
this.imgid = reader.GetInt32(imageOrdinal);
}
}
private void FetchData(SQLiteMonDataReader reader)
{
int linkOrdinal = reader.GetOrdinal("link");
int imageOrdinal = reader.GetOrdinal("image");
this.Start = TimeSpan.FromMilliseconds(reader.GetInt32(reader.GetOrdinal("start")));
this.Name = reader.GetString(reader.GetOrdinal("name"));
if (!reader.IsDBNull(linkOrdinal))
{
this.Link = new Uri(reader.GetString(linkOrdinal));
}
if (!reader.IsDBNull(imageOrdinal))
{
this.imgid = reader.GetInt32(imageOrdinal);
}
}
private static void UpdateInfoIfRequiredAsync(int progid)
{
Guid providerId = Guid.Empty;
string updateExtid = null;
// Test to see if an update is required, and then free up the database
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, lastupdate from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
providerId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
if (Provider.Exists(providerId))
{
IRadioProvider pluginInstance = Provider.GetFromId(providerId).CreateInstance();
if (reader.GetDateTime(reader.GetOrdinal("lastupdate")).AddDays(pluginInstance.ProgInfoUpdateFreqDays) < DateTime.Now)
{
updateExtid = reader.GetString(reader.GetOrdinal("extid"));
}
}
}
}
}
// Now perform the update if required
if (updateExtid != null)
{
try
{
UpdateInfo(providerId, updateExtid);
}
catch (ProviderException)
{
// Suppress any provider exceptions, as the user isn't waiting for this action
}
}
}
public static void UpdateInfoIfRequired(int epid)
{
int progid = 0;
string updateExtid = null;
// Test to see if the episode is marked as unavailable, and then free up the database
using (SQLiteCommand command = new SQLiteCommand("select progid, extid from episodes where epid=@epid and available=0", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
progid = reader.GetInt32(reader.GetOrdinal("progid"));
updateExtid = reader.GetString(reader.GetOrdinal("extid"));
}
}
}
// Perform an update if the episode was marked as unavailable
if (updateExtid != null)
{
if (Download.IsDownload(epid))
{
// The episode is in the downloads list, so just mark as available
using (SQLiteCommand command = new SQLiteCommand("update episodes set available=1 where epid=@epid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.ExecuteNonQuery();
}
}
else
{
UpdateInfo(progid, updateExtid);
}
}
}
private static int? UpdateInfo(int progid, string episodeExtId)
{
Guid pluginId;
string progExtId;
ProgrammeInfo progInfo;
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, name, description, singleepisode from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (!reader.Read())
{
throw new DataNotFoundException(progid, "Programme does not exist");
}
pluginId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
progExtId = reader.GetString(reader.GetOrdinal("extid"));
progInfo = new ProgrammeInfo();
progInfo.Name = reader.GetString(reader.GetOrdinal("name"));
int descriptionOrdinal = reader.GetOrdinal("description");
if (!reader.IsDBNull(descriptionOrdinal))
{
progInfo.Description = reader.GetString(descriptionOrdinal);
}
progInfo.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
}
}
IRadioProvider providerInst = Provider.GetFromId(pluginId).CreateInstance();
EpisodeInfo episodeInfo;
try
{
episodeInfo = providerInst.GetEpisodeInfo(progExtId, progInfo, episodeExtId);
if (episodeInfo == null)
{
return null;
}
if (string.IsNullOrEmpty(episodeInfo.Name))
{
throw new InvalidDataException("Episode name cannot be null or an empty string");
}
}
catch (Exception provExp)
{
provExp.Data.Add("Programme", progInfo.ToString() + "\r\nExtID: " + progExtId);
provExp.Data.Add("Episode ExtID", episodeExtId);
throw new ProviderException("Call to GetEpisodeInfo failed", provExp, pluginId);
}
if (episodeInfo.Date == null)
{
// The date of the episode isn't known, so use the current date
episodeInfo.Date = DateTime.Now;
}
lock (DbUpdateLock)
{
using (SQLiteMonTransaction transMon = new SQLiteMonTransaction(FetchDbConn().BeginTransaction()))
{
int? epid = null;
using (SQLiteCommand command = new SQLiteCommand("select epid from episodes where progid=@progid and extid=@extid", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(new SQLiteParameter("@extid", episodeExtId));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
epid = reader.GetInt32(reader.GetOrdinal("epid"));
}
}
}
if (epid == null)
{
using (SQLiteCommand command = new SQLiteCommand("insert into episodes (progid, extid, name, date) values (@progid, @extid, @name, @date)", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(new SQLiteParameter("@extid", episodeExtId));
command.Parameters.Add(new SQLiteParameter("@name", episodeInfo.Name));
command.Parameters.Add(new SQLiteParameter("@date", episodeInfo.Date));
command.ExecuteNonQuery();
}
using (SQLiteCommand command = new SQLiteCommand("select last_insert_rowid()", FetchDbConn(), transMon.Trans))
{
epid = (int)(long)command.ExecuteScalar();
}
}
using (SQLiteCommand command = new SQLiteCommand("update episodes set name=@name, description=@description, duration=@duration, date=@date, image=@image, available=1 where epid=@epid", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@name", episodeInfo.Name));
command.Parameters.Add(new SQLiteParameter("@description", episodeInfo.Description));
command.Parameters.Add(new SQLiteParameter("@duration", episodeInfo.Duration));
command.Parameters.Add(new SQLiteParameter("@date", episodeInfo.Date));
command.Parameters.Add(new SQLiteParameter("@image", StoreImage(episodeInfo.Image)));
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.ExecuteNonQuery();
}
using (SQLiteCommand command = new SQLiteCommand("insert or replace into episodeext (epid, name, value) values (@epid, @name, @value)", FetchDbConn(), transMon.Trans))
{
foreach (KeyValuePair<string, string> extItem in episodeInfo.ExtInfo)
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.Parameters.Add(new SQLiteParameter("@name", extItem.Key));
command.Parameters.Add(new SQLiteParameter("@value", extItem.Value));
command.ExecuteNonQuery();
}
}
transMon.Trans.Commit();
return epid;
}
}
}
protected void FetchData(SQLiteMonDataReader reader)
{
int descriptionOrdinal = reader.GetOrdinal("description");
int durationOrdinal = reader.GetOrdinal("duration");
this.Epid = reader.GetInt32(reader.GetOrdinal("epid"));
this.Progid = reader.GetInt32(reader.GetOrdinal("progid"));
this.Date = reader.GetDateTime(reader.GetOrdinal("date"));
this.Name = reader.GetString(reader.GetOrdinal("name"));
if (!reader.IsDBNull(descriptionOrdinal))
{
this.Description = reader.GetString(descriptionOrdinal);
}
if (!reader.IsDBNull(durationOrdinal))
{
this.Duration = reader.GetInt32(durationOrdinal);
}
this.AutoDownload = reader.GetInt32(reader.GetOrdinal("autodownload")) == 1;
}
public static void UpdateInfoIfRequired(int epid)
{
int progid = 0;
string updateExtid = null;
// Test to see if the episode is marked as unavailable, and then free up the database
using (SQLiteCommand command = new SQLiteCommand("select progid, extid from episodes where epid=@epid and available=0", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
progid = reader.GetInt32(reader.GetOrdinal("progid"));
updateExtid = reader.GetString(reader.GetOrdinal("extid"));
}
}
}
// Perform an update if the episode was marked as unavailable
if (updateExtid != null)
{
if (Download.IsDownload(epid))
{
// The episode is in the downloads list, so just mark as available
using (SQLiteCommand command = new SQLiteCommand("update episodes set available=1 where epid=@epid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.ExecuteNonQuery();
}
}
else
{
UpdateInfo(progid, updateExtid);
}
}
}
private static void UpdateInfoIfRequiredAsync(int progid)
{
Guid providerId = Guid.Empty;
string updateExtid = null;
// Test to see if an update is required, and then free up the database
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, lastupdate from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
providerId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
if (Provider.Exists(providerId))
{
IRadioProvider pluginInstance = Provider.GetFromId(providerId).CreateInstance();
if (reader.GetDateTime(reader.GetOrdinal("lastupdate")).AddDays(pluginInstance.ProgInfoUpdateFreqDays) < DateTime.Now)
{
updateExtid = reader.GetString(reader.GetOrdinal("extid"));
}
}
}
}
}
// Now perform the update if required
if (updateExtid != null)
{
try
{
UpdateInfo(providerId, updateExtid);
}
catch (ProviderException)
{
// Suppress any provider exceptions, as the user isn't waiting for this action
}
}
}
protected void FetchData(SQLiteMonDataReader reader)
{
int descriptionOrdinal = reader.GetOrdinal("description");
int latestdownloadOrdinal = reader.GetOrdinal("latestdownload");
this.Progid = reader.GetInt32(reader.GetOrdinal("progid"));
this.extId = reader.GetString(reader.GetOrdinal("extid"));
this.Name = reader.GetString(reader.GetOrdinal("name"));
if (!reader.IsDBNull(descriptionOrdinal))
{
this.Description = reader.GetString(descriptionOrdinal);
}
this.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
Guid pluginId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
Provider provider = Provider.GetFromId(pluginId);
if (provider != null)
{
this.ProviderName = provider.Name;
this.moreInfoHandler = provider.ShowMoreProgInfoHandler;
}
else
{
this.ProviderName = "<missing>";
}
if (!reader.IsDBNull(latestdownloadOrdinal))
{
this.LatestDownload = reader.GetDateTime(latestdownloadOrdinal);
}
}
public static List<string> GetAvailableEpisodes(int progid, bool fetchAll)
{
Guid providerId;
string progExtId;
ProgrammeInfo progInfo;
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, name, description, singleepisode from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (!reader.Read())
{
throw new DataNotFoundException(progid, "Programme does not exist");
}
providerId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
progExtId = reader.GetString(reader.GetOrdinal("extid"));
progInfo = new ProgrammeInfo();
progInfo.Name = reader.GetString(reader.GetOrdinal("name"));
int descriptionOrdinal = reader.GetOrdinal("description");
if (!reader.IsDBNull(descriptionOrdinal))
{
progInfo.Description = reader.GetString(descriptionOrdinal);
}
progInfo.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
}
}
if (!Provider.Exists(providerId))
{
return null;
}
// Fetch a list of previously available episodes for the programme
List<string> previousAvailable = new List<string>();
using (SQLiteCommand command = new SQLiteCommand("select extid from episodes where progid=@progid and available=1 order by date desc", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
int epidOrdinal = reader.GetOrdinal("extid");
while (reader.Read())
{
previousAvailable.Add(reader.GetString(epidOrdinal));
}
}
}
List<string> allEpExtIds = new List<string>();
int page = 1;
IRadioProvider providerInst = Provider.GetFromId(providerId).CreateInstance();
AvailableEpisodes available;
do
{
try
{
available = providerInst.GetAvailableEpisodes(progExtId, progInfo, page);
}
catch (Exception provExp)
{
provExp.Data.Add("Programme ExtID", progExtId);
throw new ProviderException("Call to GetAvailableEpisodeIds failed", provExp, providerId);
}
if (available.EpisodeIds.Count == 0)
{
break;
}
int trackOverlap = -1;
foreach (string epExtId in available.EpisodeIds)
{
// Append the returned IDs to the list of all episodes (minus duplicates)
if (!allEpExtIds.Contains(epExtId))
{
allEpExtIds.Add(epExtId);
}
if (previousAvailable.Contains(epExtId))
{
// Store where the available & previously available ID lists overlap
trackOverlap = previousAvailable.IndexOf(epExtId);
}
else if (trackOverlap >= 0)
{
// Bump up the overlap index to show there are more after the overlap
trackOverlap++;
}
}
if (available.MoreAvailable && !fetchAll)
{
if (trackOverlap >= 0)
{
// Remove previously available programmes before this page from the list so that they
// are not incorrectly un-flagged as available in the database
if (trackOverlap < previousAvailable.Count - 1)
{
previousAvailable.RemoveRange(trackOverlap + 1, previousAvailable.Count - (trackOverlap + 1));
}
// Stop fetching available episode pages
break;
}
}
page++;
}
while (available.MoreAvailable);
// Remove the still available episodes from the previously available list
foreach (string epExtId in allEpExtIds)
{
previousAvailable.Remove(epExtId);
}
// Unflag any no-longer available episodes in the database
if (previousAvailable.Count > 0)
{
lock (DbUpdateLock)
{
using (SQLiteMonTransaction transMon = new SQLiteMonTransaction(FetchDbConn().BeginTransaction()))
{
using (SQLiteCommand command = new SQLiteCommand("update episodes set available=0 where progid=@progid and extid=@extid", FetchDbConn(), transMon.Trans))
{
SQLiteParameter extidParam = new SQLiteParameter("@extid");
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(extidParam);
foreach (string epExtId in previousAvailable)
{
extidParam.Value = epExtId;
command.ExecuteNonQuery();
}
}
transMon.Trans.Commit();
}
}
}
return allEpExtIds;
}
private static int?UpdateInfo(int progid, string episodeExtId)
{
Guid pluginId;
string progExtId;
Provider.ProgrammeInfo progInfo;
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, name, description, singleepisode from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (!reader.Read())
{
throw new DataNotFoundException(progid, "Programme does not exist");
}
pluginId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
progExtId = reader.GetString(reader.GetOrdinal("extid"));
progInfo = new Provider.ProgrammeInfo();
progInfo.Name = reader.GetString(reader.GetOrdinal("name"));
int descriptionOrdinal = reader.GetOrdinal("description");
if (!reader.IsDBNull(descriptionOrdinal))
{
progInfo.Description = reader.GetString(descriptionOrdinal);
}
progInfo.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
}
}
Provider.RadioProvider providerInst = Provider.Handler.GetFromId(pluginId).CreateInstance();
Provider.EpisodeInfo episodeInfo;
try
{
episodeInfo = providerInst.GetEpisodeInfo(progExtId, progInfo, episodeExtId);
if (episodeInfo == null)
{
return(null);
}
if (string.IsNullOrEmpty(episodeInfo.Name))
{
throw new InvalidDataException("Episode name cannot be null or an empty string");
}
}
catch (Exception provExp)
{
provExp.Data.Add("Programme", progInfo.ToString() + "\r\nExtID: " + progExtId);
provExp.Data.Add("Episode ExtID", episodeExtId);
throw new ProviderException("Call to GetEpisodeInfo failed", provExp, pluginId);
}
if (episodeInfo.Date == null)
{
// The date of the episode isn't known, so use the current date
episodeInfo.Date = DateTime.Now;
}
lock (DbUpdateLock)
{
using (SQLiteMonTransaction transMon = new SQLiteMonTransaction(FetchDbConn().BeginTransaction()))
{
int?epid = null;
using (SQLiteCommand command = new SQLiteCommand("select epid from episodes where progid=@progid and extid=@extid", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(new SQLiteParameter("@extid", episodeExtId));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (reader.Read())
{
epid = reader.GetInt32(reader.GetOrdinal("epid"));
}
}
}
if (epid == null)
{
using (SQLiteCommand command = new SQLiteCommand("insert into episodes (progid, extid, name, date) values (@progid, @extid, @name, @date)", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(new SQLiteParameter("@extid", episodeExtId));
command.Parameters.Add(new SQLiteParameter("@name", episodeInfo.Name));
command.Parameters.Add(new SQLiteParameter("@date", episodeInfo.Date));
command.ExecuteNonQuery();
}
using (SQLiteCommand command = new SQLiteCommand("select last_insert_rowid()", FetchDbConn(), transMon.Trans))
{
epid = (int)(long)command.ExecuteScalar();
}
}
using (SQLiteCommand command = new SQLiteCommand("update episodes set name=@name, description=@description, duration=@duration, date=@date, image=@image, available=1 where epid=@epid", FetchDbConn(), transMon.Trans))
{
command.Parameters.Add(new SQLiteParameter("@name", episodeInfo.Name));
command.Parameters.Add(new SQLiteParameter("@description", episodeInfo.Description));
command.Parameters.Add(new SQLiteParameter("@duration", episodeInfo.Duration));
command.Parameters.Add(new SQLiteParameter("@date", episodeInfo.Date));
command.Parameters.Add(new SQLiteParameter("@image", StoreImage(episodeInfo.Image)));
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.ExecuteNonQuery();
}
using (SQLiteCommand command = new SQLiteCommand("insert or replace into episodeext (epid, name, value) values (@epid, @name, @value)", FetchDbConn(), transMon.Trans))
{
foreach (KeyValuePair <string, string> extItem in episodeInfo.ExtInfo)
{
command.Parameters.Add(new SQLiteParameter("@epid", epid));
command.Parameters.Add(new SQLiteParameter("@name", extItem.Key));
command.Parameters.Add(new SQLiteParameter("@value", extItem.Value));
command.ExecuteNonQuery();
}
}
transMon.Trans.Commit();
return(epid);
}
}
}
protected new void FetchData(SQLiteMonDataReader reader)
{
base.FetchData(reader);
int filepathOrdinal = reader.GetOrdinal("filepath");
this.Status = (DownloadStatus)reader.GetInt32(reader.GetOrdinal("status"));
if (this.Status == DownloadStatus.Errored)
{
this.ErrorType = (ErrorType)reader.GetInt32(reader.GetOrdinal("errortype"));
if (this.ErrorType != ErrorType.UnknownError)
{
this.ErrorDetails = reader.GetString(reader.GetOrdinal("errordetails"));
}
}
if (!reader.IsDBNull(filepathOrdinal))
{
this.DownloadPath = reader.GetString(filepathOrdinal);
}
this.PlayCount = reader.GetInt32(reader.GetOrdinal("playcount"));
}
public static List <string> GetAvailableEpisodes(int progid, bool fetchAll)
{
Guid providerId;
string progExtId;
ProgrammeInfo progInfo;
using (SQLiteCommand command = new SQLiteCommand("select pluginid, extid, name, description, singleepisode from programmes where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
if (!reader.Read())
{
throw new DataNotFoundException(progid, "Programme does not exist");
}
providerId = new Guid(reader.GetString(reader.GetOrdinal("pluginid")));
progExtId = reader.GetString(reader.GetOrdinal("extid"));
progInfo = new ProgrammeInfo();
progInfo.Name = reader.GetString(reader.GetOrdinal("name"));
int descriptionOrdinal = reader.GetOrdinal("description");
if (!reader.IsDBNull(descriptionOrdinal))
{
progInfo.Description = reader.GetString(descriptionOrdinal);
}
progInfo.SingleEpisode = reader.GetBoolean(reader.GetOrdinal("singleepisode"));
}
}
if (!Provider.Exists(providerId))
{
return(null);
}
// Fetch a list of previously available episodes for the programme
List <string> previousAvailable = new List <string>();
using (SQLiteCommand command = new SQLiteCommand("select extid from episodes where progid=@progid and available=1 order by date desc", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
int epidOrdinal = reader.GetOrdinal("extid");
while (reader.Read())
{
previousAvailable.Add(reader.GetString(epidOrdinal));
}
}
}
List <string> allEpExtIds = new List <string>();
int page = 1;
IRadioProvider providerInst = Provider.GetFromId(providerId).CreateInstance();
AvailableEpisodes available;
do
{
try
{
available = providerInst.GetAvailableEpisodes(progExtId, progInfo, page);
}
catch (Exception provExp)
{
provExp.Data.Add("Programme ExtID", progExtId);
throw new ProviderException("Call to GetAvailableEpisodeIds failed", provExp, providerId);
}
if (available.EpisodeIds == null || available.EpisodeIds.Length == 0)
{
break;
}
int trackOverlap = -1;
foreach (string epExtId in available.EpisodeIds)
{
// Append the returned IDs to the list of all episodes (minus duplicates)
if (!allEpExtIds.Contains(epExtId))
{
allEpExtIds.Add(epExtId);
}
if (previousAvailable.Contains(epExtId))
{
// Store where the available & previously available ID lists overlap
trackOverlap = previousAvailable.IndexOf(epExtId);
}
else if (trackOverlap >= 0)
{
// Bump up the overlap index to show there are more after the overlap
trackOverlap++;
}
}
if (available.MoreAvailable && !fetchAll)
{
if (trackOverlap >= 0)
{
// Remove previously available programmes before this page from the list so that they
// are not incorrectly un-flagged as available in the database
if (trackOverlap < previousAvailable.Count - 1)
{
previousAvailable.RemoveRange(trackOverlap + 1, previousAvailable.Count - (trackOverlap + 1));
}
// Stop fetching available episode pages
break;
}
}
page++;
}while (available.MoreAvailable);
// Remove the still available episodes from the previously available list
foreach (string epExtId in allEpExtIds)
{
previousAvailable.Remove(epExtId);
}
// Unflag any no-longer available episodes in the database
if (previousAvailable.Count > 0)
{
lock (Database.DbUpdateLock)
{
using (SQLiteMonTransaction transMon = new SQLiteMonTransaction(FetchDbConn().BeginTransaction()))
{
using (SQLiteCommand command = new SQLiteCommand("update episodes set available=0 where progid=@progid and extid=@extid", FetchDbConn(), transMon.Trans))
{
SQLiteParameter extidParam = new SQLiteParameter("@extid");
command.Parameters.Add(new SQLiteParameter("@progid", progid));
command.Parameters.Add(extidParam);
foreach (string epExtId in previousAvailable)
{
extidParam.Value = epExtId;
command.ExecuteNonQuery();
}
}
transMon.Trans.Commit();
}
}
}
return(allEpExtIds);
}