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