public bool AddPost(Post post) { using (ModelSelfReference ctx = new ModelSelfReference()) { bool bResult = false; if (post.PostId == Guid.Empty) { var it = ctx.Entry <Post>(post).State = EntityState.Added; ctx.SaveChanges(); bResult = true; } return(bResult); } }
public Post UpdatePost(Post newPost) { using (ModelSelfReference ctx = new ModelSelfReference()) { Post oldPost = ctx.Posts.Find(newPost.PostId); if (oldPost == null) // nu exista in bd { return(null); } oldPost.Description = newPost.Description; oldPost.Domain = newPost.Domain; oldPost.Date = newPost.Date; ctx.SaveChanges(); return(oldPost); } }
public bool AddComment(Comment comment) { using (ModelSelfReference ctx = new ModelSelfReference()) { bool bResult = false; if (comment == null || comment.PostPostId == Guid.Empty) { return(bResult); } if (comment.CommentId == Guid.Empty) { ctx.Entry <Comment>(comment).State = EntityState.Added; Post p = ctx.Posts.Find(comment.PostPostId); ctx.Entry <Post>(p).State = EntityState.Unchanged; ctx.SaveChanges(); bResult = true; } return(bResult); } }
public Comment UpdateComment(Comment newComment) { using (ModelSelfReference ctx = new ModelSelfReference()) { Comment oldComment = ctx.Comments.Find(newComment.CommentId); // Deoarece parametrul este un Comment ar trebui verificata fiecare // proprietate din newComment daca are valoare atribuita si // daca valoarea este diferita de cea din bd. // Acest lucru il fac numai la modificarea asocierii. if (newComment.Text != null) { oldComment.Text = newComment.Text; } if ((oldComment.PostPostId != newComment.PostPostId) && (newComment.PostPostId != Guid.Empty)) { oldComment.PostPostId = newComment.PostPostId; } ctx.SaveChanges(); return(oldComment); } }