public static List <TourChiTietViewModel> TimTour(TimKiemTourViewModel model)
{
QlTourDuLichEntities entity = new QlTourDuLichEntities();
var res = (from t in entity.TOURs
//join ks in entity.KHACHSANs
//on t.MaKS equals ks.MaKS
join ht in entity.HANHTRINHs
on t.MaHanhTrinh equals ht.MaHanhTrinh
join dd1 in entity.DIADIEMs
on ht.NoiDen equals dd1.MaDiaDiem
join dd2 in entity.DIADIEMs
on ht.NoiDi equals dd2.MaDiaDiem
where t.NgayKhoiHanh.Value.Year == model.NgayDi.Year &&
t.NgayKhoiHanh.Value.Month == model.NgayDi.Month &&
t.NgayKhoiHanh.Value.Day == model.NgayDi.Day
select new TourChiTietViewModel()
{
Tour = new TourViewModel()
{
MaTour = t.MaTour,
NgayKH = t.NgayKhoiHanh,
NgayKT = t.NgayKetThuc,
//TenKhachSan = ks.TenKS,
DiemDen = dd1.TenDiaDiem,
DiemDi = dd2.TenDiaDiem,
GiaNguoiLon = t.GiaNguoiLon,
GiaTreEm = t.GiaTreEm
},
AnhDiaDiem = t.AnhDaiDien
});
return(res.ToList());
}
// [HttpPost]
public ActionResult TimKiemTour(TimKiemTourViewModel model)
{
if (ModelState.IsValid)
{
TempData["TourTimDuoc"] = TourQueries.TimTour(model);
TempData["ThongTinTimKiem"] = model;
}
return(RedirectToAction("Index", "TrangChu"));
}
