public IActionResult UrlDatasource([FromBody] DataManagerRequest dm)
        {
            EFDataContext          db         = new EFDataContext();
            IQueryable <Customers> DataSource = db.customers;
            QueryableOperation     operation  = new QueryableOperation();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                       //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Count();

            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
예제 #2
0
        public IActionResult OnPostUrlDataSource([FromBody] DataManagerRequest dm)
        {
            IEnumerable <DictionaryValue_Dto> DataSource = DictionaryValueAppService.GetAllCustom();
            DataOperations operation = new DataOperations();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                       //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <DictionaryValue_Dto>().Count();

            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(dm.RequiresCounts ? new JsonResult(new { result = DataSource, count = count }) : new JsonResult(DataSource));
        }
예제 #3
0
        public IActionResult Setting([FromBody] DataManagerRequest dm)
        {
            IEnumerable <ProductIncoms> DataSource = data.SqlQuery <ProductIncoms>("select * from ProductIncoms order by Id desc");
            DataOperations operation = new DataOperations();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                       //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <ProductIncoms>().Count();

            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
예제 #4
0
        public async Task <IActionResult> PermissionsDataSource(long roleId, [FromBody] DataManagerRequest dm)
        {
            var result =
                await getPermissionsService.GetRolePermissionsAsync(roleId);

            return(dm.RequiresCounts ? Json(new { result = result, count = result.Count }) : Json(result));
        }
예제 #5
0
        public override async Task <object> ReadAsync(DataManagerRequest dataManagerRequest, string key = null)
        {
            #region 建立查詢物件
            DataRequest dataRequest = new DataRequest()
            {
                Skip = dataManagerRequest.Skip,
                Take = dataManagerRequest.Take,
            };
            if (dataManagerRequest.Search != null && dataManagerRequest.Search.Count > 0)
            {
                var keyword = dataManagerRequest.Search[0].Key;
                dataRequest.Search = keyword;
            }
            if (CurrentSortCondition != null)
            {
                dataRequest.Sorted = CurrentSortCondition;
            }
            #endregion

            #region 發出查詢要求
            DataRequestResult <MenuRoleAdapterModel> adaptorModelObjects = await Service.GetAsync(dataRequest);

            var item = dataManagerRequest.RequiresCounts
                ? new DataResult()
            {
                Result = adaptorModelObjects.Result, Count = adaptorModelObjects.Count
            }
                : (object)adaptorModelObjects.Result;
            await Task.Yield();

            return(item);

            #endregion
        }
        public ActionResult UrlDatasource(DataManagerRequest dm)
        {
            List <GanttData> DataList = db.GanttDatas.ToList();
            var count = DataList.Count();

            return(Json(new { result = DataList, count = count }));
        }
예제 #7
0
        public ActionResult DataSource([FromBody] DataManagerRequest dm)
        {
            using (HttpClient client = new HttpClient())
            {
                client.BaseAddress = new Uri(GloVar.iBaseURI);
                MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
                client.DefaultRequestHeaders.Accept.Add(contentType);
                HttpResponseMessage response = client.GetAsync("/api/StdCats/?mdBID=" + mdBId).Result;
                var            stringData    = response.Content.ReadAsStringAsync().Result;
                List <StdCat>  stdCat        = JsonConvert.DeserializeObject <List <StdCat> >(stringData);
                DataOperations operation     = new DataOperations();
                IEnumerable    data          = stdCat;
                var            count         = data.AsQueryable().Count();
                if (dm.Skip > 0)
                {
                    data = operation.PerformSkip(data, dm.Skip);
                }

                if (dm.Take > 0)
                {
                    data = operation.PerformTake(data, dm.Take);
                }

                return(Json(new { result = data, count = count }));
            }
        }
예제 #8
0
        public ActionResult UrlDatasource([FromBody] DataManagerRequest dm)
        {
            IEnumerable DataSource = _jobService.Get();



            DataOperations operation = new DataOperations();

            if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <Job>().Count();

            if (dm.Skip != 0)//Paging
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(Json(new { result = DataSource, count = count }));
        }
        public override async Task <object> ReadAsync(DataManagerRequest dm, string key = null)
        {
            var orders = await _ordersRepository.Get().ConfigureAwait(false);

            if (dm.Search?.Count > 0)
            {
                orders = DataOperations.PerformSearching(orders, dm.Search);
            }
            if (dm.Sorted?.Count > 0)
            {
                orders = DataOperations.PerformSorting(orders, dm.Sorted);
            }
            if (dm.Where?.Count > 0)
            {
                orders = DataOperations.PerformFiltering(orders, dm.Where, dm.Where[0].Operator);
            }

            var count = orders.Count();

            if (dm.Skip != 0)
            {
                orders = DataOperations.PerformSkip(orders, dm.Skip);
            }
            if (dm.Take != 0)
            {
                orders = DataOperations.PerformTake(orders, dm.Take);
            }

            return(dm.RequiresCounts ? new DataResult {
                Result = orders, Count = count
            } : (object)orders);
        }
예제 #10
0
        public async Task <IActionResult> Patients([FromBody] DataManagerRequest dm)
        {
            var patientViewModel = await _patientViewModelService.GetPatientItems();

            //  return Json(patientViewModel);

            IEnumerable <PatientViewModel> DataSource = patientViewModel.PatientItems;
            DataOperations operation = new DataOperations();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                       //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <PatientViewModel>().Count();

            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);         //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
예제 #11
0
 public ActionResult DataSource(string Clss, string tSearchStr, [FromBody] DataManagerRequest dm)
 {
     using (HttpClient client = new HttpClient())
     {
         client.BaseAddress = new Uri(GloVar.iBaseURI);
         MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
         client.DefaultRequestHeaders.Accept.Add(contentType);
         HttpResponseMessage response = client.GetAsync("/api/SearchStds?SClass=" + Clss + "&tSearchStr=" + tSearchStr + "&dSess=" + dSess + "&mdBID=" + mdBId).Result;
         var stringData = response.Content.ReadAsStringAsync().Result;
         IEnumerable <Students> stdLst    = JsonConvert.DeserializeObject <IEnumerable <Students> >(stringData);
         DataOperations         operation = new DataOperations();
         IEnumerable            data      = stdLst;
         var count = data.AsQueryable().Count();
         //ViewBag.stdFee = stdFee;
         if (dm.Skip > 0)
         {
             data = operation.PerformSkip(data, dm.Skip);
         }
         if (dm.Take > 0)
         {
             data = operation.PerformTake(data, dm.Take);
         }
         return(Json(new { result = data, count = count }));
     }
 }
예제 #12
0
        public ActionResult DataSource(string clss, DateTime stDate, [FromBody] DataManagerRequest dm)
        {
            double fStDate = GloFunc.ToOADate(stDate);

            using (HttpClient client = new HttpClient())
            {
                client.BaseAddress = new Uri(iBaseURI);
                MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
                client.DefaultRequestHeaders.Accept.Add(contentType);
                HttpResponseMessage response = client.GetAsync("/api/Conveyances?clss=" + clss + "&stDate=" + fStDate + "&dSess=" + dSess + "&mdBID=" + mdBId).Result;
                var stringData              = response.Content.ReadAsStringAsync().Result;
                List <Conveyance> subjects  = JsonConvert.DeserializeObject <List <Conveyance> >(stringData);
                DataOperations    operation = new DataOperations();
                IEnumerable       data      = subjects;
                var count = data.AsQueryable().Count();
                if (dm.Skip > 0)
                {
                    data = operation.PerformSkip(data, dm.Skip);
                }
                if (dm.Take > 0)
                {
                    data = operation.PerformTake(data, dm.Take);
                }
                return(Json(new { result = data, count = count }));
            }
        }
        public IActionResult UrlDatasource([FromBody] DataManagerRequest dm)
        {
            IEnumerable <OrderDetails> DataSource = OrderDetails.GetOrderDetails();
            int count = DataSource.Count();

            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
        public IActionResult UrlDatasource([FromBody] DataManagerRequest dm)
        {
            IEnumerable    DataSource = OrdersDetails.GetAllRecords();
            DataOperations operation  = new DataOperations();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                       //Sorting
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <OrdersDetails>().Count();

            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }
            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
예제 #15
0
        public static JsonResult FilterDataSource <T>(this DataManagerRequest dm, IEnumerable <T> dataSource)
        {
            var operation = new DataOperations();

            if (dm.Search != null && dm.Search.Any())
            {
                dataSource = operation.PerformSearching(dataSource, dm.Search);
            }
            if (dm.Sorted != null && dm.Sorted.Any())
            {
                dataSource = operation.PerformSorting(dataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Any())
            {
                dataSource = operation.PerformFiltering(dataSource, dm.Where, dm.Where[0].Operator);
            }

            var dataList = dataSource.ToList();
            var count    = dataList.Count;

            if (dm.Skip != 0)
            {
                dataList = operation.PerformSkip(dataList, dm.Skip).ToList();
            }
            if (dm.Take != 0)
            {
                dataList = operation.PerformTake(dataList, dm.Take).ToList();
            }
            return(dm.RequiresCounts ? new JsonResult(new { result = dataList, count }) : new JsonResult(dataSource));
        }
        public object DataSource([FromBody] DataManagerRequest dm)
        {

            IEnumerable treeData = TreeData.GetTree();
            DataOperations operation = new DataOperations();
            if (dm.Where != null && dm.Where.Count > 0)
            {
                treeData = operation.PerformFiltering(treeData, dm.Where, "and");
            }

            if (dm.Sorted != null && dm.Sorted.Count > 0)
            {
                treeData = operation.PerformSorting(treeData, dm.Sorted);
            }

            var count = TreeData.Tree.Count();
            if (dm.Skip != 0)
            {
                treeData = operation.PerformSkip(treeData, dm.Skip);
            }

            if (dm.Take != 0)
            {
                treeData = operation.PerformTake(treeData, dm.Take);
            }

            return dm.RequiresCounts ? Json(new { result = treeData, count = count }) : Json(treeData);

        }
        public object Post([FromBody] DataManagerRequest dm)
        {
            if (order.Count == 0)
            {
                BindDataSource();
            }
            IEnumerable DataSource = order;

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = DataOperations.PerformSearching(DataSource, dm.Search); //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0)                            //Sorting
            {
                DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast <Orders>().Count();

            if (dm.Skip != 0)
            {
                DataSource = DataOperations.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = DataOperations.PerformTake(DataSource, dm.Take);
            }
            return(new { result = DataSource, count = count });
        }
예제 #18
0
        public async Task <ReadGrudDto> GetForGrid([FromBody] DataManagerRequest dm)
        {
            var data = await _repository.GetAllListAsync();

            IEnumerable <ReadEmployeeDto> employees = ObjectMapper.Map <List <ReadEmployeeDto> >(data);

            var operations = new DataOperations();

            if (dm.Where != null && dm.Where.Count > 0)
            {
                employees = operations.PerformFiltering(employees, dm.Where, "and");
            }

            if (dm.Sorted != null && dm.Sorted.Count > 0)
            {
                employees = operations.PerformSorting(employees, dm.Sorted);
            }

            var count = employees.Count();

            if (dm.Skip != 0)
            {
                employees = operations.PerformSkip(employees, dm.Skip);
            }

            if (dm.Take != 0)
            {
                employees = operations.PerformTake(employees, dm.Take);
            }

            return(new ReadGrudDto()
            {
                result = employees, count = count
            });
        }
        public ActionResult RolesDataSource([FromBody] DataManagerRequest dataManager)
        {
            IEnumerable data = _roleManager.Roles.Select(r => new ApplicationRolesViewModel
            {
                Id       = r.Id,
                RoleName = r.Name
            }).ToList();
            DataOperations operation = new DataOperations();
            int            count     = data.Cast <ApplicationRolesViewModel>().Count();

            if (dataManager.Search != null && dataManager.Search.Count > 0) //Searching
            {
                data = operation.PerformSearching(data, dataManager.Search);
            }

            if (dataManager.Sorted != null && dataManager.Sorted.Count > 0) //Sorting
            {
                data = operation.PerformSorting(data, dataManager.Sorted);
            }

            if (dataManager.Skip != 0)                                      //Paging
            {
                data = operation.PerformSkip(data, dataManager.Skip);
            }
            if (dataManager.Take != 0)
            {
                data = operation.PerformTake(data, dataManager.Take);
            }
            return(Json(new { result = data, count = count }));
        }
        public IActionResult GridDatasource([FromBody] DataManagerRequest dm)
        {
            var DataSource = OrdersDetails.GetAllRecords().ToList();

            DataOperations operation = new DataOperations();
            int            count     = DataSource.Count();

            return(dm.RequiresCounts ? Json(new { result = DataSource.Skip(dm.Skip).Take(dm.Take), count = count }) : Json(DataSource));
        }
예제 #21
0
        public DataResult DataOperationInvoke <T>(
            IEnumerable DataSource,
            DataManagerRequest queries)
        {
            DataResult dataResult = new DataResult();

            if (DataSource == null || DataSource.Cast <object>().Count <object>() == 0)
            {
                dataResult.Result = DataSource;
                return(dataResult);
            }
            if (!(DataSource.GetType() == typeof(List <ExpandoObject>)) && !(DataSource.GetElementType() == typeof(ExpandoObject)))
            {
                Type type        = typeof(IDynamicMetaObjectProvider);
                Type elementType = DataSource.GetElementType();
                Type c           = (object)elementType != null ? elementType.BaseType : (Type)null;
                if (!type.IsAssignableFrom(c))
                {
                    List <WhereFilter> where = queries.Where;
                    List <SearchFilter> search = queries.Search;
                    List <Sort>         sorted = queries.Sorted;
                }
            }
            DataSource       = DynamicObjectOperation.PerformDataOperations(DataSource, queries);
            dataResult.Count = DataSource.Cast <object>().Count <object>();
            IEnumerable jsonData = DataSource;

            if (queries.Skip != 0)
            {
                DataSource = DataOperations.PerformSkip(DataSource, queries.Skip);
            }
            if (queries.Take != 0)
            {
                DataSource = DataOperations.PerformTake(DataSource, queries.Take);
            }
            if (queries.IdMapping != null && queries.Where != null)
            {
                DataSource = this.CollectChildRecords(DataSource, queries);
            }
            List <Aggregate> aggregates = queries.Aggregates;
            List <string>    group      = queries.Group;

            if (group != null && queries.ServerSideGroup)
            {
                foreach (string field in queries.Group)
                {
                    DataSource = DataUtil.Group <T>(DataSource, field, queries.Aggregates, 0, queries.GroupByFormatter);
                }
                dataResult.Result = DataSource;
            }
            else
            {
                dataResult.Result = (IEnumerable)DataSource.Cast <object>().ToList <object>();
            }
            return(dataResult);
        }
        public async Task <IActionResult> List(Guid freelancerId, [FromBody] DataManagerRequest dm)
        {
            List <Freelancer> freelancers = await _freelancerService.GetAllAsync();

            List <Availability> availabilities = await _availabilityService.GetAvailabilitiesByFreelancerIdAsync(freelancerId);

            List <AvailabilityVM> availabilitiesVM = PrepareAvailabilityVM(availabilities);

            return(Json(new { result = availabilitiesVM, count = availabilitiesVM.Count }));
        }
예제 #23
0
        public object Post([FromBody] DataManagerRequest dm)
        {
            IEnumerable data  = db.GetAllOrders();  //call the method to fetch data from db and return to client
            int         count = data.Cast <Order>().Count();

            return(dm.RequiresCounts ? new DataResult()
            {
                Result = data, Count = count
            } : (object)data);
        }
예제 #24
0
        public override async Task <object> ReadAsync(DataManagerRequest dataManagerRequest, string key = null)
        {
            if (dataManagerRequest.RequiresCounts)
            {
                return(new DataResult {
                    Result = GetData(dataManagerRequest.Skip, dataManagerRequest.Take), Count = 100
                });
            }

            return(GetData(0, 10));
        }
예제 #25
0
        public override async Task <object> ReadAsync(DataManagerRequest dataManagerRequest, string key = null)
        {
            List <Bug> bugs = await _dataLayer.GetBugsAsync();

            int count = await _dataLayer.GetBugCountAsync();

            return(dataManagerRequest.RequiresCounts ? new DataResult()
            {
                Result = bugs, Count = count
            } : count);
        }
        public override object Read(DataManagerRequest dm, string key = null)
        {
            using (var databaseContext = DatabaseContextFactory.CreateDbContext())
            {
                var dataSource = FilterRead(databaseContext.Set <TEntity>().AsQueryable());


                if (dm.Search != null && dm.Search.Count > 0)
                {
                    // Searching
                    dataSource = DataOperations.PerformSearching(dataSource, dm.Search);
                }

                if (dm.Sorted != null && dm.Sorted.Count > 0)
                {
                    // Sorting
                    dataSource = DataOperations.PerformSorting(dataSource, dm.Sorted);
                }

                if (dm.Where != null && dm.Where.Count > 0) //Filtering
                {
                    try
                    {
                        dataSource = DataOperations.PerformFiltering(dataSource, dm.Where, dm.Where[0].Operator);
                    }
                    catch (Exception e)
                    {
                        Log.Logger.Error(nameof(Read), e);
                    }
                }

                var countBeforePaging = dataSource.Count();
                if (dm.Skip != 0)
                {
                    //Paging
                    dataSource = DataOperations.PerformSkip(dataSource, dm.Skip);
                }

                if (dm.Take != 0)
                {
                    dataSource = DataOperations.PerformTake(dataSource, dm.Take);
                }

                var toList = dataSource.ToList();
                toList = ListFilter(toList);

                return(dm.RequiresCounts
                    ? new DataResult {
                    Result = toList, Count = countBeforePaging
                }
                    : (object)toList);
            }
        }
예제 #27
0
        public IActionResult ForDropDown([FromBody] DataManagerRequest dm)
        {
            IEnumerable <Customers> DataSource = data.GetAll <Customers>();
            DataOperations          operation  = new DataOperations();

            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search);  //Search
            }
            int count = DataSource.Cast <Customers>().Count();

            return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
        }
예제 #28
0
        public override async Task <object> ReadAsync(DataManagerRequest dataManagerRequest, string key = null)
        {
            #region 建立查詢物件
            DataRequest dataRequest = new DataRequest()
            {
                Skip = dataManagerRequest.Skip,
                Take = dataManagerRequest.Take,
            };
            if (dataManagerRequest.Search != null && dataManagerRequest.Search.Count > 0)
            {
                var keyword = dataManagerRequest.Search[0].Key;
                dataRequest.Search = keyword;
            }
            if (CurrentSortCondition != null)
            {
                dataRequest.Sorted = CurrentSortCondition;
            }
            #endregion

            #region 發出查詢要求
            try
            {
                DataRequestResult <OrderItemAdapterModel> adaptorModelObjects;
                if (HeaderID == -1)
                {
                    adaptorModelObjects = await Service.GetAsync(dataRequest);
                }
                else
                {
                    adaptorModelObjects = await Service.GetByHeaderIDAsync(HeaderID, dataRequest);
                }
                var item = dataManagerRequest.RequiresCounts
                    ? new DataResult()
                {
                    Result = adaptorModelObjects.Result, Count = adaptorModelObjects.Count
                }
                    : (object)adaptorModelObjects.Result;
                await Task.Yield();

                return(item);
            }
            catch (Exception)
            {
                return(new DataResult()
                {
                    Result = new List <OrderItemAdapterModel>(), Count = 0
                });
            }
            #endregion
        }
예제 #29
0
        public ActionResult StrategicPlanDataSource([FromBody] DataManagerRequest dm, string SpSiCode, int?SpStrategyCode)
        {
            if (string.IsNullOrEmpty(SpSiCode) || SpSiCode.Contains("null"))
            {
                SpSiCode = null;
            }

            StrategicPlanModels obj = new StrategicPlanModels(context);

            //IEnumerable data = _data.Where(e => ((e.sp_si_code == sp_si_code || sp_si_code == null) && (e.sp_strategy_code == sp_strategy_code || sp_strategy_code == null))).ToList();
            //int count = _data.Where(e => ((e.sp_si_code == sp_si_code || sp_si_code == null) && (e.sp_strategy_code == sp_strategy_code || sp_strategy_code == null))).ToList().Count;

            var         _data = obj.GetAll().Where(a => (a.sp_si_code == SpSiCode || SpSiCode == null) && (a.sp_strategy_code == SpStrategyCode || SpStrategyCode == null)).ToList();
            IEnumerable data  = _data;
            int         count = _data.Count;

            DataOperations operation = new DataOperations();

            //Performing filtering operation
            if (dm.Where != null)
            {
                data = operation.PerformFiltering(data, dm.Where, "and");
                var filtered = (IEnumerable <object>)data;
                count = filtered.Count();
            }
            //Performing search operation
            if (dm.Search != null)
            {
                data = operation.PerformSearching(data, dm.Search);
                var searched = (IEnumerable <object>)data;
                count = searched.Count();
            }
            //Performing sorting operation
            if (dm.Sorted != null)
            {
                data = operation.PerformSorting(data, dm.Sorted);
            }

            //Performing paging operations
            if (dm.Skip > 0)
            {
                data = operation.PerformSkip(data, dm.Skip);
            }
            if (dm.Take > 0)
            {
                data = operation.PerformTake(data, dm.Take);
            }

            return(Json(new { result = data, count = count }));
        }
예제 #30
0
        public override async Task <object> ProcessResponse <T>(
            object Data,
            DataManagerRequest queries)
        {
            if (queries.RequiresCounts)
            {
                List <string> group = queries.Group;
                // ISSUE: explicit non-virtual call
                return((group != null ? (__nonvirtual(group.Count) > 0 ? 1 : 0) : 0) != 0 ? (object)await Task.FromResult <DataResult <object> >(Data as DataResult <object>) : (object)await Task.FromResult <DataResult <object> >(Data as DataResult <object>));
            }
            List <string> group1 = queries.Group;

            // ISSUE: explicit non-virtual call
            return((group1 != null ? (__nonvirtual(group1.Count) > 0 ? 1 : 0) : 0) != 0 ? (object)await Task.FromResult <List <Group <T> > >(((IEnumerable)Data).Cast <Group <T> >().ToList <Group <T> >()) : (object)await Task.FromResult <List <T> >(((IEnumerable)Data).Cast <T>().ToList <T>()));
        }