how set code for school fees type in monthly , quarterly, Annually in

You can try something link this:

private IQueryableint?, Product>> GroupByDate(IQueryable products, DateGroupType group, DateTime startDate)
{
switch (group)
{
case DateGroupType.Day:
return products.GroupBy(x => SqlFunctions.DateDiff("dd", startDate, x.CreateDate));
case DateGroupType.Week:
return products.GroupBy(x => SqlFunctions.DateDiff("ww", startDate, x.CreateDate));
case DateGroupType.Month:
return products.GroupBy(x => SqlFunctions.DateDiff("mm", startDate, x.CreateDate));
case DateGroupType.Quarter:
return products.GroupBy(x => SqlFunctions.DateDiff("qq", startDate, x.CreateDate));
case DateGroupType.Year:
return products.GroupBy(x => SqlFunctions.DateDiff("yy", startDate, x.CreateDate));
default:
throw new NotSupportedException($"Grouping by '{group}' is not supported");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.