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