public async Task <IActionResult> Get([FromQuery] ResourceQueryFilter filter, [FromQuery] ResourceQuerySort sort, [FromQuery] ResourceQueryProjection projection, [FromQuery] ResourceQueryPaging paging, [FromQuery] ResourceQueryOptions options) { var validationResult = _service.ValidateGetResources( User, filter, sort, projection, paging, options); if (!validationResult.Valid) { return(BadRequest(validationResult.Result)); } var result = await _service.QueryResourceDynamic( projection, options, filter, sort, paging); if (options.single_only) { if (result == null) { return(NotFound(new AppResultBuilder().NotFound())); } return(Ok(new AppResultBuilder().Success(result.SingleResult))); } return(Ok(new AppResultBuilder().Success(result))); }
public async Task <QueryResult <IDictionary <string, object> > > QueryResourceDynamic( ResourceQueryProjection projection, ResourceQueryOptions options, ResourceQueryFilter filter = null, ResourceQuerySort sort = null, ResourceQueryPaging paging = null) { var query = Resources; #region General if (filter != null) { query = query.Filter(filter); } query = query.Project(projection); int?totalCount = null; if (options.count_total) { totalCount = query.Count(); } #endregion if (!options.single_only) { #region List query if (sort != null) { query = query.Sort(sort); } if (paging != null && (!options.load_all || !ResourceQueryOptions.IsLoadAllAllowed)) { query = query.SelectPage(paging.page, paging.limit); } #endregion } if (options.single_only) { var single = query.SingleOrDefault(); if (single == null) { return(null); } var singleResult = GetResourceDynamic(single, projection, options); return(new QueryResult <IDictionary <string, object> >() { Single = singleResult }); } var entities = query.ToList(); var list = GetResourceDynamic(entities, projection, options); var result = new QueryResult <IDictionary <string, object> >(); result.List = list; if (options.count_total) { result.Count = totalCount; } return(result); }
public ValidationData ValidateGetResources( ClaimsPrincipal principal, ResourceQueryFilter filter, ResourceQuerySort sort, ResourceQueryProjection projection, ResourceQueryPaging paging, ResourceQueryOptions options) { return(new ValidationData()); }
public async Task <IActionResult> Get([FromQuery][QueryObject] ResourceQueryFilter filter, [FromQuery] ResourceQuerySort sort, [FromQuery] ResourceQueryProjection projection, [FromQuery] ResourceQueryPaging paging, [FromQuery] ResourceQueryOptions options) { var validationData = _service.ValidateGetResources( User, filter, sort, projection, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var result = await _service.QueryResourceDynamic( projection, options, filter, sort, paging); if (options.single_only && result == null) { return(NotFound(AppResult.NotFound())); } return(Ok(AppResult.Success(result))); }
public async Task <QueryResult <ResourceQueryRow> > QueryResource( ResourceQueryFilter filter = null, ResourceQuerySort sort = null, ResourceQueryProjection projection = null, ResourceQueryPaging paging = null, ResourceQueryOptions options = null) { var conn = context.Database.GetDbConnection(); var openConn = conn.OpenAsync(); var query = ResourceQuery.CreateDynamicSql(); #region General if (filter != null) { query = query.SqlFilter(filter); } if (projection != null) { query = query.SqlJoin(projection, filter); } DynamicSql countQuery = null; int?totalCount = null; Task <int> countTask = null; if (options != null && options.count_total) { countQuery = query.SqlCount("*"); } if (projection != null) { query = query.SqlProjectFields(projection); } #endregion await openConn; if (options != null && !options.single_only) { #region List query if (sort != null) { query = query.SqlSort(sort); } if (paging != null && (!options.load_all || !ResourceQueryOptions.IsLoadAllAllowed)) { query = query.SqlSelectPage(paging.page, paging.limit); } #endregion #region Count query if (options.count_total) { countTask = conn.ExecuteScalarAsync <int>( sql: countQuery.PreparedForm, param: countQuery.DynamicParameters); } #endregion } if (projection != null) { query = query.SqlExtras(projection, filter); } var multipleResult = await conn.QueryMultipleAsync( sql : query.PreparedForm, param : query.DynamicParameters); using (multipleResult) { var queryResult = multipleResult.Read( types: query.GetTypesArr(), map: (objs) => ProcessMultiResults(query, objs), splitOn: string.Join(',', query.GetSplitOns())); if (projection != null) { var extraKeys = projection.GetFieldsArr() .Where(f => ResourceQueryProjection.Extras.ContainsKey(f)); IEnumerable <CateOfResQueryRow> categories = null; foreach (var key in extraKeys) { switch (key) { case ResourceQueryProjection.CATEGORIES: categories = GetCategoriesQueryResult(multipleResult); break; } } ProcessExtras(queryResult, categories); } if (options != null && options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } return(new QueryResult <ResourceQueryRow> { SingleResult = single }); } if (options != null && options.count_total) { totalCount = await countTask; } return(new QueryResult <ResourceQueryRow> { Results = queryResult, TotalCount = totalCount }); } }