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); }