public static bool LoadWeblogDiscussion(WeblogEntry entry, int startRow, int endRow)
{
bool res = false;
try
{
// Initiate profile forum
// For all profiles discussions ForumId = 1
Forum forum = entry.Forum;
if (forum == null)
{
forum = new Forum();
entry.Forum = forum;
}
forum.ForumId = (Int16)Memory.Forums.ForumType.Weblog;
forum.UrlName = string.Empty;
forum.PageId = entry.EntryId.Value;
res = LoadDiscussions(forum, startRow, endRow);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(string.Format("Exception:{0}", ex.ToString()));
}
return(res);
}
public void Format_Should_Return_String_Representation_Of_LogEntry()
{
var logEntry = new WeblogEntry(new Mock <HttpContextBase>().Object, "Dummy Message", "All", TraceEventType.Information, null, null, null);
var response = _formatter.Format(logEntry);
Assert.True(response.Length > 0);
}
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);
}
public void GetMethodDetails_Should_Return_Namespace_Class_And_MethodSignature()
{
string namespaceName;
string className;
string methodSignature;
WeblogEntry.GetMethodDetails(1, out namespaceName, out className, out methodSignature);
Assert.True(namespaceName.Length > 0);
Assert.True(className.Length > 0);
Assert.True(methodSignature.Length > 0);
}
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);
}
internal static bool Load(WeblogEntry weblogEntry)
{
bool res = false;
string query = string.Format(
"SELECT * FROM Weblog WHERE EntryId = {0} AND LanguageId = {1}",
weblogEntry.EntryId, Sql.Languages.GetId(weblogEntry.CultureId).Value);
using (SqlConnection cnn = new SqlConnection(Properties.Settings.Default.PersianSoftwareConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.Text;
cnn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null && reader.HasRows)
{
if (reader.Read())
{
weblogEntry.Brief = Utils.Convert.ToString(reader["EntryBrief"]);
weblogEntry.Content = Utils.Convert.ToString(reader["EntryContent"]);
weblogEntry.CultureId = Sql.Languages.GetCulture(Utils.Convert.ToInt32(reader["LanguageId"]));
weblogEntry.EntryId = Utils.Convert.ToInt64(reader["EntryId"]);
weblogEntry.ExpirationDate = Utils.Convert.ToDateTime(reader["EntryOnlineTo"]);
weblogEntry.IsAnnouncement = Utils.Convert.ToBool(reader["EntryIsAnnouncement"]);
weblogEntry.Score = Utils.Convert.ToDecimal(reader["EntryScorePoints"]);
weblogEntry.Title = Utils.Convert.ToString(reader["EntryTitle"]);
weblogEntry.UploadDate = Utils.Convert.ToDateTime(reader["EntryOnlineFrom"]);
weblogEntry.Url = Utils.Convert.ToString(reader["EntryUrl"]);
}
reader.Close();
}
}
cnn.Close();
res = true;
}
}
return(res);
}
internal static bool Update(WeblogEntry weblogEntry)
{
bool res = false;
string query =
"UPDATE Weblog " +
"SET EntryOnlineFrom=@EntryOnlineFrom, EntryOnlineTo=@EntryOnlineTo, " +
"EntryUrl=@EntryUrl, EntryTitle=@EntryTitle, EntryBrief=@EntryBrief, EntryContent=@EntryContent, " +
"EntryScorePoints=@EntryScorePoints, EntryIsAnnouncement=@EntryIsAnnouncement " +
"WHERE EntryId=@EntryId AND LanguageId=@LanguageId";
using (SqlConnection cnn = new SqlConnection(Properties.Settings.Default.PersianSoftwareConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@EntryId", weblogEntry.EntryId));
cmd.Parameters.Add(new SqlParameter("@LanguageId", Sql.Languages.GetId(weblogEntry.CultureId)));
cmd.Parameters.Add(new SqlParameter("@EntryOnlineFrom", weblogEntry.UploadDate));
cmd.Parameters.Add(new SqlParameter("@EntryOnlineTo", weblogEntry.ExpirationDate));
cmd.Parameters.Add(new SqlParameter("@EntryUrl", weblogEntry.Url));
cmd.Parameters.Add(new SqlParameter("@EntryTitle", weblogEntry.Title));
cmd.Parameters.Add(new SqlParameter("@EntryBrief", weblogEntry.Brief));
cmd.Parameters.Add(new SqlParameter("@EntryContent", weblogEntry.Content));
cmd.Parameters.Add(new SqlParameter("@EntryScorePoints", weblogEntry.Score));
cmd.Parameters.Add(new SqlParameter("@EntryIsAnnouncement", weblogEntry.IsAnnouncement));
cnn.Open();
int affected = cmd.ExecuteNonQuery();
if (affected > 0)
{
res = true;
}
cnn.Close();
}
}
return(res);
}
internal static bool Insert(WeblogEntry weblogEntry)
{
bool res = false;
string query =
"INSERT INTO Weblog " +
"(EntryId, LanguageId, EntryOnlineFrom, EntryOnlineTo, EntryUrl, EntryTitle, EntryBrief, EntryContent, EntryScorePoints, EntryIsAnnouncement) " +
"VALUES " +
"(@EntryId, @LanguageId, @EntryOnlineFrom, @EntryOnlineTo, @EntryUrl, @EntryTitle, @EntryBrief, @EntryContent, @EntryScorePoints, @EntryIsAnnouncement)";
using (SqlConnection cnn = new SqlConnection(Properties.Settings.Default.PersianSoftwareConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@EntryId", weblogEntry.EntryId));
cmd.Parameters.Add(new SqlParameter("@LanguageId", Sql.Languages.GetId(weblogEntry.CultureId)));
cmd.Parameters.Add(new SqlParameter("@EntryOnlineFrom", weblogEntry.UploadDate));
cmd.Parameters.Add(new SqlParameter("@EntryOnlineTo", weblogEntry.ExpirationDate));
cmd.Parameters.Add(new SqlParameter("@EntryUrl", weblogEntry.Url));
cmd.Parameters.Add(new SqlParameter("@EntryTitle", weblogEntry.Title));
cmd.Parameters.Add(new SqlParameter("@EntryBrief", weblogEntry.Brief));
cmd.Parameters.Add(new SqlParameter("@EntryContent", weblogEntry.Content));
cmd.Parameters.Add(new SqlParameter("@EntryScorePoints", weblogEntry.Score));
cmd.Parameters.Add(new SqlParameter("@EntryIsAnnouncement", weblogEntry.IsAnnouncement));
cnn.Open();
int affected = cmd.ExecuteNonQuery();
if (affected > 0)
{
res = true;
}
cnn.Close();
}
}
return(res);
}
internal static bool Exists(WeblogEntry weblogEntry)
{
bool res = false;
string query = string.Format(
"IF EXISTS (SELECT EntryId FROM Weblog WHERE EntryId = {0} AND LanguageId = {1}) SELECT 1",
weblogEntry.EntryId, Sql.Languages.GetId(weblogEntry.CultureId).Value);
using (SqlConnection cnn = new SqlConnection(Properties.Settings.Default.PersianSoftwareConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.CommandType = CommandType.Text;
cnn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null && reader.HasRows)
{
if (reader.Read())
{
if (Utils.Convert.ToInt32(reader[0]) == 1)
{
res = true;
}
}
reader.Close();
}
}
cnn.Close();
}
}
return(res);
}
