public Task <IEnumerable <EmpfangerItem> > GetEmpfangerPendenzen() { var query = new EmpfangerPendenzenQuery() { Keyword = "" }; return(_mediator.Process(query)); }
public override async Task <IEnumerable <EmpfangerItem> > Handle(EmpfangerPendenzenQuery query) { string keyword = query.Keyword ?? ""; var data = await _dbConnection.QueryAsync <EmpfangerItem>( @" SELECT Typ = 'Benutzer', Kurzel = USR.LogonName, Name = USR.NameVorname, Abteilung = USR.OrgEinheitName, Id = USR.UserID, TypeCode = 1, DisplayText = USR.DisplayText FROM dbo.vwUser USR WITH (READUNCOMMITTED) WHERE (USR.NameVorname LIKE @keyword + '%' OR USR.LogonName LIKE @keyword + '%') AND USR.IsLocked = 0 --nur nicht gesperrte UNION ALL SELECT Typ = 'Gruppe', Kurzel = NULL, Name = FPG.Name, Abteilung = NULL, Id = FPG.FaPendenzgruppeID, TypeCode = 2, DisplayText = FPG.Name FROM dbo.FaPendenzgruppe FPG WITH (READUNCOMMITTED) WHERE FPG.Name LIKE @keyword + '%' AND FPG.Name NOT LIKE 'migrierte_Grp_%' ORDER BY TypeCode DESC, Name", new { keyword }); var result = data.AsList(); if (result.Count > 0) { return(result); } return(new List <EmpfangerItem>()); }