public ActionResult QuanLyBanVe(string id) { if (CheckUser()) { if (id != null) { ThongTinHoaDon thongTin = new ThongTinHoaDon(); thongTin.HoaDon = _context.Ves.Find(id).HoaDon; thongTin.CacVe = thongTin.HoaDon.Ves.ToList(); thongTin.KhachHang = thongTin.HoaDon.KhachHang; thongTin.NhanVien = thongTin.HoaDon.NhanVien; return(View("~/Views/Admin/ChiTietVe.cshtml", thongTin)); } QuanLyVeViewModel quanLyVeViewModel = new QuanLyVeViewModel(); quanLyVeViewModel.DanhSachThongTinVe = _context.Ves.Join(_context.Tours, ve => ve.MaTour, tour => tour.MaTour, (ve, tour) => new { Ve = ve, DiaDiemDen = tour.DiaDiemDen, DiaDiemDi = tour.DiaDiemDi }).Join(_context.LoaiVes, c => c.Ve.MaLoaiVe, loaiVe => loaiVe.MaLoaiVe, (c, loaiVe) => new ThongTinVeExpanded() { Ve = c.Ve, GiaTien = loaiVe.GiaTien, DiaDiemDen = c.DiaDiemDen, DiaDiemDi = c.DiaDiemDi }).ToList(); return(View(quanLyVeViewModel)); } return(HttpNotFound("Hãy Đăng Nhập")); }
public ActionResult QuanLyBanVeTheoUser(string userId) { if (CheckUser()) { QuanLyVeViewModel quanLyVeViewModel = new QuanLyVeViewModel(); quanLyVeViewModel.DanhSachThongTinVe = _context.Ves.Join(_context.Tours, ve => ve.MaTour, tour => tour.MaTour, (ve, tour) => new { Ve = ve, DiaDiemDen = tour.DiaDiemDen, DiaDiemDi = tour.DiaDiemDi }).Join(_context.LoaiVes, c => c.Ve.MaLoaiVe, loaiVe => loaiVe.MaLoaiVe, (c, loaiVe) => new ThongTinVeExpanded() { Ve = c.Ve, GiaTien = loaiVe.GiaTien, DiaDiemDen = c.DiaDiemDen, DiaDiemDi = c.DiaDiemDi }).ToList(); quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .Where(ve => ve.Ve.HoaDon.KhachHang.MaKhachHang == userId).ToList(); return(View("QuanLyBanVe", quanLyVeViewModel)); } return(HttpNotFound("Hãy Đăng Nhập")); }
public ActionResult QuanLyBanVeSort(string sortValue, int?sortDirection) { if (CheckUser()) { QuanLyVeViewModel quanLyVeViewModel = new QuanLyVeViewModel(); quanLyVeViewModel.DanhSachThongTinVe = _context.Ves.Join(_context.Tours, ve => ve.MaTour, tour => tour.MaTour, (ve, tour) => new { Ve = ve, DiaDiemDen = tour.DiaDiemDen, DiaDiemDi = tour.DiaDiemDi }).Join(_context.LoaiVes, c => c.Ve.MaLoaiVe, loaiVe => loaiVe.MaLoaiVe, (c, loaiVe) => new ThongTinVeExpanded() { Ve = c.Ve, GiaTien = loaiVe.GiaTien, DiaDiemDen = c.DiaDiemDen, DiaDiemDi = c.DiaDiemDi }).ToList(); if (sortValue.IsNullOrWhiteSpace() || (sortDirection != 0 && sortDirection != 1)) { return(View("QuanLyBanVe", quanLyVeViewModel)); } if (string.Compare("MaVe", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe.OrderBy(thongTinVe => thongTinVe.Ve.MaVe).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.MaVe).ToList(); } } if (string.Compare("NguoiMua", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderBy(thongTinVe => thongTinVe.Ve.HoaDon.KhachHang.Ten).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.HoaDon.KhachHang.Ten).ToList(); } } if (string.Compare("NgayThanhToan", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderBy(thongTinVe => thongTinVe.Ve.HoaDon.ThoiGianXuat).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.HoaDon.ThoiGianXuat).ToList(); } } if (string.Compare("SoTien", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderBy(thongTinVe => thongTinVe.Ve.LoaiVe.GiaTien).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.LoaiVe.GiaTien).ToList(); } } if (string.Compare("DiemDen", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderBy(thongTinVe => thongTinVe.Ve.Tour.DiaDiemDi.TenDiaDiem).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.Tour.DiaDiemDi.TenDiaDiem).ToList(); } } if (string.Compare("DiemDi", sortValue) == 0) { if (sortDirection == 0) { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderBy(thongTinVe => thongTinVe.Ve.Tour.DiaDiemDen.TenDiaDiem).ToList(); } else { quanLyVeViewModel.DanhSachThongTinVe = quanLyVeViewModel.DanhSachThongTinVe .OrderByDescending(thongTinVe => thongTinVe.Ve.Tour.DiaDiemDen.TenDiaDiem).ToList(); } } return(View("QuanLyBanVe", quanLyVeViewModel)); } return(HttpNotFound()); }