public async Task UpdateArticle(ViewModel.ArticleModel item)
{
var author = item.Author;
await DeleteAsync <Model.AuthorModel>(item.Slug).ContinueWith(async(results) =>
{
await InsertAsync(new Model.AuthorModel
{
Slug = author.Slug,
Bio = author.Bio,
Description = author.Description,
Hash = author.Hash,
IsOrg = author.IsOrg,
Name = author.Name,
ProfileUrl = author.ProfileUrl,
Uid = author.Uid,
Best_answererIdDescription = author.Badge != null ? author.Badge.Best_answerer.Description : null,
IdentityDescription = author.Badge != null ? author.Badge.Identity.Description : null
});
});
await DeleteAsync <Model.AvatarModel>(item.Slug).ContinueWith(async(results1) =>
{
await InsertAsync(new Model.AvatarModel
{
AuthorSlug = author.Slug,
Id = author.Avatar.Id,
Template = author.Avatar.Template,
});
});
await DeleteAsync <Model.ArticleModel>(item.Slug).ContinueWith(async(results) =>
{
await InsertAsync(new Model.ArticleModel
{
CommentsCount = item.CommentsCount,
Content = item.Content,
LikesCount = item.LikesCount,
PublishedTime = item.PublishedTime,
Slug = item.Slug,
Title = item.Title,
TitleImage = item.TitleImage,
Url = item.Url,
AuthorSlug = item.Author.Slug,
UpdateTime = item.UpdateTime
});
});
}
public async Task <ViewModel.ArticleModel> QueryArticle(int slug)
{
var vArticle = new ViewModel.ArticleModel();
var article = await Table <Model.ArticleModel>().Where(d => d.Slug == slug).FirstOrDefaultAsync();
if (article != null)
{
vArticle = new ViewModel.ArticleModel()
{
Slug = article.Slug,
CommentsCount = article.CommentsCount,
Content = article.Content,
LikesCount = article.LikesCount,
PublishedTime = article.PublishedTime,
Title = article.Title,
TitleImage = article.TitleImage,
Url = article.Url,
UpdateTime = article.UpdateTime,
Author = await QueryAuthor(article.AuthorSlug)
};
}
return(vArticle);
}