public async Task <ActionResult> ChooseHiglighted(HighlitedNewsNiewModels model)
{
if (!User.IsAuthorized("news"))
{
return(RedirectToAction("Index", "AdminHome"));
}
var first = await _db.NewsArticles.FirstOrDefaultAsync(r => r.Id == model.First);
var second = await _db.NewsArticles.FirstOrDefaultAsync(r => r.Id == model.Second);
var thirt = await _db.NewsArticles.FirstOrDefaultAsync(r => r.Id == model.Thirt);
await _db.Database.ExecuteSqlCommandAsync("UPDATE NewsArticles SET [IsHighLighted] = 0");
first.IsHighLighted = true;
second.IsHighLighted = true;
thirt.IsHighLighted = true;
_db.Entry(first).State = EntityState.Modified;
_db.Entry(second).State = EntityState.Modified;
_db.Entry(thirt).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(RedirectToAction("ChooseHiglighted"));
}
public async Task <ActionResult> ChooseHiglighted()
{
if (!User.IsAuthorized("news"))
{
return(RedirectToAction("Index", "AdminHome"));
}
var vm = new HighlitedNewsNiewModels
{
Articles = await _db.NewsArticles.ToListAsync()
};
vm.Higlighted = vm.Articles.Where(r => r.IsHighLighted).ToList();
return(View(vm));
}
