Hi Junaid,
Thanks for contacting Syncfusion forums.
Query: “I want to check a condition on the column whether its value is greater or less than the current date? Is it possible?”
Yes. We can achieve your requirement using QueryCellInfo event and AddClass() method of EjsGrid. QueryCellInfo event will be triggered when each and every cell is created. Using AddClass method, you can customize the cell using CSS styles.
Refer the below code example.
|
<EjsGrid DataSource="@Orders" AllowFiltering="true" Height="315">
<GridFilterSettings Type="FilterType.Menu"></GridFilterSettings>
<GridEvents QueryCellInfo="CellInfoHandler" TValue="Order"></GridEvents>
<GridColumns>
. . . . . . . . .. . . . . .
</GridColumns>
</EjsGrid>
<style>
.currentweek{
background-color: green;
}
.previousweek{
background-color:yellow;
}
.previousmonth{
background-color: red;
}
</style>
@code{
public List<Order> Orders { get; set; }
public void CellInfoHandler(QueryCellInfoEventArgs<Order> Args)
{
if (Args.Column.Field == "OrderDate") {
if ( Args.Data.OrderDate < DateTime.Now.AddDays(-20))
{
Args.Cell.AddClass(new string[] { "previousmonth" });
}
else if (Args.Data.OrderDate < DateTime.Now.AddDays(-10))
{
Args.Cell.AddClass(new string[] { "previousweek" });
}
else
{
Args.Cell.AddClass(new string[] { "currentweek" });
}
}
} |
Refer our UG documentation for your reference
Please get back to us if you have further queries.
Regards,
Vignesh Natarajan.
