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