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 static IEnumerable <T> PerformFiltering <T>(
IEnumerable <T> dataSource,
List <WhereFilter> whereFilter,
string condition)
{
return((IEnumerable <T>)QueryableOperation.PerformFiltering <T>(dataSource.AsQueryable <T>(), whereFilter, condition));
}
public static IEnumerable <T> PerformSearching <T>(
IEnumerable <T> dataSource,
List <SearchFilter> searchFilter)
{
return((IEnumerable <T>)QueryableOperation.PerformSearching <T>(dataSource.AsQueryable <T>(), searchFilter));
}
public static IEnumerable <T> PerformSorting <T>(
IEnumerable <T> dataSource,
List <Sort> sortedColumns)
{
return((IEnumerable <T>)QueryableOperation.PerformSorting <T>(dataSource.AsQueryable <T>(), sortedColumns));
}
public static IEnumerable PerformSelect(IEnumerable dataSource, List <string> select) => (IEnumerable)QueryableOperation.PerformSelect(dataSource.AsQueryable(), select);
public static IEnumerable <T> PerformTake <T>(IEnumerable <T> dataSource, int take) => (IEnumerable <T>)QueryableOperation.PerformTake <T>(dataSource.AsQueryable <T>(), take);
public static IEnumerable PerformGrouping <T>(
IEnumerable <T> dataSource,
List <string> grouped)
{
return((IEnumerable)QueryableOperation.PerformGrouping <T>(dataSource.AsQueryable <T>(), grouped));
}
public static IEnumerable <T> Execute <T>(
IEnumerable <T> dataSource,
DataManagerRequest query)
{
return((IEnumerable <T>)QueryableOperation.Execute <T>(dataSource.AsQueryable <T>(), query));
}
public static IEnumerable <T> PerformSkip <T>(IEnumerable <T> dataSource, int skip) => (IEnumerable <T>)QueryableOperation.PerformSkip <T>(dataSource.AsQueryable <T>(), skip);
public static IQueryable <T> PerformSearching <T>(
IQueryable <T> dataSource,
List <SearchFilter> searchFilter)
{
return(QueryableOperation.PerformSearching <T>(dataSource, searchFilter));
}
public static IQueryable PerformSelect <T>(
IQueryable <T> dataSource,
List <string> select)
{
return(QueryableOperation.PerformSelect((IQueryable)dataSource, select));
}
public static IQueryable <T> PerformTake <T>(IQueryable <T> dataSource, int take) => QueryableOperation.PerformTake <T>(dataSource, take);
public static IQueryable <T> PerformSkip <T>(IQueryable <T> dataSource, int skip) => QueryableOperation.PerformSkip <T>(dataSource, skip);
public static IQueryable <T> PerformSorting <T>(
IQueryable <T> dataSource,
List <Sort> sortedColumns)
{
return(QueryableOperation.PerformSorting <T>(dataSource, sortedColumns));
}
public static IQueryable PerformGrouping <T>(
IQueryable <T> dataSource,
List <string> grouped)
{
return(QueryableOperation.PerformGrouping <T>(dataSource, grouped));
}
public static IQueryable <T> Execute <T>(
IQueryable <T> dataSource,
DataManagerRequest query)
{
return(QueryableOperation.Execute <T>(dataSource, query));
}
