Пример #1
0
 public List <Post> GetAllPosts()
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         return(ctx.Posts.Include("Comments").ToList <Post>());
         // Obligatoriu de verificat in apelant rezultatul primit.
     }
 }
Пример #2
0
 public Comment GetCommentById(int id)
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         var items = from c in ctx.Comments where (c.CommentId == id) select c;
         return(items.Include(p => p.Post).SingleOrDefault());
     }
 }
Пример #3
0
        public int DeletePost(int id)
        {
            using (ModelDesignContainer ctx = new ModelDesignContainer())
            {
                return(ctx.Database.ExecuteSqlCommand("Delete From Post where postid =

               @p0", id));
            }
        }
Пример #4
0
 public Post GetPostById(int id)
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         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); // trebuie verificat in apelant
     }
 }
Пример #5
0
 public bool AddPost()
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         bool bResult = false;
         if (this.PostId == 0)
         {
             var it = ctx.Entry <Post>(this).State = System.Data.Entity.EntityState.Added;
             ctx.SaveChanges();
             bResult = true;
         }
         return(bResult);
     }
 }
Пример #6
0
 public Post UpdatePost(Post newPost)
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         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);
     }
 }
Пример #7
0
 public bool AddComment()
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         bool bResult = false;
         if (this == null || this.PostPostId == 0)
         {
             return(bResult);
         }
         if (this.CommentId == 0)
         {
             ctx.Entry <Comment>(this).State = System.Data.Entity.EntityState.Added;
             Post p = ctx.Posts.Find(this.PostPostId);
             ctx.Entry <Post>(p).State = System.Data.Entity.EntityState.Unchanged;
             ctx.SaveChanges();
             bResult = true;
         }
         return(bResult);
     }
 }
Пример #8
0
 public Comment UpdateComment(Comment newComment)
 {
     using (ModelDesignContainer ctx = new ModelDesignContainer())
     {
         Comment oldComment = ctx.Comments.Find(newComment.CommentId);
         // Deoarece parametrul este un Comment ar trebui verificata fiecare
         // proprietate din newComment daca are valoare atribuita si
         // daca valoarea este diferita de cea din bd.
         // Acest lucru il fac numai la modificarea asocierii.
         if (newComment.Text != null)
         {
             oldComment.Text = newComment.Text;
         }
         if ((oldComment.PostPostId != newComment.PostPostId) &&
             (newComment.PostPostId != 0))
         {
             oldComment.PostPostId = newComment.PostPostId;
         }
         ctx.SaveChanges();
         return(oldComment);
     }
 }