-
-
Notifications
You must be signed in to change notification settings - Fork 19
Expand file tree
/
Copy pathQueryKitExtensions.cs
More file actions
123 lines (100 loc) · 4.14 KB
/
QueryKitExtensions.cs
File metadata and controls
123 lines (100 loc) · 4.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
namespace QueryKit;
using Configuration;
public static class QueryKitExtensions
{
public static IQueryable<TEntity> ApplyQueryKit<TEntity>(this IQueryable<TEntity> source, QueryKitData queryKitData)
where TEntity : class
{
var appliedQueryable = source;
if (!string.IsNullOrWhiteSpace(queryKitData.Filters))
{
appliedQueryable = appliedQueryable.ApplyQueryKitFilter(queryKitData.Filters, queryKitData.Configuration);
}
if (!string.IsNullOrWhiteSpace(queryKitData.SortOrder))
{
appliedQueryable = appliedQueryable.ApplyQueryKitSort(queryKitData.SortOrder, queryKitData.Configuration);
}
return appliedQueryable;
}
public static IQueryable<TEntity> ApplyQueryKitFilter<TEntity>(this IQueryable<TEntity> source, string filter, IQueryKitConfiguration? config = null)
where TEntity : class
{
if (string.IsNullOrWhiteSpace(filter))
{
return source;
}
var expression = FilterParser.ParseFilter<TEntity>(filter, config);
return source.Where(expression);
}
public static IOrderedQueryable<T> ApplyQueryKitSort<T>(this IQueryable<T> queryable, string sortExpression, IQueryKitConfiguration? config = null)
{
var sortLambdas = SortParser.ParseSort<T>(sortExpression, config);
if (sortLambdas.Count == 0)
return queryable.OrderBy(_ => 0);
var firstSortInfo = sortLambdas[0];
if (firstSortInfo.Expression != null)
{
var orderedQueryable = firstSortInfo.IsAscending ? queryable.OrderBy(firstSortInfo.Expression) : queryable.OrderByDescending(firstSortInfo.Expression);
for (var i = 1; i < sortLambdas.Count; i++)
{
var sortInfo = sortLambdas[i];
if (sortInfo.Expression != null)
orderedQueryable = sortInfo.IsAscending
? orderedQueryable.ThenBy(sortInfo.Expression)
: orderedQueryable.ThenByDescending(sortInfo.Expression);
}
return orderedQueryable;
}
return queryable.OrderBy(x => x);
}
public static IEnumerable<TEntity> ApplyQueryKit<TEntity>(
this IEnumerable<TEntity> source,
QueryKitData queryKitData)
where TEntity : class
{
var applied = source;
if (!string.IsNullOrWhiteSpace(queryKitData.Filters))
{
applied = applied.ApplyQueryKitFilter(queryKitData.Filters, queryKitData.Configuration);
}
if (!string.IsNullOrWhiteSpace(queryKitData.SortOrder))
{
applied = applied.ApplyQueryKitSort(queryKitData.SortOrder, queryKitData.Configuration);
}
return applied;
}
public static IEnumerable<TEntity> ApplyQueryKitFilter<TEntity>(
this IEnumerable<TEntity> source,
string filter,
IQueryKitConfiguration? config = null)
where TEntity : class
{
if (string.IsNullOrWhiteSpace(filter))
return source;
var expression = FilterParser.ParseFilter<TEntity>(filter, config);
var predicate = expression.Compile();
return source.Where(predicate);
}
public static IOrderedEnumerable<T> ApplyQueryKitSort<T>(
this IEnumerable<T> source,
string sortExpression,
IQueryKitConfiguration? config = null)
{
var sortInfos = SortParser.ParseSort<T>(sortExpression, config);
if (sortInfos.Count == 0 || sortInfos[0].Expression is null)
return source.OrderBy(_ => 0);
var first = sortInfos[0];
var ordered = first.IsAscending
? source.OrderBy(first.Expression!.Compile())
: source.OrderByDescending(first.Expression!.Compile());
for (var i = 1; i < sortInfos.Count; i++)
{
var info = sortInfos[i];
if (info.Expression is null) continue;
ordered = info.IsAscending
? ordered.ThenBy(info.Expression.Compile())
: ordered.ThenByDescending(info.Expression.Compile());
}
return ordered;
}
}