public static bool AddPost(Post post)
{
using (var ctx = new ModelPostEntities())
{
var bResult = false;
if (post.PostId == 0)
{
var it = ctx.Entry(post).State = EntityState.Added;
ctx.SaveChanges();
bResult = true;
}
return(bResult);
}
}
public static Comment UpdateComment(Comment newComment)
{
using (var ctx = new ModelPostEntities())
{
var oldComment = ctx.Comments.Find(newComment.CommentId);
if (newComment.Text != null)
{
oldComment.Text = newComment.Text;
}
if (oldComment.PostPostId != newComment.PostPostId && newComment.PostPostId1 != 0)
{
oldComment.PostPostId = newComment.PostPostId;
}
ctx.SaveChanges();
return(oldComment);
}
}
public static Post UpdatePost(Post newPost)
{
using (var ctx = new ModelPostEntities())
{
// Ce e in bd. PK nu poate fi modificata
var oldPost = ctx.Posts.Find(newPost.PostId);
if (oldPost == null)
{
return(null);
}
oldPost.Description = newPost.Description;
oldPost.Domain = newPost.Domain;
oldPost.Date = newPost.Date;
ctx.SaveChanges();
return(oldPost);
}
}
public static bool AddComment(Comment comment)
{
using (var ctx = new ModelPostEntities())
{
var bResult = false;
if (comment == null || comment.PostPostId1 == 0)
{
return(bResult);
}
if (comment.CommentId == 0)
{
ctx.Entry(comment).State = EntityState.Added;
var p = ctx.Posts.Find(comment.PostPostId);
ctx.Entry(p).State = EntityState.Unchanged;
ctx.SaveChanges();
bResult = true;
}
return(bResult);
}
}