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