public v_DropoutsWWoDisEconELPSchoolDistState GetDropoutData2() { DALDropouts dropouts = new DALDropouts(); List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); List <int> gradeCodeRange = GetGradeCodes(); Years = base.GetYearList(); List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); v_DropoutsWWoDisEconELPSchoolDistState ds = new v_DropoutsWWoDisEconELPSchoolDistState(); List <string> orderBy = GetOrderByList(ds._v_DropoutsWWoDisEconELPSchoolDistState, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = dropouts.GetDropoutData2(FullKeyUtils.FullKeyDecode(this._fullKeys), schoolTypes, Years, sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes, orderBy); this.sql = dropouts.SQL; return(ds); }
public v_Grad_Reqs GetGradReqs() { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = MyGetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict); //Subject IDs List <int> subjectIDs = GenericsListHelper.GetPopulatedList(1, 7); DALGrad_Reqs reqs = new DALGrad_Reqs(); v_Grad_Reqs ds = new v_Grad_Reqs(); List <string> orderBy = GetOrderByList(ds._v_Grad_Reqs, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = reqs.GetGradReqs(raceCodes, sexCodes, disabilityCodes, Years, FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes, schoolTypes, econDisadvCodes, ELPCodes, subjectIDs, orderBy); this.sql = reqs.SQL; return(ds); }
public v_WSAS GetData(int Grade, List <string> Subjects, List <int> Groups) { v_WSAS ds = new v_WSAS(); Years = base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys; _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); List <string> orderBy = GetOrderByList(ds._v_WSAS, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = new DALWSAS().GetData(Years, _fullKeys, Grade, Subjects, Groups, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); return(ds); }
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); }
public v_ActivitiesSchoolDistState getActivitiesQuery(string SHOW) { Years = base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); bool useFullkeys; _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( OrigFullKey, S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALActivities dalAO = new DALActivities(); v_ActivitiesSchoolDistState ds = new v_ActivitiesSchoolDistState(); List <string> orderBy = GetOrderByList(ds._v_ActivitiesSchoolDistState, CompareTo, OrigFullKey); ds = dalAO.GetActivitiesSchoolDistStateData(Years, _fullKeys, schoolTypes, SHOW, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); // to get it to compile return(ds); }
public vExpulsionServicesAndReturns GetExpulsionAndReturnsData() { DALExpulsionServices dal = new DALExpulsionServices(); vExpulsionServicesAndReturns ds = new vExpulsionServicesAndReturns(); Years = base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList( CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); List <string> orderBy = GetOrderByList( ds._vExpulsionServicesAndReturns, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = dal.GetExpulsionAndReturnsData( Years, FullKeyUtils.FullKeyDecode(_fullKeys), _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); //for sql trace this.sql = dal.SQL; return(ds); }
public v_Course_Offerings getCourseOfferingsQuery(CourseTypeID CourseTypeID, WMAS WMASID1) { Years = base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys; _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALCourseOfferings dalCO = new DALCourseOfferings(); v_Course_Offerings ds = new v_Course_Offerings(); List <string> orderBy = GetOrderByList(ds.v_COURSE_OFFERINGS, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = dalCO.GetData(_fullKeys, Years, CourseTypeID, WMASID1, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); // to get it to compile return(ds); }
public v_POST_GRAD_INTENT GetPostGradIntent() { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = MyGetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict); DALPOST_GRAD_INTENT grad = new DALPOST_GRAD_INTENT(); v_POST_GRAD_INTENT ds = new v_POST_GRAD_INTENT(); List <string> orderBy = GetOrderByList(ds._v_POST_GRAD_INTENT, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); if (ViewBy.Key == GroupKeys.Gender) { orderBy.Insert(0, ds._v_POST_GRAD_INTENT.SexDescColumn.ColumnName); } else if (ViewBy.Key == GroupKeys.Race) { orderBy.Insert(0, ds._v_POST_GRAD_INTENT.RaceDescColumn.ColumnName); } ds = grad.GetPostGradIntent(raceCodes, sexCodes, disabilityCodes, Years, FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes, schoolTypes, econDisadvCodes, ELPCodes, orderBy); this.sql = grad.SQL; return(ds); }
public v_Coursework getCourseworkQuery(int Grade, CourseTypeID CourseTypeID, WMAS WMASID1) { List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys; _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALCoursesTaken dalCT = new DALCoursesTaken(); v_Coursework ds = new v_Coursework(); List <string> orderBy = GetOrderByList(ds.v_COURSEWORK, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = dalCT.GetData(_fullKeys, Years, sexCodes, Grade, CourseTypeID, WMASID1, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); // to get it to compile return(ds); }
public v_Districts GetDistric(string fullKey, int year) { DALDistrict district = new DALDistrict(); string masked = FullKeyUtils.DistrictFullKey(fullKey); v_Districts ds = district.GetDistrict(masked, year); return(ds); }
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); }
public v_Suspensions GetSuspensionsDaysLostData() { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically // populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); // jdj: must override default grade when ViewBY <> Grade if (ViewBy.Key != GroupKeys.Grade) { gradeCodes = GenericsListHelper.GetPopulatedList(99); } Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALSuspensionsDaysLost SuspensionsDaysLost = new DALSuspensionsDaysLost(); v_Suspensions ds = new v_Suspensions(); List <string> orderBy = GetOrderByList(ds._v_Suspensions, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = SuspensionsDaysLost.GetSuspensionsDaysLostData( raceCodes, sexCodes, disabilityCodes, Years, FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes, schoolTypes, econDisadvCodes, ELPCodes, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = SuspensionsDaysLost.SQL; return(ds); }
private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict) { string myOrigFullkey = origFullKey; if (OrgLevel.Key != OrgLevelKeys.School) { //On Post Grad Intent page, if org level == district, school level fullkey should not appear. if (FullKeyUtils.GetOrgLevelFromFullKeyX(origFullKey).Key == OrgLevelKeys.School) { myOrigFullkey = FullKeyUtils.DistrictFullKey(origFullKey); } } return(FullKeyUtils.GetFullKeysList(compareTo, orgLevel, myOrigFullkey, compareToSchoolsOrDistrict, S4orALL)); }
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) )); }
public v_AP_TESTS GetAPTestData() { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); if (ViewBy.Key == GroupKeys.Race) { raceCodes = GenericsListHelper.GetPopulatedList(1, 2, 3, 4, 5, 8); } //Special logic for which fullkeys to use. _fullKeys = MyGetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(newOrigFullKey), S4orALL, CompareTo, newOrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); //Exam Codes List <int> examCodes = GenericsListHelper.GetPopulatedList(99); DALAP_TESTS tests = new DALAP_TESTS(); v_AP_TESTS ds = new v_AP_TESTS(); List <string> orderBy = GetOrderByList(ds._v_AP_TESTS, CompareTo, newOrigFullKey); ds = tests.GetAPTestData(raceCodes, sexCodes, disabilityCodes, Years, FullKeyUtils.FullKeyDecode(_fullKeys) , gradeCodes, schoolTypes, econDisadvCodes, ELPCodes, examCodes, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = tests.SQL; return(ds); }
public v_Staff GetStaffData() { //List<int> schoolTypes = GetSchoolTypesList(this.STYP); ////create a bunch of Generics Lists, automatically populated with a 9 (the default value). //List<int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; //base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, // out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( OrigFullKey, S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALStaff staff = new DALStaff(); v_Staff ds = new v_Staff(); List <string> orderBy = GetOrderByList(ds._v_Staff, CompareTo, OrigFullKey); //List<string> orderBy = new List<string>(); //orderBy.Add("PRIORYEAR"); if (CompareTo.Key == CompareToKeys.SelSchools || CompareTo.Key == CompareToKeys.SelDistricts) { orderBy.Add(ds._v_Staff.LinkedDistrictNameColumn.ColumnName); } orderBy.Add("Category"); ds = staff.GetStaffData( Years, _fullKeys, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = staff.SQL; return(ds); }
private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict) { List <string> retval = new List <string>(); if (OrgLevel.Key == OrgLevelKeys.School) { //For Grad Requirements page: school level data are not available. Use District instead. string maskedFullKey = FullKeyUtils.DistrictFullKey(origFullKey); retval.Add(maskedFullKey); } else { retval = FullKeyUtils.GetFullKeysList(compareTo, orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL); } return(retval); }
/*public override string GetCompareToColumnName() * { * return "Category"; * }*/ public v_Expend_2 GetExpenditureData() { Years = base.GetYearList(); //before database view changed, hard code here //List <string> category = new List<string>(); //category.Add("Food and Comm. Serv."); //category.Add("Transportation + Facilities"); //category.Add("Current Education Cost"); //category.Add("Total Cost"); List <string> CT = new List <string>(); CT.Add(cost); CT.Add(SligoCS.BL.WI.Constants.MONEY_PAGE_CURRENT_EDUCATION_COST); //Special logic for which fullkeys to use. _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALExpenditure dal = new DALExpenditure(); v_Expend_2 ds = new v_Expend_2(); // before database view changed, hard code here. the base orderBy logic does not work here //List<string> orderBy = GetOrderByList(ds._v_Revenues_2, CompareToEnum, FullKeyUtils.FullKeyDecode(OrigFullKey)); List <string> orderBy = new List <string>(); orderBy.Add("Year desc"); ds = dal.GetExpendData(CT, Years, FullKeyUtils.FullKeyDecode(_fullKeys), _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = dal.SQL; return(ds); }
public v_TeacherQualifications GetTeacherQualifications(string subjectCode) { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically // populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = MyGetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALTeacherQualifications teachers = new DALTeacherQualifications(); v_TeacherQualifications ds = new v_TeacherQualifications(); List <string> orderBy = GetOrderByList(ds._v_TeacherQualifications, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey)); ds = teachers.GetTeacherQualifications( raceCodes, sexCodes, Years, FullKeyUtils.FullKeyDecode(_fullKeys), schoolTypes, subjectCode, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy ); this.sql = teachers.SQL; return(ds); }
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); }
public v_RetentionWWoDisEconELPSchoolDistState GetRetentionData2() { List <int> schoolTypes = GetSchoolTypesList(this.SchoolType); //create a bunch of Generics Lists, automatically populated with a 9 (the default value). List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = GetYearList(); // base.GetYearList(); _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( OrigFullKey, S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALRetention retention = new DALRetention(); v_RetentionWWoDisEconELPSchoolDistState ds = new v_RetentionWWoDisEconELPSchoolDistState(); List <string> orderBy = GetOrderByList(ds._v_RetentionWWoDisEconELPSchoolDistState, CompareTo, OrigFullKey); ds = retention.GetRetentionData2( raceCodes, sexCodes, disabilityCodes, Years, _fullKeys, gradeCodes, schoolTypes, econDisadvCodes, ELPCodes, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = retention.SQL; return(ds); }
public static String GetMaskedFullkey(string origFullKey, String desiredOrgLevelKey) { string retval = origFullKey; OrgLevel origOrgLevel = FullKeyUtils.GetOrgLevelFromFullKeyX(origFullKey); if (desiredOrgLevelKey == OrgLevelKeys.School) { if ((origOrgLevel.Key == OrgLevelKeys.District) || (origOrgLevel.Key == OrgLevelKeys.State)) { //cannot create a school's fullkey from a District or State fullky. retval = string.Empty; } //otherwise, continue using default value } else if (desiredOrgLevelKey == OrgLevelKeys.District) { if (origOrgLevel.Key == OrgLevelKeys.State) { //cannot create s District fullkey given a State fullkey. retval = string.Empty; } else { //otherwise, replace the last 4 digits of the fullkey //retval = origFullKey.Substring(0, 7) + "3XXXX"; //BR: shoulb be "3ZZZZ" for out going URL //to fix Charter school issues retval = origFullKey.Substring(0, 6) + "03XXXX"; //BR: shoulb be "03ZZZZ" for out going URL } } else { //orglevel == State retval = "XXXXXXXXXXXX"; //BR: shoulb be "ZZZZZZZZZZZZ" for out going URL 6/08 } 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); }