public IEnumerable <KiemKhoViewModel> thongTinChiTietPhieuKiemKhoTheoMa(int soPhieuKiemKho)
{
IQueryable <ChiTietPhieuKiemKho> dsPhieuKiemKho = _chiTietPhieuKiemKhoRepo.GetAll();
var all = (from chitietphieukiemkho in dsPhieuKiemKho
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieukiemkho.MaHangHoa equals hanghoa.MaHangHoa
select new
{
SoPhieuKiemKho = chitietphieukiemkho.SoPhieuKiemKho,
MaHangHoa = hanghoa.MaHangHoa,
SoLuongHienTai = chitietphieukiemkho.SoLuongHienTai,
SoLuongKiemTra = chitietphieukiemkho.SoLuongKiemTra,
TenHangHoa = hanghoa.TenHangHoa,
DonViTinh = hanghoa.DonViTinh,
}).AsEnumerable().Select(x => new KiemKhoViewModel()
{
soPhieuKiemKho = x.SoPhieuKiemKho,
maHangHoa = x.MaHangHoa,
soLuongHienTai = x.SoLuongHienTai,
soLuongKiemTra = x.SoLuongKiemTra,
tenHangHoa = x.TenHangHoa,
donViTinh = x.DonViTinh,
}).ToList();
//Lấy thông tin chi tiết phiếu từ số phiếu kiểm kho
var information = (from i in all
where (i.soPhieuKiemKho == soPhieuKiemKho)
select i).ToList();
return(information.ToList());
}
public IList <ChiTietPhieuBanHangViewModel> danhSachPhieuBanHangTheoMa(int soPhieuBanHang)
{
IQueryable <ChiTietPhieuBanHang> dsChiTietPhieuBanHang = _chiTietPhieuBanHangRepo.GetAll();
List <ChiTietPhieuBanHangViewModel> all = new List <ChiTietPhieuBanHangViewModel>();
all = (from chitietphieubanhang in dsChiTietPhieuBanHang
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieubanhang.MaHangHoa equals hanghoa.MaHangHoa
select new
{
SoPhieuBanHang = chitietphieubanhang.SoPhieuBanHang,
MaHangHoa = chitietphieubanhang.MaHangHoa,
SoLuong = chitietphieubanhang.SoLuong,
Gia = chitietphieubanhang.Gia,
ThanhTien = chitietphieubanhang.ThanhTien,
tenHangHoa = hanghoa.TenHangHoa,
}).AsEnumerable().Select(x => new ChiTietPhieuBanHangViewModel()
{
soPhieuBanHang = x.SoPhieuBanHang,
maHangHoa = x.MaHangHoa,
soLuong = x.SoLuong,
gia = x.Gia,
thanhTien = x.ThanhTien,
tenHangHoa = x.tenHangHoa,
}).ToList();
var information = (from i in all
where (i.soPhieuBanHang == soPhieuBanHang)
select i).ToList();
return(information.ToList());
}
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 IEnumerable <PhieuBaoHanhViewModel> thongTinChiTietPhieuBaoHanhTheoMa(int soPhieuBaoHanh)
{
IQueryable <ChiTietPhieuBaoHanh> dsPhieuBaoHanh = _chiTietPhieuBaoHanhRepo.GetAll();
var all = (from chitietphieubaohanh in dsPhieuBaoHanh
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieubaohanh.MaHangHoa equals hanghoa.MaHangHoa
join phieubaohanh in _phieuBaoHanhRepo.GetAll()
on chitietphieubaohanh.SoPhieuBaoHanh equals phieubaohanh.SoPhieuBaoHanh
where (phieubaohanh.SoPhieuBaoHanh == soPhieuBaoHanh)
select new
{
MaHangHoa = hanghoa.MaHangHoa,
TenHangHoa = hanghoa.TenHangHoa,
}).AsEnumerable().Select(x => new PhieuBaoHanhViewModel()
{
maHangHoa = x.MaHangHoa,
tenHangHoa = x.TenHangHoa,
}).ToList();
return(all);
}
public IEnumerable <PhieuXuatKhoViewModel> thongTinChiTietPhieuXuatKhoTheoMa(int soPhieuXuatKho)
{
IQueryable <ChiTietPhieuXuatKho> dsPhieuXuatKho = _chiTietPhieuXuatKhoRepo.GetAll();
var all = (from chitietphieuxuatkho in dsPhieuXuatKho
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieuxuatkho.MaHangHoa equals hanghoa.MaHangHoa
join phieuxuat in _phieuXuatKhoRepo.GetAll()
on chitietphieuxuatkho.SoPhieuXuatKho equals phieuxuat.SoPhieuXuatKho
select new
{
SoPhieuXuatKho = chitietphieuxuatkho.SoPhieuXuatKho,
MaHangHoa = hanghoa.MaHangHoa,
DonViTinh = hanghoa.DonViTinh,
SoLuong = chitietphieuxuatkho.SoLuong,
Gia = chitietphieuxuatkho.Gia,
ThanhTien = chitietphieuxuatkho.ThanhTien,
TenHangHoa = hanghoa.TenHangHoa,
}).AsEnumerable().Select(x => new PhieuXuatKhoViewModel()
{
soPhieuXuatKho = x.SoPhieuXuatKho,
maHangHoa = x.MaHangHoa,
donViTinh = x.DonViTinh,
soLuong = x.SoLuong,
gia = x.Gia,
thanhTien = x.ThanhTien,
tenHangHoa = x.TenHangHoa,
}).ToList();
//Lấy thông tin chi tiết phiếu từ số phiếu nhập kho
var information = (from i in all
where (i.soPhieuXuatKho == soPhieuXuatKho)
select i).ToList();
return(information.ToList());
}
public IEnumerable <PhieuNhapViewModel> thongTinChiTietPhieuNhapTheoMa(int soPhieuNhap)
{
IQueryable <ChiTietPhieuNhap> dsPhieuNhap = _chiTietPhieuNhapRepo.GetAll();
var all = (from chitietphieunhap in dsPhieuNhap
join hanghoa in _hangHoaRepo.GetAll()
on chitietphieunhap.MaHangHoa equals hanghoa.MaHangHoa
join phieunhap in _phieuNhapRepo.GetAll()
on chitietphieunhap.SoPhieuNhap equals phieunhap.SoPhieuNhap
select new
{
SoPhieuNhap = chitietphieunhap.SoPhieuNhap,
MaHangHoa = hanghoa.MaHangHoa,
DonViTinh = hanghoa.DonViTinh,
SoLuongNhap = chitietphieunhap.SoLuong,
GiaNhap = chitietphieunhap.GiaNhap,
ThanhTien = chitietphieunhap.ThanhTien,
TenHangHoa = hanghoa.TenHangHoa,
}).AsEnumerable().Select(x => new PhieuNhapViewModel()
{
soPhieuNhap = x.SoPhieuNhap,
maHangHoa = x.MaHangHoa,
donViTinh = x.DonViTinh,
soLuongNhap = x.SoLuongNhap,
giaNhap = x.GiaNhap,
thanhTien = x.ThanhTien,
tenHangHoa = x.TenHangHoa,
}).ToList();
//Lấy thông tin chi tiết phiếu từ số phiếu nhập kho
var information = (from i in all
where (i.soPhieuNhap == soPhieuNhap)
select i).ToList();
return(information.ToList());
}
public IList <BaoCaoTonKhoViewModel> ListView(int month, int year)
{
IQueryable <BaoCaoTonKho> danhSachBaoCaoTonKho = _baoCaoTonKhoRepo.GetAll();
IQueryable <HangHoa> danhSachHangHoa = _hangHoaRepo.GetAll();
List <BaoCaoTonKhoViewModel> allForManager = new List <BaoCaoTonKhoViewModel>();
if (month == DateTime.Now.Month && year == DateTime.Now.Year)
{
allForManager = (from baoCaoTonKho in danhSachBaoCaoTonKho
join hangHoa in danhSachHangHoa
on baoCaoTonKho.MaHangHoa equals hangHoa.MaHangHoa
where baoCaoTonKho.Thang == DateTime.Now.Month && baoCaoTonKho.Nam == DateTime.Now.Year
select new
{
MaBaoCaoTonKho = baoCaoTonKho.MaBaoCaoTonKho,
Thang = baoCaoTonKho.Thang,
Nam = baoCaoTonKho.Nam,
MaHangHoa = baoCaoTonKho.MaHangHoa,
TenHangHoa = hangHoa.TenHangHoa,
DonViTinh = hangHoa.DonViTinh,
SoLuongTonDau = baoCaoTonKho.SoLuongTonDau,
SoLuongNhap = baoCaoTonKho.SoLuongNhap,
SoLuongXuat = baoCaoTonKho.SoLuongXuat,
SoLuongTonCuoi = baoCaoTonKho.SoLuongTonCuoi
}).AsEnumerable().Select(x => new BaoCaoTonKhoViewModel()
{
maBaoCaoTonKho = x.MaBaoCaoTonKho,
thang = x.Thang,
nam = x.Nam,
maHangHoa = x.MaHangHoa,
tenHangHoa = x.TenHangHoa,
donViTinh = x.DonViTinh,
soLuongTonDau = x.SoLuongTonDau,
soLuongNhap = x.SoLuongNhap,
soLuongXuat = x.SoLuongXuat,
soLuongTonCuoi = x.SoLuongTonCuoi
}).OrderBy(x => x.maBaoCaoTonKho).ToList();
return(allForManager);
}
else
{
allForManager = (from baoCaoTonKho in danhSachBaoCaoTonKho
join hangHoa in danhSachHangHoa
on baoCaoTonKho.MaHangHoa equals hangHoa.MaHangHoa
where baoCaoTonKho.Thang == month && baoCaoTonKho.Nam == year
select new
{
MaBaoCaoTonKho = baoCaoTonKho.MaBaoCaoTonKho,
Thang = baoCaoTonKho.Thang,
Nam = baoCaoTonKho.Nam,
MaHangHoa = baoCaoTonKho.MaHangHoa,
TenHangHoa = hangHoa.TenHangHoa,
DonViTinh = hangHoa.DonViTinh,
SoLuongTonDau = baoCaoTonKho.SoLuongTonDau,
SoLuongNhap = baoCaoTonKho.SoLuongNhap,
SoLuongXuat = baoCaoTonKho.SoLuongXuat,
SoLuongTonCuoi = baoCaoTonKho.SoLuongTonCuoi
}).AsEnumerable().Select(x => new BaoCaoTonKhoViewModel()
{
maBaoCaoTonKho = x.MaBaoCaoTonKho,
thang = x.Thang,
nam = x.Nam,
maHangHoa = x.MaHangHoa,
tenHangHoa = x.TenHangHoa,
donViTinh = x.DonViTinh,
soLuongTonDau = x.SoLuongTonDau,
soLuongNhap = x.SoLuongNhap,
soLuongXuat = x.SoLuongXuat,
soLuongTonCuoi = x.SoLuongTonCuoi
}).OrderBy(x => x.maBaoCaoTonKho).ToList();
return(allForManager);
}
}
public IEnumerable <HangHoa> GetAllHangHoa()
{
IQueryable <HangHoa> danhSachHangHoa = _hangHoaRepo.GetAll();
var all = (from hanghoa in danhSachHangHoa
select new
{
TenHangHoa = hanghoa.TenHangHoa,
ModelName = hanghoa.ModelName,
}).AsEnumerable().Select(x => new HangHoa()
{
TenHangHoa = x.TenHangHoa,
ModelName = x.ModelName,
}).ToList();
return(all);
}
