public Task <IEnumerable <FalltragerItem> > LoadFalltrager()
{
var query = new LoadFalltragerQuery()
{
SearchString = ""
};
return(_mediator.Process(query));
}
public override async Task <IEnumerable <FalltragerItem> > Handle(LoadFalltragerQuery query)
{
var data = await _dbConnection.QueryAsync <FalltragerItem>(@"
SELECT Id = FAL.FaFallID,
Name = PRS.Name,
Vorname = PRS.Vorname,
Benutzer = USR.DisplayText,
FaFallID = FAL.FaFallID,
NameVorname = PRS.NameVorname + ' (' + CONVERT(VARCHAR, FAL.FaFallID) + ')'
FROM dbo.FaFall FAL WITH (READUNCOMMITTED)
INNER JOIN dbo.vwPerson PRS ON PRS.BaPersonID = FAL.BaPersonID
INNER JOIN dbo.vwUser USR ON USR.UserID = FAL.UserID
WHERE PRS.NameVorname LIKE @SearchString + '%' OR
FAL.FaFallID = CASE WHEN ISNUMERIC(@SearchString) = 1 THEN CONVERT(INT, ROUND(@SearchString, 0)) ELSE -1 END
ORDER BY PRS.Name, PRS.Vorname", new { query.SearchString });
if (data.AsList().Count > 0)
{
return(data);
}
return(new List <FalltragerItem>());
}
