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