Beispiel #1
0
        public async Task <QueryResult <IDictionary <string, object> > > QueryProductionLineDynamic(
            ProductionLineQueryProjection projection,
            ProductionLineQueryOptions options,
            ProductionLineQueryFilter filter = null,
            ProductionLineQuerySort sort     = null,
            ProductionLineQueryPaging paging = null)
        {
            var query = ProductionLines;

            #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 || !ProductionLineQueryOptions.IsLoadAllAllowed))
                {
                    query = query.SelectPage(paging.page, paging.limit);
                }
                #endregion
            }

            if (options.single_only)
            {
                var single = query.SingleOrDefault();
                if (single == null)
                {
                    return(null);
                }
                var singleResult = GetProductionLineDynamic(single, projection, options);
                return(new QueryResult <IDictionary <string, object> >()
                {
                    Single = singleResult
                });
            }
            var entities = query.ToList();
            var list     = GetProductionLineDynamic(entities, projection, options);
            var result   = new QueryResult <IDictionary <string, object> >();
            result.List = list;
            if (options.count_total)
            {
                result.Count = totalCount;
            }
            return(result);
        }
Beispiel #2
0
 public ValidationData ValidateGetProductionLines(
     ClaimsPrincipal principal,
     ProductionLineQueryFilter filter,
     ProductionLineQuerySort sort,
     ProductionLineQueryProjection projection,
     ProductionLineQueryPaging paging,
     ProductionLineQueryOptions options)
 {
     return(new ValidationData());
 }
Beispiel #3
0
 public static IQueryable <ProductionLine> Sort(this IQueryable <ProductionLine> query,
                                                ProductionLineQuerySort model)
 {
     foreach (var s in model._sortsArr)
     {
         var asc       = s[0] == 'a';
         var fieldName = s.Remove(0, 1);
         switch (fieldName)
         {
         case ProductionLineQuerySort.CODE:
         {
             query = asc ? query.OrderBy(o => o.Code) :
                     query.OrderByDescending(o => o.Code);
         }
         break;
         }
     }
     return(query);
 }
        public async Task <IActionResult> Get([FromQuery][QueryObject] ProductionLineQueryFilter filter,
                                              [FromQuery] ProductionLineQuerySort sort,
                                              [FromQuery] ProductionLineQueryProjection projection,
                                              [FromQuery] ProductionLineQueryPaging paging,
                                              [FromQuery] ProductionLineQueryOptions options)
        {
            var validationData = _service.ValidateGetProductionLines(
                User, filter, sort, projection, paging, options);

            if (!validationData.IsValid)
            {
                return(BadRequest(AppResult.FailValidation(data: validationData)));
            }
            var result = await _service.QueryProductionLineDynamic(
                projection, options, filter, sort, paging);

            if (options.single_only && result == null)
            {
                return(NotFound(AppResult.NotFound()));
            }
            return(Ok(AppResult.Success(result)));
        }