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