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);
}
