public IEnumerable <SastnLookupResponse> Lookup(SastnLookupRequest sastnLookupRequest)
{
sastnLookupRequest.term = sastnLookupRequest.term?.ToUpper() ?? string.Empty;
var where = new StringBuilder();
where.Append($"sastn.cono = {this.sastnRepository.Cono}");
where.AppendFormatWithEscape(" AND sastn.codeiden = '{0}'", sastnLookupRequest.codeiden);
var returnSastns = this.sastnRepository.GetList(where.ToString(), sastnLookupRequest.IsAutoComplete ? 500 : sastnLookupRequest.recordcountlimit, "codeiden,codeval,descrip,rowID");
var list = new List <SastnLookupResponse>();
foreach (var returnSastn in returnSastns)
{
var combinedValue = (returnSastn.codeval + returnSastn.descrip).ToUpper();
if (combinedValue.Contains(sastnLookupRequest.term))
{
list.Add(new SastnLookupResponse {
codeiden = returnSastn.codeiden, codeval = returnSastn.codeval, descrip = returnSastn.descrip, rowID = returnSastn.rowID
});
}
if (sastnLookupRequest.IsAutoComplete && list.Count == sastnLookupRequest.recordcountlimit)
{
break;
}
}
return(list);
}
public IEnumerable <SastnLookupResponse> Lookup(SastnLookupRequest sastnLookupRequest)
{
return(this.sastnService.Lookup(sastnLookupRequest));
}
