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 ActionResult DataSourceStrategicPlan([FromBody] DataManagerRequest dm) { StrategicPlanModels obj = new StrategicPlanModels(context); var _data = obj.GetAll().OrderByDescending(a => a.sp_si_code).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 })); }