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