public RoleViewModel FindById(int id)
{
return(Mapper.Map <Role, RoleViewModel>(roleRepository.FindSingle(s => s.Id == id)));
}
public PostViewModel GetById(int id)
{
return(Mapper.Map <Post, PostViewModel>(_postRepository.FindSingle(s => s.Id == id)));
}
public void Delete(int userId)
{
var user = userRepository.FindSingle(s => s.Id == userId);
userCUDRepository.Remove(user);
}
public DetailPostViewModel GetDetail(int id)
{
// lay chi tiet post theo id
var post = GetById(id);
// lay user theo post
var user = _userRepository.FindSingle(s => s.Id == post.UserId);
// lay danh sach tag theo post id
var tags = from t in _tagRepository.FindAll()
join pt in _postTagRepository.FindAll(s => s.PostId == id)
on t.Id equals pt.TagId
//where pt.PostId == id
select new TagViewModel
{
Id = t.Id,
TagName = t.TagName
};
// lay danh sach category theo postid
var categories = from pc in _postCategoryRepository.FindAll(s => s.PostId == id)
join c in _categoryRepository.FindAll()
on pc.CategoryId equals c.Id
//where pc.PostId == id
select new CategoryViewModel
{
Id = c.Id,
CategoryName = c.CategoryName
};
// lay danh sach comment
var comments = from cm in _commentRepository.FindAll()
join p in _postRepository.FindAll()
on cm.PostId equals p.Id
join us in _userRepository.FindAll()
on p.UserId equals us.Id
where cm.PostId == id && cm.Status == true
select new CommentInPostViewModel
{
UserName = us.UserName,
CreateDate = cm.CreateDate,
Content = cm.Content
};
//get previous post
var previousPost = _postRepository.FindAll(s => s.Id < id).ProjectTo <PostViewModel>().LastOrDefault();
//get next post
var nextPost = _postRepository.FindAll(s => s.Id > id).ProjectTo <PostViewModel>().FirstOrDefault();
var postViewModel = new DetailPostViewModel
{
PostId = post.Id,
Title = post.Title,
Content = post.Content,
Tags = tags,
Categories = categories,
Avatar = user.Avatar,
Author = user.FirstName,
Comments = comments.OrderByDescending(s => s.CreateDate),
DateAgo = DateFormat.GetPrettyDateAgo(post.CreateDate),
PreviousPost = previousPost,
NextPost = nextPost
};
return(postViewModel);
}
public void Delete(string bussinessRoleId)
{
var businessRole = businessRoleRepository.FindSingle(s => s.Id == bussinessRoleId);
brCUDRepository.Remove(businessRole);
}
