public async Task <IActionResult> Get([FromQuery] OwnerQueryFilter filter, [FromQuery] OwnerQuerySort sort, [FromQuery] OwnerQueryProjection projection, [FromQuery] OwnerQueryPaging paging, [FromQuery] OwnerQueryOptions options) { var validationResult = _service.ValidateGetOwners( User, filter, sort, projection, paging, options); if (!validationResult.Valid) { return(BadRequest(validationResult.Result)); } var result = await _service.QueryOwnerDynamic( 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 ValidationResult ValidateGetOwners( ClaimsPrincipal principal, OwnerQueryFilter filter, OwnerQuerySort sort, OwnerQueryProjection projection, OwnerQueryPaging paging, OwnerQueryOptions options) { return(ValidationResult.Pass()); }
public async Task <QueryResult <IDictionary <string, object> > > QueryOwnerDynamic( OwnerQueryProjection projection, OwnerQueryOptions options, OwnerQueryFilter filter = null, OwnerQuerySort sort = null, OwnerQueryPaging paging = null) { var conn = context.Database.GetDbConnection(); var openConn = conn.OpenAsync(); var query = OwnerQuery.CreateDynamicSql(); #region General if (filter != null) { query = query.SqlFilter(filter); } query = query.SqlJoin(projection); DynamicSql countQuery = null; int?totalCount = null; Task <int> countTask = null; if (options.count_total) { countQuery = query.SqlCount("*"); } query = query.SqlProjectFields(projection); #endregion await openConn; if (!options.single_only) { #region List query if (sort != null) { query = query.SqlSort(sort); } if (paging != null && (!options.load_all || !OwnerQueryOptions.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 } var queryResult = await conn.QueryAsync( sql : query.PreparedForm, types : query.GetTypesArr(), map : (objs) => ProcessMultiResults(query, objs), splitOn : string.Join(',', query.GetSplitOns()), param : query.DynamicParameters); if (options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } var singleResult = GetOwnerDynamic(single, projection, options); return(new QueryResult <IDictionary <string, object> >() { SingleResult = singleResult }); } if (options.count_total) { totalCount = await countTask; } var result = GetOwnerDynamic(queryResult, projection, options, totalCount); return(result); }