public async Task <IEnumerable <GetServiceHostOutput> > GetServiceHosts(QueryServiceHostInput query)
{
var sql = "SELECT ServiceHost FROM `Action` GROUP BY ServiceHost";
var sqlParams = new Dictionary <string, object>();
if (query != null && !query.ServiceHost.IsNullOrWhiteSpace())
{
sql += " HAVING ServiceHost LIKE @ServiceHost";
sqlParams.Add("ServiceHost", $"%{query.ServiceHost}%");
}
using (Connection)
{
var queryResult = await Connection.QueryAsync <GetServiceHostOutput>(sql, sqlParams);
return(queryResult);
}
}
public async Task <IEnumerable <GetServiceHostOutput> > GetServiceHosts(QueryServiceHostInput query)
{
return(await _actionDomainService.GetServiceHosts(query));
}
