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