/
SearchPanesEndpoint.cs
60 lines (55 loc) · 2.29 KB
/
SearchPanesEndpoint.cs
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
using DataTables;
using MinimalDatatablesEditor.Endpoints.Internal;
using MinimalDatatablesEditor.Models;
using Newtonsoft.Json;
namespace MinimalDatatablesEditor.Endpoints;
public class SearchPanesEndpoint : IEndpoints
{
public static void DefineEndpoint(IEndpointRouteBuilder app)
{
/// <summary>
/// This Controller is used to demonstrate SearchPanes use through Server Side Processing
/// </summary>
app.MapMethods("/api/searchPanes", new[] {"POST", "GET"},
(HttpRequest request) =>
{
var dbType = Environment.GetEnvironmentVariable("DBTYPE");
var dbConnection = Environment.GetEnvironmentVariable("DBCONNECTION");
using var db = new Database(dbType, dbConnection);
var response = new Editor(db, "users")
.Model<UploadManyModel>()
.Field(new Field("users.first_name")
.SearchPaneOptions(new SearchPaneOptions())
)
.Field(new Field("users.last_name")
.SearchPaneOptions(new SearchPaneOptions())
)
.Field(new Field("users.phone")
.SearchPaneOptions(new SearchPaneOptions()
.Table("users")
.Value("phone")
)
)
.Field(new Field("sites.name")
.SearchPaneOptions(new SearchPaneOptions()
.Label("sites.name")
.Value("sites.name")
.LeftJoin("sites", "sites.id", "=", "users.site")
)
)
.Field(new Field("users.site")
.Options(new Options()
.Table("sites")
.Value("id")
.Label("name")
)
)
.LeftJoin("sites", "sites.id", "=", "users.site")
.Debug(true)
.TryCatch(false)
.Process(request)
.Data();
return JsonConvert.SerializeObject(response);
});
}
}