Example #1
0
        public static Post FindPostById(int postId)
        {
            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            Post requestedPost = blogDB.Posts.SingleOrDefault(p => p.PostID == postId);

            return requestedPost;
        }
Example #2
0
        public static void DeletePost(int postId)
        {
            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            Post deletedPost = blogDB.Posts.SingleOrDefault(p => p.PostID == postId);

            blogDB.DeleteObject(deletedPost);
            blogDB.SaveChanges();
        }
Example #3
0
        public static Post EditPost(int postId, string title, string postContent)
        {
            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            Post editedPost = blogDB.Posts.SingleOrDefault(p => p.PostID == postId);

            editedPost.PostTitle = title;
            editedPost.PostContent = postContent;
            blogDB.SaveChanges();

            return editedPost;
        }
Example #4
0
        public static Post CreatePost(string title, string postContent)
        {
            Post newPost = new Post();
            newPost.PostTitle = title;
            newPost.PostContent = postContent;
            newPost.PostDate = DateTime.Now;

            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            blogDB.Posts.AddObject(newPost);
            blogDB.SaveChanges();

            return newPost;
        }
Example #5
0
        public static Comment AddComment(int postId, string author, string text)
        {
            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            Comment comment = new Comment();

            comment.PostID = postId;
            comment.Author = author;
            comment.CommentText = text;

            blogDB.Comments.AddObject(comment);
            blogDB.SaveChanges();

            return comment;
        }
Example #6
0
        public static int CommentCount()
        {
            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();
            var count = blogDB.Comments.Count(p => p.CommentID >= 1);

            if (count != 0)
            {
                return count;
            }

            else
            {
                return 0;
            }
        }
Example #7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string requestPostId = Request.Params["id"];
            postId = Int32.Parse(requestPostId);

            Post viewedPost = BlogDAL.FindPostById(postId);

            this.LabelPostTitle.Text = viewedPost.PostTitle;
            this.LabelPostContent.Text = viewedPost.PostContent;
            this.LabelPostDate.Text = viewedPost.PostDate.ToString();
            this.HyperLinkEdit.NavigateUrl = "Admin/EditPost.aspx?id=" + postId.ToString();
            this.HyperLinkDelete.NavigateUrl = "Admin/DeletePost.aspx?id=" + postId.ToString();

            string str = postId.ToString();

            if (!Page.IsPostBack)
            {
                if (viewedPost.Comments.Count > 0)
                {
                    MultiViewComments.ActiveViewIndex += 1;
                }

                if (HttpContext.Current.User.Identity.IsAuthenticated)
                {
                    this.MultiViewEditDelete.ActiveViewIndex += 1;
                }
                else
                {
                    this.MultiViewEditDelete.ActiveViewIndex -= 1;
                }
            }

            CSCB766BlogDBEntities blogDB = new CSCB766BlogDBEntities();

            EntityDataSourceComments.WhereParameters.Add(new Parameter("PageId", TypeCode.Int32, postId.ToString()));
        }