public IList <ChiTietPhieuDatHangViewModel> danhSachPhieuDatHangTheoMa(int soPhieuDatHang)
{
IQueryable <ChiTietPhieuDatHang> dsChiTietPhieuDatHang = _chiTietPhieuDatHangRepo.GetAll();
List <ChiTietPhieuDatHangViewModel> all = new List <ChiTietPhieuDatHangViewModel>();
all = (from chitietphieudathang in dsChiTietPhieuDatHang
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieudathang.MaHangHoa equals hanghoa.MaHangHoa
select new
{
SoPhieuDatHang = chitietphieudathang.SoPhieuDatHang,
MaHangHoa = chitietphieudathang.MaHangHoa,
SoLuong = chitietphieudathang.SoLuong,
Gia = chitietphieudathang.Gia,
ThanhTien = chitietphieudathang.ThanhTien,
tenHangHoa = hanghoa.TenHangHoa,
}).AsEnumerable().Select(x => new ChiTietPhieuDatHangViewModel()
{
soPhieuDatHang = x.SoPhieuDatHang,
maHangHoa = x.MaHangHoa,
soLuong = x.SoLuong,
gia = x.Gia,
thanhTien = x.ThanhTien,
tenHangHoa = x.tenHangHoa,
}).ToList();
var information = (from i in all
where (i.soPhieuDatHang == soPhieuDatHang)
select i).ToList();
return(information.ToList());
}
public IList <SanPhamBanChayOnlineViewModel> DanhSachSanPhamBanChayNhatOnline()
{
IQueryable <HangHoa> danhSachHangHoa = _hangHoaRepo.GetAll();
IQueryable <ChiTietPhieuDatHang> danhSachchiTietPhieuDatHang = _chiTietPhieuDatHangRepo.GetAll();
List <SanPhamBanChayOnlineViewModel> all = new List <SanPhamBanChayOnlineViewModel>();
var phieudathangs = (from phieudathang in danhSachchiTietPhieuDatHang
group phieudathang by phieudathang.MaHangHoa into phieudathangGroup
orderby phieudathangGroup.Sum(i => i.SoLuong) descending
select new
{
MaHangHoa = phieudathangGroup.Key,
TongSoLuongBan = phieudathangGroup.Sum(i => i.SoLuong),
TongTien = phieudathangGroup.Sum(i => i.ThanhTien)
}).Take(15).ToList();
all = (from phieudathang in phieudathangs
join hanghoa in danhSachHangHoa
on phieudathang.MaHangHoa equals hanghoa.MaHangHoa
select new SanPhamBanChayOnlineViewModel
{
maHangHoa = phieudathang.MaHangHoa,
tongSoLuongBan = phieudathang.TongSoLuongBan,
tongTienBan = phieudathang.TongTien,
tenHangHoa = hanghoa.TenHangHoa,
hinhAnh = hanghoa.HinhAnh
}).ToList();
return(all);
}
