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