public IDictionary <string, object> GetAreaDynamic( AreaQueryRow row, AreaQueryProjection projection, AreaQueryOptions options) { var obj = new Dictionary <string, object>(); foreach (var f in projection.GetFieldsArr()) { switch (f) { case AreaQueryProjection.INFO: { var entity = row.Area; obj["id"] = entity.Id; obj["name"] = entity.Name; obj["description"] = entity.Description; obj["floor_id"] = entity.FloorId; obj["building_id"] = entity.BuildingId; obj["location_id"] = entity.LocationId; obj["archived"] = entity.Archived; obj["code"] = entity.Code; } break; case AreaQueryProjection.SELECT: { var entity = row.Area; obj["id"] = entity.Id; obj["name"] = entity.Name; obj["code"] = entity.Code; } break; case AreaQueryProjection.FLOOR: { var entity = row.Floor; obj["floor"] = new { id = entity.Id, name = entity.Name, code = entity.Code, }; } break; case AreaQueryProjection.BUILDING: { var entity = row.Building; obj["building"] = new { id = entity.Id, name = entity.Name, code = entity.Code, }; } break; } } return(obj); }
public IDictionary <string, object> GetBuildingAreaDynamic( BuildingArea row, AreaQueryProjection projection, AreaQueryOptions options) { var obj = new Dictionary <string, object>(); foreach (var f in projection.GetFieldsArr()) { switch (f) { case AreaQueryProjection.INFO: { var entity = row; obj["archived"] = entity.Archived; obj["code"] = entity.Code; obj["description"] = entity.Description; obj["name"] = entity.Name; } break; case AreaQueryProjection.SELECT: { var entity = row; obj["code"] = entity.Code; obj["name"] = entity.Name; } break; } } return(obj); }
public async Task <IActionResult> Get([FromQuery] AreaQueryFilter filter, [FromQuery] AreaQuerySort sort, [FromQuery] AreaQueryProjection projection, [FromQuery] AreaQueryPaging paging, [FromQuery] AreaQueryOptions options) { var validationResult = _service.ValidateGetAreas( User, filter, sort, projection, paging, options); if (!validationResult.Valid) { return(BadRequest(validationResult.Result)); } var result = await _service.QueryAreaDynamic( 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 ValidateGetAreas( ClaimsPrincipal principal, AreaQueryFilter filter, AreaQuerySort sort, AreaQueryProjection projection, AreaQueryPaging paging, AreaQueryOptions options) { return(ValidationResult.Pass()); }
public ValidationData ValidateGetAreas( AreaQueryFilter filter, AreaQuerySort sort, AreaQueryProjection projection, AreaQueryPaging paging, AreaQueryOptions options) { var validationData = new ValidationData(); return(validationData); }
public List <IDictionary <string, object> > GetBuildingAreaDynamic( IEnumerable <BuildingArea> rows, AreaQueryProjection projection, AreaQueryOptions options) { var list = new List <IDictionary <string, object> >(); foreach (var o in rows) { var obj = GetBuildingAreaDynamic(o, projection, options); list.Add(obj); } return(list); }
public QueryResult <IDictionary <string, object> > GetAreaDynamic( IEnumerable <AreaQueryRow> rows, AreaQueryProjection projection, AreaQueryOptions options, int?totalCount = null) { var list = new List <IDictionary <string, object> >(); foreach (var o in rows) { var obj = GetAreaDynamic(o, projection, options); list.Add(obj); } var resp = new QueryResult <IDictionary <string, object> >(); resp.Results = list; if (options.count_total) { resp.TotalCount = totalCount; } return(resp); }
public async Task <IActionResult> Get([FromQuery][QueryObject] AreaQueryFilter filter, [FromQuery] AreaQuerySort sort, [FromQuery] Business.Models.AreaQueryProjection projection, [FromQuery] AreaQueryPaging paging, [FromQuery] AreaQueryOptions options) { var validationData = _service.ValidateGetAreas( filter, sort, projection, paging, options); if (!validationData.IsValid) { return(BadRequest(AppResult.FailValidation(data: validationData))); } var result = await _service.QueryAreaDynamic( projection, validationData.TempData, filter, sort, paging, options); if (options.single_only && result == null) { return(NotFound(AppResult.NotFound())); } return(Ok(AppResult.Success(data: result))); }
public async Task <QueryResult <AreaQueryRow> > QueryArea( AreaQueryFilter filter = null, AreaQuerySort sort = null, AreaQueryProjection projection = null, AreaQueryPaging paging = null, AreaQueryOptions options = null) { var conn = context.Database.GetDbConnection(); var openConn = conn.OpenAsync(); var query = AreaQuery.CreateDynamicSql(); #region General if (filter != null) { query = query.SqlFilter(filter); } if (projection != null) { query = query.SqlJoin(projection); } 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 || !AreaQueryOptions.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 != null && options.single_only) { var single = queryResult.FirstOrDefault(); return(new QueryResult <AreaQueryRow> { SingleResult = single }); } if (options != null && options.count_total) { totalCount = await countTask; } return(new QueryResult <AreaQueryRow> { Results = queryResult, TotalCount = totalCount }); }
public async Task <QueryResult <IDictionary <string, object> > > QueryAreaDynamic( AreaQueryProjection projection, IDictionary <string, object> tempData = null, AreaQueryFilter filter = null, AreaQuerySort sort = null, AreaQueryPaging paging = null, AreaQueryOptions options = null) { var query = BuildingAreas.AsNoTracking(); if (filter != null) { query = query.Filter(filter, tempData); } int?totalCount = null; Task <int> countTask = null; var countQuery = query; query = query.Project(projection); if (options != null && !options.single_only) { #region List query if (sort != null) { query = query.Sort(sort); } if (paging != null && (!options.load_all || !AreaQueryOptions.IsLoadAllAllowed)) { query = query.SelectPage(paging.page, paging.limit); } #endregion #region Count query if (options.count_total) { countTask = countQuery.CountAsync(); } #endregion } if (options != null && options.count_total) { totalCount = await countTask; } var queryResult = await query.ToListAsync(); if (options != null && options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } var singleResult = GetBuildingAreaDynamic(single, projection, options); return(new QueryResult <IDictionary <string, object> >() { SingleResult = singleResult }); } var results = GetBuildingAreaDynamic(queryResult, projection, options); return(new QueryResult <IDictionary <string, object> >() { Results = results, TotalCount = totalCount }); }