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