public ActionResult bikeList() { if (!authorize()) { return(new HttpStatusCodeResult(System.Net.HttpStatusCode.Unauthorized)); } var model = new List <ViewModels.Admin.AdminBikeVM>(); foreach (var bike in context.Bike.OrderBy(i => i.isArchived).ThenBy(n => n.bikeNumber)) { var vm = new ViewModels.Admin.AdminBikeVM { Id = bike.bikeId, IsArchived = bike.isArchived, IsAvailable = bike.isAvailable(), Name = bike.bikeName, Number = bike.bikeNumber, LastBorrowed = bike.lastCheckedOut }; if (bike.onInspectionHold) { vm.Notes += "On inspection hold. "; } if (bike.onMaintenanceHold) { vm.Notes += "On maintenance hold. "; } if (bike.lastCheckedOut.Year < 2014) //necessary because of messy db model { vm.LastBorrowed = null; vm.LastCheckedOutTo = null; } try { int lastUserId = context.CheckOut.Where(b => b.bike == bike.bikeId).OrderByDescending(d => d.timeOut).First().rider; vm.LastCheckedOutTo = context.BikeUser.Find(lastUserId).userName; } catch { vm.LastCheckedOutTo = null; } model.Add(vm); } return(View(model)); }
public ActionResult bikeList() { if (!authorize()) { return new HttpStatusCodeResult(System.Net.HttpStatusCode.Unauthorized); } var model = new List<ViewModels.Admin.AdminBikeVM>(); foreach(var bike in context.Bike.OrderBy(i => i.isArchived).ThenBy(n => n.bikeNumber)) { var vm = new ViewModels.Admin.AdminBikeVM { Id = bike.bikeId, IsArchived = bike.isArchived, IsAvailable = bike.isAvailable(), Name = bike.bikeName, Number = bike.bikeNumber, LastBorrowed = bike.lastCheckedOut }; if (bike.onInspectionHold) { vm.Notes += "On inspection hold. "; } if (bike.onMaintenanceHold) { vm.Notes += "On maintenance hold. "; } if (bike.lastCheckedOut.Year < 2014) //necessary because of messy db model { vm.LastBorrowed = null; vm.LastCheckedOutTo = null; } try { int lastUserId = context.CheckOut.Where(b => b.bike == bike.bikeId).OrderByDescending(d => d.timeOut).First().rider; vm.LastCheckedOutTo = context.BikeUser.Find(lastUserId).userName; } catch { vm.LastCheckedOutTo = null; } model.Add(vm); } return View(model); }