public void OnGet() { List <OrderHeader> OrderHeaderList = _db.OrderHeader.Where(u => u.Status != SD.StatusCompleted && u.Status != SD.StatusReady && u.Status != SD.StatusCancelled).OrderByDescending(u => u.PickUpTime).ToList(); foreach (OrderHeader item in OrderHeaderList) { OrderDetailsViewModel individual = new ViewModel.OrderDetailsViewModel(); individual.OrderDetail = _db.OrderDetail.Where(o => o.OrderId == item.Id).ToList(); individual.OrderHeader = item; OrderDetailsViewModel.Add(individual); } }
//if id =0 display only 5 past orders else display all the orders public void OnGet(int id = 0) { var claimsIdentity = (ClaimsIdentity)this.User.Identity; var claim = claimsIdentity.FindFirst(ClaimTypes.NameIdentifier); OrderDetailsViewModel = new List <ViewModel.OrderDetailsViewModel>(); List <OrderHeader> OrderHeaderList = _db.OrderHeader.Where(u => u.UserId == claim.Value).OrderByDescending(u => u.OrderDate).ToList(); if (id == 0 && OrderHeaderList.Count > 4) { OrderHeaderList = OrderHeaderList.Take(5).ToList(); } foreach (OrderHeader item in OrderHeaderList) { OrderDetailsViewModel individual = new ViewModel.OrderDetailsViewModel(); individual.OrderHeader = item; individual.OrderDetail = _db.OrderDetail.Where(o => o.Id == item.Id).ToList(); OrderDetailsViewModel.Add(individual); } }
public void OnGet(string option = null, string search = null) { if (search != null) { var user = new ApplicationUser(); List <OrderHeader> OrderHeaderList = new List <OrderHeader>(); if (option == "order") { OrderHeaderList = _db.OrderHeader.Where(o => o.Id == Convert.ToInt32(search)).ToList(); } else { if (option == "email") { user = _db.Users.Where(u => u.Email.ToLower().Contains(search.ToLower())).FirstOrDefault(); } else { if (option == "phone") { user = _db.Users.Where(u => u.PhoneNumber.ToLower().Contains(search.ToLower())).FirstOrDefault(); } else { if (option == "name") { user = _db.Users.Where(u => u.FirstName.ToLower().Contains(search.ToLower()) || u.LastName.ToLower().Contains(search.ToLower())).FirstOrDefault(); } } } } if (user != null || OrderHeaderList.Count > 0) { if (OrderHeaderList.Count == 0) { OrderHeaderList = _db.OrderHeader.Where(o => o.UserId == user.Id).OrderByDescending(o => o.PickUpTime).ToList(); } foreach (OrderHeader item in OrderHeaderList) { OrderDetailsViewModel individual = new ViewModel.OrderDetailsViewModel(); individual.OrderDetail = _db.OrderDetail.Where(o => o.OrderId == item.Id).ToList(); individual.OrderHeader = item; OrderDetailsViewModel.Add(individual); } } } else { // Se não houver critérios de pesquisa List <OrderHeader> OrderHeaderList = _db.OrderHeader.Where(u => u.Status == SD.StatusReady).OrderByDescending(u => u.PickUpTime).ToList(); foreach (OrderHeader item in OrderHeaderList) { OrderDetailsViewModel Individual = new ViewModel.OrderDetailsViewModel(); Individual.OrderDetail = _db.OrderDetail.Where(o => o.OrderId == item.Id).ToList(); Individual.OrderHeader = item; OrderDetailsViewModel.Add(Individual); } } }