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