public ActionResult Index() { GetDriversVM model = new GetDriversVM(); using (TruckTransportDbContext _db = new TruckTransportDbContext()) { model.DriversList = _db.vozaci.Select(x => new GetDriversVM.DriverVM { DriverID = x.vozac_id, FirstName = x.ime, LastName = x.prezime, PersonUniqueID = x.jmbg, Username = x.user, Status = _db.nalozi.Where(s => s.stanje_id == 1 && s.vozac_id == x.vozac_id).FirstOrDefault() != null ? "Aktivan" : "Na čekanju" }).AsNoTracking().ToList(); } return(View(viewName: "Index", model: model)); }
public ActionResult GetActiveDrivers() { GetDriversVM model = new GetDriversVM(); using (TruckTransportDbContext _db = new TruckTransportDbContext()) { model.DriversList = _db.nalozi.Include(x => x.vozaci).Where(x => x.stanje_id == 1).Select(x => new GetDriversVM.DriverVM { DriverID = x.vozaci.vozac_id, FirstName = x.vozaci.ime, LastName = x.vozaci.prezime, PersonUniqueID = x.vozaci.jmbg, Username = x.vozaci.user, Status = "Aktivan" }).AsNoTracking().ToList(); } return(PartialView(viewName: "_ActiveDrivers", model: model)); }