/// <summary>
/// 获取用户自己的Blog
/// </summary>
/// <param name="personId">PersonID</param>
/// <param name="pageIndex">页索引</param>
/// <param name="pageSize">页大小</param>
/// <returns></returns>
public async Task<List<BlogDTO>> GetOwnBlogs(long personId, int pageIndex, int pageSize)
{
using (KoalaBlogDbContext dbContext = new KoalaBlogDbContext())
{
List<BlogDTO> blogDtoList = null;
BlogHandler blogHandler = new BlogHandler(dbContext);
//1. 获取用户的Blogs集合。
var blogs = await blogHandler.GetBlogsByPersonId(personId, pageIndex, pageSize);
if(blogs.Count > 0)
{
PersonHandler perHandler = new PersonHandler(dbContext);
CommentHandler commentHandler = new CommentHandler(dbContext);
BlogXBlogHandler bxbHandler = new BlogXBlogHandler(dbContext);
EntityLikeHandler likeHandler = new EntityLikeHandler(dbContext);
BlogXContentHandler bxcHandler = new BlogXContentHandler(dbContext);
blogDtoList = new List<BlogDTO>();
foreach (var blog in blogs)
{
BlogDTO blogDto = blog.ToDTO();
//2. 判断Person对象是否为空，如果为空则获取。
if (blogDto.Person == null)
{
var personEntity = await perHandler.GetByIdAsync(blog.PersonID);
if (personEntity != null)
{
blogDto.Person = personEntity.ToDTO();
}
}
//3. 判断Contents集合是否为空，如果为空则获取。
if (blogDto.Contents == null)
{
List<Content> contentList = await bxcHandler.GetContentsAsync(blogDto.ID);
if (contentList != null && contentList.Count > 0)
{
blogDto.Contents = new List<ContentDTO>();
foreach (var content in contentList)
{
ContentDTO contentDto = content.ToDTO();
blogDto.Contents.Add(contentDto);
}
}
}
//4. 判断此Blog是否转发了其他Blog。
if (blogDto.BaseBlog == null)
{
Blog baseBlog = await bxbHandler.GetBaseBlogByBlogIdAsync(blogDto.ID);
if (baseBlog != null)
{
blogDto.BaseBlog = baseBlog.ToDTO();
//4.1 判断转发的Blog的Person对象是否为空，如果为空则获取。不需要获取头像。
if (blogDto.BaseBlog.Person == null)
{
var personEntity = await perHandler.GetByIdAsync(baseBlog.PersonID);
if (personEntity != null)
{
blogDto.BaseBlog.Person = personEntity.ToDTO();
}
}
//4.2 判断转发的Blog是否有发Contents。
if (blogDto.BaseBlog.Contents == null)
{
List<Content> contentList = await bxcHandler.GetContentsAsync(blogDto.BaseBlog.ID);
if (contentList != null && contentList.Count > 0)
{
blogDto.BaseBlog.Contents = new List<ContentDTO>();
foreach (var content in contentList)
{
ContentDTO contentDto = content.ToDTO();
blogDto.BaseBlog.Contents.Add(contentDto);
}
}
}
//4.3 获取转发的Blog的转发数量。
blogDto.BaseBlog.RepostCount = await bxbHandler.GetRepostCountAsync(blogDto.BaseBlog.ID);
//4.4 获取转发的Blog的评论数量。
blogDto.BaseBlog.CommentCount = await commentHandler.GetCommentCountAsync(blogDto.BaseBlog.ID);
//4.5 获取转发的Blog的点赞数量
blogDto.BaseBlog.LikeCount = await likeHandler.GetBlogLikeCountAsync(blogDto.BaseBlog.ID);
//4.6 获取转发的Blog是否已经点赞。
blogDto.BaseBlog.IsLike = await likeHandler.IsLikeAsync(personId, blogDto.BaseBlog.ID, typeof(Blog));
}
}
//5. 获取评论数量。
blogDto.CommentCount = await commentHandler.GetCommentCountAsync(blog.ID);
//6. 获取转发数量。
blogDto.RepostCount = await bxbHandler.GetRepostCountAsync(blog.ID);
//7. 获取点赞数量和用户是否已经点赞。
Tuple<int, bool> likeObj = await GetLikeObjectAsync(personId, blog.ID);
blogDto.IsLike = likeObj.Item2;
blogDto.LikeCount = likeObj.Item1;
blogDtoList.Add(blogDto);
}
}
return blogDtoList;
}
}
/// <summary>
/// 发表一篇Blog
/// </summary>
/// <param name="personId">PersonID</param>
/// <param name="content">Blog的内容</param>
/// <param name="attachContents">Blog的附件</param>
/// <param name="accessInfo">Blog的访问控制</param>
/// <param name="groupId">当Blog的访问控制为群可见则需要指定GroupID</param>
/// <param name="forwardBlogId">转发的BlogID</param>
/// <returns></returns>
public async Task<Blog> CreateBlogAsync(long personId, string content, BlogInfoAccessInfo accessInfo, long? groupId = null, List<long> attachContentIds = null, long? forwardBlogId = null)
{
using(var dbTransaction = _dbContext.Database.BeginTransaction())
{
try
{
BlogAccessControlHandler bacHandler = new BlogAccessControlHandler(_dbContext);
//1. 创建Blog对象并保存。
Blog blog = new Blog()
{
PersonID = personId,
Content = content,
IsDeleted = false
};
this.Add(blog);
await SaveChangesAsync();
//2. 判断是否有附件，有则建立与Blog的关联。
if (attachContentIds != null && attachContentIds.Count > 0)
{
ContentHandler contentHandler = new ContentHandler(_dbContext);
BlogXContentHandler bxcHandler = new BlogXContentHandler(_dbContext);
#region 检查attachContent集合。
List<Content> attachContents = await contentHandler.Fetch(x => attachContentIds.Contains(x.ID)).ToListAsync();
bool isDifferentType = attachContents.Select(x => x.Type).Distinct().Count() > 1;
if(isDifferentType)
{
throw new DisplayableException("不能发不同类型内容的Blog");
}
int photoCount = attachContents.Count(x => x.Type == ContentType.Photo);
int musicCount = attachContents.Count(x => x.Type == ContentType.Music);
int videoCount = attachContents.Count(x => x.Type == ContentType.Video);
if(photoCount > 6)
{
throw new DisplayableException("发表图片不能超过6张");
}
if (musicCount > 1)
{
throw new DisplayableException("发表音乐不能超过1首");
}
if (videoCount > 1)
{
throw new DisplayableException("发表视频不能超过1个");
}
#endregion
foreach (var attachContentId in attachContentIds)
{
BlogXContent bxc = new BlogXContent()
{
BlogID = blog.ID,
ContentID = attachContentId
};
bxcHandler.Add(bxc);
}
await SaveChangesAsync();
}
//3. 判断当前是否转发Blog，是则建立转发Blog与新Blog的关联。
if(forwardBlogId.HasValue)
{
//3.1 判断ForwardBlog是否存在。
Blog forwardBlog = await GetByIdAsync(forwardBlogId);
if(forwardBlog == null || forwardBlog.IsDeleted)
{
throw new DisplayableException("该Blog不存在或者已经被删除");
}
//3.2 判断ForwardBlog是否转发了Blog，如果是则关联2条Blog，否则只关联当前要转发的Blog。
BlogXBlogHandler bxbHandler = new BlogXBlogHandler(_dbContext);
BlogXBlog blogXblog = new BlogXBlog();
blogXblog.NewBlogID = blog.ID;
blogXblog.BaseBlogID = forwardBlog.ID;
blogXblog.IsBase = false;
//3.3 判断ForwardBlog是否有转发Blog。
Blog baseBlog = await bxbHandler.GetBaseBlogByBlogIdAsync(forwardBlog.ID);
if(baseBlog == null)
{
blogXblog.IsBase = true;
}
else
{
BlogXBlog baseBlogXblog = new BlogXBlog();
baseBlogXblog.NewBlogID = blog.ID;
baseBlogXblog.BaseBlogID = baseBlog.ID;
baseBlogXblog.IsBase = true;
bxbHandler.Add(baseBlogXblog);
}
bxbHandler.Add(blogXblog);
await SaveChangesAsync();
}
//4. 建立AccessControl访问控制。
BlogAccessControl blogAccessControl = new BlogAccessControl()
{
BlogID = blog.ID,
AccessLevel = accessInfo
};
bacHandler.Add(blogAccessControl);
await SaveChangesAsync();
//5. 判断如果访问控制为GroupOnly，则建立AccessControlXGroup关系。
if(accessInfo == BlogInfoAccessInfo.GroupOnly)
{
if(groupId == null)
{
throw new DisplayableException("未指定组");
}
BlogAccessControlXGroupHandler bacxgHandler = new BlogAccessControlXGroupHandler(_dbContext);
BlogAccessControlXGroup bacxg = new BlogAccessControlXGroup()
{
BlogAccessControlID = blogAccessControl.ID,
GroupID = (long)groupId
};
bacxgHandler.Add(bacxg);
await SaveChangesAsync();
}
dbTransaction.Commit();
return blog;
}
catch (Exception)
{
dbTransaction.Rollback();
throw;
}
}
}
/// <summary>
/// 获取用户关注的人Blog
/// </summary>
/// <param name="personId">PersonID</param>
/// <param name="groupId">GroupID</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">数量/页</param>
/// <returns></returns>
public async Task<List<BlogDTO>> GetBlogsAsync(long personId, long? groupId, int pageIndex, int pageSize)
{
using(KoalaBlogDbContext dbContext = new KoalaBlogDbContext())
{
List<BlogDTO> blogDtoList = null;
BlogHandler blogHandler = new BlogHandler(dbContext);
//1. 获取正在关注的人Blog集合。
var blogs = await blogHandler.GetBlogsAsync(personId, groupId, pageIndex, pageSize);
if (blogs.Count > 0)
{
PersonHandler perHandler = new PersonHandler(dbContext);
AvatarHandler avatarHandler = new AvatarHandler(dbContext);
CommentHandler commentHandler = new CommentHandler(dbContext);
BlogXBlogHandler bxbHandler = new BlogXBlogHandler(dbContext);
EntityLikeHandler likeHandler = new EntityLikeHandler(dbContext);
BlogXContentHandler bxcHandler = new BlogXContentHandler(dbContext);
blogDtoList = new List<BlogDTO>();
foreach (var blog in blogs)
{
BlogDTO blogDto = blog.ToDTO();
//2. 判断Person对象是否为空，如果为空则获取。
if (blogDto.Person == null)
{
var personEntity = await perHandler.GetByIdAsync(blog.PersonID);
if (personEntity != null)
{
blogDto.Person = personEntity.ToDTO();
//3.1 判断头像Url是否已经获取。
if (string.IsNullOrEmpty(blogDto.Person.AvatarUrl))
{
blogDto.Person.AvatarUrl = await avatarHandler.GetActiveAvatarUrlByPersonId(blogDto.Person.ID);
}
}
}
else
{
//2.2 如果Person对象不为空，判断头像Url是否已经获取。
if (string.IsNullOrEmpty(blogDto.Person.AvatarUrl))
{
blogDto.Person.AvatarUrl = await avatarHandler.GetActiveAvatarUrlByPersonId(blogDto.Person.ID);
}
}
//3. 判断Contents集合是否为空，如果为空则获取。
if (blogDto.Contents == null)
{
List<Content> contentList = await bxcHandler.GetContentsAsync(blogDto.ID);
if (contentList != null && contentList.Count > 0)
{
blogDto.Contents = new List<ContentDTO>();
foreach (var content in contentList)
{
ContentDTO contentDto = content.ToDTO();
blogDto.Contents.Add(contentDto);
}
}
}
//4. 判断此Blog是否转发了其他Blog。
if(blogDto.BaseBlog == null)
{
Blog baseBlog = await bxbHandler.GetBaseBlogByBlogIdAsync(blogDto.ID);
if(baseBlog != null)
{
blogDto.BaseBlog = baseBlog.ToDTO();
//4.1 判断转发的Blog的Person对象是否为空，如果为空则获取。不需要获取头像。
if (blogDto.BaseBlog.Person == null)
{
var personEntity = await perHandler.GetByIdAsync(baseBlog.PersonID);
if (personEntity != null)
{
blogDto.BaseBlog.Person = personEntity.ToDTO();
}
}
//4.2 判断转发的Blog是否有发Contents。
if (blogDto.BaseBlog.Contents == null)
{
List<Content> contentList = await bxcHandler.GetContentsAsync(blogDto.BaseBlog.ID);
if (contentList != null && contentList.Count > 0)
{
blogDto.BaseBlog.Contents = new List<ContentDTO>();
foreach (var content in contentList)
{
ContentDTO contentDto = content.ToDTO();
blogDto.BaseBlog.Contents.Add(contentDto);
}
}
}
//4.3 获取转发的Blog的转发数量。
blogDto.BaseBlog.RepostCount = await bxbHandler.GetRepostCountAsync(blogDto.BaseBlog.ID);
//4.4 获取转发的Blog的评论数量。
blogDto.BaseBlog.CommentCount = await commentHandler.GetCommentCountAsync(blogDto.BaseBlog.ID);
//4.5 获取转发的Blog的点赞数量
blogDto.BaseBlog.LikeCount = await likeHandler.GetBlogLikeCountAsync(blogDto.BaseBlog.ID);
//4.6 获取转发的Blog是否已经点赞。
blogDto.BaseBlog.IsLike = await likeHandler.IsLikeAsync(personId, blogDto.BaseBlog.ID, typeof(Blog));
}
}
//5. 获取用户是否收藏了Blog的Task。
Task<bool> isFavoriteTask = IsFavoriteAsync(personId, blog.ID);
//6. 获取评论数量的Task。
CommentManager commentManager = new CommentManager();
Task<int> commentCountTask = commentManager.GetCommentCountAsync(blog.ID);
//7. 获取转发数量的Task。
Task<int> repostCountTask = GetRepostCountAsync(blog.ID);
//8. 获取点赞数量和用户是否已经点赞的Task。
Task<Tuple<int, bool>> likeObjTask = GetLikeObjectAsync(personId, blog.ID);
blogDto.IsFavorite = await isFavoriteTask;
blogDto.CommentCount = await commentCountTask;
blogDto.RepostCount = await repostCountTask;
//9. 获取点赞数量和用户是否点赞的对象Tuple，赋值。
Tuple<int, bool> likeObj = await likeObjTask;
blogDto.IsLike = likeObj.Item2;
blogDto.LikeCount = likeObj.Item1;
blogDtoList.Add(blogDto);
}
}
return blogDtoList;
}
}
