public Datacontract.BlogResponse DeleteBlog(Datacontract.BlogRequest request) { bool result = false; using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { Blog deleteBlog = blog.Blogs.Where(e => e.BlogID == request.Delete.BlogId).Select(e => e).First(); blog.Blogs.Remove(deleteBlog); try { blog.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.BlogResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail }; }
public Datacontract.BlogResponse InsertBlog(Datacontract.BlogRequest request) { bool result = false; using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { foreach (Datacontract.Blog blg in request.Blog) { blog.Blogs.Add(new Blog() { Title = blg.Title, Description = blg.Description, TStamp = DateTime.Now }); } try { blog.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.BlogResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail }; }
public Datacontract.BlogResponse SelectBlog(Datacontract.BlogRequest request) { if (request.Select.BlogId == null) { throw new Exception("BlogId must be defined"); } Datacontract.BlogResponse response = new Datacontract.BlogResponse(); using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { response.SingleBlog = blog.Blogs.Where(e => e.BlogID == request.Select.BlogId).Select(e => new Datacontract.Blog() { Title = e.Title, Description = e.Description }).First(); } return response; }
public Datacontract.PostResponse SelectPosts(Datacontract.PostRequest request) { bool result = false; Datacontract.PostResponse response = new Datacontract.PostResponse(); if (request.SelectPost.PostID == null && request.DeletePost.PostID.HasValue) throw new Exception("Post Id cannot be null"); using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { try { List<int> cPost = request.SelectPosts.PostIds; response.Posts = blog.BlogPosts.Where(e => cPost.Contains(e.BlogID)).Select(e => new Datacontract.Post() { BlogID = e.BlogID, Name = e.Name, Email = e.Email, PostDetail = e.Post }).ToList(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.PostResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail, Posts = response.Posts }; }
public Datacontract.PostResponse SelectPost(Datacontract.PostRequest request) { bool result = false; Datacontract.PostResponse response = new Datacontract.PostResponse(); if (request.DeletePost.PostID == null && request.DeletePost.PostID.HasValue) throw new Exception("Post Id cannot be null"); using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { try { Datacontract.IPost cPost = request.DeletePost; BlogPost post = blog.BlogPosts.Where(e => e.BlogID == cPost.PostID).Select(e => e).FirstOrDefault(); response.Post = new Datacontract.Post() { BlogID = post.BlogID, PostDetail = post.Post, Name = post.Name, Email = post.Email }; result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.PostResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail, Post = response.Post }; }
public Datacontract.PostResponse DeletePost(Datacontract.PostRequest request) { bool result = false; if (request.DeletePost.PostID == null && request.DeletePost.PostID.HasValue) throw new Exception("Post Id cannot be null"); using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { Datacontract.IPost cPost = request.DeletePost; BlogPost post = blog.BlogPosts.Where(e => e.BlogID == cPost.PostID).Select(e => e).FirstOrDefault(); blog.BlogPosts.Remove(post); try { blog.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.PostResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail }; }
public Datacontract.PostResponse UpdatePost(Datacontract.PostRequest request) { bool result = false; using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { Datacontract.Post cPost = request.UpdatePost; BlogPost post = blog.BlogPosts.Where(e => e.BlogID == cPost.BlogID).Select(e => e).FirstOrDefault(); if (post != null) { post.BlogID = cPost.BlogID; post.Email = cPost.Email; post.Name = cPost.Name; post.TStamp = DateTime.Now; post.Post = cPost.PostDetail; } try { blog.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.PostResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail }; }
public Datacontract.PostResponse InsertPost(Datacontract.PostRequest request) { bool result = false; using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { Datacontract.Post cPost = request.InsertPost; BlogPost post = new BlogPost(); post.BlogID = cPost.BlogID; post.Email = cPost.Email; post.Name = cPost.Name; post.TStamp = DateTime.Now; post.Post = cPost.PostDetail; blog.BlogPosts.Add(post); try { blog.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } return new Datacontract.PostResponse() { Result = result ? Datacontract.DBResult.Success : Datacontract.DBResult.Fail }; }
public Datacontract.BlogResponse SelectBlogs(Datacontract.BlogRequest request) { Datacontract.BlogResponse response = new Datacontract.BlogResponse(); if (request.SelectBlogs.BlogId == null && request.SelectBlogs.BlogId.Count() <= 0) { throw new Exception("Blog ids required to get blogs from SelectBlogs"); } using (MyBlogEntities blog = new MyBlogEntities(GetConnectionStringEF())) { response.BlogList = blog.Blogs.Where(e => request.SelectBlogs.BlogId.Contains(e.BlogID)).Select(e => new Datacontract.Blog() { Title = e.Title, Description = e.Description }).ToList(); } return response; }