public async Task <IList <ClientDto> > Handle(GetAllClientsQuery request, CancellationToken cancellationToken)
{
var clients = await _context.Clients
.AsNoTracking()
.Select(ClientDto.Projection)
.ToListAsync();
return(clients);
}
public async Task <List <ClientDTO> > Handle(GetAllClientsQuery request, CancellationToken cancellationToken)
{
List <Domain.Model.Soporte.Client> clients = await _clientRepository.GetClients();
List <ClientDTO> clientDTOs = new List <ClientDTO>();
foreach (var item in clients)
{
clientDTOs.Add(new ClientDTO(
item.ClientId,
item.Name, item.Lastname,
item.Phone,
item.Email, item.Address
));
}
return(clientDTOs);
}
public async Task <IActionResult> GetAll([FromQuery] GetAllClientsQuery query, [FromQuery] PaginationQuery paginationQuery)
{
var accountId = (int)HttpContext.Items["accountId"];
var paginationFilter = _mapper.Map <PaginationFilter>(paginationQuery);
var filter = _mapper.Map <GetAllClientsFilter>(query);
var clientSearchResult = await _clientService.GetClientListFromAccountIdAsync(accountId, filter, paginationFilter);
var clientResponse = _mapper.Map <List <ClientResponseModel> >(clientSearchResult.results);
if (paginationFilter == null || paginationFilter.PageNumber < 1 || paginationFilter.PageSize < 1)
{
return(Ok(new PagedResponseModel <ClientResponseModel>(clientResponse)));
}
var paginatedesponse = PaginationHelper.CreatePaginatedRespone(_uriService, paginationFilter, clientResponse, clientSearchResult.total);
return(Ok(paginatedesponse));
}
public async Task <IEnumerable <ClientDto> > Handle(GetAllClientsQuery request, CancellationToken cancellationToken)
{
var licensesClient =
from l in db.Licenses
group l by l.ClientId into g
select new
{
clientId = g.Key,
licensesCount = g.Count()
};
var contractsClient =
from c in db.Contracts
group c by c.ClientId into g
select new {
clientId = g.Key,
contractsCount = g.Count(),
postVentaContractsCount = g.Where(c => DateTime.Today >= c.InicioPostVenta && DateTime.Today <= c.FinalPostVenta).Count()
};
var qry =
from c in db.Clients
join l in licensesClient on c.Id equals l.clientId into ls
from l in ls.DefaultIfEmpty()
join ct in contractsClient on c.Id equals ct.clientId into cts
from ct in cts.DefaultIfEmpty()
select new ClientDto()
{
Id = c.Id,
Code = c.Code,
Description = c.Description,
AssetsCode = c.AssetsCode,
NombreCorto = c.NombreCorto,
Licencias = l.clientId == null ? 0 : l.licensesCount,
PostVenta = ct.clientId == null ? false : (ct.postVentaContractsCount > 0)
};
return(qry);
}
public async Task <Response <IEnumerable <ClientDto> > > Handle(GetAllClientsQuery _, CancellationToken cancellationToken)
{
var client = await _clientRepository.GetAll();
return(Response.Ok(_maper.Map <IEnumerable <ClientDto> >(client)));
}
public async Task <IList <Client> > Handle(GetAllClientsQuery query, CancellationToken cancellationToken)
{
var clients = await _unitOfWork.ClientRepository.GetAllAsync(cancellationToken);
return(clients);
}
public async Task <IEnumerable <Client> > Handle(GetAllClientsQuery request, CancellationToken cancellationToken)
{
return(await _clientService.GetClients());
}
public async Task <IEnumerable <ClientDTO> > Handle(GetAllClientsQuery request, CancellationToken cancellationToken)
{
var clients = await Task.Run(() => clientRepository.GetAllClients());
return(mapper.Map <ClientDTO[]>(clients));
}
