public WeblogEntryCollection GetEntries(WeblogEntryCollectionList list, string cultureId)
{
WeblogEntryCollection messages = list[cultureId];
if (messages == null)
{
list.ReloadEntries(cultureId);
messages = list[cultureId];
}
else if (
messages.ExpirationDate > DateTime.UtcNow ||
messages.Count <= 0)
{
if (messages.LastLoad != null)
{
if ((DateTime.UtcNow - messages.LastLoad.Value).Minutes <
MinDatabaseFetchInterval)
{
return(messages);
}
}
list.ReloadEntries(cultureId);
messages = list[cultureId];
}
return(messages);
}
public static bool LoadAnnouncements(WeblogEntryCollection messages, DateTime messageTime, string cultureId)
{
bool res = false;
string userName = string.Empty;
messages.LastLoad = DateTime.UtcNow;
string query = "WeblogLoadAnnouncement";
using (SqlConnection cnn = new SqlConnection(Configurations.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CultureId", cultureId));
foreach (SqlParameter Parameter in cmd.Parameters)
{
if (Parameter.Value == null)
{
Parameter.Value = DBNull.Value;
}
}
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
// Read first table: SoftwareProduct
while (reader.Read())
{
WeblogEntry msg = new WeblogEntry();
msg.CultureId = cultureId;
msg.Url = Utils.Convert.ToString(reader["EntryUrl"]);
//msg.UploadDate = Utils.Convert.ToDateTime(reader["EntryOnlineFrom"]);
//msg.ExpirationDate = Utils.Convert.ToDateTime(reader["EntryOnlineTo"]);
msg.Title = Utils.Convert.ToString(reader["EntryTitle"]);
//msg.Brief = Utils.Convert.ToString(reader["EntryBrief"]);
//msg.Content = Utils.Convert.ToString(reader["EntryContent"]);
//msg.Score = Utils.Convert.ToDecimal(reader["EntryScorePoints"]);
messages.Add(msg);
// Set minimum exp date as exp date of all messages in this cullture
// this causes the list to be updated at most after first exp datetime.
if (msg.ExpirationDate < messages.ExpirationDate)
{
messages.ExpirationDate = msg.ExpirationDate;
}
res = true;
}
}
}
}
return(res);
}
internal static bool GetMessages(string cultureId, string url, WeblogEntryCollection messages)
{
messages.Clear();
bool res = false;
string userName = string.Empty;
string query = "WeblogGetByUrl";
using (SqlConnection cnn = new SqlConnection(Configurations.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MessageUrl", url));
cmd.Parameters.Add(new SqlParameter("@CultureId", cultureId));
foreach (SqlParameter Parameter in cmd.Parameters)
{
if (Parameter.Value == null)
{
Parameter.Value = DBNull.Value;
}
}
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null && reader.HasRows)
{
// Read first table: SoftwareProduct
while (reader.Read())
{
WeblogEntry message = new WeblogEntry();
message.CultureId = cultureId;
message.EntryId = Utils.Convert.ToInt64(reader["EntryId"]);
message.Url = Utils.Convert.ToString(reader["EntryUrl"]);
message.UploadDate = Utils.Convert.ToDateTime(reader["EntryOnlineFrom"]);
message.ExpirationDate = Utils.Convert.ToDateTime(reader["EntryOnlineTo"]);
message.Title = Utils.Convert.ToString(reader["EntryTitle"]);
message.Brief = Utils.Convert.ToString(reader["EntryBrief"]);
message.Content = Utils.Convert.ToString(reader["EntryContent"]);
message.Score = Utils.Convert.ToDecimal(reader["EntryScorePoints"]);
messages.Add(message);
}
res = true;
}
}
}
return(res);
}
public WeblogEntryCollection GetMessages(string cultureId, string url)
{
WeblogEntryCollection messages = this.items[cultureId, url];
if (messages == null)
{
messages = new WeblogEntryCollection();
Repository.Sql.Weblog.GetMessages(cultureId, url, messages);
this.items.Add(messages);
}
return(messages);
}
