public ArticleTagParameters GetArticleAndTags(int id)
{
ArticleTagParameters model = new ArticleTagParameters();
var article = context.Articles.FirstOrDefault(x => x.Id == id);
if (article != null)
{
var tagList = (from tag in context.Tags
join ta in context.TagsArticles.Where(o => o.ArticlesId == article.Id) on tag.Id equals ta.TagsId
into Tags
select new Tags
{
Id = tag.Id,
Title = tag.Title
}).ToList();
model.Active = article.Active;
model.AllowsComments = article.AllowsComments;
model.CategoryId = article.CategoryId;
model.Id = article.Id;
model.Language = article.Language;
model.Photo = article.Photo;
model.PostedAt = article.PostedAt;
model.SubTitle = article.SubTitle;
model.TagList = tagList;
model.Text = article.Text;
model.ThumbnailPhoto = article.ThumbnailPhoto;
model.Title = article.Title;
model.UserId = article.UserId;
}
return(model);
}
public IEnumerable <ArticleTagParameters> GetAllArticlesAndTags()
{
List <ArticleTagParameters> model = new List <ArticleTagParameters>();
var articleList = context.Articles.ToList();
if (articleList != null && articleList.Count > 0)
{
foreach (var item in articleList)
{
ArticleTagParameters mItem = new ArticleTagParameters();
var tagList = (from tag in context.Tags
join ta in context.TagsArticles.Where(o => o.ArticlesId == item.Id) on tag.Id equals ta.TagsId
select new Tags
{
Id = tag.Id,
Title = tag.Title
}).ToList();
mItem.Active = item.Active;
mItem.AllowsComments = item.AllowsComments;
mItem.CategoryId = item.CategoryId;
mItem.Id = item.Id;
mItem.Language = item.Language;
mItem.Photo = item.Photo;
mItem.PostedAt = item.PostedAt;
mItem.SubTitle = item.SubTitle;
mItem.TagList = tagList;
mItem.Text = item.Text;
mItem.ThumbnailPhoto = item.ThumbnailPhoto;
mItem.Title = item.Title;
mItem.UserId = item.UserId;
model.Add(mItem);
}
}
return(model);
}
