public IPagedList <qtUnitManager> DanhSachNguoiDung(int page, int pageSize) { qtUserService _user = new qtUserService(); qtUnitService _unit = new qtUnitService(); qtUnitManagerService _mangager = new qtUnitManagerService(); var danhsach = (from mangager in _mangager.FindList() join user in _user.FindList() on mangager.UserId equals user.UserId select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault()); return(danhsach.ToPagedList(page, pageSize)); }
public int SoluongNguoiDung(int?unitId) { qtUserService _user = new qtUserService(); qtUnitService _unit = new qtUnitService(); qtUnitManagerService _mangager = new qtUnitManagerService(); var danhsach = (from mangager in _mangager.FindList() join user in _user.FindList() on mangager.UserId equals user.UserId where user.UnitId == unitId select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault()); return(danhsach.Count()); }
public List <qtUnit> ListUnit_By_UserId(int?userid) { if (!userid.HasValue) { return(new List <qtUnit>()); } qtUnitService _unit = new qtUnitService(); qtUnitManagerService _mangager = new qtUnitManagerService(); List <qtUnit> danhsach = _mangager.FindList().Where(m => m.UserId == userid.Value) .Join(_unit.FindList().Where(m => m.Status == true), m => m.UnitId, u => u.UnitId, (m, u) => u) .Distinct().ToList(); return(danhsach); }