public static PodcastFeedInfo[] LoadPodcastFeeds() { ArrayList podcastFeeds = new ArrayList(); IDataReader feed_reader = Globals.Library.Db.Query(@" SELECT * FROM PodcastFeeds ORDER BY Title "); while (feed_reader.Read()) { PodcastFeedInfo feed = null; feed = new PodcastFeedInfo( feed_reader.GetInt32(0), feed_reader.GetString(1), feed_reader.GetString(2), GetStringSafe(feed_reader, 3), GetStringSafe(feed_reader, 4), GetStringSafe(feed_reader, 5), feed_reader.GetDateTime(6), feed_reader.GetBoolean(7), (SyncPreference)feed_reader.GetInt32(8) ); podcastFeeds.Add(feed); feed.Add(LoadPodcasts(feed)); } feed_reader.Close(); return(podcastFeeds.ToArray(typeof(PodcastFeedInfo)) as PodcastFeedInfo[]); }
public static PodcastFeedInfo[] LoadPodcastFeeds() { ArrayList podcastFeeds = new ArrayList (); IDataReader feed_reader = Globals.Library.Db.Query (@" SELECT * FROM PodcastFeeds ORDER BY Title "); while(feed_reader.Read()) { PodcastFeedInfo feed = null; feed = new PodcastFeedInfo ( feed_reader.GetInt32 (0), feed_reader.GetString (1), feed_reader.GetString (2), GetStringSafe (feed_reader, 3), GetStringSafe (feed_reader, 4), GetStringSafe (feed_reader, 5), feed_reader.GetDateTime (6), feed_reader.GetBoolean (7), (SyncPreference)feed_reader.GetInt32(8) ); podcastFeeds.Add (feed); feed.Add (LoadPodcasts (feed)); } feed_reader.Close (); return podcastFeeds.ToArray (typeof (PodcastFeedInfo)) as PodcastFeedInfo[]; }