public int getMostRecentBlogId() { var repo = new BlogsRepository(_connectionString); var bp = repo.MostRecentBlogId(); return(bp); }
public BlogPost GetBlogPostForId(int id) { var repo = new BlogsRepository(_connectionString); var bp = repo.GetBlogPostForId(id); return(bp); }
public void NewComment(Comment comment) { comment.Date = DateTime.Now; var repo = new BlogsRepository(_connectionString); repo.AddComment(comment); }
public void NewPost(BlogPost blogPost) { blogPost.Date = DateTime.Now; blogPost.PostedBy = "Poster"; var repo = new BlogsRepository(_connectionString); repo.AddBlogPost(blogPost); }
public BlogsController(BlogsRepository blogsRepository , BlogGalleryRepository blogGalleryRepository , IHostingEnvironment environment , FileConfig fileConfig) { _fileConfig = fileConfig; _blogGalleryRepository = blogGalleryRepository; _environment = environment; _blogsRepository = blogsRepository; }
public async Task Add_writes_to_database() { try { string connection = @"Server=(localdb)\mssqllocaldb;Database=BloggingTest;Trusted_Connection=True;ConnectRetryCount=0"; var options = new DbContextOptionsBuilder <BloggingContext>() .UseSqlServer(connection) .Options; //// Create the schema in the database //using (var context = new BloggingContext(options)) //{ // context.Database.EnsureCreated(); //} // Run the test against one instance of the context using (var context = new BloggingContext(options)) { IBlogRepository blogsRepository = new BlogsRepository(context); //var BlogsController = new BlogsController(blogsRepository); //var result = await BlogsController.GetBlogs(); } //Use a separate instance of the context to verify correct data was saved to database //using (var context = new BloggingContext(options)) //{ // Assert.AreEqual(1, context.Blogs.Count()); // Assert.AreEqual("http://sample.com", context.Blogs.Single().Url); //} } catch (Exception e) { } finally { } }
public int getHighestPage() { var repo = new BlogsRepository(_connectionString); return(repo.GetHighestPage()); }
public List <BlogPost> GetBlogPosts(int page) { var repo = new BlogsRepository(_connectionString); return(repo.GetBlogPosts(page)); }
public BlogsService(BlogsRepository repo) { _repo = repo; }
public ContactUsManagementController(ContactUsRepository ContactUsRepository, BlogsRepository blogsRepository) { _ContactUsRepository = ContactUsRepository; }
public ProductController(ProductRepository productRepository, ProductColorRepository productColorRepository, BlogsRepository blogsRepository, ProductTypeRepository productTypeRepository) { _productRepository = productRepository; _productColorRepository = productColorRepository; _productTypeRepository = productTypeRepository; }
public PostsModule() { var postsRepository = new PostsRepository(); var authorsRepository = new AuthorsRepository(); var blogsRepository = new BlogsRepository(); Get["/Posts"] = p => { var posts = postsRepository.GetAll(); return(View["Posts/index", new { Posts = posts, Title = "Nancy Blog", Description = "A simple blog demo built with Nancy" }]); }; Get["/Posts/{id}"] = p => { var post = postsRepository.Find(p.id); return(View["Posts/show", new { Post = post, Title = "Nancy Blog", Description = "A simple blog demo built with Nancy" }]); }; Get["/Posts/New"] = p => { var post = new Post(); var author = authorsRepository.Find(1); var blog = blogsRepository.Find(1); return(View["Posts/new", new { Post = post, Author = author, Blog = blog, Title = "Nancy Blog", Description = "A simple blog demo built with Nancy", Action = "Create" }]); }; Post["/Posts/Create"] = p => { Post post = this.Bind(); var addedPost = postsRepository.Add(post); if (post.PostId != addedPost.PostId) { return(Response.AsRedirect("/Posts")); } return(View[""]); }; Get["/Posts/{id}/Edit"] = p => { var post = postsRepository.Find(p.id); var author = authorsRepository.Find(1); var blog = blogsRepository.Find(1); return(View["Posts/edit", new { Post = post, Author = author, Blog = blog, Title = "Nancy Blog", Description = "A simple blog demo built with Nancy", Action = p.id + "/Update" }]); }; Post["/Posts/Update"] = p => { Post post = this.Bind(); var modifiedPost = postsRepository.Update(post); if (true) { return(Response.AsRedirect("/Posts")); } return(View[""]); }; }
public HomeController(ProductRepository productRepository, BlogsRepository blogsRepository, InfoRepository infoRepository) { _infoRepository = infoRepository; _blogsRepository = blogsRepository; _productRepository = productRepository; }
/* * -- Simple test query -- * * query TestQuery { * blogPosts { * blogPostID * title * blogText * postDate * blogPostAuthor { * authorID * firstName * lastName * emailID * } * } * } */ public BlogQuery(BlogsRepository blogsRepository) { /*Version: 1 get all*/ //Field<ListGraphType<ReservationType>>("reservations", // resolve: context => blogsRepository.GetQuery()); /*Version: 2 filtering*/ Field <ListGraphType <BlogType> >("blogPosts", arguments: new QueryArguments(new List <QueryArgument> { new QueryArgument <IdGraphType> { Name = "BlogPostID" }, new QueryArgument <StringGraphType> { Name = "Title" }, new QueryArgument <StringGraphType> { Name = "BlogText" }, new QueryArgument <DateGraphType> { Name = "PostDate" } }), resolve: context => { var query = blogsRepository.GetQuery(); var user = (ClaimsPrincipal)context.UserContext; var isUserAuthenticated = ((ClaimsIdentity)user.Identity).IsAuthenticated; var blogID = context.GetArgument <int?>("blogPostID"); if (blogID.HasValue) { if (blogID.Value <= 0) { context.Errors.Add(new ExecutionError("BlogID must be greater than zero!")); //Add messages to correct the error easily return(new List <BlogPost>()); } return(blogsRepository.GetQuery().Where(r => r.BlogPostID == blogID.Value)); } var postDate = context.GetArgument <DateTime?>("postDate"); if (postDate.HasValue) { return(blogsRepository.GetQuery() .Where(r => r.PostDate.Date == postDate.Value.Date)); } var postTitle = context.GetArgument <string>("title"); if (!postTitle.IsEmpty()) { return(blogsRepository.GetQuery() .Where(r => r.Title.ToString() == postTitle)); } return(query.ToList()); } ); }
public BlogsController(BlogsRepository repo, BlogHttpGraphqlClient blogHttpGraphqlClient) { _BlogsRepository = repo; _httpGraphqlClient = blogHttpGraphqlClient; }