public async Task <DataSourceResult> Handle(SearchAppendicesByTokenPagedQuery request, CancellationToken cancellationToken)
{
IQueryable <Appendice> query = _context.Appendices.AsQueryable();
query = query.Where(c => !c.Deleted);
request.Token = request.Token?.ToLowerInvariant()?.NonUnicode();
if (!string.IsNullOrWhiteSpace(request.Token))
{
if (request.AdvancedSearch)
{
string fileNames = string.Join(";", FindFilesByToken(request.Token));
query = query.Where(c => _context.NonUnicode(c.Name).Contains(request.Token) ||
_context.NonUnicode(c.DepartmentName).Contains(request.Token) ||
_context.NonUnicode(c.CompanyName).Contains(request.Token) ||
_context.NonUnicode(c.FileName).Contains(request.Token) ||
_context.NonUnicode(c.LinkFile).Contains(request.Token) ||
_context.NonUnicode(c.Module).Contains(request.Token) ||
_context.NonUnicode(c.RelateToDocuments).Contains(request.Token) ||
_context.NonUnicode(c.ReplaceOf).Contains(request.Token) ||
_context.NonUnicode(c.ReviewNumber).Contains(request.Token) ||
_context.NonUnicode(c.ScopeOfApplication).Contains(request.Token) ||
_context.NonUnicode(c.ScopeOfDeloyment).Contains(request.Token) ||
_context.CompareTwoFiles(_context.NonUnicode(c.FileName), fileNames, ";"));
}
else
{
query = query.Where(c => _context.NonUnicode(c.Name).Contains(request.Token) ||
_context.NonUnicode(c.DepartmentName).Contains(request.Token) ||
_context.NonUnicode(c.CompanyName).Contains(request.Token) ||
_context.NonUnicode(c.FileName).Contains(request.Token) ||
_context.NonUnicode(c.LinkFile).Contains(request.Token) ||
_context.NonUnicode(c.Module).Contains(request.Token) ||
_context.NonUnicode(c.RelateToDocuments).Contains(request.Token) ||
_context.NonUnicode(c.ReplaceOf).Contains(request.Token) ||
_context.NonUnicode(c.ReviewNumber).Contains(request.Token) ||
_context.NonUnicode(c.ScopeOfApplication).Contains(request.Token) ||
_context.NonUnicode(c.ScopeOfDeloyment).Contains(request.Token));
}
}
if (!request.DataSourceRequest.SortDataField.IsNullOrEmpty())
{
if (QueryHelper.PropertyExists <Document>(request.DataSourceRequest.SortDataField))
{
switch (request.DataSourceRequest.SortOrder)
{
case "asc":
query = QueryHelper.OrderByProperty(query, request.DataSourceRequest.SortDataField);
break;
case "desc":
query = QueryHelper.OrderByPropertyDescending(query, request.DataSourceRequest.SortDataField);
break;
default:
query = query.OrderByDescending(u => u.CreatedOn);
break;
}
}
}
else
{
query = query.OrderByDescending(u => u.CreatedOn);
}
IQueryable <SearchAppendicesByTokenPagedDto> test = query.Select(document => new SearchAppendicesByTokenPagedDto
{
Id = document.Id,
Approver = document.Approver,
Code = document.Code,
CompanyCode = document.CompanyCode,
CompanyName = document.CompanyName,
DDCAudited = document.DDCAudited,
DepartmentCode = document.DepartmentCode,
DepartmentName = document.DepartmentName,
DocumentType = document.DocumentType,
EffectiveDate = document.EffectiveDate,
FileName = document.FileName,
LinkFile = document.LinkFile,
Module = document.Module,
Name = document.Name,
ReplaceEffectiveDate = document.ReplaceEffectiveDate,
ListRelateToDocuments = _context.Documents.
Where(d => _context.StringSplit(document.RelateToDocuments, ";").Any(a1 => a1.SplitData == d.Code))
.Select(d => d.Name)
.ToList(),
ReplaceOf = document.ReplaceOf,
RelateToDocuments = document.RelateToDocuments,
ReviewDate = document.ReviewDate,
ReviewNumber = document.ReviewNumber,
ScopeOfApplication = document.ScopeOfApplication,
ScopeOfDeloyment = document.ScopeOfDeloyment
});
PagedList <SearchAppendicesByTokenPagedDto> queryResult = new PagedList <SearchAppendicesByTokenPagedDto>();
await queryResult.CreateAsync(test, request.DataSourceRequest.PageNum, request.DataSourceRequest.PageSize);
return(new DataSourceResult
{
Data = queryResult.ToList(),
Total = queryResult.TotalCount
});
}
