public IList <BaoCaoDatHangViewModel> ListView(string nhanVienCode, DateTime dateFrom, DateTime dateTo) { IQueryable <PhieuDatHang> danhSachPhieuDatHang = _phieuDatHangRepo.GetAll(); List <BaoCaoDatHangViewModel> allForManager = new List <BaoCaoDatHangViewModel>(); if ((!(dateFrom == default(DateTime))) && (!(dateTo == default(DateTime)))) { allForManager = (from phieuDatHang in danhSachPhieuDatHang //join nhanVien in _nhanVienRepo.GetAll() //on phieuDatHang.MaNhanVien equals nhanVien.MaNhanVien where phieuDatHang.NgayDat >= dateFrom.Date && phieuDatHang.NgayDat <= dateTo.Date group phieuDatHang by phieuDatHang.NgayDat into pgroup select new { NgayDat = pgroup.Key, SoDonHang = pgroup.Count(), TongTien = pgroup.Sum(phieuDatHang => phieuDatHang.TongTien) }).AsEnumerable().Select(x => new BaoCaoDatHangViewModel() { ngayDat = x.NgayDat, soDonHang = x.SoDonHang, tongTien = x.TongTien }).OrderBy(x => x.ngayDat).ToList(); return(allForManager); } else { allForManager = (from phieuDatHang in danhSachPhieuDatHang //join nhanVien in _nhanVienRepo.GetAll() //on phieuDatHang.MaNhanVien equals nhanVien.MaNhanVien where phieuDatHang.NgayDat.Month == DateTime.Now.Month && phieuDatHang.NgayDat.Year == DateTime.Now.Year group phieuDatHang by phieuDatHang.NgayDat into pgroup select new { NgayDat = pgroup.Key, SoDonHang = pgroup.Count(), TongTien = pgroup.Sum(phieuDatHang => phieuDatHang.TongTien) }).AsEnumerable().Select(x => new BaoCaoDatHangViewModel() { ngayDat = x.NgayDat, soDonHang = x.SoDonHang, tongTien = x.TongTien }).OrderBy(x => x.ngayDat).ToList(); return(allForManager); } }
public IList <PhieuDatHangViewModel> ListView(string nhanVienCode) { var phieuBanHang = (new PhieuBanHangReponsitory(dbContext)).GetAll(); IQueryable <PhieuDatHang> danhSachPhieuDatHang = _phieuDatHangRepo.GetAll(); List <PhieuDatHangViewModel> all = new List <PhieuDatHangViewModel>(); List <PhieuDatHangViewModel> allForManager = new List <PhieuDatHangViewModel>(); if (_nhanVienBus.layMaChucVu(nhanVienCode) != 4 && _nhanVienBus.layMaChucVu(nhanVienCode) != 3) { return(all); } if (_nhanVienBus.layMaChucVu(nhanVienCode) == 4) { all = (from phieuDatHang in danhSachPhieuDatHang where phieuDatHang.TrangThai == true select new { SoPhieuDatHang = phieuDatHang.SoPhieuDatHang, NgayDat = phieuDatHang.NgayDat, MaNhanVien = phieuDatHang.MaNhanVien, TenKhachHang = phieuDatHang.TenKhachHang, SoDienThoai = phieuDatHang.SoDienThoai, DiaChi = phieuDatHang.Diachi, Email = phieuDatHang.Email, TongTien = phieuDatHang.TongTien, HinhThucThanhToan = phieuDatHang.HinhThucThanhToan, GhiChu = phieuDatHang.Ghichu, NgayGiao = phieuDatHang.NgayGiao, DaXacNhan = phieuDatHang.DaXacNhan, DaThanhToan = phieuDatHang.DaThanhToan, TrangThai = phieuDatHang.TrangThai, }).AsEnumerable().Select(x => new PhieuDatHangViewModel() { soPhieuDatHang = x.SoPhieuDatHang, ngayDat = x.NgayDat, maNhanVien = x.MaNhanVien, tenKhachHang = x.TenKhachHang, soDienThoai = x.SoDienThoai, diaChi = x.DiaChi, email = x.Email, tongTien = x.TongTien, hinhThucThanhToan = x.HinhThucThanhToan, ghiChu = x.GhiChu, ngayGiao = x.NgayGiao, daXacNhan = x.DaXacNhan, daThanhToan = x.DaThanhToan, trangThai = x.TrangThai }).ToList(); return(all); } else { allForManager = (from phieuDatHang in danhSachPhieuDatHang select new { SoPhieuDatHang = phieuDatHang.SoPhieuDatHang, NgayDat = phieuDatHang.NgayDat, MaNhanVien = phieuDatHang.MaNhanVien, TenKhachHang = phieuDatHang.TenKhachHang, SoDienThoai = phieuDatHang.SoDienThoai, DiaChi = phieuDatHang.Diachi, Email = phieuDatHang.Email, TongTien = phieuDatHang.TongTien, HinhThucThanhToan = phieuDatHang.HinhThucThanhToan, GhiChu = phieuDatHang.Ghichu, NgayGiao = phieuDatHang.NgayGiao, DaXacNhan = phieuDatHang.DaXacNhan, DaThanhToan = phieuDatHang.DaThanhToan }).AsEnumerable().Select(x => new PhieuDatHangViewModel() { soPhieuDatHang = x.SoPhieuDatHang, ngayDat = x.NgayDat, maNhanVien = x.MaNhanVien, tenKhachHang = x.TenKhachHang, soDienThoai = x.SoDienThoai, diaChi = x.DiaChi, email = x.Email, tongTien = x.TongTien, hinhThucThanhToan = x.HinhThucThanhToan, ghiChu = x.GhiChu, ngayGiao = x.NgayGiao, daXacNhan = x.DaXacNhan, daThanhToan = x.DaThanhToan }).ToList(); return(allForManager); } }