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