public ActionResult Index() { List<TabletViewModel> tabletList = new List<TabletViewModel>(); var tabs = db.Tablets.ToList(); foreach (Tablet tab in tabs) { TabletViewModel tabView = new TabletViewModel(); ApplicationUser _user = tab.ApplicationUser; tabView._tablet = tab; tabView._username = _user.FirstName + " " + _user.LastName; tabView._lastcheckout = tab.Checkouts .OrderBy(x => x.dtCheckedOut) .LastOrDefault() == null ? null : tab.Checkouts.OrderBy(x => x.dtCheckedOut) .Select(x => new CheckoutViewModel { dtCheckedOut = x.dtCheckedOut, dtReturned = x.dtReturned, Username = x.ApplicationUser.FirstName + " " + x.ApplicationUser.LastName }).LastOrDefault(); tabView._sold = tab.Sale ?? null; tabletList.Add(tabView); } return View(tabletList.AsEnumerable()); }
public ActionResult Details(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Tablet tablet = db.Tablets.Find(id); if (tablet == null) { return HttpNotFound(); } TabletViewModel details = new TabletViewModel(); details._tablet = tablet; details._lastcheckout = tablet.Checkouts.Any() ? tablet.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 = tablet.Sale == null ? null : tablet.Sale; return View(details); }