//update comment public void UpdateComment(Comment comment) { SovaContext db = new SovaContext(); db.Comments.Update(comment); db.SaveChanges(); }
//update post public void UpdatePost(Post post) { SovaContext db = new SovaContext(); db.Posts.Update(post); db.SaveChanges(); }
public void UpdateUser(FrameworkTables.User user) { SovaContext db = new SovaContext(); db.Update(user); db.SaveChanges(); }
//create new comment public void CreateComment(Comment comment) { SovaContext db = new SovaContext(); comment.Id = db.Comments.Max(x => x.Id) + 1; comment.CreateDate = DateTime.Now; db.Add(comment); db.SaveChanges(); }
//create new post public void CreatePost(Post post) { SovaContext db = new SovaContext(); post.Id = db.Posts.Max(x => x.Id) + 1; post.CreationDate = DateTime.Now; db.Add(post); db.SaveChanges(); }
//delete comment public bool DeleteComment(int commentId) { SovaContext db = new SovaContext(); var comment = db.Comments.Find(commentId); if (comment == null) { return(false); } db.Remove(comment); db.SaveChanges(); return(true); }
//delete post public bool DeletePost(int postId) { SovaContext db = new SovaContext(); var post = db.Posts.Find(postId); if (post == null) { return(false); } db.Remove(post); db.SaveChanges(); return(true); }
public bool DeleteUser(int userId) { SovaContext db = new SovaContext(); var user = db.FrameworkUsers.Find(userId); if (user == null) { return(false); } db.Remove(user); db.SaveChanges(); return(true); }
public void CreateUser(FrameworkTables.User user) { SovaContext db = new SovaContext(); var tmpList = db.Users.ToList(); if (tmpList.Count() == 0) { user.Id = 1; } else { user.Id = db.FrameworkUsers.Max(x => x.Id) + 1; } db.Add(user); db.SaveChanges(); }