// POST: api/Blogs
public void Post([FromBody] BlogVm value)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DevConnectionString"].ConnectionString))
{
var sqlString = string.Format("insert into dbo.Blog (Title , Body , CreatedDate , UpdatedDate) values ('{0}' , '{1}' , GETDATE() , GETDATE() );", value.Title, value.Body);
conn.Execute(sqlString);
}
}
public IActionResult Index(string searchTerm)
{
ViewBag.SearchTerm = searchTerm;
ViewBag.MetaDescription = Constants.BlogMetaDescription;
BlogVm blogVm = new BlogVm
{
FeaturedPosts = blogService.GetPosts(searchTerm, "en")
};
return(View(blogVm));
}
public ActionResult AllBlogs(int id)
{
IEnumerable <AllBlogsVm> blogs = this.service.GetAllBlogsFromCategory(id);
IEnumerable <BlogsCategoriesAdminVm> categories = this.service.GetAllCategories();
BlogVm vm = new BlogVm
{
Blogs = blogs,
Categories = categories
};
return(View(vm));
}
public ActionResult Search(string title)
{
IEnumerable <AllBlogsVm> blogs = this.service.GetBlogsByTitle(title);
IEnumerable <BlogsCategoriesAdminVm> categories = this.service.GetAllCategories();
BlogVm vm = new BlogVm
{
Blogs = blogs,
Categories = categories
};
return(View(vm));
}
// PUT: api/Blogs/5
public void Put(int id, [FromBody] BlogVm value, int Id)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DevConnectionString"].ConnectionString))
{
var sqlString = string.Format("UPDATE dbo.Blog SET Title = '{0}' , Body = '{1}' , UpdatedDate = GETDATE() WHERE Id = {2};", value.Title, value.Body, Id);
conn.Execute(sqlString);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
