public void DeletePost(int id) { using (var context = new MyContext()) { var post = context.Posts.FirstOrDefault(t => t.PostId == id); if (post != null) { context.Posts.Remove(post); context.SaveChanges(); } } }
public void DeleteComment(int commentId) { using (var context = new MyContext()) { var comment = context.Comments.FirstOrDefault(t => t.CommentId == commentId); if (comment != null) { context.Comments.Remove(comment); context.SaveChanges(); } } }
public void DeleteUser(int id) { using (var context = new MyContext()) { var user = context.Users.FirstOrDefault(t => t.UserId == id); if (user != null) { context.Users.Remove(user); context.SaveChanges(); } } }
public void SavePieceContent(PieceContent piece) { using (var context = new MyContext()) { if (piece.PieceContentId == 0) { context.Posts.Attach(piece.Post); context.Pieces.Add(piece); } else { context.Pieces.Attach(piece); context.Entry(piece).State = EntityState.Modified; } context.SaveChanges(); } }
public void SavePost(Post post) { using (var context = new MyContext()) { if (post.PostId == 0) { context.Users.Attach(post.UserPosted); context.Posts.Add(post); } else { context.Posts.Attach(post); context.Entry(post).State = EntityState.Modified; } context.SaveChanges(); } }
public void SaveUser(User user) { using (var context = new MyContext()) { if (user.UserId == 0) { user.RegisterDate = DateTime.Now; context.Users.Add(user); } else { context.Users.Attach(user); context.Entry(user).State = EntityState.Modified; } context.SaveChanges(); } }
public void SaveComment(Comment comment) { using (var context = new MyContext()) { if (comment.CommentId == 0) { context.Users.Attach(comment.UserPosted); context.Posts.Attach(comment.Post); context.Comments.Add(comment); } else { context.Comments.Attach(comment); context.Entry(comment).State = EntityState.Modified; } context.SaveChanges(); } }
public void RemovePieceContent(int pieceId) { using (var context = new MyContext()) { var piece = context.Pieces.FirstOrDefault(t => t.PieceContentId == pieceId); if (piece != null) { context.Pieces.Remove(piece); context.SaveChanges(); } } }