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