We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
|
<EjsGrid id="Grid" @ref="@grid" AllowPaging="true" AllowSorting="true" AllowFiltering="true" toolbar="@(new List<string>() {"Add", "Edit", "Delete", "Cancel", "Update" })">
<EjsDataManager Url="http://localhost:51972/api/Default" CrossDomain="true" Adaptor="Adaptors.WebApiAdaptor"></EjsDataManager>
<GridEditSettings AllowAdding="true" AllowDeleting="true" AllowEditing="true" Mode="EditMode.Normal"></GridEditSettings>
<GridColumns>
…………………………………………..
</GridColumns>
</EjsGrid> |
|
[HttpGet]
public object Get()
{
IQueryable<Order> data = db.GetAllOrders().AsQueryable();
var count = data.Count();
var queryString = Request.Query; //Based on this request query, handle the filter action
...
}
|
|
<EjsGrid TValue="Order" DataSource="@Orders" Height="315" AllowFiltering="true">
<GridFilterSettings Type="FilterType.Excel"></GridFilterSettings>
<GridEvents OnActionBegin="OnActionBegin" TValue="Order"></GridEvents>
...
</EjsGrid>
@code {
public void OnActionBegin(ActionEventArgs<Order> args)
{
if (args.RequestType.ToString() == "FilterChoiceRequest")
{
args.FilterChoiceCount = 2; //here, you can override the default take count of the filter records
}
}
...
}
|
|
[DefaultController.cs]
//Handle filter operations at server side
[HttpGet]
public object Get()
{
IQueryable<Order> data = db.GetAllOrders().AsQueryable();
var count = data.Count();
var queryString = Request.Query;
string filter = queryString["$filter"]; //filter query
string auto = queryString["$inlineCount"];
if (filter != null) //Filtering – Here you need to handle the filtering programmatically at server side, based on your Grid.
{
var newfiltersplits = filter;
var filtersplits = newfiltersplits.Split('(', ')', ' ');
var filterfield = filtersplits[1];
var filtervalue = filtersplits[3];
...
switch (filterfield)
{
case "OrderID": //Here we have performed filter by selecting the data matching the value
data = (from cust in data
where cust.OrderID.ToString() == filtervalue.ToString()
select cust);
break;
...
}
}
...
}
return take != 0 ? new { Items = data.Skip(skip).Take(take).ToList(), Count = data.Count() } : new { Items = data, Count = data.Count() };
}
|
