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