String GetCustomOrderBy(List <String> order, DataColumnCollection columns)
{
QueryMarshaller.BuildCompareToOrderBy(order, columns);
if (GlobalValues.Group.Key != GroupKeys.All
&&
(GlobalValues.CompareTo.Key == CompareToKeys.SelSchools)
)
{
order.Insert(0, v_WSAS.District_Name);//district, school
}
if (GlobalValues.Grade.Key == GradeKeys.AllDisAgg)
{
order.Add(v_WSAS.GradeCode + " ASC");
}
if (GlobalValues.SubjectID.Key == SubjectIDKeys.AllTested)
{
order.Add(v_WSAS.SubjectID);
}
if (GlobalValues.Group.Key != GroupKeys.All)
{
QueryMarshaller.BuildOrderByViewByGroup(order, columns);
}
return(String.Join(",", order.ToArray()));
}