public Task <IEnumerable <LeistungsverantwItem> > GetEmpfangerPendenzen(string keyword) { var query = new LeistungsverantwQuery() { Keyword = keyword }; return(_mediator.Process(query)); }
public override async Task <IEnumerable <LeistungsverantwItem> > Handle(LeistungsverantwQuery query) { string keyword = query.Keyword ?? ""; var querystring = string.Format(@" SELECT UserId, Name = NameVorname, LogonName, DisplayText = DisplayText FROM dbo.vwUser WITH (READUNCOMMITTED) WHERE (NameVorname LIKE '%' + N'{0}' + '%' OR LogonName LIKE '%' + N'{0}' + '%') ORDER BY Name", keyword); var data = _dbConnection.QueryAsync <LeistungsverantwItem>( querystring).Result.AsList(); return(data); }