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