public ActionResult QuanLyNguoiDung(int?page) { //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 = 10; //tạo biến số trang hiện tại int pagenumber = (page ?? 1); QuanLyNguoiDungViewModel data = new QuanLyNguoiDungViewModel(); foreach (KhachHang khach in _context.KhachHangs.ToList()) { double tongTien = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Sum(ve => ve.LoaiVe.GiaTien)); int soVe = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Count); data.ThongTinCacNguoiDung.Add(new NguoiDungViewModel { TenNguoiDung = khach.Ten, SoTienMua = tongTien, SoVeMua = soVe, NgayTaoTaiKhoan = khach.ThoiGianDangKi, MaNguoiDung = khach.MaKhachHang }); data.ThongTinCacNguoiDung.OrderBy(n => n.SoTienMua).ToPagedList(pagenumber, PageSize).ToList(); } ; return(View(data)); }
public ActionResult QuanLyNguoiDungSingle(string id) { if (CheckUser()) { QuanLyNguoiDungViewModel data = new QuanLyNguoiDungViewModel(); foreach (KhachHang khach in _context.KhachHangs.Where(khachHang => khachHang.MaKhachHang == id).ToList()) { double tongTien = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Sum(ve => ve.LoaiVe.GiaTien)); int soVe = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Count); data.ThongTinCacNguoiDung.Add(new NguoiDungViewModel { TenNguoiDung = khach.Ten, SoTienMua = tongTien, SoVeMua = soVe, NgayTaoTaiKhoan = khach.ThoiGianDangKi, MaNguoiDung = khach.MaKhachHang }); } ; return(View("QuanLyNguoiDung", data)); } else { return(Content("Bạn không có quyền vào trang này!")); } }
public ActionResult QuanLyNguoiDung() { QuanLyNguoiDungViewModel data = new QuanLyNguoiDungViewModel(); foreach (KhachHang khach in _context.KhachHangs.ToList()) { double tongTien = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Sum(ve => ve.LoaiVe.GiaTien)); int soVe = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Count); data.ThongTinCacNguoiDung.Add(new NguoiDungViewModel { TenNguoiDung = khach.Ten, SoTienMua = tongTien, SoVeMua = soVe }); } ; return(View(data)); }
public ActionResult QuanLyNguoiDungSort(string sortValue, int?sortDirection) { QuanLyNguoiDungViewModel data = new QuanLyNguoiDungViewModel(); foreach (KhachHang khach in _context.KhachHangs.ToList()) { double tongTien = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Sum(ve => ve.LoaiVe.GiaTien)); int soVe = khach.HoaDons.Sum(hoaDon => hoaDon.Ves.Count); data.ThongTinCacNguoiDung.Add(new NguoiDungViewModel { TenNguoiDung = khach.Ten, SoTienMua = tongTien, SoVeMua = soVe, NgayTaoTaiKhoan = khach.ThoiGianDangKi, MaNguoiDung = khach.MaKhachHang }); } ; if (sortValue.IsNullOrWhiteSpace() || (sortDirection != 0 && sortDirection != 1)) { return(View("QuanLyNguoiDung", data)); } if (string.Compare("Ten", sortValue) == 0) { if (sortDirection == 0) { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderBy(nguoiDung => nguoiDung.TenNguoiDung).ToList(); } else { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderByDescending(nguoiDung => nguoiDung.TenNguoiDung).ToList(); } } if (string.Compare("SoTien", sortValue) == 0) { if (sortDirection == 0) { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderBy(nguoiDung => nguoiDung.SoTienMua).ToList(); } else { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderByDescending(nguoiDung => nguoiDung.SoTienMua).ToList(); } } if (string.Compare("SoVe", sortValue) == 0) { if (sortDirection == 0) { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderBy(nguoiDung => nguoiDung.SoVeMua).ToList(); } else { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderByDescending(nguoiDung => nguoiDung.SoVeMua).ToList(); } } if (string.Compare("NgayTao", sortValue) == 0) { if (sortDirection == 0) { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderBy(nguoiDung => nguoiDung.NgayTaoTaiKhoan).ToList(); } else { data.ThongTinCacNguoiDung = data.ThongTinCacNguoiDung .OrderByDescending(nguoiDung => nguoiDung.NgayTaoTaiKhoan).ToList(); } } return(View("QuanLyNguoiDung", data)); }