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)); }
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)); }
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)); }
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)); }
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 })); }
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 })); } }
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); }
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)); }
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 })); } }
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)); }
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 }); }
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)); }
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 })); }
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); }
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)); }
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); } }
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)); }
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 }
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 })); }
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>())); }