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