static public SiteEvent CreateNewUserEventActivity(IDnaDataReader dataReader, IDnaDataReaderCreator creator)
{
SiteEvent siteEvent = null;
try
{
siteEvent = new SiteEvent();
siteEvent.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEvent.Date = new Date(dataReader.GetDateTime("DateCreated"));
siteEvent.Type = SiteActivityType.NewUserToSite;
siteEvent.ActivityData = XElement.Parse(
string.Format(DataFormat,
dataReader.GetInt32NullAsZero("user_userid"), dataReader.GetStringNullAsEmpty("user_username"),
dataReader.GetInt32NullAsZero("siteid"))
);
siteEvent.UserId = dataReader.GetInt32NullAsZero("user_userid");
siteEvent.SaveEvent(creator);
}
catch(Exception e)
{
siteEvent = null;
SiteEventsProcessor.SiteEventLogger.LogException(e);
}
return siteEvent;
}
static public SiteEvent CreateComplaintArticleEventActivity(IDnaDataReader dataReader, IDnaDataReaderCreator creator)
{
SiteEvent siteEvent = null;
try
{
siteEvent = new SiteEvent();
siteEvent.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEvent.Date = new Date(dataReader.GetDateTime("DateCreated"));
siteEvent.Type = SiteActivityType.ComplaintArticle;
var complainantUserName = dataReader.GetStringNullAsEmpty("complainantUserName");
if (String.IsNullOrEmpty(complainantUserName))
{
complainantUserName = "******";
}
siteEvent.ActivityData = XElement.Parse(
string.Format(DataFormat,
dataReader.GetInt32NullAsZero("complaintantID_userid"), complainantUserName,
dataReader.GetInt32NullAsZero("h2g2id"), dataReader.GetStringNullAsEmpty("subject"),
dataReader.GetStringNullAsEmpty("complainttext"))
);
siteEvent.UserId = 0;
siteEvent.SaveEvent(creator);
}
catch(Exception e)
{
siteEvent = null;
SiteEventsProcessor.SiteEventLogger.LogException(e);
}
return siteEvent;
}
public static Link CreateLinkFromReader(IDnaDataReader reader)
{
Link link = new Link();
link.Type = reader.GetStringNullAsEmpty("destinationtype");
link.LinkId = reader.GetInt32NullAsZero("linkid");
link.TeamId = reader.GetInt32NullAsZero("teamid");
link.Relationship = reader.GetStringNullAsEmpty("relationship");
link.Private = reader.GetTinyIntAsInt("private");
link.Description = reader.GetStringNullAsEmpty("linkdescription");
link.DateLinked = new DateElement(reader.GetDateTime("DateLinked"));
link.Submitter = new UserElement() { user = BBC.Dna.Objects.User.CreateUserFromReader(reader, "submitter") };
//Create appropriate URL from link type.
int destinationId = reader.GetInt32NullAsZero("DestinationID");
switch (link.Type)
{
case "article":
{
link.DnaUid = "A" + destinationId.ToString();
break;
}
case "userpage":
{
link.DnaUid = "U" + destinationId.ToString();
break;
}
case "category":
{
link.DnaUid = "C" + destinationId.ToString();
break;
}
case "forum":
{
link.DnaUid = "F" + destinationId.ToString();
break;
}
case "thread":
{
link.DnaUid = "T" + destinationId.ToString();
break;
}
case "posting":
{
link.DnaUid = "TP" + destinationId.ToString();
break;
}
default: // "club" )
{
link.DnaUid = "G" + destinationId.ToString();
break;
}
}
return link;
}
/// <summary>
/// Gets the topic elements from the current reader.
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
static public TopicElement GetTopicFromReader(IDnaDataReader reader)
{
var topicEdit = new TopicElement();
topicEdit.TopicId = reader.GetInt32NullAsZero("topicid");
topicEdit.H2G2Id = reader.GetInt32NullAsZero("h2g2ID");
topicEdit.SiteId = reader.GetInt32NullAsZero("SiteID");
topicEdit.TopicStatus = (TopicStatus)reader.GetInt32NullAsZero("TopicStatus");
topicEdit.Title = reader.GetStringNullAsEmpty("TITLE");
topicEdit.ForumId = reader.GetInt32NullAsZero("ForumID");
topicEdit.Description = reader.GetStringNullAsEmpty("description");
topicEdit.Position = reader.GetInt32NullAsZero("position");
topicEdit.TopicLinkId = reader.GetInt32NullAsZero("topiclinkid");
topicEdit.Createdby = new TopicCreatedDate
{
CreatedDate = new DateElement(reader.GetDateTime("createddate")),
Username = reader.GetStringNullAsEmpty("CreatedByUserName"),
Userid = reader.GetInt32NullAsZero("CreatedByUserID")
};
topicEdit.Updatedby = new TopicLastUpdated()
{
LastUpdated = new DateElement(reader.GetDateTime("LastUpdated")),
Username = reader.GetStringNullAsEmpty("UpdatedByUserName"),
Userid = reader.GetInt32NullAsZero("UpdatedByUserID")
};
topicEdit.Style = reader.GetInt32NullAsZero("style");
topicEdit.ForumPostCount = reader.GetInt32NullAsZero("forumpostcount");
topicEdit.FrontPageElement.Elementid = reader.GetInt32NullAsZero("FP_ElementID");
topicEdit.FrontPageElement.Position = reader.GetInt32NullAsZero("FP_Position");
topicEdit.FrontPageElement.Title = reader.GetStringNullAsEmpty("FP_Title");
topicEdit.FrontPageElement.TemplateElement = reader.GetInt32NullAsZero("FP_Template");
topicEdit.FrontPageElement.Text = reader.GetStringNullAsEmpty("FP_Text");
topicEdit.FrontPageElement.ImageName = reader.GetStringNullAsEmpty("FP_ImageName");
topicEdit.FrontPageElement.ImageAltText = reader.GetStringNullAsEmpty("FP_ImageAltText");
topicEdit.FrontPageElement.ForumPostCount = reader.GetInt32NullAsZero("forumpostcount");
topicEdit.FrontPageElement.TopicId = reader.GetInt32NullAsZero("topicid");
topicEdit.Fastmod = reader.GetInt32NullAsZero("fastmod");
topicEdit.Editkey = reader.GetGuid("editkey");
topicEdit.FrontPageElement.Editkey = reader.GetGuid("FP_EditKey");
return topicEdit;
}
public static ExModerationEvent CreateExModerationEvent(IDnaDataReader dataReader)
{
ExModerationEvent activity = PolicyInjection.Create<ExModerationEvent>();
activity.ModId = dataReader.GetInt32NullAsZero("modid");
activity.Notes = dataReader.GetString("notes") ?? "";
activity.Uri = dataReader.GetString("uri") ?? "";
activity.DateCompleted = dataReader.GetDateTime("datecompleted");
activity.Decision = dataReader.GetInt32NullAsZero("status");
activity.CallBackUri = dataReader.GetString("callbackuri") ?? "";
return activity;
}
static public SiteEvent CreateArticleModerationDecisionActivity(IDnaDataReader dataReader, IDnaDataReaderCreator creator)
{
SiteEvent siteEventArticleModerationDecision = null;
try
{
siteEventArticleModerationDecision = new SiteEvent();
siteEventArticleModerationDecision.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEventArticleModerationDecision.Date = new Date(dataReader.GetDateTime("DateCreated"));
var statusId = dataReader.GetInt32NullAsZero("statusid");
switch ((ModerationDecisionStatus)statusId)
{
case ModerationDecisionStatus.Fail:
siteEventArticleModerationDecision.Type = SiteActivityType.ModerateArticleFailed;
siteEventArticleModerationDecision.ActivityData = XElement.Parse(
string.Format(DataFormatFailed, dataReader.GetInt32NullAsZero("h2g2id"),
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("ModReason")
));
break;
case ModerationDecisionStatus.Referred:
siteEventArticleModerationDecision.Type = SiteActivityType.ModerateArticleReferred;
siteEventArticleModerationDecision.ActivityData = XElement.Parse(
string.Format(DataFormatReferred, dataReader.GetInt32NullAsZero("h2g2id"),
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("Notes"))
);
break;
default:
siteEventArticleModerationDecision = null;
break;
}
siteEventArticleModerationDecision.UserId = 0;
siteEventArticleModerationDecision.SaveEvent(creator);
}
catch(Exception e)
{
siteEventArticleModerationDecision = null;
SiteEventsProcessor.SiteEventLogger.LogException(e);
}
return siteEventArticleModerationDecision;
}
protected override void SetProperties(IDnaDataReader reader)
{
base.SetProperties(reader);
ThreadEntryId = reader.GetNullableInt32("ThreadEntryId");
ModClassId = reader.GetInt32("ModClassId");
SiteId = reader.GetInt32("SiteId");
ForumId = reader.GetInt32("ForumId");
ThreadId = reader.GetNullableInt32("ThreadId");
UserId = reader.GetInt32("UserId");
DatePosted = reader.GetDateTime("DatePosted");
Text = reader.GetString("text");
RiskModThreadEntryQueueId = reader.GetInt32("RiskModThreadEntryQueueId");
}
protected override void SetProperties(IDnaDataReader reader)
{
base.SetProperties(reader);
ThreadEntryId = reader.GetInt32("ThreadEntryId");
ModClassId = reader.GetInt32("ModClassId");
SiteId = reader.GetInt32("SiteId");
ForumId = reader.GetInt32("ForumId");
ThreadId = reader.GetInt32("ThreadId");
UserId = reader.GetInt32("UserId");
NextSibling = reader.GetNullableInt32("NextSibling");
Parent = reader.GetNullableInt32("Parent");
PrevSibling = reader.GetNullableInt32("PrevSibling");
FirstChild = reader.GetNullableInt32("FirstChild");
DatePosted = reader.GetDateTime("DatePosted");
Text = reader.GetString("text");
}
public OpenSocialActivityDataReaderAdapter(IDnaDataReader dataReader)
{
Body = dataReader.GetString("Body");
PostedTime = dataReader.GetDateTime("ActivityTime").MillisecondsSinceEpoch();
DisplayName = dataReader.GetString("displayName");
ObjectTitle = dataReader.GetString("ObjectTitle");
ObjectDescription =dataReader.GetString("Body");
UserName = dataReader.GetString("Username");
ApplicationActivityObjectId = dataReader.GetInt32("PostID");
var appName = dataReader.GetString("DnaUrl") ?? "";
ObjectUri = (dataReader.GetString("ObjectUriFormat") ?? "").FormatReplacementStrings(dataReader.GetInt32("ForumID"),
dataReader.GetInt32("ThreadID"), dataReader.GetInt32("PostID"), appName, dataReader.GetString("BlogUrl") ?? "",
dataReader.GetString("ObjectUri") ?? "");
ContentPermaUrl = (dataReader.GetString("ContentPermaUrl") ?? "").FormatReplacementStrings(dataReader.GetInt32("ForumID"),
dataReader.GetInt32("ThreadID"), dataReader.GetInt32("PostID"), appName, dataReader.GetString("BlogUrl") ?? "",
dataReader.GetString("ObjectUri") ?? "");
CustomActivityType = dataReader.GetString("CustomActivityType") ?? "";
}
/// <summary>
/// Creates user object from given reader and user id
/// </summary>
/// <param name="reader"></param>
/// <param name="userID"></param>
/// <returns></returns>
static public User CreateUserFromReader(IDnaDataReader reader, string prefix)
{
//IUser user = new User(_dnaDataReaderCreator, _dnaDiagnostics, _cacheManager);
IUser user = new User();
if (reader.Exists(prefix + "userID"))
{
user.UserId = reader.GetInt32NullAsZero(prefix + "userID");
}
else if (reader.Exists(prefix + "ID"))
{
user.UserId = reader.GetInt32NullAsZero(prefix + "ID");
}
if (reader.Exists(prefix + "IdentityUserID"))
{
user.IdentityUserId = reader.GetStringNullAsEmpty(prefix + "IdentityUserId");
}
if (reader.Exists(prefix + "IdentityUserName"))
{
user.IdentityUserName = reader.GetStringNullAsEmpty(prefix + "IdentityUserName");
}
else if (reader.Exists(prefix + "LoginName"))
{
user.IdentityUserName = reader.GetStringNullAsEmpty(prefix + "LoginName");
}
/*
if (reader.Exists(prefix + "FirstNames"))
{
user.FirstNames = reader.GetStringNullAsEmpty(prefix + "FirstNames") ?? "";
}
if(reader.Exists(prefix + "LastName"))
{
user.LastName = reader.GetStringNullAsEmpty(prefix + "LastName") ?? "";
}
*/
if(reader.Exists(prefix + "Status"))
{
user.Status= reader.GetInt32NullAsZero(prefix + "Status");
}
if(reader.Exists(prefix + "TaxonomyNode"))
{
user.TaxonomyNode= reader.GetInt32NullAsZero(prefix + "TaxonomyNode");
}
if (reader.Exists(prefix + "UserName"))
{
user.UserName = reader.GetStringNullAsEmpty(prefix + "UserName") ?? "";
}
else if (reader.Exists(prefix + "Name"))
{
user.UserName = reader.GetStringNullAsEmpty(prefix + "Name") ?? "";
}
if (user.UserName == String.Empty)
{
user.UserName = "******" + user.UserId.ToString();
}
/* NO NO not emails
* if (reader.Exists(prefix + "Email"))
{
user.Email = reader.GetStringNullAsEmpty(prefix + "Email") ?? "";
}
*/
if (reader.Exists(prefix + "SiteSuffix"))
{
user.SiteSuffix = reader.GetStringNullAsEmpty(prefix + "SiteSuffix") ?? "";
}
if (reader.Exists(prefix + "Area"))
{
user.Area = reader.GetStringNullAsEmpty(prefix + "Area") ?? "";
}
if (reader.Exists(prefix + "Title"))
{
user.Title = reader.GetStringNullAsEmpty(prefix + "Title") ?? "";
}
if (reader.Exists(prefix + "SubQuota"))
{
user.SubQuota = reader.GetInt32NullAsZero(prefix + "SubQuota");
}
if (reader.Exists(prefix + "Allocations"))
{
user.Allocations = reader.GetInt32NullAsZero(prefix + "Allocations");
}
if (reader.Exists(prefix + "Journal"))
{
user.Journal = reader.GetInt32NullAsZero(prefix + "Journal");
}
if (reader.Exists(prefix + "Active") && !reader.IsDBNull(prefix + "Active"))
{
user.Active = reader.GetBoolean(prefix + "Active");
}
if (reader.Exists(prefix + "DateLastNotified") && reader.GetValue(prefix + "DateLastNotified") != DBNull.Value)
{
user.DateLastNotified = new DateElement(reader.GetDateTime(prefix + "DateLastNotified"));
}
if (reader.Exists(prefix + "DateJoined") && reader.GetValue(prefix + "DateJoined") != DBNull.Value)
{
user.DateJoined = new DateElement(reader.GetDateTime(prefix + "DateJoined"));
}
if (reader.Exists(prefix + "ForumPostedTo"))
{
user.ForumPostedTo = reader.GetInt32NullAsZero(prefix + "ForumPostedTo");
}
if (reader.Exists(prefix + "Masthead"))
{
user.MastHead = reader.GetInt32NullAsZero(prefix + "Masthead");
}
if (reader.Exists(prefix + "SinBin"))
{
user.SinBin = reader.GetInt32NullAsZero(prefix + "SinBin");
}
if (reader.Exists(prefix + "ForumID"))
{
user.ForumId = reader.GetInt32NullAsZero(prefix + "ForumID");
}
var siteId = 0;
if (reader.Exists("SiteID"))
{
siteId = reader.GetInt32NullAsZero("SiteID");
}
if (siteId != 0 && user.UserId != 0)
{
var userGroups = (UserGroups)SignalHelper.GetObject(typeof(UserGroups));
var groupList = userGroups.GetUsersGroupsForSite(user.UserId, siteId);
foreach (var group in groupList)
{
user.Groups.Add(new Group(){Name = group.Name.ToUpper()});
}
}
else
{
}
return (User)user;
}
protected virtual void SetProperties(IDnaDataReader reader)
{
EventId = reader.GetInt32("EventId");
EventType = (EventTypes)reader.GetInt32("EventType");
EventDate = reader.GetDateTime("EventDate");
}
public static Post CreatePostFromReader(IDnaDataReader reader)
{
Post post = new Post();
post.YourLastPost = reader.GetInt32NullAsZero("YourLastPost");
post.YourLastPostIndex = reader.GetInt32NullAsZero("YourLastPostIndex");
post.CountPosts = reader.GetInt32NullAsZero("CountPosts");
post.Thread = PostThreadInfo.CreatePostThreadInfoFromReader(reader);
if (reader["LastReply"] != DBNull.Value)
{
post.LastReply = new DateElement(reader.GetDateTime("LastReply"));
}
if (post.YourLastPost > 0)
{
if (reader["MostRecent"] != DBNull.Value)
{
post.MostRecent = new DateElement(reader.GetDateTime("MostRecent"));
}
}
post.SiteId = reader.GetInt32NullAsZero("SiteId");
post.Private = reader.GetInt32NullAsZero("Private");
post.HasReply = reader.GetInt32NullAsZero("Replies");
post.FirstPoster = new UserElement() { user = BBC.Dna.Objects.User.CreateUserFromReader(reader, "FirstPoster") };
return post;
}
/// <summary>
/// Generates/fills the full forum thread posts xml document
/// </summary>
/// <param name="uid">The unique identifier for the Comment CommentBoxForum</param>
/// <param name="fromPostIndex">Start Post Index</param>
/// <param name="toPostIndex">Finish Post Index</param>
/// <param name="show">If no to and from parameters we need the number of comments to show</param>
/// <param name="dataReader">Dna Data Reader object</param>
/// <param name="title">Passed in title of the comment</param>
/// <param name="url">the passed in host page url</param>
private void GenerateForumThreadPostsXML(string uid, int fromPostIndex, int toPostIndex, int show, IDnaDataReader dataReader, string title, string url)
{
int forumPostCount;
int returnedPostCount;
ExtractPostCount(dataReader, out forumPostCount);
// Put the forum closing date into the xml
XmlNode commentBox = RootElement.SelectSingleNode("COMMENTBOX");
if (commentBox == null)
{
// Create this node
commentBox = AddElementTag(RootElement, "COMMENTBOX");
}
// Add the closing date time to the xml, if we have one
bool forumClosed = false;
bool isForumCloseDateNull = dataReader.IsDBNull("ForumCloseDate");
string existingtitle = dataReader.GetStringNullAsEmpty("commentforumtitle");
string existingurl = dataReader.GetStringNullAsEmpty("URL");
existingurl = StringUtils.EscapeAllXml(existingurl);
url = StringUtils.EscapeAllXml(url);
int forumID = dataReader.GetInt32NullAsZero("forumID");
if (!isForumCloseDateNull)
{
DateTime closeDate = dataReader.GetDateTime("ForumCloseDate");
//TODO: Write DnaComponent.AddDateElement method to encapsulate this
XmlNode endDate = AddElementTag(commentBox, "ENDDATE");
endDate.AppendChild(DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, closeDate));
forumClosed = closeDate < DateTime.Now;
}
returnedPostCount = CreateForumThreadPosts(uid, fromPostIndex, toPostIndex, dataReader, show, forumPostCount, commentBox);
AddMoreAttribute(dataReader, forumPostCount, toPostIndex, returnedPostCount);
// Modify the CanWrite flag depending on the user or if either the site or forum are closed
UpdateCanWriteStatus(forumClosed);
//Update the comment forum title if the passed in value is changed
if (title != String.Empty && title != existingtitle)
{
UpdateCommentForumTitle(forumID, title);
XmlNodeList commentForumTitleNodes = RootElement.SelectNodes("COMMENTBOX/FORUMTHREADPOSTS/POST/COMMENTFORUMTITLE");
foreach (XmlNode commentForumTitle in commentForumTitleNodes)
{
commentForumTitle.InnerText = title;
}
}
if (url != string.Empty && url != existingurl)
{
UpdateCommentForumURL(forumID, url);
XmlNode commentForumUrlNode = RootElement.SelectSingleNode("COMMENTBOX/FORUMTHREADPOSTS");
if (commentForumUrlNode.Attributes["HOSTPAGEURL"] != null)
{
commentForumUrlNode.Attributes["HOSTPAGEURL"].InnerText = url;
}
}
}
/// <summary>
/// Generates the individual Comment CommentBoxForum Xml within the Comment CommentBoxForum List xml page
/// </summary>
/// <param name="dataReader">SP containing the comment forums</param>
/// <param name="commentForumList">Parent node to attach to</param>
private void AddCommentForumListXML(IDnaDataReader dataReader, XmlNode commentForumList)
{
// start creating the comment forum structure
XmlNode commentForum = CreateElementNode("COMMENTFORUM");
AddAttribute(commentForum, "UID", dataReader.GetStringNullAsEmpty("uid"));
AddAttribute(commentForum, "FORUMID", dataReader.GetInt32NullAsZero("forumID").ToString());
AddAttribute(commentForum, "FORUMPOSTCOUNT", dataReader.GetInt32NullAsZero("forumpostcount").ToString());
AddAttribute(commentForum, "FORUMPOSTLIMIT", InputContext.GetSiteOptionValueInt("Forum", "PostLimit"));
AddAttribute(commentForum, "CANWRITE", dataReader.GetByteNullAsZero("CanWrite").ToString());
AddAttribute(commentForum, "NOTSIGNEDINUSERID", dataReader.GetInt32NullAsZero("NotSignedInUserID").ToString());
AddTextTag(commentForum, "HOSTPAGEURL", dataReader.GetStringNullAsEmpty("url"));
AddTextTag(commentForum, "TITLE", dataReader.GetStringNullAsEmpty("title"));
AddTextTag(commentForum, "MODSTATUS", dataReader.GetByteNullAsZero("ModerationStatus"));
AddTextTag(commentForum, "SITEID", dataReader.GetInt32NullAsZero("siteid"));
AddTextTag(commentForum, "FASTMOD", dataReader.GetInt32NullAsZero("fastmod"));
if (dataReader.DoesFieldExist("DateCreated") && !dataReader.IsDBNull("DateCreated"))
{
DateTime dateCreated = dataReader.GetDateTime("DateCreated");
AddElement(commentForum, "DATECREATED", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, dateCreated));
}
if (dataReader.DoesFieldExist("ForumCloseDate") && !dataReader.IsDBNull("ForumCloseDate"))
{
DateTime closeDate = dataReader.GetDateTime("ForumCloseDate");
AddElement(commentForum, "CLOSEDATE", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, closeDate));
}
if (dataReader.DoesFieldExist("LastUpdated") && !dataReader.IsDBNull("LastUpdated"))
{
DateTime dateLastUpdated = dataReader.GetDateTime("LastUpdated");
AddElement(commentForum, "LASTUPDATED", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, dateLastUpdated));
}
int forumId = dataReader.GetInt32NullAsZero("forumID");
//get terms admin object
TermsFilterAdmin termsAdmin = TermsFilterAdmin.CreateForumTermAdmin(InputContext.CreateDnaDataReaderCreator(), _cache, forumId);
XmlDocument termNodeDoc = SerialiseToXmlDoc(termsAdmin);
string termNodeText = termNodeDoc.DocumentElement.InnerXml.ToString();
AddXmlTextTag(commentForum, "TERMS", termNodeText);
commentForumList.AppendChild(commentForum);
}
static public List<SiteEvent> CreatePostModerationDecisionActivity(IDnaDataReader dataReader, IDnaDataReaderCreator creator)
{
List<SiteEvent> siteEventList = new List<SiteEvent>();
try
{
SiteEvent siteEvent1 = null;
siteEvent1 = new SiteEvent();
siteEvent1.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEvent1.Date = new Date(dataReader.GetDateTime("DateCreated"));
var statusId = dataReader.GetInt32NullAsZero("status");
var type = "post";
if (!string.IsNullOrEmpty(dataReader.GetStringNullAsEmpty("parenturl")))
{
type = "comment";
}
switch ((ModerationDecisionStatus)statusId)
{
case ModerationDecisionStatus.Fail:
siteEvent1.Type = SiteActivityType.ModeratePostFailed;
siteEvent1.ActivityData = XElement.Parse(
string.Format(DataFormatFailed,
dataReader.GetInt32NullAsZero("forumid"), dataReader.GetInt32NullAsZero("postid"),
dataReader.GetInt32NullAsZero("threadid"), dataReader.GetStringNullAsEmpty("parenturl"), type,
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("ModReason"))
);
siteEvent1.UserId = dataReader.GetInt32NullAsZero("author_userid");
siteEventList.Add(siteEvent1);
if (dataReader.GetInt32NullAsZero("complainantid") != 0)
{//complaint upheld event
var siteEvent2 = new SiteEvent();
siteEvent2.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEvent2.Date = new Date(dataReader.GetDateTime("DateCreated"));
siteEvent2.Type = SiteActivityType.ComplaintPostUpHeld;
siteEvent2.ActivityData = XElement.Parse(
string.Format(DataFormatUpHeld,
dataReader.GetInt32NullAsZero("forumid"), dataReader.GetInt32NullAsZero("postid"),
dataReader.GetInt32NullAsZero("threadid"), dataReader.GetStringNullAsEmpty("parenturl"), type,
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("ModReason"))
);
siteEvent2.UserId = dataReader.GetInt32NullAsZero("complainantid");
siteEventList.Add(siteEvent2);
}
break;
case ModerationDecisionStatus.Referred:
siteEvent1.Type = SiteActivityType.ModeratePostReferred;
siteEvent1.ActivityData = XElement.Parse(
string.Format(DataFormatReferred,
dataReader.GetInt32NullAsZero("forumid"), dataReader.GetInt32NullAsZero("postid"),
dataReader.GetInt32NullAsZero("threadid"), dataReader.GetStringNullAsEmpty("parenturl"), type,
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("Notes"))
);
siteEvent1.UserId = dataReader.GetInt32NullAsZero("author_userid");
siteEventList.Add(siteEvent1);
break;
case ModerationDecisionStatus.Passed:
if (dataReader.GetInt32NullAsZero("complainantid") != 0)
{//complaint rejected
if (dataReader.GetStringNullAsEmpty("complainttext").IndexOf(ComplaintStringPrefix) < 0)
{
siteEvent1.Type = SiteActivityType.ComplaintPostRejected;
siteEvent1.ActivityData = XElement.Parse(
string.Format(DataFormatReject,
dataReader.GetInt32NullAsZero("forumid"), dataReader.GetInt32NullAsZero("postid"),
dataReader.GetInt32NullAsZero("threadid"), dataReader.GetStringNullAsEmpty("parenturl"), type,
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("Notes"))
);
siteEvent1.UserId = dataReader.GetInt32NullAsZero("complainantid");
siteEventList.Add(siteEvent1);
}
else
{//is a reinstate so add that event
siteEvent1.Type = SiteActivityType.ModeratePostFailedReversal;
siteEvent1.ActivityData = XElement.Parse(string.Format(DataFormatReversed,
dataReader.GetInt32NullAsZero("forumid"), dataReader.GetInt32NullAsZero("postid"),
dataReader.GetInt32NullAsZero("threadid"), dataReader.GetStringNullAsEmpty("parenturl"), type,
dataReader.GetInt32NullAsZero("author_userid"), dataReader.GetStringNullAsEmpty("author_username"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
dataReader.GetStringNullAsEmpty("Notes"))
);
siteEvent1.UserId = dataReader.GetInt32NullAsZero("author_userid");
siteEventList.Add(siteEvent1);
}
}
break;
default:
siteEventList = null;
break;
}
if (siteEventList != null)
{
foreach (var siteEvent in siteEventList)
{
siteEvent.SaveEvent(creator);
}
}
}
catch(Exception e)
{
siteEventList = null;
SiteEventsProcessor.SiteEventLogger.LogException(e);
}
return siteEventList;
}
private MostCommentedCommentForum MostCommentedCommentForumCreateFromReader(IDnaDataReader reader)
{
var mostCommentedCommentForum = new MostCommentedCommentForum();
mostCommentedCommentForum.UID = reader.GetStringNullAsEmpty("Uid");
var site = SiteList.GetSite(reader.GetInt32NullAsZero("SiteID"));
mostCommentedCommentForum.SiteName = (site != null) && (false == string.IsNullOrEmpty(site.SiteName)) ? site.SiteName : string.Empty;
mostCommentedCommentForum.ForumId = reader.GetInt32NullAsZero("ForumID");
mostCommentedCommentForum.Url = reader.GetStringNullAsEmpty("Url");
mostCommentedCommentForum.Title = reader.GetStringNullAsEmpty("Title");
mostCommentedCommentForum.CanWrite = reader.GetByteNullAsZero("CanWrite") == 1;
mostCommentedCommentForum.ForumPostCount = reader.GetInt32NullAsZero("ForumPostCount");
mostCommentedCommentForum.DateCreated = reader.GetDateTime("DateCreated");
mostCommentedCommentForum.ForumCloseDate = reader.GetDateTime("ForumCloseDate");
mostCommentedCommentForum.CommentForumListCount = reader.GetInt32NullAsZero("CommentForumListCount");
mostCommentedCommentForum.LastPosted = reader.GetDateTime("LastPosted");
return mostCommentedCommentForum;
}
private void CreateFormXml(IDnaDataReader dataReader, string comments, bool acceptButton, bool rejectButton, bool cancelButton, bool fetchButton, bool byRecommendationID)
{
RootElement.RemoveAll();
_processRecommendationForm = AddElementTag(RootElement, "PROCESS-RECOMMENDATION-FORM");
int recommendationID = dataReader.GetInt32NullAsZero("recommendationID");
int h2g2ID = dataReader.GetInt32NullAsZero("h2g2ID");
int entryID = dataReader.GetInt32NullAsZero("entryID");
string entrySubject = dataReader.GetStringNullAsEmpty("Subject");
int editorID = dataReader.GetInt32NullAsZero("EditorID");
string editorName = dataReader.GetStringNullAsEmpty("EditorName");
User editor = new User(InputContext);
int scoutID = dataReader.GetInt32NullAsZero("ScoutID");
string scoutName = dataReader.GetStringNullAsEmpty("ScoutName");
User scout = new User(InputContext);
DateTime dateRecommended = dataReader.GetDateTime("DateRecommended");
string retrievedComments = dataReader.GetStringNullAsEmpty("Comments");
AddIntElement(_processRecommendationForm, "RECOMMENDATION-ID", recommendationID);
AddIntElement(_processRecommendationForm, "H2G2-ID", h2g2ID);
AddTextTag(_processRecommendationForm, "SUBJECT", entrySubject);
AddTextTag(_processRecommendationForm, "COMMENTS", retrievedComments);
XmlElement editorElement = AddElementTag(_processRecommendationForm, "EDITOR");
editor.AddPrefixedUserXMLBlock(dataReader, editorID, "editor", editorElement);
XmlElement scoutElement = AddElementTag(_processRecommendationForm, "SCOUT");
scout.AddPrefixedUserXMLBlock(dataReader, scoutID, "scout", scoutElement);
AddDateXml(dateRecommended, _processRecommendationForm, "DATE-RECOMMENDED");
// if we know what the decision is going to be then create an appropriate
// default email to send
string scoutEmailSubject = String.Empty;
string scoutEmailText = String.Empty;
string authorEmailSubject = String.Empty;
string authorEmailText = String.Empty;
if (acceptButton && !rejectButton)
{
CreateScoutAcceptanceEmail(scoutName, entrySubject, h2g2ID, dateRecommended, ref scoutEmailSubject, ref scoutEmailText);
if (byRecommendationID)
{
CreateAuthorAcceptanceEmail(editorName, entrySubject, h2g2ID, dateRecommended, ref authorEmailSubject, ref authorEmailText);
}
}
else if (rejectButton && !acceptButton)
{
CreateScoutRejectionEmail(scoutName, entrySubject, h2g2ID, dateRecommended, ref scoutEmailSubject, ref scoutEmailText);
}
if (byRecommendationID)
{
XmlElement scoutEmail = AddElementTag(_processRecommendationForm, "SCOUT-EMAIL");
AddTextTag(scoutEmail, "SUBJECT", scoutEmailSubject);
AddTextTag(scoutEmail, "TEXT", scoutEmailText);
XmlElement authorEmail = AddElementTag(_processRecommendationForm, "AUTHOR-EMAIL");
AddTextTag(authorEmail, "SUBJECT", authorEmailSubject);
AddTextTag(authorEmail, "TEXT", authorEmailText);
}
else
{
AddTextTag(_processRecommendationForm, "EMAIL-SUBJECT", scoutEmailSubject);
AddTextTag(_processRecommendationForm, "EMAIL-TEXT", scoutEmailText);
}
XmlElement functions = AddElementTag(_processRecommendationForm, "FUNCTIONS");
if (acceptButton)
{
AddElementTag(functions, "ACCEPT");
}
if (rejectButton)
{
AddElementTag(functions, "REJECT");
}
if (cancelButton)
{
AddElementTag(functions, "CANCEL");
}
if (fetchButton)
{
AddElementTag(functions, "FETCH");
}
}
/// <summary>
/// Creates a commentinfo object
/// </summary>
/// <param name="reader">A reader with all information</param>
/// <param name="site">site information</param>
/// <returns>Comment info object</returns>
private CommentInfo CommentCreateFromReader(IDnaDataReader reader, ISite site)
{
var commentInfo = new CommentInfo
{
Created =
new DateTimeHelper(DateTime.Parse(reader.GetDateTime("Created").ToString())),
User = UserReadById(reader, site),
ID = reader.GetInt32NullAsZero("id")
};
commentInfo.hidden = (CommentStatus.Hidden) reader.GetInt32NullAsZero("hidden");
if (reader.IsDBNull("poststyle"))
{
commentInfo.PostStyle = PostStyle.Style.richtext;
}
else
{
commentInfo.PostStyle = (PostStyle.Style) reader.GetTinyIntAsInt("poststyle");
}
commentInfo.IsEditorPick = reader.GetBoolean("IsEditorPick");
commentInfo.Index = reader.GetInt32NullAsZero("PostIndex");
//get complainant
var replacement = new Dictionary<string, string>();
replacement.Add("sitename", site.SiteName);
replacement.Add("postid", commentInfo.ID.ToString());
commentInfo.ComplaintUri = UriDiscoverability.GetUriWithReplacments(BasePath,
SiteList.GetSiteOptionValueString(site.SiteID, "General", "ComplaintUrl"),
replacement);
replacement = new Dictionary<string, string>();
replacement.Add("commentforumid", reader.GetString("forumuid"));
replacement.Add("sitename", site.SiteName);
commentInfo.ForumUri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.CommentForumById,
replacement);
replacement = new Dictionary<string, string>();
replacement.Add("parentUri", reader.GetString("parentUri"));
replacement.Add("postid", commentInfo.ID.ToString());
commentInfo.Uri = UriDiscoverability.GetUriWithReplacments(BasePath, UriDiscoverability.UriType.Comment,
replacement);
if(reader.DoesFieldExist("nerovalue"))
{
commentInfo.NeroRatingValue = reader.GetInt32NullAsZero("nerovalue");
}
if (reader.DoesFieldExist("neropositivevalue"))
{
commentInfo.NeroPositiveRatingValue = reader.GetInt32NullAsZero("neropositivevalue");
}
if (reader.DoesFieldExist("neronegativevalue"))
{
commentInfo.NeroNegativeRatingValue = reader.GetInt32NullAsZero("neronegativevalue");
}
if (reader.DoesFieldExist("tweetid"))
{
commentInfo.TweetId = reader.GetLongNullAsZero("tweetid");
}
commentInfo.text = CommentInfo.FormatComment(reader.GetStringNullAsEmpty("text"), commentInfo.PostStyle, commentInfo.hidden, commentInfo.User.Editor);
if (reader.DoesFieldExist("twitterscreenname"))
{
commentInfo.TwitterScreenName = reader.GetStringNullAsEmpty("twitterscreenname");
}
if (reader.DoesFieldExist("retweetid"))
{
commentInfo.RetweetId = reader.GetLongNullAsZero("retweetid");
}
if (reader.DoesFieldExist("retweetedby"))
{
commentInfo.RetweetedBy = reader.GetStringNullAsEmpty("retweetedby");
}
if (reader.DoesFieldExist("DmID"))
{
if (reader.IsDBNull("DmID") == false)
{
commentInfo.DistressMessage = IncludeDistressMessage(reader, site);
}
}
return commentInfo;
}
/// <summary>
/// Fills the userData Dictionary with User DB data
/// </summary>
/// <param name="sp">Stored Procedure Data Reader object</param>
/// <returns>True if sucessful or false</returns>
private bool FillUserDataDictionary(IDnaDataReader sp)
{
// Set member variables that are useful as values
_userID = sp.GetInt32NullAsZero("userid");
_identityUserId = sp.GetStringNullAsEmpty("identityuserid");
_status = (UserStatus)sp.GetInt32NullAsZero("Status");
_userName = sp.GetStringNullAsEmpty("UserName");
_firstNames = sp.GetStringNullAsEmpty("FirstNames");
_lastName = sp.GetStringNullAsEmpty("LastName");
_userEmail = sp.GetStringNullAsEmpty("Email");
_password = sp.GetStringNullAsEmpty("Password");
if (_loginName.Length == 0)
{
_loginName = sp.GetStringNullAsEmpty("LoginName");
}
_preferredSkin = sp.GetStringNullAsEmpty("PrefSkin");
_masthead = sp.GetInt32NullAsZero("Masthead");
_journalID = sp.GetInt32NullAsZero("Journal");
_title = sp.GetStringNullAsEmpty("Title");
_siteSuffix = sp.GetStringNullAsEmpty("SiteSuffix");
_acceptSubscriptions = sp.GetBoolean("AcceptSubscriptions");
_prefStatus = sp.GetInt32NullAsZero("PrefStatus");
_teamID = sp.GetInt32NullAsZero("TeamID");
_lastUpdated = DateTime.Now;
_lastUpdated = sp.GetDateTime("LastUpdatedDate");
bool success = false;
if (_gotUserData)
{
//AddUserDataObject("UserID", sp);
//AddUserDataObject("UserName", sp);
AddUserDataObject("Postcode", sp);
AddUserDataObject("Region", sp);
AddUserDataObject("PrefUserMode", sp);
//AddUserDataObject("Status", sp);
AddUserDataObject("Area", sp);
AddUserDataObject("Title", sp);
//AddUserDataObject("FirstNames", sp);
//AddUserDataObject("LastName", sp);
AddUserDataObject("SiteSuffix", sp);
AddUserDataObject("TeamID", sp);
AddUserDataObject("UnreadPublicMessageCount", sp);
AddUserDataObject("UnreadPrivateMessageCount", sp);
AddUserDataObject("TaxonomyNode", sp);
AddUserDataObject("HideLocation", sp);
AddUserDataObject("HideUserName", sp);
//AddUserDataObject("AcceptSubscriptions", sp);
if (ShowFullDetails)
{
AddUserDataObject("PrefXML", sp);
//AddUserDataObject("Email", sp);
//AddUserDataObject("LoginName", sp);
AddUserDataObject("BBCUID", sp);
AddUserDataObject("Cookie", sp);
//AddUserDataObject("Password", sp);
AddUserDataObject("Masthead", sp);
AddUserDataObject("Journal", sp);
AddUserDataObject("PrivateForum", sp);
AddUserDataObject("DateJoined", sp);
AddUserDataObject("DateReleased", sp);
AddUserDataObject("Active", sp);
AddUserDataObject("Anonymous", sp);
AddUserDataObject("SinBin", sp);
AddUserDataObject("Latitude", sp);
AddUserDataObject("Longitude", sp);
AddUserDataObject("PrefSkin", sp);
AddUserDataObject("IsModClassMember", sp);
AddUserDataObject("PrefForumStyle", sp);
AddUserDataObject("AgreedTerms", sp);
AddUserDataObject("PrefStatus", sp);
AddUserDataObject("AutoSinBin", sp);
}
success = true;
}
return success;
}
static public SiteEvent CreateUserModatedEventActivity(IDnaDataReader dataReader, IDnaDataReaderCreator creator)
{
SiteEvent siteEvent = null;
try
{
siteEvent = new SiteEvent();
siteEvent.SiteId = dataReader.GetInt32NullAsZero("siteid");
siteEvent.Date = new Date(dataReader.GetDateTime("DateCreated"));
var duration = "";
var moderationStatus = "";
switch ((ModerationStatus.UserStatus)dataReader.GetInt32NullAsZero("status"))
{
case ModerationStatus.UserStatus.Postmoderated:
siteEvent.Type = SiteActivityType.UserModeratedPostMod;
moderationStatus = "postmoderated";
break;
case ModerationStatus.UserStatus.Premoderated:
siteEvent.Type = SiteActivityType.UserModeratedPremod;
moderationStatus = "premoderated";
break;
case ModerationStatus.UserStatus.Restricted:
siteEvent.Type = SiteActivityType.UserModeratedBanned;
moderationStatus = "banned";
break;
case ModerationStatus.UserStatus.Deactivated:
siteEvent.Type = SiteActivityType.UserModeratedDeactivated;
moderationStatus = "deactivated";
break;
case ModerationStatus.UserStatus.Standard:
siteEvent.Type = SiteActivityType.UserModeratedStandard;
moderationStatus = "returned to normal";
break;
case ModerationStatus.UserStatus.Trusted:
siteEvent.Type = SiteActivityType.UserModeratedTrusted;
moderationStatus = "trusted";
break;
default:
throw new Exception("Unknown moderation status: " + ((ModerationStatus.UserStatus)dataReader.GetInt32NullAsZero("status")).ToString());
}
switch(dataReader.GetInt32NullAsZero("prefduration"))
{
case 1440: duration = " for 1 day";break;
case 10080: duration = " for 1 week";break;
case 20160: duration = " for 2 weeks";break;
case 40320: duration = " for 1 month";break;
default:
if (dataReader.GetInt32NullAsZero("prefduration") > 0)
{
duration = " for " + dataReader.GetInt32NullAsZero("prefduration").ToString() + " hours";
}
break;
}
siteEvent.ActivityData = XElement.Parse(
string.Format(DataFormat,
dataReader.GetInt32NullAsZero("user_userid"), dataReader.GetStringNullAsEmpty("user_username"),
dataReader.GetInt32NullAsZero("status"), moderationStatus, dataReader.GetInt32NullAsZero("siteid"),
dataReader.GetInt32NullAsZero("mod_userid"), dataReader.GetStringNullAsEmpty("mod_username"),
duration, dataReader.GetStringNullAsEmpty("modreason"))
);
siteEvent.UserId = dataReader.GetInt32NullAsZero("user_userid");
if (siteEvent != null)
{
siteEvent.SaveEvent(creator);
}
}
catch(Exception e)
{
siteEvent = null;
SiteEventsProcessor.SiteEventLogger.LogException(e);
}
return siteEvent;
}
/// <summary>
/// Creates the last poster block for a thread
/// </summary>
/// <param name="reader">The DNADataReader that contains the post details</param>
/// <param name="threadNode">The node that you want to add the poster to</param>
private void CreateLastPoster(IDnaDataReader reader, XmlNode threadNode)
{
XmlNode lastPostNode = CreateThreadPostingXml(reader, threadNode, "Last");
lastPostNode.InsertBefore(DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, reader.GetDateTime("LastPosted"), true), lastPostNode.FirstChild);
}
public static ArticleSummary CreateArticleSummaryFromReader(IDnaDataReader reader)
{
ArticleSummary articleSummary = new ArticleSummary();
articleSummary.H2G2ID = reader.GetInt32NullAsZero("h2g2id");
articleSummary.Name = reader.GetStringNullAsEmpty("subject");
articleSummary.StrippedName = StringUtils.StrippedName(reader.GetStringNullAsEmpty("subject"));
if (reader.DoesFieldExist("Type"))
{
articleSummary.Type = Article.GetArticleTypeFromInt(reader.GetInt32NullAsZero("Type"));
}
if (reader.DoesFieldExist("editor"))
{
articleSummary.Editor = new UserElement() { user = User.CreateUserFromReader(reader, "editor") };
}
articleSummary.DateCreated = new DateElement(reader.GetDateTime("datecreated"));
if (reader.DoesFieldExist("lastupdated"))
{
articleSummary.LastUpdated = new DateElement(reader.GetDateTime("lastupdated")); ;
}
articleSummary.Status = ArticleStatus.GetStatus(reader.GetInt32NullAsZero("status"));
return articleSummary;
}
/// <summary>
/// This method reads in the entry form the database and sets up all the member fields
/// </summary>
/// <param name="safeToCache">A flag to state whether or not this entry is safe to cache. Usually set to false whhen an error occures.</param>
/// <param name="failingGracefully">A flag that states whether or not this method is failing gracefully.</param>
static public ArticleInfo GetEntryFromDataBase(int entryId, IDnaDataReader reader, IDnaDataReaderCreator readerCreator)
{
ArticleInfo articleInfo = null;
// fetch all the lovely intellectual property from the database
// Make sure we got something back
if (reader.HasRows)
{
// Go though the results untill we get the main article
do
{
if (reader.GetInt32("IsMainArticle") == 1 )
{
articleInfo = new ArticleInfo();
// Now start reading in all the values for the entry
articleInfo.H2g2Id = reader.GetInt32("h2g2ID");
articleInfo.ForumId = reader.GetInt32("ForumID");
articleInfo.ModerationStatus = (BBC.Dna.Moderation.Utils.ModerationStatus.ArticleStatus)reader.GetInt32NullAsZero("ModerationStatus");
articleInfo.Status = ArticleStatus.GetStatus(reader.GetInt32("Status"));
articleInfo.DateCreated = new DateElement(reader.GetDateTime("DateCreated"));
articleInfo.LastUpdated = new DateElement(reader.GetDateTime("LastUpdated"));
articleInfo.PreProcessed = reader.GetInt32("PreProcessed");
articleInfo.SiteId = reader.GetInt32("SiteID");
articleInfo.Site = new ArticleInfoSite() { Id = articleInfo.SiteId };
//create children objects
articleInfo.PageAuthor = ArticleInfoPageAuthor.CreateListForArticle(articleInfo.H2g2Id, reader.GetInt32("Editor"), readerCreator);
articleInfo.RelatedMembers = ArticleInfoRelatedMembers.GetRelatedMembers(articleInfo.H2g2Id, readerCreator);
articleInfo.CrumbTrails = CrumbTrails.CreateArticleCrumbtrail(articleInfo.H2g2Id, readerCreator);
if (articleInfo.Status.Type == 3)
{//create Submittable if status = 3...
bool isSubmittable = (reader.GetTinyIntAsInt("Submittable")==1);
articleInfo.Submittable = ArticleInfoSubmittable.CreateSubmittable(readerCreator, articleInfo.H2g2Id, isSubmittable);
}
}
if (articleInfo != null)
{
break;//got the info so run
}
}
while (reader.Read());
}
return articleInfo;
}
private void AddCommentForumListXML(IDnaDataReader dataReader, XmlNode commentForumList)
{
// start creating the comment forum structure
XmlNode commentForum = CreateElementNode("COMMENTFORUM");
AddAttribute(commentForum, "UID", dataReader.GetStringNullAsEmpty("uid"));
AddAttribute(commentForum, "FORUMID", dataReader.GetInt32NullAsZero("forumID").ToString());
AddAttribute(commentForum, "FORUMPOSTCOUNT", dataReader.GetInt32NullAsZero("forumpostcount").ToString());
AddAttribute(commentForum, "FORUMPOSTLIMIT", InputContext.GetSiteOptionValueInt("Forum", "PostLimit"));
AddAttribute(commentForum, "CANWRITE", dataReader.GetByteNullAsZero("CanWrite").ToString());
AddAttribute(commentForum, "NOTSIGNEDINUSERID", dataReader.GetInt32NullAsZero("NotSignedInUserID").ToString());
AddTextTag(commentForum, "HOSTPAGEURL", dataReader.GetStringNullAsEmpty("url"));
AddTextTag(commentForum, "TITLE", dataReader.GetStringNullAsEmpty("title"));
AddTextTag(commentForum, "MODSTATUS", dataReader.GetByteNullAsZero("ModerationStatus"));
AddTextTag(commentForum, "SITEID", dataReader.GetInt32NullAsZero("siteid"));
AddTextTag(commentForum, "FASTMOD", dataReader.GetInt32NullAsZero("fastmod"));
AddTextTag(commentForum, "CONTACTEMAIL", dataReader.GetStringNullAsEmpty("encryptedcontactemail"));
if (dataReader.DoesFieldExist("DateCreated") && !dataReader.IsDBNull("DateCreated"))
{
DateTime dateCreated = dataReader.GetDateTime("DateCreated");
AddElement(commentForum, "DATECREATED", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, dateCreated));
}
if (dataReader.DoesFieldExist("ForumCloseDate") && !dataReader.IsDBNull("ForumCloseDate"))
{
DateTime closeDate = dataReader.GetDateTime("ForumCloseDate");
AddElement(commentForum, "CLOSEDATE", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, closeDate));
}
if (dataReader.DoesFieldExist("LastUpdated") && !dataReader.IsDBNull("LastUpdated"))
{
DateTime dateLastUpdated = dataReader.GetDateTime("LastUpdated");
AddElement(commentForum, "LASTUPDATED", DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, dateLastUpdated));
}
int forumId = dataReader.GetInt32NullAsZero("forumID");
AddXmlTextTag(commentForum, "TERMS", "");
commentForumList.AppendChild(commentForum);
}
/// <summary>
/// Creates the commentforumdata from a given reader
/// </summary>
/// <param name="reader">The database reaser</param>
/// <returns>A Filled comment forum object</returns>
private CommentForum CommentForumCreateFromReader(IDnaDataReader reader)
{
var closingDate = reader.GetDateTime("forumclosedate");
//if (closingDate == null)
//{
// closingDate = DateTime.MaxValue;
//}
var site = SiteList.GetSite(reader.GetStringNullAsEmpty("sitename"));
var commentForum = new CommentForum();
commentForum.Title = reader.GetStringNullAsEmpty("Title");
commentForum.Id = reader.GetStringNullAsEmpty("UID");
commentForum.CanRead = reader.GetByteNullAsZero("canRead") == 1;
commentForum.CanWrite = reader.GetByteNullAsZero("canWrite") == 1;
commentForum.ParentUri = reader.GetStringNullAsEmpty("Url");
commentForum.SiteName = reader.GetStringNullAsEmpty("sitename");
commentForum.CloseDate = closingDate;
commentForum.LastUpdate = reader.GetDateTime("LastUpdated");
if (reader.GetDateTime("lastposted") > commentForum.LastUpdate)
{
//use last posted as it is newer
commentForum.LastUpdate = reader.GetDateTime("lastposted");
}
commentForum.Updated = new DateTimeHelper(commentForum.LastUpdate);
commentForum.Created = new DateTimeHelper(reader.GetDateTime("DateCreated"));
commentForum.commentSummary = new CommentsSummary
{
Total = reader.GetInt32NullAsZero("ForumPostCount"),
EditorPicksTotal = reader.GetInt32NullAsZero("editorpickcount")
};
commentForum.ForumID = reader.GetInt32NullAsZero("forumid");
commentForum.isClosed = !commentForum.CanWrite || site.IsEmergencyClosed ||
site.IsSiteScheduledClosed(DateTime.Now) ||
(DateTime.Now > closingDate);
//MaxCharacterCount = siteList.GetSiteOptionValueInt(site.SiteID, "CommentForum", "'MaxCommentCharacterLength")
var replacements = new Dictionary<string, string>();
replacements.Add("commentforumid", reader.GetStringNullAsEmpty("uid"));
replacements.Add("sitename", site.SiteName);
if (reader.Exists("IsContactForm") && !reader.IsDBNull("IsContactForm"))
{
commentForum.isContactForm = true;
commentForum.Uri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.ContactFormById,
replacements);
commentForum.commentSummary.Uri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.ContactFormById,
replacements);
}
else
{
commentForum.Uri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.CommentForumById,
replacements);
commentForum.commentSummary.Uri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.CommentsByCommentForumId,
replacements);
}
//get moderation status
commentForum.ModerationServiceGroup = ModerationStatus.ForumStatus.Unknown;
if (!reader.IsDBNull("moderationstatus"))
{
//if it is set for the specific forum
commentForum.ModerationServiceGroup =
(ModerationStatus.ForumStatus) (reader.GetTinyIntAsInt("moderationstatus"));
}
if (commentForum.ModerationServiceGroup == ModerationStatus.ForumStatus.Unknown)
{
//else fall back to site moderation status
switch (site.ModerationStatus)
{
case ModerationStatus.SiteStatus.UnMod:
commentForum.ModerationServiceGroup = ModerationStatus.ForumStatus.Reactive;
break;
case ModerationStatus.SiteStatus.PreMod:
commentForum.ModerationServiceGroup = ModerationStatus.ForumStatus.PreMod;
break;
case ModerationStatus.SiteStatus.PostMod:
commentForum.ModerationServiceGroup = ModerationStatus.ForumStatus.PostMod;
break;
default:
commentForum.ModerationServiceGroup = ModerationStatus.ForumStatus.Reactive;
break;
}
}
commentForum.NotSignedInUserId = reader.GetInt32NullAsZero("NotSignedInUserId");
commentForum.allowNotSignedInCommenting = commentForum.NotSignedInUserId != 0;
return commentForum;
}
/// <summary>
///
/// </summary>
/// <param name="dataReader"></param>
/// <param name="userSearchType"></param>
/// <param name="searchText"></param>
/// <param name="checkAllSites"></param>
/// <param name="twitterAPIException"></param>
public void GenerateMemberListXml(
IDnaDataReader dataReader,
int userSearchType,
string searchText,
bool checkAllSites,
string twitterAPIException)
{
int count = 0;
XmlNode memberList = AddElementTag(RootElement, "MEMBERLIST");
AddAttribute(memberList, "USERSEARCHTYPE", userSearchType.ToString());
AddAttribute(memberList, "SEARCHTEXT", searchText);
AddAttribute(memberList, "CHECKALLSITES", checkAllSites.ToString());
if (dataReader.HasRows)
{
if (dataReader.Read())
{
XmlNode userAccounts = AddElementTag(memberList, "USERACCOUNTS");
//int previousUserID = 0;
XmlNode userAccount = null;
do
{
int userID = dataReader.GetInt32NullAsZero("USERID");
/*if (userID != previousUserID)
{
if (userAccount != null)
{
userAccounts.AppendChild(userAccount);
}
userAccount = CreateElementNode("USERACCOUNT");
previousUserID = userID;
}*/
userAccount = CreateElementNode("USERACCOUNT");
//Start filling new user xml
AddAttribute(userAccount, "USERID", userID);
AddTextTag(userAccount, "SITEID", dataReader.GetInt32NullAsZero("SITEID"));
AddTextTag(userAccount, "USERNAME", dataReader.GetStringNullAsEmpty("USERNAME"));
AddTextTag(userAccount, "LOGINNAME", dataReader.GetStringNullAsEmpty("LOGINNAME"));
AddTextTag(userAccount, "EMAIL", dataReader.GetStringNullAsEmpty("EMAIL"));
AddTextTag(userAccount, "PREFSTATUS", dataReader.GetInt32NullAsZero("PREFSTATUS"));
AddTextTag(userAccount, "PREFSTATUSDURATION", dataReader.GetInt32NullAsZero("PREFSTATUSDURATION"));
AddTextTag(userAccount, "USERSTATUSDESCRIPTION", ((ModerationStatus.UserStatus)dataReader.GetInt32NullAsZero("PREFSTATUS")).ToString());
if (!dataReader.IsDBNull("DATEJOINED"))
{
AddDateXml(dataReader.GetDateTime("DATEJOINED"), userAccount, "DATEJOINED");
}
if (!dataReader.IsDBNull("PREFSTATUSCHANGEDDATE"))
{
DateTime prefStatusChangedDate = dataReader.GetDateTime("PREFSTATUSCHANGEDDATE");
AddDateXml(prefStatusChangedDate, userAccount, "PREFSTATUSCHANGEDDATE");
}
else
{
AddTextTag(userAccount, "PREFSTATUSCHANGEDDATE", "");
}
AddTextTag(userAccount, "SHORTNAME", dataReader.GetStringNullAsEmpty("SHORTNAME"));
AddTextTag(userAccount, "URLNAME", dataReader.GetStringNullAsEmpty("URLNAME"));
if (dataReader.DoesFieldExist("IPADDRESS") && dataReader.GetStringNullAsEmpty("IPADDRESS") != String.Empty)
{
AddTextTag(userAccount, "IPADDRESS", dataReader.GetStringNullAsEmpty("IPADDRESS"));
}
if (dataReader.DoesFieldExist("BBCUID") && dataReader.GetGuidAsStringOrEmpty("BBCUID") != String.Empty)
{
AddTextTag(userAccount, "BBCUID", dataReader.GetGuidAsStringOrEmpty("BBCUID"));
}
if (userSearchType == 6)
{
AddTextTag(userAccount, "TWITTERUSERID", dataReader.GetStringNullAsEmpty("TwitterUserID"));
}
else
{
AddIntElement(userAccount, "SSOUSERID", dataReader.GetInt32NullAsZero("SSOUserID"));
}
AddTextTag(userAccount, "IDENTITYUSERID", dataReader.GetStringNullAsEmpty("IdentityUserID"));
AddIntElement(userAccount, "ACTIVE", dataReader.GetInt32NullAsZero("STATUS") != 0 ? 1:0);
userAccounts.AppendChild(userAccount);
count++;
} while (dataReader.Read());
memberList.AppendChild(userAccounts);
}
}
AddAttribute(memberList, "COUNT", count);
AddAttribute(memberList, "TWITTEREXCEPTION", twitterAPIException);
//FileCache.PutItem(AppContext.TheAppContext.Config.CachePath, "memberlist", _cacheName, memberList.OuterXml);
//memberList.OwnerDocument.Save(@"c:\TEMP\memberlist.xml");
}
private CommentInfo IncludeDistressMessage(IDnaDataReader reader, ISite site)
{
var commentInfo = new CommentInfo();
commentInfo.Created = new DateTimeHelper(DateTime.Parse(reader.GetDateTime("DmCreated").ToString()));
commentInfo.ID = reader.GetInt32NullAsZero("DmId");
commentInfo.User = DmUserFromReader(reader, site);
commentInfo.hidden = (CommentStatus.Hidden)reader.GetInt32NullAsZero("DmHidden");
if (reader.IsDBNull("DmPostStyle"))
{
commentInfo.PostStyle = PostStyle.Style.richtext;
}
else
{
commentInfo.PostStyle = (PostStyle.Style)reader.GetTinyIntAsInt("DmPostStyle");
}
commentInfo.Index = reader.GetInt32NullAsZero("DmPostIndex");
commentInfo.text = CommentInfo.FormatComment(reader.GetStringNullAsEmpty("DmText"),
commentInfo.PostStyle,
commentInfo.hidden,
commentInfo.User.Editor);
var replacement = new Dictionary<string, string>();
replacement.Add("commentforumid", reader.GetString("forumuid"));
replacement.Add("sitename", site.SiteName);
commentInfo.ForumUri = UriDiscoverability.GetUriWithReplacments(BasePath,
UriDiscoverability.UriType.CommentForumById,
replacement);
replacement = new Dictionary<string, string>();
replacement.Add("parentUri", reader.GetString("parentUri"));
replacement.Add("postid", commentInfo.ID.ToString());
commentInfo.Uri = UriDiscoverability.GetUriWithReplacments(BasePath, UriDiscoverability.UriType.Comment,
replacement);
return commentInfo;
}
void TestNullableDateField(IDnaDataReader reader, string fieldName, TestDate expected)
{
if (reader.IsDBNull(fieldName))
Assert.IsNull(expected);
else
Assert.IsTrue(expected.CheckDate(reader.GetDateTime(fieldName)));
}
/// <summary>
/// Creates and adds the returned User Xml block to a given parent post node from the passed user parameters with a prefix
/// ie the field name of OwnerUserName, OwnerFirstNames
/// </summary>
/// <param name="dataReader">Data reader object</param>
/// <param name="userID">The users id</param>
/// <param name="prefix">The prefix of the field names for a different user in the same result set</param>
/// <param name="parent">The parent Node to add the user xml to</param>
/// <returns>XmlNode Containing user XML from the stored procedure</returns>
public void AddPrefixedUserXMLBlock(IDnaDataReader dataReader, int userID, string prefix, XmlNode parent)
{
string userName = "";
if (dataReader.Exists(prefix + "UserName"))
{
userName = dataReader.GetStringNullAsEmpty(prefix + "UserName");
}
else if (dataReader.Exists(prefix + "Name"))
{
userName = dataReader.GetStringNullAsEmpty(prefix + "Name");
}
if (userName == String.Empty)
{
userName = "******" + userID.ToString();
}
string identityUserId = "";
if (dataReader.Exists(prefix + "identityUserId"))
{
identityUserId = dataReader.GetStringNullAsEmpty(prefix + "identityUserId");
}
string emailAddress = "";
if (dataReader.Exists(prefix + "Email"))
{
emailAddress = dataReader.GetStringNullAsEmpty(prefix + "Email");
}
double zeigeistScore = 0.0;
if (dataReader.DoesFieldExist(prefix + "ZeitgeistScore"))
{
zeigeistScore = dataReader.GetDoubleNullAsZero(prefix + "ZeitgeistScore");
}
string siteSuffix = "";
if (dataReader.Exists(prefix + "SiteSuffix"))
{
siteSuffix = dataReader.GetStringNullAsEmpty(prefix + "SiteSuffix");
}
string area = "";
if (dataReader.Exists(prefix + "Area"))
{
area = dataReader.GetStringNullAsEmpty(prefix + "Area");
}
string title = "";
if (dataReader.Exists(prefix + "Title"))
{
title = dataReader.GetStringNullAsEmpty(prefix + "Title");
}
int subQuota = 0;
if (dataReader.Exists(prefix + "SubQuota"))
{
subQuota = dataReader.GetInt32NullAsZero(prefix + "SubQuota");
}
int allocations = 0;
if (dataReader.Exists(prefix + "Allocations"))
{
allocations = dataReader.GetInt32NullAsZero(prefix + "Allocations");
}
int journal = 0;
if (dataReader.Exists(prefix + "Journal"))
{
journal = dataReader.GetInt32NullAsZero(prefix + "Journal");
}
bool isActive = false;
if (dataReader.Exists(prefix + "Active") && !dataReader.IsDBNull(prefix + "Active"))
{
isActive = dataReader.GetBoolean(prefix + "Active");
}
DateTime dateLastNotified = DateTime.MinValue;
if (dataReader.Exists(prefix + "DateLastNotified") && dataReader.GetValue(prefix + "DateLastNotified") != DBNull.Value)
{
dateLastNotified = dataReader.GetDateTime(prefix + "DateLastNotified");
}
DateTime dateJoined = DateTime.MinValue;
if (dataReader.Exists(prefix + "DateJoined") && dataReader.GetValue(prefix + "DateJoined") != DBNull.Value)
{
dateJoined = dataReader.GetDateTime(prefix + "DateJoined");
}
int forumPostedTo = -1;
if (dataReader.Exists(prefix + "ForumPostedTo"))
{
forumPostedTo = dataReader.GetInt32NullAsZero(prefix + "ForumPostedTo");
}
int masthead = -1;
if (dataReader.Exists(prefix + "Masthead"))
{
masthead = dataReader.GetInt32NullAsZero(prefix + "Masthead");
}
int sinbin = -1;
if (dataReader.Exists(prefix + "SinBin"))
{
sinbin = dataReader.GetInt32NullAsZero(prefix + "SinBin");
}
int forumID = -1;
if (dataReader.Exists(prefix + "ForumID"))
{
forumID = dataReader.GetInt32NullAsZero(prefix + "ForumID");
}
XmlNode userXML = GenerateUserXml(userID,
userName,
emailAddress,
dataReader.GetStringNullAsEmpty(prefix + "FirstNames"),
dataReader.GetStringNullAsEmpty(prefix + "LastName"),
dataReader.GetInt32NullAsZero(prefix + "Status"),
dataReader.GetInt32NullAsZero(prefix + "TaxonomyNode"),
isActive,
zeigeistScore,
siteSuffix,
area,
title,
journal,
dateLastNotified,
subQuota,
allocations,
dateJoined,
forumID,
forumPostedTo,
masthead,
sinbin,
identityUserId);
if (userXML != null)
{
XmlNode importxml = parent.OwnerDocument.ImportNode(userXML, true);
parent.AppendChild(importxml);
}
}
private static Contribution CreateContributionInternal(IDnaDataReader reader)
{
Contribution contribution = new Contribution();
// Make sure we got something back
if (reader.HasRows && reader.Read())
{
contribution.Body = reader.GetStringNullAsEmpty("Body");
contribution.PostIndex = reader.GetLongNullAsZero("PostIndex");
contribution.SiteName = reader.GetStringNullAsEmpty("SiteName");
contribution.SiteType = (SiteType)Enum.Parse(typeof(SiteType), reader.GetStringNullAsEmpty("SiteType"));
contribution.SiteDescription = reader.GetStringNullAsEmpty("SiteDescription");
contribution.SiteUrl = reader.GetStringNullAsEmpty("UrlName");
contribution.FirstSubject = reader.GetStringNullAsEmpty("FirstSubject");
contribution.Subject = reader.GetStringNullAsEmpty("Subject");
contribution.Timestamp = new DateTimeHelper(reader.GetDateTime("TimeStamp"));
contribution.Title = reader.GetStringNullAsEmpty("ForumTitle");
contribution.ThreadEntryID = reader.GetInt32("ThreadEntryID");
contribution.CommentForumUrl = reader.GetStringNullAsEmpty("CommentForumUrl");
contribution.GuideEntrySubject = reader.GetStringNullAsEmpty("GuideEntrySubject");
contribution.TotalPostsOnForum = reader.GetInt32NullAsZero("TotalPostsOnForum");
contribution.AuthorUserId = reader.GetInt32NullAsZero("AuthorUserId");
contribution.AuthorUsername = reader.GetStringNullAsEmpty("AuthorUsername");
contribution.AuthorIdentityUsername = reader.GetStringNullAsEmpty("AuthorIdentityUsername");
bool forumCanWrite = reader.GetByteNullAsZero("ForumCanWrite") == 1;
bool isEmergencyClosed = reader.GetInt32NullAsZero("SiteEmergencyClosed") == 1;
//bool isSiteScheduledClosed = reader2.GetByteNullAsZero("SiteScheduledClosed") == 1;
DateTime closingDate = DateTime.MaxValue;
if (reader.DoesFieldExist("forumclosedate") && !reader.IsDBNull("forumclosedate"))
{
closingDate = reader.GetDateTime("forumclosedate");
contribution.ForumCloseDate = new DateTimeHelper(closingDate);
}
contribution.isClosed = (!forumCanWrite || isEmergencyClosed || (closingDate != null && DateTime.Now > closingDate));
}
else
{
throw ApiException.GetError(ErrorType.ThreadPostNotFound);
}
return contribution;
}
