public IEnumerable <int> GetVanishedBtsIds() { if (!BtsExcels.Any()) { return(new List <int>()); } return(from bts in _btsRepository.GetAllInUseList() join info in BtsExcels on bts.BtsId equals info.BtsId into btsQuery from eq in btsQuery.DefaultIfEmpty() where eq == null select bts.BtsId); }
public IEnumerable <BtsExcel> GetNewBtsExcels() { if (!BtsExcels.Any()) { return(new List <BtsExcel>()); } return(from info in BtsExcels join bts in _btsRepository.GetAllList() on info.BtsId equals bts.BtsId into btsQuery from bq in btsQuery.DefaultIfEmpty() where bq == null select info); }