public async Task <ActionResult <PostsData> > PostPostsData(PostsData postsData)
{
_context.PostsData.Add(postsData);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPostsData", new { id = postsData.PostId }, postsData));
}
public async Task <IActionResult> PutPostsData(int id, PostsData postsData)
{
if (id != postsData.PostId)
{
return(BadRequest());
}
_context.Entry(postsData).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PostsDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static PostListViewModel ToOverview(this PostsData <PostsNode> source, string baseCategory = "")
{
var posts = new List <PostOverview>();
foreach (var edge in source.EdgeList.Edges)
{
var ov = new PostOverview();
ov.Id = edge.Node.Id;
ov.Cursor = edge.Cursor;
ov.AuthorInfo = $"{edge.Node.Author.ToAuthorInfo()} am {edge.Node.Date.ToShortDateString()}";
ov.Categories = edge.Node.Categories.ToCategoryList(baseCategory);
ov.Excerpt = edge.Node.Excerpt;
ov.IsSticky = edge.Node.IsSticky;
ov.Title = edge.Node.Title;
ov.Date = edge.Node.Date;
ov.Link = $"/post/{ov.Id}";
posts.Add(ov);
}
var vm = new PostListViewModel
{
Posts = posts,
PageInfo = source.EdgeList.PageInfo
};
return(vm);
}
public ActionResult Search(string query)
{
var result = PostsData
.GetAll()
.AsQueryable()
.Where(post => post.Title.ToLower().Contains(query.ToLower()) ||
post.Author.FullName.ToLower().Contains(query.ToLower()))
.Select(PostViewModel.FromPost)
.ToList();
return(this.PartialView("_PostResult", result));
}
public ActionResult Index()
{
var data = PostsData
.GetAll()
.AsQueryable()
.Select(PostViewModel.FromPost)
.ToList();
return(this.View(data));
//var db = new ApplicationDbContext();
//var post = db.Posts.OrderByDescending(p => p.Date);
//return View(post.ToList());
}
public ActionResult GetTestData(DataTableSettings model, ExtraParam modelParam)
{
var dt = new PostsData();
var result = dt.Post.ToList();
var jsonData = GetJsonObject(result.Count(), model, result, p => new IComparable[]
{
p.Id,
p.Name,
p.Description,
p.Name + p.Description
});
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
