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));
}
