/// <summary>
/// Helper method to append text to the display.
/// </summary>
/// <param name="title">Title of the search.</param>
/// <param name="searchRequest">The Search Request instance.</param>
private void AppendSearch(string title, DSSearchRequest searchRequest)
{
SampleSearchText.Text += string.Format(
"<h2>{0}</h2><div>{1}</div>",
title,
DSSerializer.Serialize(json, searchRequest));
}
/// <summary>
/// Executes a supplied DSSearch against a SQL Server database.
/// </summary>
/// <param name="searchRequest">Search definition and context.</param>
/// <returns>Results from the search or any erorr messages generated.</returns>
public DSSearchResponse ExecuteSearch(DSSearchRequest searchRequest)
{
// This is the context specific to this call
var ctx = new DSDataContext(_cache, searchRequest.APIContext);
var search = searchRequest.Search;
return(_processor.ExecuteSearch(search, ctx));
}
/// <summary>
/// Handles the Load event of the page. Displays results of a bunch of sample queries converted to JSON.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void Page_Load(object sender, EventArgs e)
{
var searchRequest = new DSSearchRequest();
DSSearch search;
searchRequest.APIContext = new DSAPIContext {
UserID = 943, SessionID = Guid.Empty.ToString()
};
search = new DSSearch(DSEnrollment.EntityName);
search.AddSelect(DSEnrollment.Attrs.EnrollmentID);
search.AddSelect(DSEnrollment.Attrs.Student.LastName);
search.AddSelect(DSEnrollment.Attrs.Student.ID);
search.AddSelect(DSEnrollment.Attrs.Course.Title);
search.AddSelect(DSEnrollment.Attrs.Course.Department.Name);
searchRequest.Search = search;
AppendSearch("Simple search", searchRequest);
search = new DSSearch(DSEnrollment.EntityName);
search.AddSelect(DSEnrollment.Attrs.EnrollmentID);
search.AddSelect(DSEnrollment.Attrs.Student.LastName);
search.AddSelect(DSEnrollment.Attrs.Student.ID);
search.AddSelect(DSEnrollment.Attrs.Course.Title);
search.AddSelect(DSEnrollment.Attrs.Course.Department.Name);
search.AddSelect(DSEnrollment.Attrs.Grade);
search.Where.Add(new DSPredicate
{
Column = DSEnrollment.Attrs.Course.Title,
Operator = DSSearchOperatorEnum.Contains,
Value = "e",
});
search.AddOrder(DSEnrollment.Attrs.Student.LastName);
searchRequest.Search = search;
AppendSearch("Search with filter", searchRequest);
searchRequest.Search.Where.OrGroup = true;
searchRequest.Search.Where.DSContains(DSEnrollment.Attrs.Course.Title, "s");
AppendSearch("Search with multiple filters", searchRequest);
}
public DSSearchResponse Search([FromBody] DSSearchRequest searchRequest)
{
return(_dataAccess.ExecuteSearch(searchRequest));
}
/// <summary>
/// Execute the supplied search request.
/// </summary>
/// <param name="searchRequest">The search request definition.</param>
/// <returns>A search response with results.</returns>
public DSSearchResponse ExecuteSearch(DSSearchRequest searchRequest)
{
return(_connector.ExecuteSearch(searchRequest));
}
