//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();
}