/// <summary> /// Returnez toate Post-urile si Comment-urile corespunzatoare /// </summary> /// <returns></returns> public static List <Post> GetAllPosts() { using (Model2Container ctx = new Model2Container()) { return(ctx.Posts.Include("Comments").ToList <Post>()); } }
public static int DeletePost(int id) { using (Model2Container ctx = new Model2Container()) { return(ctx.Database.ExecuteSqlCommand("Delete From Post where postid = @p0", id)); } }
public static Comment GetCommentById(int id) { using (Model2Container ctx = new Model2Container()) { var items = from c in ctx.Comments where (c.Id == id) select c; return(items.Include(p => p.Post).SingleOrDefault()); } }
/// <summary> /// Returnez un Post si toate Comment-urile asociate lui /// </summary> /// <param name="id"></param> /// <returns></returns> public static Post GetPostById(int id) { using (Model2Container ctx = new Model2Container()) { var items = from p in ctx.Posts where (p.PostId == id) select p; if (items != null) { return(items.Include(c => c.Comments).SingleOrDefault()); } return(null); } }
public static bool AddPost(Post post) { using (Model2Container ctx = new Model2Container()) { 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 (Model2Container ctx = new Model2Container()) { // 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 (Model2Container ctx = new Model2Container()) { Comment oldComment = ctx.Comments.Find(newComment.Id); 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 (Model2Container ctx = new Model2Container()) { bool bResult = false; if (comment == null || comment.PostPostId == 0) { return(bResult); } if (comment.Id == 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); } }
public Service() { Model2Container context = new Model2Container(); _repository = new photoRepository(context); }