Exemplo n.º 1
0
         /// <summary>
        /// Method called to update the statuses of any of the comment forums. 
        /// </summary>
        private bool TryUpdateCommentForum()
        {
            string action = String.Empty;
            if (InputContext.TryGetParamString("dnaaction", ref action, "Action to take on this request. 'update' is the only action currently recognised"))
            {
                if (action == "create")
                {
                    string uid = String.Empty;
                    if (InputContext.DoesParamExist("dnauid", "The uid of the given comment forum."))
                    {
                        InputContext.TryGetParamString("dnauid", ref uid, "The uid of the given comment forum.");
                        if (uid == String.Empty)
                        {
                            return AddErrorXml("invalidparameters", "blank unique id provided", null);
                        }
                    }
                    else
                    {
                        //Cannot continue.
                        return AddErrorXml("invalidparameters", "No unique id provided", null);
                    }

                    string hostPageUrl = String.Empty;
                    if (InputContext.DoesParamExist("dnahostpageurl", "The url of the given comment forum."))
                    {
                        InputContext.TryGetParamString("dnahostpageurl", ref hostPageUrl, "The url of the given comment forum.");
                        if (hostPageUrl == String.Empty)
                        {
                            return AddErrorXml("invalidparameters", "blank url provided", null);
                        }
                    }
                    else
                    {
                        //Cannot continue.
                        return AddErrorXml("invalidparameters", "No url provided", null);
                    }

                    string title = String.Empty;
                    if (InputContext.DoesParamExist("dnatitle", "The title of the given comment forum."))
                    {
                        InputContext.TryGetParamString("dnatitle", ref title, "The title of the given comment forum.");
                        if (title == String.Empty)
                        {
                            return AddErrorXml("invalidparameters", "blank title provided", null);
                        }
                    }
                    else
                    {
                        //Cannot continue.
                        return AddErrorXml("invalidparameters", "No title provided", null);
                    }

                    ISite siteForForum = InputContext.CurrentSite;
                    if (InputContext.DoesParamExist("dnasitename", "The name of the dna site you want to use"))
                    {
                        string siteURLName = "";
                        if (InputContext.TryGetParamString("dnasitename", ref siteURLName, "The name of the dna site you want to use"))
                        {
                            siteForForum = InputContext.TheSiteList.GetSite(siteURLName);
                            if (siteForForum == null)
                            {
                                return AddErrorXml("invalidparameters", "invalid dna site name", null);
                            }
                        }
                    }

                    CommentForum forum = new CommentForum()
                    {
                        Id = uid,
                        ParentUri = hostPageUrl,
                        Title = title
                    };

                    Comments comments = new Comments(AppContext.TheAppContext.Diagnostics, AppContext.ReaderCreator, CacheFactory.GetCacheManager(), InputContext.TheSiteList);
                    try
                    {
                        comments.CreateCommentForum(forum, siteForForum);
                    }
                    catch(ApiException e) 
                    {
                        return AddErrorXml(e.type.ToString(), e.Message, null);
                    }


                }
                if (action == "update")
                {
                    string newCloseDateParam = String.Empty;
                    object newCloseDate = null;
                    int newModStatus = 0;
                    int newCanWrite = 0;
                    string uid = String.Empty;

                    string docUid = "The uid of the given comment forum.";
                    bool uidExists = false;
                    uidExists = InputContext.DoesParamExist("dnauid", docUid);
                    if (uidExists)
                    {
                        InputContext.TryGetParamString("dnauid", ref uid, docUid);
                        if (uid == String.Empty)
                        {
                            return AddErrorXml("invalidparameters", "blank unique id provided", null);
                        }
                    }
                    else
                    {
                        //Cannot continue.
                        return AddErrorXml("invalidparameters", "No unique id provided", null);
                    }

                    string docNewForumCloseDate = "The new CommentBoxForum Close Date for the given comment forum.";
                    bool newNewForumCloseDateExists = false;
                    newNewForumCloseDateExists = InputContext.DoesParamExist("dnanewforumclosedate", docNewForumCloseDate);
                    if (newNewForumCloseDateExists)
                    {
                        InputContext.TryGetParamString("dnanewforumclosedate", ref newCloseDateParam, docNewForumCloseDate);
                        // Try to parse the date
                        try
                        {
                            // Set the closing date from the value - The format of the date is YYYYMMDD.
                            newCloseDate = new DateTime(Convert.ToInt32(newCloseDateParam.Substring(0, 4)), Convert.ToInt32(newCloseDateParam.Substring(4, 2).TrimStart('0')), Convert.ToInt32(newCloseDateParam.Substring(6, 2).TrimStart('0')));
                        }
                        catch (Exception ex)
                        {
                            return AddErrorXml("invalidparameters", "Invalid date format given for forumclosedate. " + ex.Message, null);
                        }
                    }

                    string docNewModStatus = "The new Moderation Status for the given comment forum.";
                    bool newModStatusExists = false;
                    newModStatusExists = InputContext.DoesParamExist("dnanewmodstatus", docNewModStatus);
                    if (newModStatusExists)
                    {
                        string dnaNewModStatus = InputContext.GetParamStringOrEmpty("dnanewmodstatus", docNewModStatus);
                        if (dnaNewModStatus == "reactive")
                        {
                            newModStatus = 1;
                        }
                        else if (dnaNewModStatus == "postmod")
                        {
                            newModStatus = 2;
                        }
                        else if (dnaNewModStatus == "premod")
                        {
                            newModStatus = 3;
                        }
                        else
                        {
                            return AddErrorXml("invalidparameters", "Illegal New Moderation Status setting (" + dnaNewModStatus + ")", null);
                        }
                    }
                    int fastModStatus = 0;
                    bool newFastModStatusExists = InputContext.DoesParamExist("dnafastmod", "");
                    if (newFastModStatusExists)
                    {
                        var fastModVal = InputContext.GetParamStringOrEmpty("dnafastmod", "");
                        if (fastModVal.ToUpper() == "ENABLED")
                        {
                            fastModStatus = 1;
                        }
                        else
                        {
                            fastModStatus = 0;
                        }
                    }

                    string docNewCanWrite = "The new Open Close Status for the given comment forum.";
                    bool newNewCanWriteExists = false;
                    newNewCanWriteExists = InputContext.DoesParamExist("dnanewcanwrite", docNewCanWrite);
                    if (newNewCanWriteExists)
                    {
                        newCanWrite = InputContext.GetParamIntOrZero("dnanewcanwrite", docNewCanWrite);
                    }

                    #region Anonymous Posting

                    int forumId = 0;
                    if (InputContext.DoesParamExist("forumid", "Forum ID"))
                    {
                        forumId = InputContext.GetParamIntOrZero("forumid", "Forum ID");
                    }

                    bool anonymousPostingStatusExists = false;
                    anonymousPostingStatusExists = InputContext.DoesParamExist("dnaanonymoussetting", "");
                    if (anonymousPostingStatusExists && forumId != 0)
                    {
                        var anonPostVal = InputContext.GetParamStringOrEmpty("dnaanonymoussetting", "");
                        if (anonPostVal.ToUpper() == "ALLOW")
                        {
                            if (InputContext.TheSiteList.GetSiteOptionValueBool(InputContext.CurrentSite.SiteID, "CommentForum", "AllowNotSignedInCommenting"))
                            {
                                var user = new Dna.Users.User(AppContext.ReaderCreator, AppContext.TheAppContext.Diagnostics, AppContext.DnaCacheManager);
                                user.CreateAnonymousUserForForum(InputContext.CurrentSite.SiteID, forumId, "");
                            }
                        }
                    }

                    #endregion

                    if (newNewForumCloseDateExists || newModStatusExists || newNewCanWriteExists || newFastModStatusExists)
                    {

                        using (IDnaDataReader dataReader = InputContext.CreateDnaDataReader("updatecommentforumstatus"))
                        {
                            dataReader.AddParameter("uid", uid);

                            if (newNewForumCloseDateExists && newCloseDate != null)
                            {
                                dataReader.AddParameter("forumclosedate", newCloseDate);
                            }
                            else
                            {
                                dataReader.AddParameter("forumclosedate", DBNull.Value);
                            }

                            if (newModStatusExists)
                            {
                                dataReader.AddParameter("modstatus", newModStatus);
                            }
                            else
                            {
                                dataReader.AddParameter("modstatus", DBNull.Value);
                            }
                            if (newNewCanWriteExists)
                            {
                                dataReader.AddParameter("canwrite", newCanWrite);
                            }
                            else
                            {
                                dataReader.AddParameter("canwrite", DBNull.Value);
                            }
                            if (newFastModStatusExists)
                            {
                                dataReader.AddParameter("fastmod", fastModStatus);
                            }
                            else
                            {
                                dataReader.AddParameter("fastmod", DBNull.Value);
                            }
                            dataReader.Execute();
                        }
                    }
                }
            }

            return true;
        }
