コード例 #1
0
 public override void DeleteComment(int id)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Comments {Id = id};
     context.AttachTo("tblBlogs_Comments", obj);
     context.DeleteObject(obj);
     context.SaveChanges();
 }
コード例 #2
0
        public override void DeletePost(int id)
        {
            var context = new BlogsEntities();
            using (var transaction = new TransactionScope())
            {
                var post = context.tblBlogs_Posts.Include("Categories").Where(item => item.Id == id).FirstOrDefault();
                post.Categories.Clear();
                context.SaveChanges();
                var comments = context.tblBlogs_Comments.Where(item => item.PostId == post.Id);
                foreach (var comment in comments)
                {
                    context.DeleteObject(comment);
                }

                context.DeleteObject(post);
                context.SaveChanges();
                transaction.Complete();
            }
        }
コード例 #3
0
 public override void DeleteBlog(int id)
 {
     var context = new BlogsEntities();
     var obj = context.tblBlogs_Blogs.Where(item => item.Id == id).FirstOrDefault();
     if (obj != null)
     {
         context.DeleteObject(obj);
         context.SaveChanges();
     }
 }
コード例 #4
0
        public override void UpdatePost(Post post)
        {
            var context = new BlogsEntities();
            var obj = context.tblBlogs_Posts.Include("Categories").Where(item => item.Id == post.Id).FirstOrDefault();
            post.CopyToObject(obj);

            obj.Categories.Clear();
            if (post.Categories.Count > 0)
            {
                var categories =
                    context.tblBlogs_Categories.Where(
                        Utils.BuildContainsExpression<tblBlogs_Categories, int>(item => item.Id,
                                                                                post.Categories.Select(item => item.Id)));
                foreach (var category in categories)
                {
                    obj.Categories.Add(category);
                }
            }

            context.SaveChanges();
        }
コード例 #5
0
 public override void UpdateComment(Comment comment)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Comments {Id = comment.Id};
     context.AttachTo("tblBlogs_Comments", obj);
     BizObject<Comment, int>.CopyToObject(comment, obj);
     context.SaveChanges();
 }
コード例 #6
0
 public override void UpdateCategory(Category category)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Categories {Id = category.Id};
     context.AttachTo("tblBlogs_Categories", obj);
     BizObject<Category, int>.CopyToObject(category, obj);
     context.SaveChanges();
 }
コード例 #7
0
 public override void UpdateBlogroll(Blogroll blogroll)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Blogrolls {Id = blogroll.Id};
     context.AttachTo("tblBlogs_Blogrolls", obj);
     BizObject<Blogroll, int>.CopyToObject(blogroll, obj);
     context.SaveChanges();
 }
コード例 #8
0
 public override void UpdateBlog(Blog blog)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Blogs {Id = blog.Id};
     context.AttachTo("tblBlogs_Blogs", obj);
     blog.CopyToObject(obj);
     context.SaveChanges();
 }
コード例 #9
0
        public override int InsertPost(Post post)
        {
            var context = new BlogsEntities();
            var obj = new tblBlogs_Posts();
            post.CopyToObject(obj);

            if (post.Categories != null)
            {
                foreach (var category in post.Categories)
                {
                    var item = new tblBlogs_Categories {Id = category.Id};
                    context.AttachTo("tblBlogs_Categories", item);
                    obj.Categories.Add(item);
                }
            }

            context.AddTotblBlogs_Posts(obj);
            context.SaveChanges();
            return obj.Id;
        }
コード例 #10
0
 public override int InsertComment(Comment comment)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Comments();
     BizObject<Comment, int>.CopyToObject(comment, obj);
     context.AddTotblBlogs_Comments(obj);
     context.SaveChanges();
     return obj.Id;
 }
コード例 #11
0
 public override int InsertCategory(Category category)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Categories();
     BizObject<Category, int>.CopyToObject(category, obj);
     context.AddTotblBlogs_Categories(obj);
     context.SaveChanges();
     return obj.Id;
 }
コード例 #12
0
 public override int InsertBlogroll(Blogroll blogroll)
 {
     var context = new BlogsEntities();
     var obj = new tblBlogs_Blogrolls();
     BizObject<Blogroll, int>.CopyToObject(blogroll, obj);
     context.AddTotblBlogs_Blogrolls(obj);
     context.SaveChanges();
     return obj.Id;
 }
コード例 #13
0
 public override void IncreaseViewCount(int postId)
 {
     var context = new BlogsEntities();
     var post = context.tblBlogs_Posts.Where(item => item.Id == postId).First();
     post.ViewCount++;
     context.SaveChanges();
 }