public ActionResult DataArtista(Syncfusion.JavaScript.DataManager dm) { DataResultArtista result = new DataResultArtista(); Syncfusion.JavaScript.DataSources.DataOperations dataOperations = new Syncfusion.JavaScript.DataSources.DataOperations(); result.result = context.Artistas.ToList(); if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting { result.result = dataOperations.PerformSorting(result.result, dm.Sorted); } if (dm.Where != null && dm.Where.Count > 0) //Filtering { result.result = dataOperations.PerformWhereFilter(result.result, dm.Where, dm.Where[0].Operator); if (!dm.RequiresCounts) { return(Json(result.result)); } } result.count = context.Artistas.AsQueryable().Count(); if (dm.Skip != 0) { result.result = dataOperations.PerformSkip(result.result, dm.Skip); } if (dm.Take != 0) { result.result = dataOperations.PerformTake(result.result, dm.Take); } return(Json(new { result = result.result, count = result.count }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetOrder_Lab(Syncfusion.JavaScript.DataManager dm, int FC, string StartDate, string EndDate) { DateTime?sDate = DateTime.ParseExact(StartDate, "dd/MM/yyyy", null); DateTime?eDate = DateTime.ParseExact(EndDate, "dd/MM/yyyy", null); LaboratoryModels obj = new LaboratoryModels(); //IEnumerable DataSource = obj.getOrders(18, DateTime.Parse("2017-04-01 00:00:00.000"), DateTime.Parse("2017-05-31 00:00:00.000")); context.Configuration.ProxyCreationEnabled = false; IEnumerable data = obj.GetOrder_Add(FC, sDate, eDate).ToList(); int count = obj.GetOrder_Add(FC, sDate, eDate).Count(); DataOperations operation = new DataOperations(); //Performing filtering operation if (dm.Where != null) { data = operation.PerformWhereFilter(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 }, JsonRequestBehavior.AllowGet)); }
//GetOrder_Add public ActionResult GetOrderCustom(Syncfusion.JavaScript.DataManager dm, string param_on) { //string a = start_date.ToString(); //string b = end_date.ToString(); TBModels obj = new TBModels(); //IEnumerable DataSource = obj.getOrders(18, DateTime.Parse("2017-04-01 00:00:00.000"), DateTime.Parse("2017-05-31 00:00:00.000")); context.Configuration.ProxyCreationEnabled = false; IEnumerable data = obj.GetOrderCustom(param_on); int count = obj.GetOrderCustom(param_on).Count(); DataOperations operation = new DataOperations(); //Performing filtering operation if (dm.Where != null) { data = operation.PerformWhereFilter(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 }, JsonRequestBehavior.AllowGet)); }
public ActionResult BatchDataSMC(Syncfusion.JavaScript.DataManager dm, int?Code) { IEnumerable Data = context.Order_SMC_SLM_Physical_Count.Where(a => a.ProductCode == Code).ToList(); DataResult result = new DataResult(); DataOperations operation = new DataOperations(); result.count = context.Order_SMC_SLM_Physical_Count.Where(a => a.ProductCode == Code).ToList().Count(); if (dm.Skip > 0) { Data = operation.PerformSkip(Data, dm.Skip); } if (dm.Take > 0) { Data = operation.PerformTake(Data, dm.Take); } result.result = Data; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult UrlDataSource(Syncfusion.JavaScript.DataManager dm) { if (order.Count() == 0) { BindDataSource(); } IEnumerable data = order.ToList(); // IEnumerable data = new NorthwindDataContext().OrdersViews.ToList(); DataOperations operation = new DataOperations(); if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting { data = operation.PerformSorting(data, dm.Sorted); } if (dm.Where != null && dm.Where.Count > 0) //Filtering { data = operation.PerformWhereFilter(data, dm.Where, dm.Where[0].Operator); } if (dm.Search != null && dm.Search.Count > 0) //Searching { data = operation.PerformSearching(data, dm.Search); } if (dm.Select != null && dm.Select.Count > 0) { data = operation.PerformSelect(data, dm.Select); } 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 BatchDataEditSMC(Syncfusion.JavaScript.DataManager dm, int?FacilityCode, string DateOfPhysicalCount) { DateTime vDate = DateTime.ParseExact(DateOfPhysicalCount, "dd/MM/yyyy", null); IEnumerable Data = context.View_WebTemplate_SMC_SLM_PhysicalCount_Edit.Where(h => h.FacilityCode == FacilityCode && h.DateOfPhysicalCount == vDate).ToList(); DataResult result = new DataResult(); DataOperations operation = new DataOperations(); result.count = context.View_WebTemplate_SMC_SLM_PhysicalCount_Edit.Where(h => h.FacilityCode == FacilityCode && h.DateOfPhysicalCount == vDate).ToList().Count(); if (dm.Skip > 0) { Data = operation.PerformSkip(Data, dm.Skip); } if (dm.Take > 0) { Data = operation.PerformTake(Data, dm.Take); } result.result = Data; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult BatchData(Syncfusion.JavaScript.DataManager dm, int?Code) { context.Configuration.ProxyCreationEnabled = false; IEnumerable Data = context.Order_DrugDetails_PhysicalCount.Where(a => a.product_code == Code).ToList(); DataResult result = new DataResult(); DataOperations operation = new DataOperations(); context.Configuration.ProxyCreationEnabled = false; result.count = context.Order_DrugDetails_PhysicalCount.Where(a => a.product_code == Code).ToList().Count(); if (dm.Skip > 0) { Data = operation.PerformSkip(Data, dm.Skip); } if (dm.Take > 0) { Data = operation.PerformTake(Data, dm.Take); } result.result = Data; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetOrderTestSummary(Syncfusion.JavaScript.DataManager dm, string param_on) { TBModels obj = new TBModels(); IEnumerable data = obj.GetOrderTBSummary(param_on); int count = obj.GetOrderTBSummary(param_on).Count(); DataOperations operation = new DataOperations(); //Performing filtering operation if (dm.Where != null) { data = operation.PerformWhereFilter(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 }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetOrder(Syncfusion.JavaScript.DataManager dm, string param_on) { context.Configuration.ProxyCreationEnabled = false; IEnumerable data = context.View_Order_TrackingModule_OrderDetails_1.Where(a => a.OrderNumber == param_on); int count = context.View_Order_TrackingModule_OrderDetails_1.Where(a => a.OrderNumber == param_on).Count(); DataOperations operation = new DataOperations(); //Performing filtering operation if (dm.Where != null) { data = operation.PerformWhereFilter(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 }, JsonRequestBehavior.AllowGet)); //return Json(data, JsonRequestBehavior.AllowGet); }