public List <String> BuildFullKeyList(String fullkey) { List <String> keylist = new List <string>(); fullkey = FullKeyUtils.GetMaskedFullkey(fullkey, globals.OrgLevel); if ((globals.CompareTo.Key == CompareToKeys.Years) || (globals.CompareTo.Key == CompareToKeys.Current)) { //When comparing to Prior Years or Current School Data, keylist.Add(fullkey); } else if (globals.CompareTo.Key == CompareToKeys.OrgLevel) { //always add the State fullkey to the list. keylist.Add(FullKeyUtils.StateFullKey(fullkey)); if (globals.OrgLevel.Key != OrgLevelKeys.State) { //org level is District or School keylist.Add(FullKeyUtils.DistrictFullKey(fullkey)); } if (globals.OrgLevel.Key == OrgLevelKeys.School) { //org level is school keylist.Add(FullKeyUtils.SchoolFullKey(fullkey)); } } return(keylist); }
private String CompareSelectedClauseTemplate(String Operator, String Name, String Value) { String template = " ( ( {0} in ('{1}') and right(fullkey,1){2}'X' ) or FullKey in ('{3}')) "; return(String.Format(template, Name, Value, Operator, FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel) )); }
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); }
private String CompareSelectedClauseStatewideTemplate(String Operator) { String template = " ( ( right(fullkey,1){0}'X' ) or FullKey in ('{1}')) "; //return an inocuous where clause: if (GlobalValues.SuperDownload.Key == SupDwnldKeys.True) { return(" 1=1 "); } return(String.Format(template, Operator, FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel) )); }
protected List <string> MyGetFullKeysList( CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict) { List <string> retval = FullKeyUtils.GetFullKeysList(compareTo, orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL); if (this.OrgLevel.Key != OrgLevelKeys.School) { List <string> maskedVals = new List <string>(); foreach (string fullkey in retval) { string maskedVal = FullKeyUtils.GetMaskedFullkey(fullkey, this.OrgLevel); maskedVals.Add(maskedVal); } retval = maskedVals; } return(retval); }
//Notes for graph /* public override string GetViewByColumnName() * { * //There is no RaceShortLabel column in this page, so we need to use the Full paramName * if (ViewBy.Key == GroupKeys.Race) * { * return "RaceLabel"; * } * else * { * return base.GetViewByColumnName(); * } * }*/ //Notes for graph /* public override string GetCompareToColumnName() * { * if (CompareTo == CompareToEnum.DISTSTATE) * { * return "District paramName"; * } * else * { * return base.GetCompareToColumnName(); * } * }*/ private List <string> MyGetFullKeysList( CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict) { List <string> retval = new List <string>(); if (OrgLevel.Key == OrgLevelKeys.School) { newOrigFullKey = FullKeyUtils.DistrictFullKey(origFullKey); newOrgLevel.Value = newOrgLevel.Range[OrgLevelKeys.District]; //convert each school into a district fullkey foreach (string fullkey in compareToSchoolsOrDistrict) { string maskedFullkey = FullKeyUtils.GetMaskedFullkey(fullkey, OrgLevelKeys.District); newCompareToSchools.Add(maskedFullkey); } } if (orgLevel.Key == OrgLevelKeys.District) { newOrgLevel = orgLevel; newOrigFullKey = origFullKey; newCompareToSchools = compareToSchoolsOrDistrict; } else if (orgLevel.Key == OrgLevelKeys.State) { newOrgLevel = orgLevel; newOrigFullKey = FullKeyUtils.StateFullKey(origFullKey); } retval = FullKeyUtils.GetFullKeysList(compareTo, newOrgLevel, newOrigFullKey, newCompareToSchools, S4orALL); return(retval); }