private async Task <bool> CheckUpdateData(BPFCEstablishDtoForImportExcel bPFCEstablishDto) { var model = await(from m in _repoModelName.FindAll() join n in _repoModelNo.FindAll() on m.ID equals n.ModelNameID join a in _repoArticleNo.FindAll() on n.ID equals a.ModelNoID join ap in _repoArtProcess.FindAll().Include(x => x.Process) on a.ID equals ap.ArticleNoID select new BPFCEstablishDtoForImportExcel { ModelName = m.Name, ModelNo = n.Name, ArticleNo = a.Name, Process = ap.Process.Name, CreatedBy = bPFCEstablishDto.CreatedBy, CreatedDate = bPFCEstablishDto.CreatedDate }).ToListAsync(); return(model.Any(x => x.ModelName == bPFCEstablishDto.ModelName && x.ModelNo == bPFCEstablishDto.ModelNo && x.ArticleNo == bPFCEstablishDto.ArticleNo && x.Process == bPFCEstablishDto.Process)); }
public async Task <List <ModelNoForMapModelDto> > GetModelNos(int modelNameID) { var map = _repoMapModel.GetAll(); var list = await _repoModelNo.FindAll().ProjectTo <ModelNoForMapModelDto>(_configMapper) .OrderByDescending(x => x.ID).Select(x => new ModelNoForMapModelDto { ID = x.ID, Name = x.Name, Status = map.Any(a => a.ModelNameID == modelNameID && a.ModelNoID == a.ModelNoID) }).ToListAsync(); return(list); }
//Lấy danh sách Brand và phân trang public async Task <PagedList <ModelNoDto> > GetWithPaginations(PaginationParams param) { var lists = _repoModelNo.FindAll().Include(x => x.ModelName).ProjectTo <ModelNoDto>(_configMapper).OrderByDescending(x => x.ID); return(await PagedList <ModelNoDto> .CreateAsync(lists, param.PageNumber, param.PageSize)); }