public String BuildClauseForCompareToSelected() { String clause = String.Empty; String region = String.Empty; String value = String.Empty; String comparison = (globals.OrgLevel.Key == OrgLevelKeys.School) ? "<>" : "="; if (globals.S4orALL.Key == S4orALLKeys.AllSchoolsOrDistrictsIn) { if (globals.SRegion.Key == SRegionKeys.County) { region = "County"; value = globals.SCounty; } else if (globals.SRegion.Key == SRegionKeys.CESA) { region = "CESA"; value = globals.SCESA; } else if (globals.SRegion.Key == SRegionKeys.AthleticConf) { region = "ConferenceKey"; value = globals.SAthleticConf; } if (globals.SRegion.Key == SRegionKeys.Statewide) { clause = CompareSelectedClauseStatewideTemplate(comparison); } else { clause = CompareSelectedClauseTemplate(comparison, region, value); } } else { region = "fullkey"; List <String> keylist = new List <String>(); //add the original fullkey keylist.Add(FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel)); keylist.AddRange( FullKeyUtils.ParseFullKeyString( globals.SFullKeys(globals.OrgLevel) ) ); clause = SQLHelper.WhereClauseValuesInList(SQLHelper.WhereClauseJoiner.NONE, region, keylist); } return(clause); }