Пример #1
0
        public void RemovePost(int postId)
        {
            try
            {
                using (var context = new ChatUp_DBEntities())
                {
                    var query = (from p in context.Post
                                 where p.Id == postId
                                 select p).FirstOrDefault();
                    if (query == null) throw new FaultException("Post not found");

                    context.Post.Remove(query);
                    context.SaveChanges();
                }
            }
            catch (Exception exception)
            {
                throw new FaultException(exception.Message);
            }
        }
Пример #2
0
 public void SubmitChat(Post post)
 {
     try
     {
         if (post == null) throw new Exception();
         using (var context = new ChatUp_DBEntities())
         {
             var newPost = new Post
             {
                 Submitter = post.Submitter,
                 ChatRoomId = post.ChatRoomId,
                 Comment = post.Comment,
                 TimeSubmitted = post.TimeSubmitted
             };
             context.Post.Add(newPost);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw new FaultException<Exception>(ex);
     }
 }
Пример #3
0
 public ICollection<Post> GetPosts(int chatRoomId)
 {
     try
     {
         List<Post> posts;
         using (var context = new ChatUp_DBEntities())
         {
             posts = context.Post.Where(x => x.ChatRoomId == chatRoomId).Select(y => new Post
             {
                 ChatRoomId = y.ChatRoomId,
                 Id = y.Id,
                 Comment = y.Comment,
                 Submitter = y.Submitter,
                 TimeSubmitted = y.TimeSubmitted
             }).ToList();
         }
         if (posts.Count <= 0) throw new FaultException("No posts found");
         return posts;
     }
     catch (Exception ex)
     {
         throw new FaultException(ex.Message);
     }
 }