public void CommentForumsRead_CorrectInput_ReturnsValidList()
        {
            var siteList = mocks.DynamicMock<ISiteList>();
            var readerCreator = mocks.DynamicMock<IDnaDataReaderCreator>();
            var reader = mocks.DynamicMock<IDnaDataReader>();
            var site = mocks.DynamicMock<ISite>();
            var cacheManager = mocks.DynamicMock<ICacheManager>();
            var siteName = "h2g2";
            var siteId = 1;

            site.Stub(x => x.ModerationStatus).Return(ModerationStatus.SiteStatus.UnMod);
            site.Stub(x => x.IsEmergencyClosed).Return(false);
            site.Stub(x => x.SiteName).Return(siteName);
            site.Stub(x => x.SiteID).Return(siteId);
            site.Stub(x => x.IsSiteScheduledClosed(DateTime.Now)).Return(false);
            reader.Stub(x => x.HasRows).Return(true);
            reader.Stub(x => x.Read()).Return(true).Repeat.Once();
            reader.Stub(x => x.GetStringNullAsEmpty("sitename")).Return(siteName);
            readerCreator.Stub(x => x.CreateDnaDataReader("commentforumsreadbysitename")).Return(reader);
            siteList.Stub(x => x.GetSite(siteName)).Return(site);
            
            mocks.ReplayAll();

            var comments = new Comments(null, readerCreator, cacheManager, siteList);
            var forums = comments.GetCommentForumListBySite(site);

            Assert.AreEqual(1, forums.CommentForums.Count);
            readerCreator.AssertWasCalled(x => x.CreateDnaDataReader("commentforumsreadbysitename"));
        }

        Task<StacManResponse<Comment>> ICommentMethods.GetAll(string site, string filter = null, int? page = null, int? pagesize = null, DateTime? fromdate = null, DateTime? todate = null, Comments.Sort? sort = null, DateTime? mindate = null, DateTime? maxdate = null, int? min = null, int? max = null, Order? order = null)
        {
            var filterObj = ValidateAndGetFilter(filter);

            ValidateString(site, "site");
            ValidatePaging(page, pagesize);
            ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);

            var ub = new ApiUrlBuilder("/comments", useHttps: false);

            ub.AddParameter("site", site);
            ub.AddParameter("filter", filter);
            ub.AddParameter("page", page);
            ub.AddParameter("pagesize", pagesize);
            ub.AddParameter("fromdate", fromdate);
            ub.AddParameter("todate", todate);
            ub.AddParameter("sort", sort);
            ub.AddParameter("min", mindate);
            ub.AddParameter("max", maxdate);
            ub.AddParameter("min", min);
            ub.AddParameter("max", max);
            ub.AddParameter("order", order);

            return CreateApiTask<Comment>(ub, filterObj, "/comments");
        }

        Task<StacManResponse<Comment>> IPostMethods.GetComments(string site, IEnumerable<int> ids, string filter = null, int? page = null, int? pagesize = null, DateTime? fromdate = null, DateTime? todate = null, Comments.Sort? sort = null, DateTime? mindate = null, DateTime? maxdate = null, int? min = null, int? max = null, Order? order = null)
        {
            var filterObj = ValidateAndGetFilter(filter);

            ValidateString(site, "site");
            ValidateEnumerable(ids, "ids");
            ValidatePaging(page, pagesize);
            ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);

            var ub = new ApiUrlBuilder(String.Format("/posts/{0}/comments", String.Join(";", ids)), useHttps: false);

            ub.AddParameter("site", site);
            ub.AddParameter("filter", filter);
            ub.AddParameter("page", page);
            ub.AddParameter("pagesize", pagesize);
            ub.AddParameter("fromdate", fromdate);
            ub.AddParameter("todate", todate);
            ub.AddParameter("sort", sort);
            ub.AddParameter("min", mindate);
            ub.AddParameter("max", maxdate);
            ub.AddParameter("min", min);
            ub.AddParameter("max", max);
            ub.AddParameter("order", order);

            return CreateApiTask<Comment>(ub, filterObj, "/posts/{ids}/comments");
        }

 protected RealExTransactionRequest(string secret, string merchantId, string account, string orderId, Amount amount, Card card, Comments comments)
     : base(secret, merchantId, account, orderId, comments)
 {
     SignatureProperties = () => new[] { Amount.Value.ToString(), Amount.Currency.CurrencyName(), Card.Number };
     Amount = amount;
     Card = card;
 }

 public RealEx3DVerifyRequest(string secret, string merchantId, string account, string orderId, Amount amount, Card card, string paRes, Comments comments)
     : base(secret, merchantId, account, orderId, amount, card, comments)
 {
     PaRes = paRes;
     Type = "3ds-verifysig";
     IsSecure = true;
 }

        public string AddComment(int postID, string commentTxt)
        {
            Comments comment = new Comments();
            comment.MemberId = Context.Session["memberID"].ToString();
            comment.CommentText = commentTxt;
            comment.PostId = postID;
            messageDAL.InsertComment(comment);

            //Insert notification
            NotificationDAL notificationDAL = new NotificationDAL();

            Post aPost = new Post(postID);

            List<Member> MemberList = new List<Member>();
            MemberList = notificationDAL.GetPostOwner(aPost);
            string friendId = MemberList[0].MemberId;
            Member aFriend = new Member(friendId);

            Member aMember = new Member(Context.Session["memberID"].ToString());

            if (aMember.MemberId != aFriend.MemberId)
            {
                notificationDAL.InsertCommentedOnPostNotification(aMember, aFriend, aPost);
            }
            //Refreshing the Comment count
            Post post = new Post();
            post.PostId = comment.PostId;

            return messageDAL.CountComments(post).ToString();
        }

 public void GetComment()
 {
     string connectionString = ConfigurationManager.AppSettings.Get("connString");
     Comments commentObj = new Comments();
     commentObj.CommentId = int.Parse(Request.QueryString["CommentId"].ToString());
     BusinessLayer businessObj = new BusinessLayer ();
     DataSet dsComment = businessObj.getComments(commentObj, connectionString);
     txtComment.Text = dsComment.Tables[0].Rows[0][0].ToString();
 }

 public string Create(Comments Model)
 {
     //Bll实例化放action里面 为了不让每次都实例化 产生废代码
     CommentsBll bll = new CommentsBll();
     //控制器里直接返回Bll里的返回结果 不写任何逻辑代码
     //保存的企业ID从登录信息里面取 所以必须要在这里赋值 因为登录信息是在BaseController里的
     Model.EnterpriseID = LoginUser.UserBasic.EnterpriseID;
     return bll.AddOrUpdate(Model);
 }

 public void GetComments()
 {
     string connectionString = ConfigurationManager.AppSettings.Get("connString");
     Comments commentObj = new Comments();
     commentObj.AdviceId = int.Parse(Session["AdviceId"].ToString());
     BusinessLayer businessLayerObj = new BusinessLayer();
     DataSet dsComment = businessLayerObj.SelectComment(commentObj, connectionString);
     gvShowComments.DataSource = dsComment;
     gvShowComments.DataBind();
 }

 public RealExAuthRequest(string secret, string merchantId, string account, string orderId, Amount amount, Card card, TssInfo tssInfo, bool autoSettle, string custNum, string prodId, string varRef, Comments comments)
     : base(secret, merchantId, account, orderId, amount, card, comments)
 {
     TssInfo = tssInfo;
     CustNum = custNum;
     ProdId = prodId;
     VarRef = varRef;
     Type = "auth";
     AutoSettle = new AutoSettle(autoSettle);
 }

 protected void SaveComment()
 {
     string connectionString = ConfigurationManager.AppSettings.Get("connString");
     Comments comment = new Comments();
     comment.CommentDateTime = DateTime.Now;
     comment.Username = Session["Username"].ToString();
     comment.AdviceId = int.Parse(Session["AdviceId"].ToString());
     comment.CommentsField = txtComment.Text;
     BusinessLayer businessLayerObj = new BusinessLayer();
     businessLayerObj.InsertComment(comment, connectionString);
 }

 public ActionResult AddComment(FormCollection form)
 {
     int id = int.Parse(form["id"].ToString());
     string comment = form["comment"].ToString();
     using (var db = new RazomContext())
     {
         Comments c = new Comments { PlaceID = id, Message = comment };
         db.Comments.Add(c);
         db.SaveChanges();
     }
     return RedirectToAction("Show", new { id=id});
 }

 protected void btnPost_Click(object sender, EventArgs e)
 {
     objComments = new Comments();
     objComments.CommentID = 0;
     objComments.BugID = intBugID;
     objComments.Name = Server.HtmlEncode(txtName.Text.Trim());
     objComments.Comment = Server.HtmlEncode(txtComments.Text.Trim());
     int i=objComments.postComments();
     if (i == 1)
     {
         fillComments();
     }
 }

 public void Add_Comment()
 {
     //Act
      Comments testComment = new Comments("TestComment", "Comment to add for testing", m_ParentTaskID);
      int initalCommentCount = m_ScrumToolDBContext.Comments.Count();
      //Arrange
      m_CommentController.Create(testComment);
      //Assert
      m_ScrumToolDBContext.Comments.Should().NotBeNullOrEmpty()
      		.And.HaveCount(initalCommentCount + 1, "Inital Comment Count + 1");
      m_ScrumToolDBContext.Comments.Last().ShouldBeEquivalentTo(testComment,
      		options => options.Excluding(c => c.ID), "The last comment object in the table should be the testComment");
 }

 public void UpdateComment()
 {
     string connectionString = ConfigurationManager.AppSettings.Get("connString");
     Comments commentObj = new Comments();
     if (txtComment.Text.Equals(string.Empty) == false)
     {
         commentObj.CommentsField = txtComment.Text;
         commentObj.CommentId = int.Parse(Request.QueryString["CommentId"].ToString());
         BusinessLayer businessObj = new BusinessLayer();
         businessObj.UpdateComment(commentObj, connectionString);
         Response.Redirect("VoteAndCommentInfo.aspx");
     }
     else
         lblError.Text = "Blank Comment Cannot Be Submitted";
 }

 private void fillComments()
 {
     SqlDataReader dr = null;
     objComments = new Comments();
     objComments.BugID = intBugID;
     dr=(SqlDataReader)objComments.getallComments();
     if (dr.HasRows)
     {
         dlShowComments.DataSource = dr;
         dlShowComments.DataBind();
     }
     else
     {
         lblError.Text = "No Comments Found";
     }
 }

    protected void addcomment(object sender, ImageClickEventArgs e)
    {
        Security.UserInfo usr = new Security.UserInfo();
        string username = Session["USERNAME"].ToString();
        Security.UserInfo usrs = usr.getUserProfileFromEmail(username);

        Comments com = new Comments();
        string brandid = Request.QueryString["id"];
        com.BrandID =""+ brandid+"";
        com.Comment = txtdiscption.InnerText;
        com.UserID = usrs.UserID;
        com.Deleted = false;
        com.Date = System.DateTime.Now;
        com.PostAsAnonymous = false;
        com.BrandCommentID = 0;
        com.CreateComment(com);
    }

    public void info()
    {
        string t = Request.QueryString["id"];
           Brand brand = new Brand();
           int brandid = int.Parse(t);
           brand = brand.getBrandDetails(brandid.ToString());

           brandlogo.Src = "Images/" + brand.Logo;
           brandlogo.Width = 100;
           brandlogo.Height = 80;
           description.InnerText = brand.BrandDescription;
           name.Text = brand.BrandName;
           website.HRef = "http://" + brand.Website;
           website.InnerText = brand.Website;

           Comments comments = new Comments();
           List<Comments> topcomments = comments.TopThreeComments(5);

           Table tblComments = new Table();

           tblComments.Width = Unit.Percentage(100);
           tblComments.Height = Unit.Percentage(100);
           TableRow tblrowcom = new TableRow();
           TableCell tblcellcom = new TableCell();

           for (int j = 0; j < topcomments.Count; j++)
           {
               tblcellcom.Text = topcomments[j].Comment;
               tblrowcom.Cells.Add(tblcellcom);
               tblComments.Controls.Add(tblrowcom);
               tblcellcom = new TableCell();
               tblrowcom = new TableRow();

               tblcellcom.Text = topcomments[j].Date.ToString();
               tblrowcom.Cells.Add(tblcellcom);
               tblComments.Controls.Add(tblrowcom);
               tblcellcom = new TableCell();
               tblrowcom = new TableRow();

           }
           phbrand.Controls.Add(tblComments);
    }

        void associations_can_be_added_directly_to_gemini()
        {
            before = () =>
            {
                comments = new Comments();

                seed = new Seed();

                seed.PurgeDb();

                seed.CreateTable("Blogs", new dynamic[] 
                {
                    new { Id = "int", Identity = true, PrimaryKey = true },
                    new { Title = "nvarchar(255)" },
                    new { Body = "nvarchar(max)" }
                }).ExecuteNonQuery();

                seed.CreateTable("Comments", new dynamic[] 
                {
                    new { Id = "int", Identity = true, PrimaryKey = true },
                    new { BlogId = "int", ForeignKey = "Blogs(Id)" },
                    new { Text = "nvarchar(1000)" }
                }).ExecuteNonQuery();

                blogId = new { Title = "Some Blog", Body = "Lorem Ipsum" }.InsertInto("Blogs");

                commentId = new { BlogId = blogId, Text = "Comment 1" }.InsertInto("Comments");
            };

            it["change tracking methods exist when changes is mixed in"] = () =>
            {
                act = () => comment = comments.Single(commentId);

                it["returns blog associated with comment"] = () =>
                {
                    (comment.Blog().Id as object).should_be(blogId as object);
                };
            };
        }

        public void CommentCreate_AsPreMod_ReturnCorrectError()
        {            
            var siteName = "h2g2";
            var siteId = 1;
            var uid = "uid";
            var text = "test text";
            var siteList = mocks.DynamicMock<ISiteList>();
            var readerCreator = mocks.DynamicMock<IDnaDataReaderCreator>();
            var site = mocks.DynamicMock<ISite>();
            var reader = mocks.DynamicMock<IDnaDataReader>();
            var cacheManager = mocks.DynamicMock<ICacheManager>();
            var callingUser = mocks.DynamicMock<ICallingUser>();
            var commentForum = new CommentForum { Id = uid, SiteName = siteName, ModerationServiceGroup = ModerationStatus.ForumStatus.PreMod };
            var commentInfo = new CommentInfo { text = text };

            callingUser.Stub(x => x.IsSecureRequest).Return(true);

            callingUser.Stub(x => x.UserID).Return(1);
            callingUser.Stub(x => x.IsUserA(UserTypes.SuperUser)).Return(false).Constraints(Is.Anything());

            cacheManager.Stub(x => x.GetData("")).Return(null).Constraints(Is.Anything());

            site.Stub(x => x.SiteID).Return(siteId);
            site.Stub(x => x.IsEmergencyClosed).Return(false);
            site.Stub(x => x.IsSiteScheduledClosed(DateTime.Now)).Return(false);

            reader.Stub(x => x.HasRows).Return(true);
            reader.Stub(x => x.Read()).Return(true).Repeat.Once();

            readerCreator.Stub(x => x.CreateDnaDataReader("commentcreate")).Return(reader);

            siteList.Stub(x => x.GetSite(siteName)).Return(site);
            mocks.ReplayAll();

            var comments = new Comments(null, readerCreator, cacheManager, siteList);
            comments.CallingUser = callingUser;
            var comment = comments.CreateComment(commentForum, commentInfo);

            Assert.IsNotNull(comment);
            readerCreator.AssertWasCalled(x => x.CreateDnaDataReader("commentcreate"));
        }