public async Task <IEnumerable <GetActionOutput> > GetActionServices(QueryActionInput query)
{
var sqlParams = new Dictionary <string, object>();
var sql = "SELECT * FROM Action WHERE EnableAuthorization=@EnableAuthorization AND AllowPermission=@AllowPermission";
sqlParams.Add("EnableAuthorization", 1);
sqlParams.Add("AllowPermission", 0);
if (!query.ServiceHost.IsNullOrEmpty())
{
sql += " AND ServiceHost=@ServiceHost";
sqlParams.Add("ServiceHost", query.ServiceHost);
}
if (!query.AppService.IsNullOrEmpty())
{
sql += " AND Application=@AppService";
sqlParams.Add("AppService", query.AppService);
}
if (!query.Service.IsNullOrEmpty())
{
sql += " AND (ServiceId=@Service OR Name=@Service)";
sqlParams.Add("Service", query.Service);
}
if (query.Ids != null)
{
sql += " AND Id IN @Ids";
sqlParams.Add("Ids", query.Ids);
}
using (Connection)
{
var serviceActions = await Connection.QueryAsync <Action>(sql, sqlParams);
return(serviceActions.MapTo <IEnumerable <GetActionOutput> >());
}
}
public async Task <IEnumerable <GetActionOutput> > GetServices(QueryActionInput query)
{
query.CheckDataAnnotations().CheckValidResult();
return(await _actionDomainService.GetActionServices(query));
}
