public void Remove(string Name) { using (DbTransaction tran = DbTransaction.Begin()) { DBForum.RemoveSetting(m_NodeId, Name); m_settings.Remove(Name); tran.Commit(); } }
/// <summary> /// Gets the owner container key. /// </summary> /// <param name="NodeId">The node id.</param> /// <returns></returns> public static string GetOwnerContainerKey(int NodeId) { using (IDataReader reader = DBForum.GetOwnerContainerKey(NodeId)) { if (reader.Read()) { return((string)reader["ContainerKey"]); } } return(null); }
public ForumThreadInfo GetForumThread(int ThreadId) { using (IDataReader reader = DBForum.GetForumThread(ThreadId)) { if (reader.Read()) { return(new ForumThreadInfo(reader)); } } return(null); }
public ForumThreadNodeInfo GetForumThreadNode(int NodeId) { using (IDataReader reader = DBForum.GetForumThreadNode(this.CurrentUserTimeZoneId, NodeId)) { if (reader.Read()) { return(new ForumThreadNodeInfo(reader)); } } return(null); }
/// <summary> /// Gets the forum thread nodes. /// </summary> /// <returns></returns> public ForumThreadNodeInfo[] GetForumThreadNodes() { ArrayList list = new ArrayList(); using (IDataReader reader = DBForum.GetForumThreadNodesByContainerKey(this.CurrentUserTimeZoneId, _ownerContainer.Key)) { while (reader.Read()) { list.Add(new ForumThreadNodeInfo(reader)); } } return((ForumThreadNodeInfo[])list.ToArray(typeof(ForumThreadNodeInfo))); }
/// <summary> /// Gets the forum thread nodes. /// </summary> /// <param name="forum">The forum.</param> /// <returns></returns> public ForumThreadNodeInfo[] GetForumThreadNodes(ForumInfo forum) { ArrayList list = new ArrayList(); using (IDataReader reader = DBForum.GetForumThreadNodesByForumId(this.CurrentUserTimeZoneId, forum.Id)) { while (reader.Read()) { list.Add(new ForumThreadNodeInfo(reader)); } } return((ForumThreadNodeInfo[])list.ToArray(typeof(ForumThreadNodeInfo))); }
/// <summary> /// Gets the forum threads. /// </summary> /// <returns></returns> public ForumThreadInfo[] GetForumThreads() { ArrayList list = new ArrayList(); using (IDataReader reader = DBForum.GetForumThreadsByContainerKey(_ownerContainer.Key)) { while (reader.Read()) { list.Add(new ForumThreadInfo(reader)); } } return((ForumThreadInfo[])list.ToArray(typeof(ForumThreadInfo))); }
/// <summary> /// Gets the forum threads. /// </summary> /// <param name="ForumId">The forum id.</param> /// <returns></returns> public ForumThreadInfo[] GetForumThreads(int ForumId) { ArrayList list = new ArrayList(); using (IDataReader reader = DBForum.GetForumThreadsByForumId(ForumId)) { while (reader.Read()) { list.Add(new ForumThreadInfo(reader)); } } return((ForumThreadInfo[])list.ToArray(typeof(ForumThreadInfo))); }
public static ForumThreadNodeInfo Load(int NodeId) { ForumThreadNodeInfo retVal = null; using (IDataReader reader = DBForum.GetForumThreadNode(Security.CurrentUser.TimeZoneId, NodeId)) { if (reader.Read()) { retVal = new ForumThreadNodeInfo(reader); } } return(retVal); }
private void SetSettings() { using (IDataReader reader = DBForum.GetSettings(m_NodeId)) { if (reader != null) { while (reader.Read()) { string name = (string)reader["Key"]; m_settings[name] = new ForumThreadNodeSetting((int)reader["SettingId"], name, (string)reader["Value"]); } } } }
private DBForum GetForumFromReader(IDataReader dataReader) { DBForum forum = new DBForum(); forum.ForumID = NopSqlDataHelper.GetInt(dataReader, "ForumID"); forum.ForumGroupID = NopSqlDataHelper.GetInt(dataReader, "ForumGroupID"); forum.Name = NopSqlDataHelper.GetString(dataReader, "Name"); forum.Description = NopSqlDataHelper.GetString(dataReader, "Description"); forum.NumTopics = NopSqlDataHelper.GetInt(dataReader, "NumTopics"); forum.NumPosts = NopSqlDataHelper.GetInt(dataReader, "NumPosts"); forum.LastTopicID = NopSqlDataHelper.GetInt(dataReader, "LastTopicID"); forum.LastPostID = NopSqlDataHelper.GetInt(dataReader, "LastPostID"); forum.LastPostUserID = NopSqlDataHelper.GetInt(dataReader, "LastPostUserID"); forum.LastPostTime = NopSqlDataHelper.GetNullableUtcDateTime(dataReader, "LastPostTime"); forum.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); forum.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); forum.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return forum; }
public void Add(string Name, string Value) { using (DbTransaction tran = DbTransaction.Begin()) { int id = DBForum.SetSetting(m_NodeId, Name, Value); ForumThreadNodeSetting setting = (ForumThreadNodeSetting)m_settings[Name]; if (setting != null && setting.SettingId == id) { setting.Value = Value; } else { m_settings[Name] = new ForumThreadNodeSetting(id, Name, Value); } tran.Commit(); } }
/// <summary> /// Deletes the forum thread. /// </summary> /// <param name="ThreadId">The thread id.</param> public void DeleteForumThread(int ThreadId) { DBForum.DeleteForumThreadById(ThreadId); }
/// <summary> /// Deletes the forum thread. /// </summary> /// <param name="info">The info.</param> public void DeleteForumThread(ForumInfo info) { DBForum.DeleteForumThreadByForumId(info.Id); }
/// <summary> /// Deletes the forum. /// </summary> /// <param name="ForumId">The forum id.</param> public void DeleteForum(int ForumId) { DBForum.DeleteForumById(ForumId); }
/// <summary> /// Deletes the forum. /// </summary> public void DeleteForum() { DBForum.DeleteForumByContainerKey(_ownerContainer.Key); }
/// <summary> /// Sets the thread node text. /// </summary> /// <param name="NodeId">The node id.</param> /// <param name="Text">The text.</param> /// <returns></returns> public ForumThreadNodeInfo SetThreadNodeText(int NodeId, string Text) { DBForum.SetThreadNodeText(NodeId, Text); return(this.GetForumThreadNode(NodeId)); }
/// <summary> /// Renames the forum thread. /// </summary> /// <param name="ThreadId">The thread id.</param> /// <param name="newName">The new name.</param> /// <returns></returns> public ForumThreadInfo RenameForumThread(int ThreadId, string newName) { DBForum.RenameForumThread(ThreadId, newName); return(this.GetForumThread(ThreadId)); }
public ForumThreadInfo CreateForumThread(int ForumId, string Name, DateTime Created) { int retVal = DBForum.CreateForumThread(ForumId, Name, Created); return(GetForumThread(retVal)); }
public ForumThreadNodeInfo CreateForumThreadNode(string Text, DateTime Created, int CreatorId, int EMailMessageId, int nodeType) { int retVal = DBForum.CreateSimpleForumThreadNode(_ownerContainer.Key, Text, Created, CreatorId, null, null, EMailMessageId, nodeType); return(GetForumThreadNode(retVal)); }
public ForumThreadNodeInfo CreateForumThreadNode(string Text, DateTime Created, string CreatorName, string CreatorEmail, int nodeType) { int retVal = DBForum.CreateSimpleForumThreadNode(_ownerContainer.Key, Text, Created, null, CreatorName, CreatorEmail, null, nodeType); return(GetForumThreadNode(retVal)); }
public ForumThreadNodeInfo CreateForumThreadNode(int ThreadId, string Text, DateTime Created, int CreatorId, int EMailMessageId, int nodeType) { int retVal = DBForum.CreateForumThreadNode(ThreadId, Text, Created, CreatorId, null, null, EMailMessageId, nodeType); return(GetForumThreadNode(retVal)); }
/// <summary> /// Deletes this instance. /// </summary> public void Delete() { DBForum.DeleteForumsByContainerKey(this._ownerContainer.Key); }
public ForumThreadInfo CreateForumThread(string Name) { int retVal = DBForum.CreateSimpleForumThread(_ownerContainer.Key, Name, DateTime.UtcNow); return(GetForumThread(retVal)); }
/// <summary> /// Deletes the forum thread node. /// </summary> /// <param name="info">The info.</param> public void DeleteForumThreadNode(ForumThreadInfo info) { DBForum.DeleteForumThreadNodeByThreadId(info.Id); }
/// <summary> /// Renames the forum. /// </summary> /// <param name="ForumId">The forum id.</param> /// <param name="newName">The new name.</param> /// <param name="newDescription">The new description.</param> /// <returns></returns> public ForumInfo RenameForum(int ForumId, string newName, string newDescription) { DBForum.RenameForum(ForumId, newName, newDescription); return(this.GetForum(ForumId)); }
/// <summary> /// Deletes the forum thread node. /// </summary> /// <param name="NodeId">The node id.</param> public void DeleteForumThreadNode(int NodeId) { DBForum.DeleteForumThreadNodeById(NodeId); }
public ForumInfo CreateForum(string Name, string Description, DateTime Created) { int retVal = DBForum.CreateForum(_ownerContainer.Key, Name, Description, Created); return(GetForum(retVal)); }
public ForumThreadNodeInfo CreateForumThreadNode(int ThreadId, string Text, DateTime Created, string CreatorName, string CreatorEmail, int nodeType) { int retVal = DBForum.CreateForumThreadNode(ThreadId, Text, Created, null, CreatorName, CreatorEmail, null, nodeType); return(GetForumThreadNode(retVal)); }
private static Forum DBMapping(DBForum dbItem) { if (dbItem == null) return null; Forum item = new Forum(); item.ForumID = dbItem.ForumID; item.ForumGroupID = dbItem.ForumGroupID; item.Name = dbItem.Name; item.Description = dbItem.Description; item.NumTopics = dbItem.NumTopics; item.NumPosts = dbItem.NumPosts; item.LastTopicID = dbItem.LastTopicID; item.LastPostID = dbItem.LastPostID; item.LastPostUserID = dbItem.LastPostUserID; item.LastPostTime = dbItem.LastPostTime; item.DisplayOrder = dbItem.DisplayOrder; item.CreatedOn = dbItem.CreatedOn; item.UpdatedOn = dbItem.UpdatedOn; return item; }