public bool UpdatePost(ref PostBDO postBDO, ref string message) { message = "post updated successfully"; var ret = true; using (var BEntities = new BlogEntities()) { var postId = postBDO.PostId; Post postInDB = (from p in BEntities.Posts where p.PostId == postId select p).FirstOrDefault(); //check post if (postInDB == null) { throw new Exception("No post with ID " + postBDO.PostId + " found."); } //update post postInDB.PostTitle = postBDO.PostTitle; postInDB.PostContent = postBDO.PostContent; postInDB.RowVersion = postBDO.RowVersion; BEntities.Posts.Attach(postInDB); BEntities.Entry(postInDB).State = System.Data.Entity.EntityState.Modified; var num = BEntities.SaveChanges(); postBDO.RowVersion = postInDB.RowVersion; if (num != 1) { ret = false; message = "no post is updated"; } } return(ret); }
public bool CreatePost(ref PostBDO postBDO, ref string message) { message = "post created"; var ret = true; using (var BEntities = new BlogEntities()) { var maxId = 0; var maxIdPost = BEntities.Posts.OrderByDescending(i => i.PostId).FirstOrDefault(); if (maxIdPost != null) { maxId = maxIdPost.PostId; } var postId = maxId + 1; //var postId = postBDO.PostId; Post postToDB = new Post { PostId = postBDO.PostId, PostTitle = postBDO.PostTitle, PostContent = postBDO.PostContent, PostDateTime = DateTime.Now }; BEntities.Posts.Add(postToDB); var num = BEntities.SaveChanges(); if (num != 1) { ret = false; message = "no post created"; } } return(ret); }