public static void SetLowGradeFloors(GlobalValues globals) { //kludge : if (globals.LOWGRADE < 12) { globals.LOWGRADE = 12; } int floor = (GradeCodeFloorMap.ContainsKey(Int16.Parse(globals.Grade.Value))) ? GradeCodeFloorMap[Int16.Parse(globals.Grade.Value)] : globals.LOWGRADE; if (globals.HIGHGRADE > floor && globals.LOWGRADE < floor) { globals.LOWGRADE = floor; } }
public String BuildAutoGradeCodeClause(SQLHelper.WhereClauseJoiner join, String field, String dbObject) { String strOrAggGradeCode = String.Empty; Int16 gradeCode = Int16.Parse(GlobalValues.Grade.Value); Int16 floor = (GradeCodeFloorMap.ContainsKey(gradeCode)) ? GradeCodeFloorMap[gradeCode] : GradeCodeFloorMap[99]; //Include Combined Grades only for pages that have individual grade selections if (GlobalValues.Group.Key != GroupKeys.Grade) // i.e. this clause was triggered some other way { strOrAggGradeCode = "OR {0} = '" + //WSAS Exception for "All Tested" Flag ((GradeCodeFloorMap.ContainsKey(gradeCode) && GlobalValues.Grade.Value != "0") ? GlobalValues.Grade.Value : "99") + "' "; } return(" " + SQLHelper.GetJoinerString(join) + " " + String.Format(@"( (--lowgrade: {0} >= (select top 1 CASE WHEN lowgrade < {2} THEN {2} ELSE lowgrade END from tblAgencyFull where {1}.year = tblAgencyFull.year and {1}.fullkey = tblAgencyFull.fullkey) OR fullkey = 'XXXXXXXXXXXX' AND {0} >= {2} )--/lowgrade AND (--highgrade {0} <= (select top 1 highgrade from tblAgencyFull where {1}.year = tblAgencyFull.year and {1}.fullkey = tblAgencyFull.fullkey) OR fullkey = 'XXXXXXXXXXXX' AND {0}< 70 )--/highgrade " + strOrAggGradeCode + @" ) " , field , dbObject , floor )); }