public PartialViewResult Filters(int?min, int?max, DateTime?begin, DateTime?end, string?searchKey) { IQueryable <SingleTour> searchRes; if (searchKey == null || searchKey == String.Empty || searchKey.Count() == 0) { searchRes = _context.SingleTours; } else { searchRes = _context.SingleTours.Where(p => p.Title.Contains(searchKey)); } List <TourLookViewModel> tours = new List <TourLookViewModel>(); foreach (var item in searchRes.Where(p => p.Price >= min && p.Price < max && (p.StartDate >= begin && p.StartDate <= end))) { var model = new TourLookViewModel(); model.Tour = item; model.Tour.Requirements = _context.Requirements.Where(p => p.SingleTourId == item.Id).ToList(); model.Images = _context.Images.Where(p => p.Id == _context.OneTourImages.First(m => m.SingleTourId == item.Id).AllImageId).ToList(); model.Guides = _context.Users.Where(p => p.Id == _context.GuideToTourPvts.First(m => m.TourId == item.Id).GuideId).ToList(); tours.Add(model); } return(PartialView("_PriceFilter", tours)); }
public IActionResult PostTour(int id, string comment) { var item = _context.SingleTours.FirstOrDefault(p => p.Id == id); var model = new TourLookViewModel(); model.Tour = item; model.Tour.Requirements = _context.Requirements.Where(p => p.SingleTourId == item.Id).ToList(); model.Images = _context.Images.Where(p => p.Id == _context.OneTourImages.First(m => m.SingleTourId == item.Id).AllImageId).ToList(); model.Guides = _context.Users.Where(p => p.Id == _context.GuideToTourPvts.First(m => m.TourId == item.Id).GuideId).ToList(); return(View("SingleTour", model)); }
public IActionResult Index() { List <TourLookViewModel> tours = new List <TourLookViewModel>(); foreach (var item in _context.SingleTours.ToList()) { var model = new TourLookViewModel(); model.Tour = item; model.Tour.Requirements = _context.Requirements.Where(p => p.SingleTourId == item.Id).ToList(); model.Images = _context.Images.Where(p => p.Id == _context.OneTourImages.First(m => m.SingleTourId == item.Id).AllImageId).ToList(); model.Guides = _context.Users.Where(p => p.Id == _context.GuideToTourPvts.First(m => m.TourId == item.Id).GuideId).ToList(); tours.Add(model); } return(View(tours)); }