private void SaveTopic()
{
var subject = ctlForm.Subject;
var body = ctlForm.Body;
subject = Utilities.CleanString(PortalId, subject, false, EditorTypes.TEXTBOX, ForumInfo.UseFilter, false, ForumModuleId, _themePath, false);
body = Utilities.CleanString(PortalId, body, _allowHTML, _editorType, ForumInfo.UseFilter, ForumInfo.AllowScript, ForumModuleId, _themePath, ForumInfo.AllowEmoticons);
var summary = ctlForm.Summary;
int authorId;
string authorName;
if (Request.IsAuthenticated)
{
authorId = UserInfo.UserID;
switch (MainSettings.UserNameDisplay.ToUpperInvariant())
{
case "USERNAME":
authorName = UserInfo.Username.Trim(' ');
break;
case "FULLNAME":
authorName = Convert.ToString(UserInfo.FirstName + " " + UserInfo.LastName).Trim(' ');
break;
case "FIRSTNAME":
authorName = UserInfo.FirstName.Trim(' ');
break;
case "LASTNAME":
authorName = UserInfo.LastName.Trim(' ');
break;
case "DISPLAYNAME":
authorName = UserInfo.DisplayName.Trim(' ');
break;
default:
authorName = UserInfo.DisplayName;
break;
}
}
else
{
authorId = -1;
authorName = Utilities.CleanString(PortalId, ctlForm.AuthorName, false, EditorTypes.TEXTBOX, true, false, ForumModuleId, _themePath, false);
if (authorName.Trim() == string.Empty)
return;
}
var tc = new TopicsController();
TopicInfo ti;
if (TopicId > 0)
{
ti = tc.Topics_Get(PortalId, ForumModuleId, TopicId);
ti.Content.DateUpdated = DateTime.Now;
authorId = ti.Author.AuthorId;
}
else
{
ti = new TopicInfo();
var dt = DateTime.Now;
ti.Content.DateCreated = dt;
ti.Content.DateUpdated = dt;
}
ti.AnnounceEnd = ctlForm.AnnounceEnd;
ti.AnnounceStart = ctlForm.AnnounceStart;
ti.Priority = ctlForm.TopicPriority;
if (!_isEdit)
{
ti.Content.AuthorId = authorId;
ti.Content.AuthorName = authorName;
ti.Content.IPAddress = Request.UserHostAddress;
}
if (Regex.IsMatch(body, "<CODE([^>]*)>", RegexOptions.IgnoreCase))
{
foreach (Match m in Regex.Matches(body, "<CODE([^>]*)>(.*?)</CODE>", RegexOptions.IgnoreCase))
body = body.Replace(m.Value, m.Value.Replace("<br>", System.Environment.NewLine));
}
if (!(string.IsNullOrEmpty(ForumInfo.PrefixURL)))
{
var cleanSubject = Utilities.CleanName(subject).ToLowerInvariant();
if (SimulateIsNumeric.IsNumeric(cleanSubject))
cleanSubject = "Topic-" + cleanSubject;
var topicUrl = cleanSubject;
var urlPrefix = "/";
if (!(string.IsNullOrEmpty(ForumInfo.ForumGroup.PrefixURL)))
urlPrefix += ForumInfo.ForumGroup.PrefixURL + "/";
if (!(string.IsNullOrEmpty(ForumInfo.PrefixURL)))
urlPrefix += ForumInfo.PrefixURL + "/";
var urlToCheck = urlPrefix + cleanSubject;
var topicsDb = new Data.Topics();
for (var u = 0; u <= 200; u++)
{
var tid = topicsDb.TopicIdByUrl(PortalId, ModuleId, urlToCheck);
if (tid > 0 && tid == TopicId)
break;
if (tid <= 0)
break;
topicUrl = (u + 1) + "-" + cleanSubject;
urlToCheck = urlPrefix + topicUrl;
}
if (topicUrl.Length > 150)
{
topicUrl = topicUrl.Substring(0, 149);
topicUrl = topicUrl.Substring(0, topicUrl.LastIndexOf("-", StringComparison.Ordinal));
}
ti.TopicUrl = topicUrl;
}
else
{
//.URL = String.Empty
ti.TopicUrl = string.Empty;
}
ti.Content.Body = body; //Utilities.CleanString(PortalId, Body, fi.AllowHTML, fi.EditorType, fi.UseFilter, fi.AllowScript, ForumModuleId, String.Empty)
ti.Content.Subject = subject;
ti.Content.Summary = summary;
ti.IsAnnounce = ti.AnnounceEnd != Utilities.NullDate() && ti.AnnounceStart != Utilities.NullDate();
if (_canModApprove && _fi.IsModerated)
ti.IsApproved = ctlForm.IsApproved;
else
ti.IsApproved = _isApproved;
bool bSend = ti.IsApproved;
ti.IsArchived = false;
ti.IsDeleted = false;
ti.IsLocked = _canLock && ctlForm.Locked;
ti.IsPinned = _canPin && ctlForm.Pinned;
ti.StatusId = ctlForm.StatusId;
ti.TopicIcon = ctlForm.TopicIcon;
ti.TopicType = 0;
if (ForumInfo.Properties != null)
{
var tData = new StringBuilder();
tData.Append("<topicdata>");
tData.Append("<properties>");
foreach (var p in ForumInfo.Properties)
{
var pkey = "afprop-" + p.PropertyId.ToString();
tData.Append("<property id=\"" + p.PropertyId.ToString() + "\">");
tData.Append("<name><![CDATA[");
tData.Append(p.Name);
tData.Append("]]></name>");
if (Request.Form[pkey] != null)
{
tData.Append("<value><![CDATA[");
tData.Append(Utilities.XSSFilter(Request.Form[pkey]));
tData.Append("]]></value>");
}
else
{
tData.Append("<value></value>");
}
tData.Append("</property>");
}
tData.Append("</properties>");
tData.Append("</topicdata>");
ti.TopicData = tData.ToString();
}
TopicId = tc.TopicSave(PortalId, ti);
ti = tc.Topics_Get(PortalId, ForumModuleId, TopicId, ForumId, -1, false);
if (ti != null)
{
tc.Topics_SaveToForum(ForumId, TopicId, PortalId, ModuleId);
SaveAttachments(ti.ContentId);
if (ti.IsApproved && ti.Author.AuthorId > 0)
{
var uc = new Data.Profiles();
uc.Profile_UpdateTopicCount(PortalId, ti.Author.AuthorId);
}
}
if (Permissions.HasPerm(ForumInfo.Security.Tag, ForumUser.UserRoles))
{
DataProvider.Instance().Tags_DeleteByTopicId(PortalId, ForumModuleId, TopicId);
var tagForm = string.Empty;
if (Request.Form["txtTags"] != null)
tagForm = Request.Form["txtTags"];
if (tagForm != string.Empty)
{
var tags = tagForm.Split(',');
foreach (var tag in tags)
{
var sTag = Utilities.CleanString(PortalId, tag.Trim(), false, EditorTypes.TEXTBOX, false, false, ForumModuleId, string.Empty, false);
DataProvider.Instance().Tags_Save(PortalId, ForumModuleId, -1, sTag, 0, 1, 0, TopicId, false, -1, -1);
}
}
}
if (Permissions.HasPerm(ForumInfo.Security.Categorize, ForumUser.UserRoles))
{
if (Request.Form["amaf-catselect"] != null)
{
var cats = Request.Form["amaf-catselect"].Split(';');
DataProvider.Instance().Tags_DeleteTopicToCategory(PortalId, ForumModuleId, -1, TopicId);
foreach (var c in cats)
{
if (string.IsNullOrEmpty(c) || !SimulateIsNumeric.IsNumeric(c))
continue;
var cid = Convert.ToInt32(c);
if (cid > 0)
DataProvider.Instance().Tags_AddTopicToCategory(PortalId, ForumModuleId, cid, TopicId);
}
}
}
if (!String.IsNullOrEmpty(ctlForm.PollQuestion) && !String.IsNullOrEmpty(ctlForm.PollOptions))
{
//var sPollQ = ctlForm.PollQuestion.Trim();
//sPollQ = Utilities.CleanString(PortalId, sPollQ, false, EditorTypes.TEXTBOX, true, false, ForumModuleId, string.Empty, false);
var pollId = DataProvider.Instance().Poll_Save(-1, TopicId, UserId, ctlForm.PollQuestion.Trim(), ctlForm.PollType);
if (pollId > 0)
{
var options = ctlForm.PollOptions.Split(new[] { System.Environment.NewLine }, StringSplitOptions.None);
foreach (string opt in options)
{
if (opt.Trim() != string.Empty)
{
var value = Utilities.CleanString(PortalId, opt, false, EditorTypes.TEXTBOX, true, false, ForumModuleId, string.Empty, false);
DataProvider.Instance().Poll_Option_Save(-1, pollId, value.Trim(), TopicId);
}
}
}
ti = tc.Topics_Get(PortalId, ForumModuleId, TopicId, ForumId, -1, false);
ti.TopicType = TopicTypes.Poll;
tc.TopicSave(PortalId, ti);
}
try
{
var cachekey = string.Format("AF-FV-{0}-{1}", PortalId, ModuleId);
DataCache.CacheClearPrefix(cachekey);
if (ctlForm.Subscribe && authorId == UserId)
{
if (!(Subscriptions.IsSubscribed(PortalId, ForumModuleId, ForumId, TopicId, SubscriptionTypes.Instant, authorId)))
{
var sc = new SubscriptionController();
sc.Subscription_Update(PortalId, ForumModuleId, ForumId, TopicId, 1, authorId, ForumUser.UserRoles);
}
}
else if (_isEdit)
{
bool isSub = Subscriptions.IsSubscribed(PortalId, ForumModuleId, ForumId, TopicId, SubscriptionTypes.Instant, authorId);
if (isSub && !ctlForm.Subscribe)
{
var sc = new SubscriptionController();
sc.Subscription_Update(PortalId, ForumModuleId, ForumId, TopicId, 1, authorId, ForumUser.UserRoles);
}
}
if (bSend && !_isEdit)
Subscriptions.SendSubscriptions(PortalId, ForumModuleId, ForumTabId, _fi, TopicId, 0, ti.Content.AuthorId);
if (ti.IsApproved == false)
{
var mods = Utilities.GetListOfModerators(PortalId, ForumId);
var notificationType = NotificationsController.Instance.GetNotificationType("AF-ForumModeration");
var notifySubject = Utilities.GetSharedResource("NotificationSubjectTopic");
notifySubject = notifySubject.Replace("[DisplayName]", UserInfo.DisplayName);
notifySubject = notifySubject.Replace("[TopicSubject]", ti.Content.Subject);
var notifyBody = Utilities.GetSharedResource("NotificationBodyTopic");
notifyBody = notifyBody.Replace("[Post]", ti.Content.Body);
var notificationKey = string.Format("{0}:{1}:{2}:{3}:{4}", TabId, ForumModuleId, ForumId, TopicId, ReplyId);
var notification = new Notification
{
NotificationTypeID = notificationType.NotificationTypeId,
Subject = notifySubject,
Body = notifyBody,
IncludeDismissAction = false,
SenderUserID = UserInfo.UserID,
Context = notificationKey
};
NotificationsController.Instance.SendNotification(notification, PortalId, null, mods);
string[] @params = { ParamKeys.ForumId + "=" + ForumId, ParamKeys.ViewType + "=confirmaction", ParamKeys.ConfirmActionId + "=" + ConfirmActions.MessagePending };
Response.Redirect(NavigateUrl(ForumTabId, "", @params), false);
}
else
{
if (ti != null)
ti.TopicId = TopicId;
var ctlUtils = new ControlUtils();
var sUrl = ctlUtils.BuildUrl(ForumTabId, ForumModuleId, ForumInfo.ForumGroup.PrefixURL, ForumInfo.PrefixURL, ForumInfo.ForumGroupId, ForumInfo.ForumID, TopicId, ti.TopicUrl, -1, -1, string.Empty, 1, -1, SocialGroupId);
if (sUrl.Contains("~/") || Request.QueryString["asg"] != null)
sUrl = Utilities.NavigateUrl(ForumTabId, "", ParamKeys.TopicId + "=" + TopicId);
if (!_isEdit)
{
try
{
var amas = new Social();
amas.AddTopicToJournal(PortalId, ForumModuleId, ForumId, TopicId, UserId, sUrl, subject, summary, body, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read, SocialGroupId);
if (Request.QueryString["asg"] == null && !(string.IsNullOrEmpty(MainSettings.ActiveSocialTopicsKey)) && ForumInfo.ActiveSocialEnabled)
{
// amas.AddTopicToJournal(PortalId, ForumModuleId, ForumId, UserId, sUrl, Subject, Summary, Body, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read)
}
else
{
amas.AddForumItemToJournal(PortalId, ForumModuleId, UserId, "forumtopic", sUrl, subject, body);
}
}
catch (Exception ex)
{
Services.Exceptions.Exceptions.LogException(ex);
}
}
Response.Redirect(sUrl, false);
}
}
catch (Exception ex)
{
Services.Exceptions.Exceptions.LogException(ex);
}
}
public int Topic_QuickCreate(int PortalId, int ModuleId, int ForumId, string Subject, string Body, int UserId, string DisplayName, bool IsApproved, string IPAddress)
{
int topicId = -1;
TopicInfo ti = new TopicInfo();
ti.AnnounceEnd = Utilities.NullDate();
ti.AnnounceStart = Utilities.NullDate();
ti.Content.AuthorId = UserId;
ti.Content.AuthorName = DisplayName;
ti.Content.Subject = Subject;
ti.Content.Body = Body;
ti.Content.Summary = string.Empty;
ti.Content.IPAddress = IPAddress;
DateTime dt = DateTime.Now;
ti.Content.DateCreated = dt;
ti.Content.DateUpdated = dt;
ti.IsAnnounce = false;
ti.IsApproved = IsApproved;
ti.IsArchived = false;
ti.IsDeleted = false;
ti.IsLocked = false;
ti.IsPinned = false;
ti.ReplyCount = 0;
ti.StatusId = -1;
ti.TopicIcon = string.Empty;
ti.TopicType = TopicTypes.Topic;
ti.ViewCount = 0;
topicId = TopicSave(PortalId, ti);
if (topicId > 0)
{
Topics_SaveToForum(ForumId, topicId, PortalId, ModuleId);
if (UserId > 0)
{
Data.Profiles uc = new Data.Profiles();
uc.Profile_UpdateTopicCount(PortalId, UserId);
}
}
return topicId;
}
private XmlRpcStruct NewTopic(int forumId, string subject, string body, string prefixId, IEnumerable<string> attachmentIds, string groupId)
{
var aftContext = ActiveForumsTapatalkModuleContext.Create(Context);
Context.Response.AddHeader("Mobiquo_is_login", aftContext.UserId > 0 ? "true" : "false");
var portalId = aftContext.Module.PortalID;
var forumModuleId = aftContext.ModuleSettings.ForumModuleId;
var fc = new AFTForumController();
var forumInfo = fc.GetForum(portalId, forumModuleId, forumId);
// Verify Post Permissions
if (!ActiveForums.Permissions.HasPerm(forumInfo.Security.Create, aftContext.ForumUser.UserRoles))
{
return new XmlRpcStruct
{
{"result", "false"}, //"true" for success
{"result_text", "Not Authorized to Post".ToBytes()},
};
}
// Build User Permissions
var canModApprove = ActiveForums.Permissions.HasPerm(forumInfo.Security.ModApprove, aftContext.ForumUser.UserRoles);
var canTrust = ActiveForums.Permissions.HasPerm(forumInfo.Security.Trust, aftContext.ForumUser.UserRoles);
var userProfile = aftContext.UserId > 0 ? aftContext.ForumUser.Profile : new UserProfileInfo { TrustLevel = -1 };
var userIsTrusted = Utilities.IsTrusted((int)forumInfo.DefaultTrustValue, userProfile.TrustLevel, canTrust, forumInfo.AutoTrustLevel, userProfile.PostCount);
// Determine if the post should be approved
var isApproved = !forumInfo.IsModerated || userIsTrusted || canModApprove;
var mainSettings = new SettingsInfo { MainSettings = new Entities.Modules.ModuleController().GetModuleSettings(forumModuleId) };
var dnnUser = Entities.Users.UserController.GetUserById(portalId, aftContext.UserId);
var authorName = GetAuthorName(mainSettings, dnnUser);
var themePath = string.Format("{0}://{1}{2}", Context.Request.Url.Scheme, Context.Request.Url.Host, VirtualPathUtility.ToAbsolute("~/DesktopModules/activeforums/themes/" + mainSettings.Theme + "/"));
subject = Utilities.CleanString(portalId, subject, false, EditorTypes.TEXTBOX, forumInfo.UseFilter, false, forumModuleId, themePath, false);
body = Utilities.CleanString(portalId, TapatalkToHtml(body), forumInfo.AllowHTML, EditorTypes.HTMLEDITORPROVIDER, forumInfo.UseFilter, false, forumModuleId, themePath, forumInfo.AllowEmoticons);
// Create the topic
var ti = new TopicInfo();
var dt = DateTime.Now;
ti.Content.DateCreated = dt;
ti.Content.DateUpdated = dt;
ti.Content.AuthorId = aftContext.UserId;
ti.Content.AuthorName = authorName;
ti.Content.IPAddress = Context.Request.UserHostAddress;
ti.TopicUrl = string.Empty;
ti.Content.Body = body;
ti.Content.Subject = subject;
ti.Content.Summary = string.Empty;
ti.IsAnnounce = false;
ti.IsPinned = false;
ti.IsLocked = false;
ti.IsDeleted = false;
ti.IsArchived = false;
ti.StatusId = -1;
ti.TopicIcon = string.Empty;
ti.TopicType = 0;
ti.IsApproved = isApproved;
// Save the topic
var tc = new TopicsController();
var topicId = tc.TopicSave(portalId, ti);
ti = tc.Topics_Get(portalId, forumModuleId, topicId, forumId, -1, false);
if (ti == null)
{
return new XmlRpcStruct
{
{"result", "false"}, //"true" for success
{"result_text", "Error Creating Post".ToBytes()},
};
}
// Update stats
tc.Topics_SaveToForum(forumId, topicId, portalId, forumModuleId);
if (ti.IsApproved && ti.Author.AuthorId > 0)
{
var uc = new ActiveForums.Data.Profiles();
uc.Profile_UpdateTopicCount(portalId, ti.Author.AuthorId);
}
try
{
// Clear the cache
var cachekey = string.Format("AF-FV-{0}-{1}", portalId, forumModuleId);
DataCache.CacheClearPrefix(cachekey);
// Subscribe the user if they have auto-subscribe set.
if (userProfile.PrefSubscriptionType != SubscriptionTypes.Disabled && !(Subscriptions.IsSubscribed(portalId, forumModuleId, forumId, topicId, SubscriptionTypes.Instant, aftContext.UserId)))
{
new SubscriptionController().Subscription_Update(portalId, forumModuleId, forumId, topicId, (int)userProfile.PrefSubscriptionType, aftContext.UserId, aftContext.ForumUser.UserRoles);
}
if (isApproved)
{
// Send User Notifications
Subscriptions.SendSubscriptions(portalId, forumModuleId, aftContext.ModuleSettings.ForumTabId, forumInfo, topicId, 0, ti.Content.AuthorId);
// Add Journal entry
var forumTabId = aftContext.ModuleSettings.ForumTabId;
var fullURL = new ControlUtils().BuildUrl(forumTabId, forumModuleId, forumInfo.ForumGroup.PrefixURL, forumInfo.PrefixURL, forumInfo.ForumGroupId, forumInfo.ForumID, topicId, ti.TopicUrl, -1, -1, string.Empty, 1, -1, forumInfo.SocialGroupId);
new Social().AddTopicToJournal(portalId, forumModuleId, forumId, topicId, ti.Author.AuthorId, fullURL, ti.Content.Subject, string.Empty, ti.Content.Body, forumInfo.ActiveSocialSecurityOption, forumInfo.Security.Read, forumInfo.SocialGroupId);
}
else
{
// Send Mod Notifications
var mods = Utilities.GetListOfModerators(portalId, forumId);
var notificationType = NotificationsController.Instance.GetNotificationType("AF-ForumModeration");
var notifySubject = Utilities.GetSharedResource("NotificationSubjectTopic");
notifySubject = notifySubject.Replace("[DisplayName]", dnnUser.DisplayName);
notifySubject = notifySubject.Replace("[TopicSubject]", ti.Content.Subject);
var notifyBody = Utilities.GetSharedResource("NotificationBodyTopic");
notifyBody = notifyBody.Replace("[Post]", ti.Content.Body);
var notificationKey = string.Format("{0}:{1}:{2}:{3}:{4}", aftContext.ModuleSettings.ForumTabId, forumModuleId, forumId, topicId, 0);
var notification = new Notification
{
NotificationTypeID = notificationType.NotificationTypeId,
Subject = notifySubject,
Body = notifyBody,
IncludeDismissAction = false,
SenderUserID = dnnUser.UserID,
Context = notificationKey
};
NotificationsController.Instance.SendNotification(notification, portalId, null, mods);
}
}
catch (Exception ex)
{
Services.Exceptions.Exceptions.LogException(ex);
}
var result = new XmlRpcStruct
{
{"result", true}, //"true" for success
// {"result_text", "OK".ToBytes()},
{"topic_id", ti.TopicId.ToString()},
};
if (!isApproved)
result.Add("state", 1);
return result;
}
public List<TopicInfo> TopicsList(int ForumId, int ModuleId, int PortalId)
{
IDataReader dr = DataProvider.Instance().Topics_List(ForumId, ModuleId, PortalId);
List<TopicInfo> tl = new List<TopicInfo>();
while (dr.Read())
{
TopicInfo ti = new TopicInfo();
if (! (dr["AnnounceEnd"] == DBNull.Value))
{
ti.AnnounceEnd = Convert.ToDateTime(dr["AnnounceEnd"]);
}
if (! (dr["AnnounceStart"] == DBNull.Value))
{
ti.AnnounceStart = Convert.ToDateTime(dr["AnnounceStart"]);
}
ti.Content.AuthorId = Convert.ToInt32(dr["AuthorId"]);
ti.Content.AuthorName = dr["AuthorName"].ToString();
ti.Content.Body = dr["Body"].ToString();
ti.Content.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.Content.DateCreated = Convert.ToDateTime(dr["DateCreated"]);
ti.Content.DateUpdated = Convert.ToDateTime(dr["DateUpdated"]);
ti.Content.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.Content.Subject = dr["Subject"].ToString();
ti.Content.Summary = dr["Summary"].ToString();
ti.Author.AuthorId = ti.Content.AuthorId;
ti.Author.DisplayName = dr["DisplayName"].ToString();
ti.Author.Email = dr["Email"].ToString();
ti.Author.FirstName = dr["FirstName"].ToString();
ti.Author.LastName = dr["LastName"].ToString();
ti.Author.Username = dr["Username"].ToString();
ti.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.IsAnnounce = Convert.ToBoolean(dr["IsAnnounce"]);
ti.IsApproved = Convert.ToBoolean(dr["IsApproved"]);
ti.IsArchived = Convert.ToBoolean(dr["IsArchived"]);
ti.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.IsLocked = Convert.ToBoolean(dr["IsLocked"]);
ti.IsPinned = Convert.ToBoolean(dr["IsPinned"]);
ti.ReplyCount = Convert.ToInt32(dr["ReplyCount"]);
ti.StatusId = Convert.ToInt32(dr["StatusId"]);
ti.TopicIcon = Convert.ToString(dr["TopicIcon"]);
ti.TopicId = Convert.ToInt32(dr["TopicId"]);
ti.TopicType = (TopicTypes)(dr["TopicType"]);
ti.ViewCount = Convert.ToInt32(dr["ViewCount"]);
ti.Tags = dr["Tags"].ToString();
tl.Add(ti);
}
dr.Close();
return tl;
}
public TopicInfo Topics_Get(int PortalId, int ModuleId, int TopicId, int ForumId, int UserId, bool WithSecurity)
{
IDataReader dr = DataProvider.Instance().Topics_Get(PortalId, ModuleId, TopicId, ForumId, UserId, WithSecurity);
TopicInfo ti = null;
while (dr.Read())
{
ti = new TopicInfo();
if (! (dr["AnnounceEnd"] == DBNull.Value))
{
ti.AnnounceEnd = Convert.ToDateTime(dr["AnnounceEnd"]);
}
if (! (dr["AnnounceStart"] == DBNull.Value))
{
ti.AnnounceStart = Convert.ToDateTime(dr["AnnounceStart"]);
}
ti.Content.AuthorId = Convert.ToInt32(dr["AuthorId"]);
ti.Content.AuthorName = dr["AuthorName"].ToString();
ti.Content.Body = dr["Body"].ToString();
ti.Content.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.Content.DateCreated = Convert.ToDateTime(dr["DateCreated"]);
ti.Content.DateUpdated = Convert.ToDateTime(dr["DateUpdated"]);
ti.Content.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.Content.Subject = dr["Subject"].ToString();
ti.Content.Summary = dr["Summary"].ToString();
ti.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.Author.AuthorId = ti.Content.AuthorId;
ti.Author.DisplayName = dr["DisplayName"].ToString();
ti.Author.Email = dr["Email"].ToString();
ti.Author.FirstName = dr["FirstName"].ToString();
ti.Author.LastName = dr["LastName"].ToString();
ti.Author.Username = dr["Username"].ToString();
ti.IsAnnounce = Convert.ToBoolean(dr["IsAnnounce"]);
ti.IsApproved = Convert.ToBoolean(dr["IsApproved"]);
ti.IsArchived = Convert.ToBoolean(dr["IsArchived"]);
ti.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.IsLocked = Convert.ToBoolean(dr["IsLocked"]);
ti.IsPinned = Convert.ToBoolean(dr["IsPinned"]);
ti.ReplyCount = Convert.ToInt32(dr["ReplyCount"]);
ti.StatusId = Convert.ToInt32(dr["StatusId"]);
ti.TopicIcon = Convert.ToString(dr["TopicIcon"]);
ti.TopicId = Convert.ToInt32(dr["TopicId"]);
ti.TopicType = (TopicTypes)(dr["TopicType"]);
ti.ViewCount = Convert.ToInt32(dr["ViewCount"]);
ti.Tags = dr["Tags"].ToString();
ti.Priority = Convert.ToInt32(dr["Priority"].ToString());
ti.Categories = dr["Categories"].ToString();
ti.ForumURL = dr["ForumURL"].ToString();
ti.TopicUrl = dr["TopicURL"].ToString();
//.URL = dr("URL").ToString
try
{
ti.TopicData = dr["TopicData"].ToString();
}
catch (Exception ex)
{
ti.TopicData = string.Empty;
}
}
//If WithSecurity Then
// dr.NextResult()
// 'Dim tmpDr As IDataReader = dr
// ti.Security = CType(DotNetNuke.Common.Utilities.CBO.FillObject(dr, GetType(PermissionInfo)), PermissionInfo)
//End If
if (! dr.IsClosed)
{
dr.Close();
}
return ti;
}
private void SaveQuickReply()
{
SettingsInfo ms = DataCache.MainSettings(ForumModuleId);
int iFloodInterval = MainSettings.FloodInterval;
if (iFloodInterval > 0)
{
UserProfileInfo upi = ForumUser.Profile;
if (upi != null)
{
if (SimulateDateDiff.DateDiff(SimulateDateDiff.DateInterval.Second, upi.DateLastPost, DateTime.Now) < iFloodInterval)
{
Controls.InfoMessage im = new Controls.InfoMessage();
im.Message = "<div class=\"afmessage\">" + string.Format(GetSharedResource("[RESX:Error:FloodControl]"), iFloodInterval) + "</div>";
plhMessage.Controls.Add(im);
return;
}
}
}
if (!Request.IsAuthenticated)
{
if ((!ctlCaptcha.IsValid) || txtUserName.Value == "")
{
return;
}
}
UserProfileInfo ui = new UserProfileInfo();
if (UserId > 0)
{
ui = ForumUser.Profile;
}
else
{
ui.TopicCount = 0;
ui.ReplyCount = 0;
ui.RewardPoints = 0;
ui.IsMod = false;
ui.TrustLevel = -1;
}
bool UserIsTrusted = false;
UserIsTrusted = Utilities.IsTrusted((int)ForumInfo.DefaultTrustValue, ui.TrustLevel, Permissions.HasPerm(ForumInfo.Security.Trust, ForumUser.UserRoles), ForumInfo.AutoTrustLevel, ui.PostCount);
bool isApproved = false;
isApproved = Convert.ToBoolean(((ForumInfo.IsModerated == true) ? false : true));
if (UserIsTrusted || Permissions.HasPerm(ForumInfo.Security.ModApprove, ForumUser.UserRoles))
{
isApproved = true;
}
ReplyInfo ri = new ReplyInfo();
ReplyController rc = new ReplyController();
int ReplyId = -1;
string sUsername = string.Empty;
if (Request.IsAuthenticated)
{
switch (MainSettings.UserNameDisplay.ToUpperInvariant())
{
case "USERNAME":
sUsername = UserInfo.Username.Trim(' ');
break;
case "FULLNAME":
sUsername = Convert.ToString(UserInfo.FirstName + " " + UserInfo.LastName).Trim(' ');
break;
case "FIRSTNAME":
sUsername = UserInfo.FirstName.Trim(' ');
break;
case "LASTNAME":
sUsername = UserInfo.LastName.Trim(' ');
break;
case "DISPLAYNAME":
sUsername = UserInfo.DisplayName.Trim(' ');
break;
default:
sUsername = UserInfo.DisplayName;
break;
}
}
else
{
sUsername = Utilities.CleanString(PortalId, txtUserName.Value, false, EditorTypes.TEXTBOX, true, false, ForumModuleId, ThemePath, false);
}
//Dim sSubject As String = Server.HtmlEncode(Request.Form("txtSubject"))
//If (UseFilter) Then
// sSubject = Utilities.FilterWords(PortalId, ForumModuleId, ThemePath, sSubject)
//End If
string sBody = string.Empty;
if (AllowHTML)
{
AllowHTML = IsHtmlPermitted(ForumInfo.EditorPermittedUsers, IsTrusted, Permissions.HasPerm(ForumInfo.Security.ModEdit, ForumUser.UserRoles));
}
sBody = Utilities.CleanString(PortalId, Request.Form["txtBody"], AllowHTML, EditorTypes.TEXTBOX, UseFilter, AllowScripts, ForumModuleId, ThemePath, ForumInfo.AllowEmoticons);
DateTime createDate = DateTime.Now;
ri.TopicId = TopicId;
ri.ReplyToId = TopicId;
ri.Content.AuthorId = UserId;
ri.Content.AuthorName = sUsername;
ri.Content.Body = sBody;
ri.Content.DateCreated = createDate;
ri.Content.DateUpdated = createDate;
ri.Content.IsDeleted = false;
ri.Content.Subject = Subject;
ri.Content.Summary = string.Empty;
ri.IsApproved = isApproved;
ri.IsDeleted = false;
ri.Content.IPAddress = Request.UserHostAddress;
ReplyId = rc.Reply_Save(PortalId, ri);
//Check if is subscribed
string cachekey = string.Format("AF-FV-{0}-{1}", PortalId, ModuleId);
DataCache.CacheClearPrefix(cachekey);
// Subscribe or unsubscribe if needed
if (AllowSubscribe && UserId > 0)
{
var subscribe = Request.Params["chkSubscribe"] == "1";
var currentlySubscribed = Subscriptions.IsSubscribed(PortalId, ForumModuleId, ForumId, TopicId, SubscriptionTypes.Instant, UserId);
if (subscribe != currentlySubscribed)
{
// Will need to update this to support multiple subscrition types later
// Subscription_Update works as a toggle, so you only call it if you want to change the value.
var sc = new SubscriptionController();
sc.Subscription_Update(PortalId, ForumModuleId, ForumId, TopicId, 1, UserId, ForumUser.UserRoles);
}
}
ControlUtils ctlUtils = new ControlUtils();
TopicsController tc = new TopicsController();
TopicInfo ti = tc.Topics_Get(PortalId, ForumModuleId, TopicId, ForumId, -1, false);
string fullURL = ctlUtils.BuildUrl(ForumTabId, ForumModuleId, ForumInfo.ForumGroup.PrefixURL, ForumInfo.PrefixURL, ForumInfo.ForumGroupId, ForumInfo.ForumID, TopicId, ti.TopicUrl, -1, -1, string.Empty, 1, SocialGroupId);
if (fullURL.Contains("~/") || Request.QueryString["asg"] != null)
{
fullURL = Utilities.NavigateUrl(TabId, "", new string[] { ParamKeys.TopicId + "=" + TopicId, ParamKeys.ContentJumpId + "=" + ReplyId });
}
if (fullURL.EndsWith("/"))
{
fullURL += "?" + ParamKeys.ContentJumpId + "=" + ReplyId;
}
if (isApproved)
{
//Send Subscriptions
try
{
//Dim sURL As String = Utilities.NavigateUrl(TabId, "", New String() {ParamKeys.ForumId & "=" & ForumId, ParamKeys.ViewType & "=" & Views.Topic, ParamKeys.TopicId & "=" & TopicId, ParamKeys.ContentJumpId & "=" & ReplyId})
Subscriptions.SendSubscriptions(PortalId, ForumModuleId, TabId, ForumId, TopicId, ReplyId, UserId);
try
{
Social amas = new Social();
amas.AddReplyToJournal(PortalId, ForumModuleId, ForumId, TopicId, ReplyId, UserId, fullURL, Subject, string.Empty, sBody, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read, SocialGroupId);
//If Request.QueryString["asg"] Is Nothing And Not String.IsNullOrEmpty(MainSettings.ActiveSocialTopicsKey) And ForumInfo.ActiveSocialEnabled And Not ForumInfo.ActiveSocialTopicsOnly Then
// amas.AddReplyToJournal(PortalId, ForumModuleId, ForumId, TopicId, ReplyId, UserId, fullURL, Subject, String.Empty, sBody, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read)
//Else
// amas.AddForumItemToJournal(PortalId, ForumModuleId, UserId, "forumreply", fullURL, Subject, sBody)
//End If
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
//Redirect to show post
Response.Redirect(fullURL, false);
}
else if (isApproved == false)
{
List <Entities.Users.UserInfo> mods = Utilities.GetListOfModerators(PortalId, ForumId);
NotificationType notificationType = NotificationsController.Instance.GetNotificationType("AF-ForumModeration");
string subject = Utilities.GetSharedResource("NotificationSubjectReply");
subject = subject.Replace("[DisplayName]", UserInfo.DisplayName);
subject = subject.Replace("[TopicSubject]", ti.Content.Subject);
string body = Utilities.GetSharedResource("NotificationBodyReply");
body = body.Replace("[Post]", sBody);
string notificationKey = string.Format("{0}:{1}:{2}:{3}:{4}", TabId, ForumModuleId, ForumId, TopicId, ReplyId);
Notification notification = new Notification();
notification.NotificationTypeID = notificationType.NotificationTypeId;
notification.Subject = subject;
notification.Body = body;
notification.IncludeDismissAction = false;
notification.SenderUserID = UserInfo.UserID;
notification.Context = notificationKey;
NotificationsController.Instance.SendNotification(notification, PortalId, null, mods);
var @params = new List <string> {
ParamKeys.ForumId + "=" + ForumId, ParamKeys.ViewType + "=confirmaction", "afmsg=pendingmod", ParamKeys.TopicId + "=" + TopicId
};
if (SocialGroupId > 0)
{
@params.Add("GroupId=" + SocialGroupId);
}
Response.Redirect(Utilities.NavigateUrl(TabId, "", @params.ToArray()), false);
}
else
{
//Dim fullURL As String = Utilities.NavigateUrl(TabId, "", New String() {ParamKeys.ForumId & "=" & ForumId, ParamKeys.ViewType & "=" & Views.Topic, ParamKeys.TopicId & "=" & TopicId, ParamKeys.ContentJumpId & "=" & ReplyId})
//If MainSettings.UseShortUrls Then
// fullURL = Utilities.NavigateUrl(TabId, "", New String() {ParamKeys.TopicId & "=" & TopicId, ParamKeys.ContentJumpId & "=" & ReplyId})
//End If
try
{
Social amas = new Social();
amas.AddReplyToJournal(PortalId, ForumModuleId, ForumId, TopicId, ReplyId, UserId, fullURL, Subject, string.Empty, sBody, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read, SocialGroupId);
//If Request.QueryString["asg"] Is Nothing And Not String.IsNullOrEmpty(MainSettings.ActiveSocialTopicsKey) And ForumInfo.ActiveSocialEnabled Then
// amas.AddReplyToJournal(PortalId, ForumModuleId, ForumId, TopicId, ReplyId, UserId, fullURL, Subject, String.Empty, sBody, ForumInfo.ActiveSocialSecurityOption, ForumInfo.Security.Read)
//Else
// amas.AddForumItemToJournal(PortalId, ForumModuleId, UserId, "forumreply", fullURL, Subject, sBody)
//End If
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
}
Response.Redirect(fullURL, false);
}
//End If
}
public int TopicSave(int PortalId, TopicInfo ti)
{
return Convert.ToInt32(DataProvider.Instance().Topics_Save(PortalId, ti.TopicId, ti.ViewCount, ti.ReplyCount, ti.IsLocked, ti.IsPinned, ti.TopicIcon, ti.StatusId, ti.IsApproved, ti.IsDeleted, ti.IsAnnounce, ti.IsArchived, ti.AnnounceStart, ti.AnnounceEnd, ti.Content.Subject.Trim(), ti.Content.Body.Trim(), ti.Content.Summary.Trim(), ti.Content.DateCreated, ti.Content.DateUpdated, ti.Content.AuthorId, ti.Content.AuthorName, ti.Content.IPAddress, (int)ti.TopicType, ti.Priority, ti.TopicUrl, ti.TopicData));
}
private void cbMod_Callback(object sender, Modules.ActiveForums.Controls.CallBackEventArgs e)
{
SettingsInfo ms = DataCache.MainSettings(ForumModuleId);
Forum fi = null;
if (e.Parameters.Length > 0)
{
if (ForumId < 1)
{
SetPermissions(Convert.ToInt32(e.Parameters[1]));
ForumController fc = new ForumController();
fi = fc.Forums_Get(Convert.ToInt32(e.Parameters[1]), -1, false, true);
}
else
{
fi = ForumInfo;
}
switch (e.Parameters[0].ToLowerInvariant())
{
case "moddel":
{
if (bModDelete)
{
int delAction = ms.DeleteBehavior;
int tmpForumId = -1;
int tmpTopicId = -1;
int tmpReplyId = -1;
tmpForumId = Convert.ToInt32(e.Parameters[1]);
tmpTopicId = Convert.ToInt32(e.Parameters[2]);
tmpReplyId = Convert.ToInt32(e.Parameters[3]);
Author auth = null;
if (fi.ModDeleteTemplateId > 0)
{
try
{
//Email.SendEmail(fi.ModDeleteTemplateId, PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, tmpReplyId, string.Empty, auth);
Email.SendEmailToModerators(fi.ModDeleteTemplateId, PortalId, tmpForumId, tmpTopicId, tmpReplyId, ForumModuleId, ForumTabId, string.Empty);
}
catch (Exception ex)
{
}
}
if (tmpForumId > 0 & tmpTopicId > 0 && tmpReplyId == 0)
{
TopicsController tc = new TopicsController();
TopicInfo ti = tc.Topics_Get(PortalId, ForumModuleId, tmpTopicId);
if (ti != null)
{
auth = ti.Author;
}
tc.Topics_Delete(PortalId, ModuleId, tmpForumId, tmpTopicId, delAction);
}
else if (tmpForumId > 0 & tmpTopicId > 0 & tmpReplyId > 0)
{
ReplyController rc = new ReplyController();
ReplyInfo ri = rc.Reply_Get(PortalId, ForumModuleId, tmpTopicId, tmpReplyId);
if (ri != null)
{
auth = ri.Author;
}
rc.Reply_Delete(PortalId, tmpForumId, tmpTopicId, tmpReplyId, delAction);
}
}
break;
}
case "modreject":
{
int tmpForumId = 0;
int tmpTopicId = 0;
int tmpReplyId = 0;
int tmpAuthorId = 0;
tmpForumId = Convert.ToInt32(e.Parameters[1]);
tmpTopicId = Convert.ToInt32(e.Parameters[2]);
tmpReplyId = Convert.ToInt32(e.Parameters[3]);
tmpAuthorId = Convert.ToInt32(e.Parameters[4]);
ModController mc = new ModController();
mc.Mod_Reject(PortalId, ForumModuleId, UserId, tmpForumId, tmpTopicId, tmpReplyId);
if (fi.ModRejectTemplateId > 0 & tmpAuthorId > 0)
{
DotNetNuke.Entities.Users.UserController uc = new DotNetNuke.Entities.Users.UserController();
DotNetNuke.Entities.Users.UserInfo ui = uc.GetUser(PortalId, tmpAuthorId);
if (ui != null)
{
Author au = new Author();
au.AuthorId = tmpAuthorId;
au.DisplayName = ui.DisplayName;
au.Email = ui.Email;
au.FirstName = ui.FirstName;
au.LastName = ui.LastName;
au.Username = ui.Username;
Email.SendEmail(fi.ModRejectTemplateId, PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, tmpReplyId, string.Empty, au);
}
}
break;
}
case "modappr":
{
int tmpForumId = -1;
int tmpTopicId = -1;
int tmpReplyId = -1;
tmpForumId = Convert.ToInt32(e.Parameters[1]);
tmpTopicId = Convert.ToInt32(e.Parameters[2]);
tmpReplyId = Convert.ToInt32(e.Parameters[3]);
string sSubject = string.Empty;
string sBody = string.Empty;
if (tmpForumId > 0 & tmpTopicId > 0 && tmpReplyId == 0)
{
TopicsController tc = new TopicsController();
TopicInfo ti = tc.Topics_Get(PortalId, ForumModuleId, tmpTopicId, tmpForumId, -1, false);
if (ti != null)
{
sSubject = ti.Content.Subject;
sBody = ti.Content.Body;
ti.IsApproved = true;
tc.TopicSave(PortalId, ti);
tc.Topics_SaveToForum(tmpForumId, tmpTopicId, PortalId, ModuleId);
//TODO: Add Audit log for who approved topic
if (fi.ModApproveTemplateId > 0 & ti.Author.AuthorId > 0)
{
Email.SendEmail(fi.ModApproveTemplateId, PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, tmpReplyId, string.Empty, ti.Author);
}
Subscriptions.SendSubscriptions(PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, 0, ti.Content.AuthorId);
try
{
ControlUtils ctlUtils = new ControlUtils();
string sUrl = ctlUtils.BuildUrl(ForumTabId, ForumModuleId, fi.ForumGroup.PrefixURL, fi.PrefixURL, fi.ForumGroupId, fi.ForumID, TopicId, ti.TopicUrl, -1, -1, string.Empty, 1, -1, fi.SocialGroupId); // Utilities.NavigateUrl(ForumTabId, "", ParamKeys.ViewType & "=" & Views.Topic & "&" & ParamKeys.ForumId & "=" & ForumId, ParamKeys.TopicId & "=" & TopicId)
if (sUrl.Contains("~/") || Request.QueryString["asg"] != null)
{
sUrl = Utilities.NavigateUrl(ForumTabId, "", ParamKeys.TopicId + "=" + TopicId);
}
Social amas = new Social();
if (Request.QueryString["asg"] == null & !(string.IsNullOrEmpty(MainSettings.ActiveSocialTopicsKey)) && fi.ActiveSocialEnabled)
{
amas.AddTopicToJournal(PortalId, ForumModuleId, ForumId, ti.TopicId, ti.Author.AuthorId, sUrl, sSubject, ti.Content.Summary, sBody, fi.ActiveSocialSecurityOption, fi.Security.Read, SocialGroupId);
}
else
{
amas.AddForumItemToJournal(PortalId, ForumModuleId, ti.Author.AuthorId, "forumtopic", sUrl, sSubject, sBody);
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
}
}
}
else if (tmpForumId > 0 & tmpTopicId > 0 & tmpReplyId > 0)
{
ReplyController rc = new ReplyController();
ReplyInfo ri = rc.Reply_Get(PortalId, ForumModuleId, tmpTopicId, tmpReplyId);
if (ri != null)
{
ri.IsApproved = true;
sSubject = ri.Content.Subject;
sBody = ri.Content.Body;
rc.Reply_Save(PortalId, ri);
TopicsController tc = new TopicsController();
tc.Topics_SaveToForum(tmpForumId, tmpTopicId, PortalId, ModuleId, tmpReplyId);
TopicInfo ti = tc.Topics_Get(PortalId, ForumModuleId, tmpTopicId, tmpForumId, -1, false);
//TODO: Add Audit log for who approved topic
if (fi.ModApproveTemplateId > 0 & ri.Author.AuthorId > 0)
{
Email.SendEmail(fi.ModApproveTemplateId, PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, tmpReplyId, string.Empty, ri.Author);
}
Subscriptions.SendSubscriptions(PortalId, ForumModuleId, ForumTabId, tmpForumId, tmpTopicId, tmpReplyId, ri.Content.AuthorId);
try
{
ControlUtils ctlUtils = new ControlUtils();
string fullURL = ctlUtils.BuildUrl(ForumTabId, ForumModuleId, fi.ForumGroup.PrefixURL, fi.PrefixURL, fi.ForumGroupId, fi.ForumID, TopicId, ti.TopicUrl, -1, -1, string.Empty, 1, -1, fi.SocialGroupId);
if (fullURL.Contains("~/") || Request.QueryString["asg"] != null)
{
fullURL = Utilities.NavigateUrl(ForumTabId, "", new string[] { ParamKeys.TopicId + "=" + TopicId, ParamKeys.ContentJumpId + "=" + tmpReplyId });
}
Social amas = new Social();
if (Request.QueryString["asg"] == null & !(string.IsNullOrEmpty(MainSettings.ActiveSocialTopicsKey)) && fi.ActiveSocialEnabled && !fi.ActiveSocialTopicsOnly)
{
amas.AddReplyToJournal(PortalId, ForumModuleId, ForumId, ri.TopicId, ri.ReplyId, ri.Author.AuthorId, fullURL, ri.Content.Subject, string.Empty, sBody, fi.ActiveSocialSecurityOption, fi.Security.Read, fi.SocialGroupId);
}
else
{
amas.AddForumItemToJournal(PortalId, ForumModuleId, ri.Author.AuthorId, "forumreply", fullURL, sSubject, sBody);
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
}
}
}
break;
}
}
string cachekey = string.Format("AF-FV-{0}-{1}", PortalId, ModuleId);
DataCache.CacheClearPrefix(cachekey);
}
BuildModList();
litTopics.RenderControl(e.Output);
}
public TopicInfo Topics_Get(int PortalId, int ModuleId, int TopicId, int ForumId, int UserId, bool WithSecurity)
{
IDataReader dr = DataProvider.Instance().Topics_Get(PortalId, ModuleId, TopicId, ForumId, UserId, WithSecurity);
TopicInfo ti = null;
while (dr.Read())
{
ti = new TopicInfo();
if (!(dr["AnnounceEnd"] == DBNull.Value))
{
ti.AnnounceEnd = Convert.ToDateTime(dr["AnnounceEnd"]);
}
if (!(dr["AnnounceStart"] == DBNull.Value))
{
ti.AnnounceStart = Convert.ToDateTime(dr["AnnounceStart"]);
}
ti.Content.AuthorId = Convert.ToInt32(dr["AuthorId"]);
ti.Content.AuthorName = dr["AuthorName"].ToString();
ti.Content.Body = dr["Body"].ToString();
ti.Content.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.Content.DateCreated = Convert.ToDateTime(dr["DateCreated"]);
ti.Content.DateUpdated = Convert.ToDateTime(dr["DateUpdated"]);
ti.Content.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.Content.Subject = dr["Subject"].ToString();
ti.Content.Summary = dr["Summary"].ToString();
ti.ContentId = Convert.ToInt32(dr["ContentId"]);
ti.Author.AuthorId = ti.Content.AuthorId;
ti.Author.DisplayName = dr["DisplayName"].ToString();
ti.Author.Email = dr["Email"].ToString();
ti.Author.FirstName = dr["FirstName"].ToString();
ti.Author.LastName = dr["LastName"].ToString();
ti.Author.Username = dr["Username"].ToString();
ti.IsAnnounce = Convert.ToBoolean(dr["IsAnnounce"]);
ti.IsApproved = Convert.ToBoolean(dr["IsApproved"]);
ti.IsArchived = Convert.ToBoolean(dr["IsArchived"]);
ti.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
ti.IsLocked = Convert.ToBoolean(dr["IsLocked"]);
ti.IsPinned = Convert.ToBoolean(dr["IsPinned"]);
ti.ReplyCount = Convert.ToInt32(dr["ReplyCount"]);
ti.StatusId = Convert.ToInt32(dr["StatusId"]);
ti.TopicIcon = Convert.ToString(dr["TopicIcon"]);
ti.TopicId = Convert.ToInt32(dr["TopicId"]);
ti.TopicType = (TopicTypes)(dr["TopicType"]);
ti.ViewCount = Convert.ToInt32(dr["ViewCount"]);
ti.Tags = dr["Tags"].ToString();
ti.Priority = Convert.ToInt32(dr["Priority"].ToString());
ti.Categories = dr["Categories"].ToString();
ti.ForumURL = dr["ForumURL"].ToString();
ti.TopicUrl = dr["TopicURL"].ToString();
//.URL = dr("URL").ToString
try
{
ti.TopicData = dr["TopicData"].ToString();
}
catch (Exception ex)
{
ti.TopicData = string.Empty;
}
}
//If WithSecurity Then
// dr.NextResult()
// 'Dim tmpDr As IDataReader = dr
// ti.Security = CType(DotNetNuke.Common.Utilities.CBO.FillObject(dr, GetType(PermissionInfo)), PermissionInfo)
//End If
if (!dr.IsClosed)
{
dr.Close();
}
return(ti);
}
public int TopicSave(int PortalId, TopicInfo ti)
{
return(Convert.ToInt32(DataProvider.Instance().Topics_Save(PortalId, ti.TopicId, ti.ViewCount, ti.ReplyCount, ti.IsLocked, ti.IsPinned, ti.TopicIcon, ti.StatusId, ti.IsApproved, ti.IsDeleted, ti.IsAnnounce, ti.IsArchived, ti.AnnounceStart, ti.AnnounceEnd, ti.Content.Subject.Trim(), ti.Content.Body.Trim(), ti.Content.Summary.Trim(), ti.Content.DateCreated, ti.Content.DateUpdated, ti.Content.AuthorId, ti.Content.AuthorName, ti.Content.IPAddress, (int)ti.TopicType, ti.Priority, ti.TopicUrl, ti.TopicData)));
}
private void btnSend_Click(object sender, System.EventArgs e)
{
if (Request.IsAuthenticated)
{
Email objEmail = new Email();
string Comments = null;
Comments = drpReasons.SelectedItem.Value + "<br>";
Comments += Utilities.CleanString(PortalId, txtComments.Text, false, EditorTypes.TEXTBOX, false, false, ModuleId, string.Empty, false);
int templateId = 0;
TemplateController tc = new TemplateController();
TemplateInfo ti = tc.Template_Get("ModAlert", PortalId, ModuleId);
string sUrl;
if (SocialGroupId > 0)
{
sUrl = NavigateUrl(Convert.ToInt32(Request.QueryString["TabId"]), "", new string[] { ParamKeys.ForumId + "=" + ForumId, ParamKeys.TopicId + "=" + TopicId, ParamKeys.ViewType + "=confirmaction", ParamKeys.ConfirmActionId + "=" + ConfirmActions.AlertSent + "&" + ParamKeys.GroupIdName + "=" + SocialGroupId });
}
else
{
sUrl = NavigateUrl(Convert.ToInt32(Request.QueryString["TabId"]), "", new string[] { ParamKeys.ForumId + "=" + ForumId, ParamKeys.TopicId + "=" + TopicId, ParamKeys.ViewType + "=confirmaction", ParamKeys.ConfirmActionId + "=" + ConfirmActions.AlertSent });
}
NotificationType notificationType = NotificationsController.Instance.GetNotificationType("AF-ContentAlert");
TopicsController topicController = new TopicsController();
TopicInfo topic = topicController.Topics_Get(PortalId, ModuleId, TopicId, ForumId, -1, false);
string sBody = string.Empty;
string authorName = string.Empty;
string sSubject = string.Empty;
string sTopicURL = string.Empty;
sTopicURL = topic.TopicUrl;
if (ReplyId > 0 & TopicId != ReplyId)
{
ReplyController rc = new ReplyController();
ReplyInfo reply = rc.Reply_Get(PortalId, ModuleId, TopicId, ReplyId);
sBody = reply.Content.Body;
sSubject = reply.Content.Subject;
authorName = reply.Author.DisplayName;
}
else
{
sBody = topic.Content.Body;
sSubject = topic.Content.Subject;
authorName = topic.Author.DisplayName;
}
ControlUtils ctlUtils = new ControlUtils();
string fullURL = ctlUtils.BuildUrl(ForumTabId, ForumModuleId, ForumInfo.ForumGroup.PrefixURL, ForumInfo.PrefixURL, ForumInfo.ForumGroupId, ForumInfo.ForumID, TopicId, sTopicURL, -1, -1, string.Empty, 1, ReplyId, SocialGroupId);
string subject = Utilities.GetSharedResource("AlertSubject");
subject = subject.Replace("[DisplayName]", authorName);
subject = subject.Replace("[Subject]", sSubject);
subject = subject.Replace("[FlaggedBy]", UserInfo.DisplayName);
string body = Utilities.GetSharedResource("AlertBody");
body = body.Replace("[Post]", sBody);
body = body.Replace("[Comment]", Comments);
body = body.Replace("[URL]", fullURL);
body = body.Replace("[Reason]", drpReasons.SelectedItem.Value);
List <Entities.Users.UserInfo> mods = Utilities.GetListOfModerators(PortalId, ForumId);
string notificationKey = string.Format("{0}:{1}:{2}:{3}:{4}", TabId, ForumModuleId, ForumId, TopicId, ReplyId);
Notification notification = new Notification();
notification.NotificationTypeID = notificationType.NotificationTypeId;
notification.Subject = subject;
notification.Body = body;
notification.IncludeDismissAction = false;
notification.SenderUserID = UserInfo.UserID;
notification.Context = notificationKey;
NotificationsController.Instance.SendNotification(notification, PortalId, null, mods);
Response.Redirect(sUrl);
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
btnCancel.Click += new System.EventHandler(btnCancel_Click);
btnSend.Click += new System.EventHandler(btnSend_Click);
string warnImg = "<img src=\"" + ImagePath + "/images/warning.png\" />";
reqEmail.Text = warnImg;
reqMessage.Text = warnImg;
reqName.Text = warnImg;
reqSubject.Text = warnImg;
regEmail.Text = warnImg;
regEmail.ValidationExpression = "\\b[a-zA-Z0-9._%\\-+']+@[a-zA-Z0-9.\\-]+\\.[a-zA-Z]{2,4}\\b";
string TopicSubject = string.Empty;
if (TopicId > 0)
{
TopicsController tc = new TopicsController();
TopicInfo ti = tc.Topics_Get(PortalId, ModuleId, TopicId, ForumId, UserId, true);
if (ti != null)
{
if (Permissions.HasPerm(ForumInfo.Security.Read, ForumUser.UserRoles))
{
if (!Page.IsPostBack)
{
string SubjectDefault = GetSharedResource("[RESX:EmailSubjectDefault]");
TopicSubject = ti.Content.Subject;
SubjectDefault = SubjectDefault.Replace("[SUBJECT]", ti.Content.Subject);
txtRecipSubject.Text = SubjectDefault;
string MessageDefault = GetSharedResource("[RESX:EmailMessageDefault]");
string sURL = NavigateUrl(TabId, "", new string[] { ParamKeys.ForumId + "=" + ForumId, ParamKeys.ViewType + "=" + Views.Topic, ParamKeys.TopicId + "=" + TopicId });
if (MainSettings.UseShortUrls)
{
sURL = NavigateUrl(TabId, "", new string[] { ParamKeys.TopicId + "=" + TopicId });
}
MessageDefault = MessageDefault.Replace("[TOPICLINK]", sURL);
MessageDefault = MessageDefault.Replace("[DISPLAYNAME]", UserProfiles.GetDisplayName(ModuleId, UserId, UserInfo.Username, UserInfo.FirstName, UserInfo.LastName, UserInfo.DisplayName));
txtMessage.Text = MessageDefault;
}
}
if (MainSettings.UseSkinBreadCrumb)
{
string sCrumb = "<a href=\"" + NavigateUrl(TabId, "", ParamKeys.GroupId + "=" + ForumGroupId) + "\">" + ForumInfo.GroupName + "</a>|";
if (MainSettings.UseShortUrls)
{
sCrumb += "<a href=\"" + NavigateUrl(TabId, "", ParamKeys.ForumId + "=" + ForumId) + "\">" + ForumInfo.ForumName + "</a>";
sCrumb += "|<a href=\"" + NavigateUrl(TabId, "", ParamKeys.TopicId + "=" + TopicId) + "\">" + TopicSubject + "</a>";
}
else
{
sCrumb += "<a href=\"" + NavigateUrl(TabId, "", new string[] { ParamKeys.ForumId + "=" + ForumId, ParamKeys.ViewType + "=" + Views.Topics }) + "\">" + ForumInfo.ForumName + "</a>";
sCrumb += "|<a href=\"" + NavigateUrl(TabId, "", new string[] { ParamKeys.ForumId + "=" + ForumId, ParamKeys.ViewType + "=" + Views.Topic, ParamKeys.TopicId + "=" + TopicId }) + "\">" + TopicSubject + "</a>";
}
if (Environment.UpdateBreadCrumb(Page.Controls, sCrumb))
{
bcUpdated = true;
}
}
}
else
{
Response.Redirect(NavigateUrl(TabId));
}
}
}
