public async Task ArticleSetArticleCategory(int ArticleId, int ArticleCategoryId)
{
var item = await CmsContext.ArticleCategoryArticle.FirstOrDefaultAsync(p => p.ArticleId == ArticleId && p.ArticleCategoryId == ArticleCategoryId);
if (item != null) // Update
{
item.ArticleCategoryId = ArticleCategoryId;
CmsContext.SaveChanges();
}
else
{
var addItem = new ArticleCategoryArticle();
addItem.ArticleId = ArticleId;
addItem.ArticleCategoryId = ArticleCategoryId;
CmsContext.ArticleCategoryArticle.Add(addItem);
await CmsContext.SaveChangesAsync();
}
}
public async Task ArticleSetArticleCategory(int ArticleId, List <int> articleCategoryArticle)
{
var listItem = new List <ArticleCategoryArticle>();
var item = await CmsContext.ArticleCategoryArticle.Where(p => p.ArticleId == ArticleId).ToListAsync();
if (item != null) // Update
{
CmsContext.ArticleCategoryArticle.RemoveRange(item);
await CmsContext.SaveChangesAsync();
}
//Add
foreach (var p in articleCategoryArticle)
{
var itemArtCate = new ArticleCategoryArticle();
itemArtCate.ArticleId = ArticleId;
itemArtCate.ArticleCategoryId = p;
listItem.Add(itemArtCate);
}
await CmsContext.ArticleCategoryArticle.AddRangeAsync(listItem);
await CmsContext.SaveChangesAsync();
}
