public static bool AddPost(Post post) { using (ModelDesignContainer ctx = new ModelDesignContainer()) { bool bResult = false; if (post.PostId == 0) { var it = ctx.Entry <Post>(post).State = EntityState.Added; ctx.SaveChanges(); bResult = true; } return(bResult); } }
public static Post UpdatePost(Post newPost) { using (ModelDesignContainer ctx = new ModelDesignContainer()) { // Ce e in bd. PK nu poate fi modificata 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 static Comment UpdateComment(Comment newComment) { using (ModelDesignContainer ctx = new ModelDesignContainer()) { Comment oldComment = ctx.Comments.Find(newComment.CommentId); if (newComment.Text != null) { oldComment.Text = newComment.Text; } if ((oldComment.PostPostId != newComment.PostPostId) && (newComment.PostPostId != 0)) { oldComment.PostPostId = newComment.PostPostId; } ctx.SaveChanges(); return(oldComment); } }
// Comment table public static bool AddComment(Comment comment) { using (ModelDesignContainer ctx = new ModelDesignContainer()) { bool bResult = false; if (comment == null || comment.PostPostId == 0) { return(bResult); } if (comment.CommentId == 0) { 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); } }