public IActionResult Get([FromQuery] AttachmentSearch search
, [FromServices] IGetAttachmentsQuery query)
{
IEnumerable <GetAttachmentDto> items = _useCaseExecutor.ExecuteQuery(query, search);
return(Ok(items));
}
public IEnumerable <GetAttachmentDto> Execute(AttachmentSearch search)
{
var query = context.Attachments.AsQueryable();
if (search.NameKeyword != null)
{
query = query.Where(x => x.Name.Contains(search.NameKeyword));
}
if (search.TicketId != null)
{
query = query.Where(x => x.TicketId == (int)search.TicketId);
}
if (search.PathKeyword != null)
{
query = query.Where(x => x.Path.Contains(search.PathKeyword));
}
if (search.OnlyActive != null)
{
if (search.OnlyActive == true)
{
query = query.Where(x => x.DeletedAt == null);
}
}
query = query.SkipItems(search.Page, search.ItemsPerPage);
return(query.Select(x => _mapper.Map <GetAttachmentDto>(x)).ToList());
}
