/// <summary> /// Get the RSS cache. /// </summary> /// <param name="catalogCode">Catalog code representing the RSS</param> public static FoeServerRssFeed GetRssFeedCache(string catalogCode) { FoeServerRssFeed feed = null; SqlConnection conn = FoeServerDb.OpenDb(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from RssFeeds where Code=@code"; cmd.Parameters.Add("@code", SqlDbType.NVarChar, 10); cmd.Prepare(); cmd.Parameters["@code"].Value = catalogCode; SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { feed = new FoeServerRssFeed(); feed.Id = (int)FoeServerDb.GetInt32(reader, "Id"); feed.Rss = FoeServerDb.GetString(reader, "Rss"); feed.Code = FoeServerDb.GetString(reader, "Code"); feed.DtLastUpdated = (DateTime)FoeServerDb.GetDateTime(reader, "DtLastUpdated"); } reader.Close(); conn.Close(); return(feed); }
/// <summary> /// Get the RSS cache. /// </summary> /// <param name="catalogCode">Catalog code representing the RSS</param> public static FoeServerRssFeed GetRssFeedCache(string catalogCode) { FoeServerRssFeed feed = null; SqlConnection conn = FoeServerDb.OpenDb(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from RssFeeds where Code=@code"; cmd.Parameters.Add("@code", SqlDbType.NVarChar, 10); cmd.Prepare(); cmd.Parameters["@code"].Value = catalogCode; SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { feed = new FoeServerRssFeed(); feed.Id = (int)FoeServerDb.GetInt32(reader, "Id"); feed.Rss = FoeServerDb.GetString(reader, "Rss"); feed.Code = FoeServerDb.GetString(reader, "Code"); feed.DtLastUpdated = (DateTime)FoeServerDb.GetDateTime(reader, "DtLastUpdated"); } reader.Close(); conn.Close(); return feed; }