public async Task <IEnumerable <GetAppServiceOutput> > GetAppServices(QueryAppServiceInput query)
{
var sql = $"SELECT Application as AppService, '{query.ServiceHost}' as ServiceHost FROM `Action` WHERE ServiceHost='{query.ServiceHost}' GROUP BY Application";
var sqlParams = new Dictionary <string, object>();
if (!query.AppService.IsNullOrWhiteSpace())
{
sql += " HAVING Application LIKE @Application";
sqlParams.Add("Application", $"%{query.AppService}%");
}
using (Connection)
{
var queryResult = await Connection.QueryAsync <GetAppServiceOutput>(sql, sqlParams);
return(queryResult);
}
}
public async Task <IEnumerable <GetAppServiceOutput> > GetAppServices(QueryAppServiceInput query)
{
query.CheckDataAnnotations().CheckValidResult();
return(await _actionDomainService.GetAppServices(query));
}
