public IList <BaoCaoHangHoaViewModel> ListView(string nhanVienCode, bool trangThai)
{
IQueryable <HangHoa> danhSachHangHoa = _hangHoaRepo.GetAll();
IQueryable <LoaiHangHoa> danhSachLoaiHangHoa = _loaiHangHoaRepo.GetAll();
List <BaoCaoHangHoaViewModel> allForManager = new List <BaoCaoHangHoaViewModel>();
allForManager = (from hangHoa in danhSachHangHoa
join loaiHangHoa in danhSachLoaiHangHoa
on hangHoa.MaLoaiHangHoa equals loaiHangHoa.MaLoaiHangHoa
where hangHoa.TrangThai == trangThai
select new
{
MaHangHoa = hangHoa.MaHangHoa,
TenHangHoa = hangHoa.TenHangHoa,
TenLoaiHangHoa = loaiHangHoa.TenLoaiHangHoa,
GiaBan = hangHoa.GiaBan,
GiamGia = hangHoa.GiamGia,
TrangThai = hangHoa.TrangThai,
SoLuongTon = hangHoa.SoLuongTon,
ModelName = hangHoa.ModelName
}).AsEnumerable().Select(x => new BaoCaoHangHoaViewModel()
{
maHangHoa = x.MaHangHoa,
tenHangHoa = x.TenHangHoa,
tenLoaiHangHoa = x.TenLoaiHangHoa,
giaBan = x.GiaBan,
giamGia = x.GiamGia,
trangThai = x.TrangThai,
soLuongTon = x.SoLuongTon,
modelName = x.ModelName
}).OrderBy(x => x.maHangHoa).ToList();
return(allForManager);
}
public IList <HangHoaViewModel> DanhSachHangHoaTheoMaLoaiHangHoa(int maLoaiHangHoa)
{
IQueryable <HangHoa> danhSachHangHoa = _hangHoaRepo.GetAll();
List <HangHoaViewModel> all = new List <HangHoaViewModel>();
all = (from hanghoa in danhSachHangHoa
join loaihanghoa in _loaiHangHoaRepo.GetAll()
on hanghoa.MaLoaiHangHoa equals loaihanghoa.MaLoaiHangHoa
where (hanghoa.MaLoaiHangHoa.Equals(maLoaiHangHoa) && hanghoa.TrangThai == true)
select new
{
MaHangHoa = hanghoa.MaHangHoa,
TenHangHoa = hanghoa.TenHangHoa,
HinhAnh = hanghoa.HinhAnh,
GiaBan = hanghoa.GiaBan,
GiaKhuyenMai = hanghoa.GiamGia,
TenLoaiHangHoa = loaihanghoa.TenLoaiHangHoa,
XuatXu = hanghoa.XuatXu,
}).AsEnumerable().Select(x => new HangHoaViewModel()
{
maHangHoa = x.MaHangHoa,
tenHangHoa = x.TenHangHoa,
hinhAnh = x.HinhAnh,
giaBan = x.GiaBan,
giamGia = x.GiaKhuyenMai,
tenLoaiHangHoa = x.TenLoaiHangHoa,
xuatXu = x.XuatXu,
}).ToList();
return(all);
}
public IList <LoaiHangHoa> LoadDSLoaiHangHoa()
{
IQueryable <LoaiHangHoa> loaiHangHoa = _loaiHangHoaRepo.GetAll();
return(loaiHangHoa.ToList());
}
