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