// GET: Orders public async Task <IActionResult> Index() { // var bellyful_v03Context = _context.Order.Include(o => o.Recipient).Include(o => o.Status).Include(o => o.Volunteer); // return View(await bellyful_v03Context.ToListAsync()); var ordersVMs = new List <OrderIndexViewModel>(); foreach (var o in _context.Order) { var vm = new OrderIndexViewModel { OrderId = o.OrderId }; if (o.CreatedDatetime != null) { vm.PlacedTime = o.CreatedDatetime; } if (o.AssignDatetime != null) { vm.AssignedTime = o.AssignDatetime; } if (o.PickupDatetime != null) { vm.PickedUpTime = o.PickupDatetime; } if (o.DeliveredDatetime != null) { vm.DeliveredTime = o.DeliveredDatetime; } if (o.StatusId != null) { vm.StatusId = o.StatusId.Value; } if (o.VolunteerId != null) { var ss = await _context.GetVolunteerForIndex(o.VolunteerId.Value); vm.VIdName = ss; } vm.RIdName = await _context.GetRecipientForIndex(o.RecipientId); if (o.StatusId != null) { vm.Status = _context.OrderStatus.FindAsync(o.StatusId.Value).Result.Content; } ordersVMs.Add(vm); } ordersVMs.Sort(); return(View(ordersVMs)); }