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