public ActionResult QuanLyTourSingle(string id)
{
if (CheckUser())
{
QuanLyTourViewModel quanLyTourViewModel = new QuanLyTourViewModel();
var query1 = from diaDiem in _context.DiaDiems
join tour in _context.Tours on diaDiem.MaDiaDiem equals tour.MaDiemDen
join loaive in _context.LoaiVes on tour.MaTour equals loaive.MaTour
where tour.MaTour == id
select new ThongTinTourExpanded
{
Tour = tour,
DuongDanAnh = diaDiem.DuongDanAnh,
TenDiaDiem = diaDiem.TenDiaDiem,
GiaTien = loaive.GiaTien,
Ten = loaive.Ten,
DiaDiemDen = tour.DiaDiemDen,
DiaDiemDi = tour.DiaDiemDi
};
quanLyTourViewModel.danhsachtour = query1.ToList();
return(View("QuanLyTour", quanLyTourViewModel));
}
else
{
return(Content("Bạn không có quyền vào trang này!"));
}
}
public ActionResult QuanLyTour(int?page)
{
QuanLyTourViewModel quanLyTourViewModel = new QuanLyTourViewModel();
//thực hiện chức năng phân trang
//tạo biến số sản phẩm trên trang
int PageSize = 5;
//tạo biến số trang hiện tại
int pagenumber = (page ?? 1);
var query1 = from diaDiem in _context.DiaDiems
join tour in _context.Tours on diaDiem.MaDiaDiem equals tour.MaDiemDen
join loaive in _context.LoaiVes on tour.MaTour equals loaive.MaTour
select new ThongTinTourExpanded
{
Tour = tour,
DuongDanAnh = diaDiem.DuongDanAnh,
GiaTien = loaive.GiaTien,
Ten = loaive.Ten,
DiaDiemDi = tour.DiaDiemDi,
DiaDiemDen = tour.DiaDiemDen
};
double soTrangCheck = query1.ToList().Count() / PageSize;
int soTrang = 0;
if (soTrangCheck > (int)soTrangCheck)
{
soTrang = (int)soTrangCheck + 1;
}
else
{
soTrang = (int)soTrangCheck;
}
quanLyTourViewModel.danhsachtour = query1.OrderBy(n => n.Tour.MaTour).ToPagedList(pagenumber, PageSize).ToList();
quanLyTourViewModel.SoTrang = soTrang;
quanLyTourViewModel.STT = (pagenumber - 1) * PageSize + 1;
return(View(quanLyTourViewModel));
}
public ActionResult QuanLyTourSort(string sortValue, int?sortDirection)
{
QuanLyTourViewModel quanLyTourViewModel = new QuanLyTourViewModel();
var query1 = from diaDiem in _context.DiaDiems
join tour in _context.Tours on diaDiem.MaDiaDiem equals tour.MaDiemDen
join loaive in _context.LoaiVes on tour.MaTour equals loaive.MaTour
select new ThongTinTourExpanded
{
Tour = tour,
DuongDanAnh = diaDiem.DuongDanAnh,
GiaTien = loaive.GiaTien,
Ten = loaive.Ten,
DiaDiemDi = tour.DiaDiemDi,
DiaDiemDen = tour.DiaDiemDen
};
quanLyTourViewModel.danhsachtour = query1.ToList();
if (sortValue.IsNullOrWhiteSpace() || (sortDirection != 0 && sortDirection != 1))
{
return(View("QuanLyTour", quanLyTourViewModel));
}
if (string.Compare("MaTour", sortValue) == 0)
{
if (sortDirection == 0)
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderBy(thongTinTour => thongTinTour.Tour.MaTour).ToList();
}
else
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderByDescending(thongTinTour => thongTinTour.Tour.MaTour).ToList();
}
}
if (string.Compare("DiemDen", sortValue) == 0)
{
if (sortDirection == 0)
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderBy(thongTinTour => thongTinTour.DiaDiemDen.TenDiaDiem).ToList();
}
else
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderByDescending(thongTinTour => thongTinTour.DiaDiemDen.TenDiaDiem).ToList();
}
}
if (string.Compare("DiemDi", sortValue) == 0)
{
if (sortDirection == 0)
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderBy(thongTinTour => thongTinTour.DiaDiemDi.TenDiaDiem).ToList();
}
else
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderByDescending(thongTinTour => thongTinTour.DiaDiemDi.TenDiaDiem).ToList();
}
}
if (string.Compare("SoTien", sortValue) == 0)
{
if (sortDirection == 0)
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderBy(thongTinTour => thongTinTour.GiaTien).ToList();
}
else
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderByDescending(thongTinTour => thongTinTour.GiaTien).ToList();
}
}
if (string.Compare("ThoiGian", sortValue) == 0)
{
if (sortDirection == 0)
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderBy(thongTinTour => thongTinTour.Tour.ThoigianDi).ToList();
}
else
{
quanLyTourViewModel.danhsachtour =
quanLyTourViewModel.danhsachtour.OrderByDescending(thongTinTour => thongTinTour.Tour.ThoigianDi).ToList();
}
}
return(View("QuanLyTour", quanLyTourViewModel));
}
