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)); }