//public IActionResult KeyNote(long postId)
//{
// var result = _postDetialView.Execute(new PostDetailDataBind { PostId = postId });
// if (result == null)
// {
// RedirectToAction("Error", "Home");
// }
// TagCloudDataBind tagCloudDataBind = new TagCloudDataBind();
// var tagResult = _tagCloudView.Execute(tagCloudDataBind);
// Tuple<PostDetialViewModel, List<TagCloudViewModel>> tuple = new Tuple<PostDetialViewModel, List<TagCloudViewModel>>(result, tagResult);
// return View(tuple);
//}
public IActionResult Index(int page = 1, int pageSize = 10)
{
PostListDataBind postListDataBind = new PostListDataBind();
postListDataBind.PageIndex = page;
postListDataBind.PageSize = pageSize;
TagCloudDataBind tagCloudDataBind = new TagCloudDataBind();
var tagResult = _tagCloudView.Execute(tagCloudDataBind);
var resultModel = _postListView.Execute(postListDataBind);
//var ipAddr = _netWorkTool.GetRemoteIp();
Tuple <PageInfo <PostListViewModel>, List <TagCloudViewModel> > tuple = new Tuple <PageInfo <PostListViewModel>, List <TagCloudViewModel> >(resultModel, tagResult);
return(View(tuple));
}
public List <TagCloudViewModel> Execute(TagCloudDataBind command)
{
const string sql = "SELECT t.tag as TagName,count(t.post_id) as TagPostCount from tag t GROUP BY t.tag";
using (var conn = _dapperConnection.GetDataBaseConnection())
{
var result = conn.Query <TagCloudViewModel>(sql);
if (result != null && result.Count() > 0)
{
return(result.ToList());
}
}
return(null);
}
public IActionResult PostDetail(long postId)
{
var result = _postDetialView.Execute(new PostDetailDataBind {
PostId = postId
});
if (result == null)
{
RedirectToAction("Error", "Home");
}
TagCloudDataBind tagCloudDataBind = new TagCloudDataBind();
var tagResult = _tagCloudView.Execute(tagCloudDataBind);
Tuple <PostDetialViewModel, List <TagCloudViewModel> > tuple = new Tuple <PostDetialViewModel, List <TagCloudViewModel> >(result, tagResult);
return(View(tuple));
}
