public async Task <List <ArticleDto> > GetAllArticlesByUserID(Guid userid)
{
using (var articleSvc = new ArticleService())
{
var list = await articleSvc.GetAllAsync().Include(m => m.User).Where(m => m.UserID == userid)
.Select(m => new Dto.ArticleDto()
{
Title = m.Title,
BadCount = m.BadCount,
GoodCount = m.GoodCount,
Email = m.User.Email,
Content = m.Content,
CreateTime = m.CreateTime,
ID = m.ID,
ImagePath = m.User.ImagePath
})
.ToListAsync();
using (IArticleToCategoryService articleToCategoryService = new ArticleToCategoryService())
{
foreach (var articleDto in list)
{
var cates = await articleToCategoryService.GetAllAsync().Include(m => m.BlogCategory).Where(m => m.ArticleID == articleDto.ID).ToListAsync();
articleDto.CategoryIDs = cates.Select(m => m.CategoryID).ToArray();
articleDto.CategoryNames = cates.Select(m => m.BlogCategory.CategoryName).ToArray();
}
return(list);
}
}
}
public async Task <int> GetDataCount(Guid userId)
{
using (BlogSystem.IdAL.IArticleService articleService = new ArticleService())
{
return(await articleService.GetAllAsync().CountAsync(m => m.UseId == userId));
}
}
public async Task <ArticleDto> GetOneArticleById(Guid articleId)
{
using (BlogSystem.IdAL.IArticleService articleService = new ArticleService())
{
var data = await articleService.GetAllAsync()
.Include(m => m.User)
.Where(m => m.Id == articleId)
.Select(m => new Dto.ArticleDto()
{
Id = m.Id,
BadCount = m.BadCount,
Title = m.Title,
Content = m.Content,
CreateTime = m.CreateTime,
Email = m.User.Email,
GoodCount = m.GoodCount,
ImagePath = m.User.ImagePath,
}).FirstAsync();
using (IArticleToCategoryService articleToCategoryService = new ArticleToCategory())
{
var cates = await articleToCategoryService.GetAllAsync().Include(m => m.BlogCategory).Where(m => m.ArticleId == data.Id).ToListAsync();
data.CategoryIds = cates.Select(m => m.BlogCategoryId).ToArray();
data.CategoryNames = cates.Select(m => m.BlogCategory.CategoryName).ToArray();
return(data);
}
}
}
public async Task <int> RemoveArticle(Guid articleId) //根据文章Id删除
{
using (IArticleService articleSvc = new ArticleService())
{
var data = await articleSvc.GetAllAsync().FirstOrDefaultAsync(m => m.Id == articleId);
var acid = data.Id;
using (IArticleToCategoryService articleToCategoryService = new ArticleToCategoryService())
{
//var article=await articleToCategoryService.GetAllAsync().Include(m => m.Article).Where(m => m.ArticleId == acid).ToListAsync();
//if (article.Count==0) //说明该文章未被分类可以进行删除操作
//{
// await articleSvc.RemoveAsync(data);
// return 1;
//}
//else
//{
// return 0;
//}
await articleSvc.RemoveAsync(data);
return(1);
}
}
}
public async Task <bool> ExistsArticle(Guid articleId)
{
using (BlogSystem.IdAL.IArticleService articleService = new ArticleService())
{
return(await articleService.GetAllAsync().AnyAsync(predicate: m => m.Id == articleId));
}
}
public async Task <List <ArticleDto> > GetAllArticlesByUserId(Guid userId)
{
using (IArticleService articleSvc = new ArticleService())
{
var data = await articleSvc.GetAllAsync()
.Include(m => m.User)
.Where(m => m.UserId == userId)
.Where(m => m.IsRemoved == false)
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
Content = m.Content,
GoodCount = m.GoodCounnt,
BadCount = m.BadCount,
CreateTime = m.CreateTime,
State = m.State,
IsStick = m.IsStick
}).ToListAsync();
return(data);
//using (IArticleToCategoryService articleToCategorySvc = new ArticleToCategoryService())
//{
// var cate = await articleToCategorySvc.GetAllAsync()
// .Include(m => m.BlogCategory)
// .Where(m => m.ArticleId == data.Id).ToListAsync();
// data.CategoryIds = cate.Select(m => m.BlogCategoryId).ToArray();
// data.CategoryNames = cate.Select(m => m.BlogCategory.CategoryName).ToArray();
// return data;
//}
}
}
public async Task <bool> ExistsArticle(Guid articleId)
{
using (IDAL.IArticleService articleService = new ArticleService())
{
return(await articleService.GetAllAsync().AnyAsync(m => m.Id == articleId));
}
}
public async Task <List <ArticleDto> > GetAllArticlesByNickName(string nickName, string title, bool state, DateTime?start, DateTime?end) //后台模糊查询（根据作者查询）
{
using (IArticleService articleService = new ArticleService())
{
//DateTime sta = Convert.ToDateTime(start);
//DateTime en = Convert.ToDateTime(end);
if (start.ToString() != "0001/1/1 0:00:00" || end.ToString() != "0001/1/1 0:00:00")
{
var data = await articleService.GetAllAsync()
.Include(m => m.User)
.Where(m => m.State == state)
.Where(m => string.IsNullOrEmpty(nickName) & string.IsNullOrEmpty(title) || m.User.NickName.Contains(nickName) & m.Title.Contains(title))
.Where(m => m.CreateTime >= start & m.CreateTime <= end)
.OrderByDescending(m => m.CreateTime)
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
NickName = m.User.NickName,
State = m.State,
CreateTime = m.CreateTime,
}).ToListAsync();
return(data);
}
else
{
var data = await articleService.GetAllAsync()
.Include(m => m.User)
.Where(m => m.State == state)
.Where(m => string.IsNullOrEmpty(nickName) & string.IsNullOrEmpty(title) || m.User.NickName.Contains(nickName) & m.Title.Contains(title))
.OrderByDescending(m => m.CreateTime)
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
NickName = m.User.NickName,
State = m.State,
CreateTime = m.CreateTime,
}).ToListAsync();
return(data);
}
}
}
public async Task <List <ArticleDto> > GetAllArticlesByState(bool state) //根据发布状态查询文章
{
using (IArticleService articleSvc = new ArticleService())
{
return(await articleSvc.GetAllAsync().Where(m => m.State == state).Select(m => new ArticleDto()
{
Title = m.Title,
Content = m.Content,
CreateTime = m.CreateTime,
State = m.State,
GoodCount = m.GoodCounnt,
BadCount = m.BadCount
}).ToListAsync());
}
}
public async Task <List <ArticleDto> > GetArticleLikeByArticleTitle(string title)
{
using (IArticleService articleService = new ArticleService())
{
var data = await articleService.GetAllAsync()
.Where(m => string.IsNullOrEmpty(title) || m.Title.Contains(title))
.OrderBy(m => Guid.NewGuid())
.Take(5)
.Select(m => new ArticleDto()
{
Title = m.Title,
Id = m.Id
}).ToListAsync();
return(data);
}
}
public async Task <List <ArticleDto> > GetAllArticleByTime(DateTime times, Guid userid) //查询当天发布的文章
{
using (IArticleService artSvc = new ArticleService())
{
var data = await artSvc.GetAllAsync()
.Where(m => m.CreateTime.Day == times.Day)
.Where(m => m.UserId == userid)
.Select(m => new ArticleDto()
{
Title = m.Title,
Id = m.Id,
CreateTime = m.CreateTime
}).ToListAsync();
//2020/6/4 19:29:56
return(data);
}
}
public async Task EditStickyPostsByArticle(Guid id) //设置文章置顶
{
using (IArticleService article = new ArticleService())
{
var data = await article.GetAllAsync().FirstAsync(m => m.Id == id);
if (data != null)
{
if (data.IsStick == 0) //设置置顶
{
data.IsStick = 1;
}
else
{
data.IsStick = 0; //取消置顶
}
await article.EditAsync(data);
}
}
}
public async Task <List <ArticleDto> > GetAllArticlesByNickName(string nickName, string title, bool state) //后台模糊查询（根据作者查询）
{
using (IArticleService articleService = new ArticleService())
{
var data = await articleService.GetAllAsync()
.Include(m => m.User)
.Where(m => m.State == state)
.Where(m => string.IsNullOrEmpty(nickName) & string.IsNullOrEmpty(title) || m.User.NickName.Contains(nickName) & m.Title.Contains(title))
.OrderByDescending(m => m.CreateTime)
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
NickName = m.User.NickName,
State = m.State,
CreateTime = m.CreateTime,
}).ToListAsync();
return(data);
}
}
public async Task <List <ArticleDto> > GetAllArticleIsFreeze(string search) //查询所有文章显示在主页(用户也可模糊查询)
{
using (IArticleService articleSvc = new ArticleService())
{
return(await articleSvc.GetAllAsync().Include(m => m.User)
.Where(m => m.State == true & m.User.IsFreeze == false)
.Where(m => string.IsNullOrEmpty(search) || m.Title.Contains(search) || m.User.NickName.Contains(search))
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
Content = m.Content,
CreateTime = m.CreateTime,
GoodCount = m.GoodCounnt,
BadCount = m.BadCount,
ImagePath = m.User.ImagePath,
State = true,
NickName = m.User.NickName,
UserId = m.UserId
}).ToListAsync());
}
}
public async Task <ArticleDto> GetOneArticleById(Guid articleId) //根据文章Id查询
{
using (IArticleService articleSvc = new ArticleService())
{
var data = await articleSvc.GetAllAsync()
.Include(m => m.User)
.Where(m => m.Id == articleId)
.Select(m => new ArticleDto()
{
Id = m.Id,
Title = m.Title,
Content = m.Content,
CreateTime = m.CreateTime,
NickName = m.User.NickName,
GoodCount = m.GoodCounnt,
BadCount = m.BadCount,
UserId = m.UserId,
ImagePath = m.User.ImagePath,
State = m.State,
IsClosingComments = m.IsClosingComments
}).FirstAsync();
using (IArticleToCategoryService articleToCategorySvc = new ArticleToCategoryService())
{
var cate = await articleToCategorySvc.GetAllAsync()
.Include(m => m.BlogCategory)
.Where(m => m.ArticleId == data.Id)
.Where(m => m.BlogCategory.IsRemoved == false)
.ToListAsync();
data.CategoryIds = cate.Select(m => m.BlogCategoryId).ToArray(); //转化为数组Id
data.CategoryNames = cate.Select(m => m.BlogCategory.CategoryName).ToArray();
return(data);
}
}
}
