public override async Task <IEnumerable <PositionsartDisplayItem> > Handle(PositionsartenQuery query) { return(await _dbConnection.QueryAsync <PositionsartDisplayItem>( @"SELECT POA.BgPositionsartID, Text = IsNull(KOA.KontoNr, '') + ' ' + POA.Name FROM dbo.WhPositionsart POA LEFT JOIN dbo.WhKostenart KOA ON KOA.BgKostenartID = POA.BgKostenartID WHERE BgKategorieCode = 3 ORDER BY SortKey")); }
public Task <IEnumerable <PositionsartDisplayItem> > GetPositionsarten() { var query = new PositionsartenQuery(); return(_mediator.Process(query)); }