Getting exception while doing server side filtering on date column
Hi Team,
I am using sync fusion data grid and I am getting an exception when searching on date column.
And we are using sync fusion grid nuget.
When we start entering date and it call the URl.
MY CODE IS AS
<SfGrid TValue="OrderResponse" @ref="OrderGrid"
AllowPaging="true"
AllowSorting="true"
AllowFiltering="true"
GridLines="GridLine.Both"
AllowTextWrap="true"
Toolbar="@(new List<string>() { "Search" })" @attributes="@(new Dictionary<string, object>(){ { "class", "table-striped" }})">
<GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Excel"></GridFilterSettings>
<SfDataManager Url="@OrderEndPoints.GetAllOrder" Adaptor="Adaptors.UrlAdaptor"></SfDataManager>
<GridPageSettings PageSize="10" PageSizes="@pagerDropdown" PageCount="3"></GridPageSettings>
<GridColumns>
<GridColumn Field="OrderTypeName" HeaderText="Source" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="OrderDate" Format="dd/MM/yyyy" Type="ColumnType.Date" HeaderText="Date" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="OrderReference" HeaderText="N° commande" Format="d" TextAlign="TextAlign.Center">
<Template>
@{
var model = (context as OrderResponse);
<span style="color: blue; cursor: pointer;" @onclick="@((e) => OpenDialog(model))">@model.OrderReference</span>
}
</Template>
</GridColumn>
<GridColumn Field="ClientReference" HeaderText="N° client" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="AxelisReference" HeaderText="Réf Axelis" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="TrackingNumber" HeaderText="N° tracking" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="AddressName" HeaderText="Destinataire" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="ZipCode" HeaderText="Code postal" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="City" HeaderText="Ville" TextAlign="TextAlign.Center"></GridColumn>
<GridColumn Field="Country" HeaderText="Pays" TextAlign="TextAlign.Center"></GridColumn>
</GridColumns>
</SfGrid>
Server side Code
[HttpPost("GetAllOrder")]
public object GetAllOrder([FromBody] DataManagerRequest dm)
{
return _orderService.GetAllOrder(dm);
}
Service Code
public object GetAllOrder(DataManagerRequest dm)
{
var DataSource = _unitOfWork.EmbryolisseRepository
if (dm.Skip == 0 && dm.Take == 0 && dm.Sorted.Count > 0)
{
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
var data = (IQueryable
DataSource = data.Cast
DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
IEnumerable
return dm.RequiresCounts ? new { result = ResultData1, count = DataSource.Count() } : ResultData1 as object;
}
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = DataOperations.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Count();
if (dm.Skip != 0)
{
DataSource = DataOperations.PerformSkip(DataSource, dm.Skip); //Paging
}
if (dm.Take != 0)
{
DataSource = DataOperations.PerformTake(DataSource, dm.Take);
}
IEnumerable
return dm.RequiresCounts ? new { result = ResultData, count = count } : ResultData as object;
}
Please assist me on this!!