Exemplo n.º 2
0
        /// <summary>
        /// Creates a new comment forum for a specificed site. if the commentforum id already exists, then nothing will be created
        /// </summary>
        /// <param name="commentForum">The comment forum object</param>
        /// <param name="site"></param>
        /// <returns>The comment forum (either new or existing) which matches to the </returns>
        public void CreateForum(Forum commentForum, ISite site)
        {
            //validate data
            if (string.IsNullOrEmpty(commentForum.Id) || commentForum.Id.Length > 255)
            {
                throw ApiException.GetError(ErrorType.InvalidForumUid);
            }
            if (string.IsNullOrEmpty(commentForum.ParentUri) || (commentForum.ParentUri.IndexOf("bbc.co.uk") < 0 && commentForum.ParentUri.IndexOf("bbc.com") < 0))
            {
                throw ApiException.GetError(ErrorType.InvalidForumParentUri);
            }
            if (string.IsNullOrEmpty(commentForum.Title))
            {
                throw ApiException.GetError(ErrorType.InvalidForumTitle);
            }
            if (site == null)
            {
                throw ApiException.GetError(ErrorType.UnknownSite);
            }

            //get the inital moderation status...
            var moderationStatus = (int)commentForum.ModerationServiceGroup;
            //get forum duration in days
            int duration = 0;
            if (commentForum.CloseDate != DateTime.MinValue)
            {
                duration = (commentForum.CloseDate.Subtract(DateTime.Today)).Days; //the plus one takes to midnight
            }

            using (IDnaDataReader reader = CreateReader("commentforumcreate"))
            {
                try
                {
                    reader.AddParameter("uid", commentForum.Id);
                    reader.AddParameter("url", commentForum.ParentUri);
                    reader.AddParameter("title", commentForum.Title);
                    reader.AddParameter("sitename", site.SiteName);
                    if (moderationStatus != 0)
                    {
                        reader.AddParameter("moderationstatus", moderationStatus);
                    }
                    if (duration > 0)
                    {
                        reader.AddParameter("duration", duration);
                    }
                    reader.Execute();

                    if (reader.Read())
                    {
                        commentForum.ForumID = reader.GetInt32NullAsZero("forumid");
                    }
                }
                catch (Exception ex)
                {
                    throw new ApiException(ex.Message, ex.InnerException);
                    //DnaApiWebProtocalException.ThrowDnaApiWebProtocalException(System.Net.HttpStatusCode.InternalServerError, ex.Message, ex);
                }
            }

            //set up not signed in commenting
            if (commentForum.allowNotSignedInCommenting)
            {
                if (SiteList.GetSiteOptionValueBool(site.SiteID, "CommentForum", "AllowNotSignedInCommenting"))
                {
                    var user = new Dna.Users.User(DnaDataReaderCreator, DnaDiagnostics, CacheManager);
                    user.CreateAnonymousUserForForum(site.SiteID, commentForum.ForumID, "");
                }
            }
        }