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