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

Question

how set code for school fees type in monthly , quarterly, Annually in c# shap pleas help

Amit Gupta · Answer

Hey When you design your code/database, in your case (school)-> the person might have the requirement, how the school manages the fees. When you fully understand the requirement (by keeping all sorts of future stuffs) go ahead to implement that. If you stuck somewhere then explain more to help you Hope you undertand the point

Rijwan Ansari · Answer

You can try something link this: private IQueryable int ?, 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" ); } }

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

Answers (2)