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