public ActionResult ViewFavouriteTours()
{
using (var db = new WishoianContext())
{
var restult = new List<TourPlanDetailViewModel>();
var tourPlan = db.TourPlans.Take(5).ToList().OrderByDescending(t => t.Viewed);
foreach (var item in tourPlan)
{
var viewModel = new TourPlanDetailViewModel
{
Tour = new TourDetailViewModel() { Tour = item.Tour, SpecialTourPlan = item },
TourSchedules = item.Tour.TourSchedules.OrderBy(s => s.IndexDay).ToList(),
TourPlan = item
};
restult.Add(viewModel);
}
// Set up our ViewModel
return PartialView(restult);
}
}
public ViewResult ViewTourDetail(Guid tourPlanId)
{
using (var db = new WishoianContext())
{
var tourPlan = db.TourPlans.Find(tourPlanId);
if (tourPlan != null)
{
// Set up our ViewModel
var viewModel = new TourPlanDetailViewModel
{
Tour = new TourDetailViewModel() { Tour = tourPlan.Tour, SpecialTourPlan = tourPlan },
TourSchedules = tourPlan.Tour.TourSchedules.OrderBy(s => s.IndexDay).ToList(),
TourPlan = tourPlan
};
// Update View
db.Entry(tourPlan).State = EntityState.Modified;
if (tourPlan.Viewed == null)
tourPlan.Viewed = 1;
else
tourPlan.Viewed += 1;
db.SaveChanges();
return View(viewModel);
}
return View();
}
}
public ViewResult SearchTour(TourSearchViewModel search)
{
var lst = new List<TourPlanDetailViewModel>();
using (var db = new WishoianContext())
{
var tourPlan = db.TourPlans.Where(t =>
t.Tour.TourType.TypeName == search.TourTypeName
&& ((search.OpenDate == null) || t.OpenDate >= search.OpenDate)
&& (search.StartLocationId == t.Tour.StartLocationId && (search.EndLocationId == null || search.EndLocationId.Value == t.Tour.EndLocationId))
).ToList();
foreach (var item in tourPlan)
{
// Set up our ViewModel
var viewModel = new TourPlanDetailViewModel
{
Tour = new TourDetailViewModel() { Tour = item.Tour, SpecialTourPlan = item },
TourSchedules = item.Tour.TourSchedules.OrderBy(s => s.IndexDay).ToList(),
TourPlan = item
};
lst.Add(viewModel);
}
return View(lst);
}
}