public ActionResult StrategyDataSource([FromBody] DataManagerRequest dm, string stratissue)
{
if (string.IsNullOrEmpty(stratissue) || stratissue.Contains("null"))
{
stratissue = null;
}
StrategyModels obj = new StrategyModels(context);
var _data = obj.GetAll().Where(a => (a.sp_si_code == stratissue || stratissue == 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 DataSourceStrategy([FromBody] DataManagerRequest dm)
{
//var _data = context.ViewSpActivity.AsNoTracking().Select(a => new
//{
// a.SpStrategyCode,
// a.SpSiCode,
// a.SpSiIssue,
// a.SpSiObjectives,
// a.SpStrategyDesc
//}).Distinct().OrderByDescending(a => a.SpStrategyCode).ToList();
StrategyModels obj = new StrategyModels(context);
//var _data = obj.GetAll().OrderByDescending(a => a.sp_strategy_code).ToList();
var _data = obj.GetAll().Select(a => new
{
a.sp_strategy_code,
a.sp_si_code,
a.sp_si_issue,
a.sp_si_objectives,
a.sp_strategy_desc
}).OrderByDescending(a => a.sp_strategy_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 }));
}
