public ActionResult Index()
{
List<CameraViewModel> cameraList = new List<CameraViewModel>();
var cams = db.Cameras.ToList();
foreach (Camera cam in cams)
{
CameraViewModel camView = new CameraViewModel();
ApplicationUser _user = cam.ApplicationUser;
camView._camera = cam;
camView._username = _user.FirstName + " " + _user.LastName;
camView._lastcheckout = cam.Checkouts
.OrderBy(x => x.dtCheckedOut)
.LastOrDefault() == null ? null :
cam.Checkouts.OrderBy(x => x.dtCheckedOut)
.Select(x => new CheckoutViewModel
{
dtCheckedOut = x.dtCheckedOut,
dtReturned = x.dtReturned,
Username = x.ApplicationUser.FirstName + " " + x.ApplicationUser.LastName
}).LastOrDefault();
camView._sold = cam.Sale ?? null;
cameraList.Add(camView);
}
return View(cameraList.AsEnumerable());
}
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Camera camera = db.Cameras.Find(id);
if (camera == null)
{
return HttpNotFound();
}
CameraViewModel details = new CameraViewModel();
details._camera = camera;
details._lastcheckout = camera.Checkouts.Any() ? camera.Checkouts.OrderByDescending(x => x.dtCheckedOut).Select(x => new CheckoutViewModel
{
dtCheckedOut = x.dtCheckedOut,
dtReturned = x.dtReturned,
Username = x.ApplicationUser.FirstName + " " + x.ApplicationUser.LastName
}).First() : null;
details._sold = camera.Sale == null ? null : camera.Sale;
return View(details);
}
