private List <int> GetGradeCodes() { //From bug 386: //when View By <> Grade: WHERE parameter for Dropouts should be //" AND gradecode = '95' " //when View By = Grade and OrgLevel = SC: WHERE parameter for Dropouts should be //"AND ((GradeCode >= 52) AND (GradeCode <= 64)) " //when View By = Grade and OrgLevel <> SC: WHERE parameter for Dropouts should be //"AND ((GradeCode >= 44) AND (GradeCode <= 64)) " List <int> gradeCodeRange = GenericsListHelper.GetPopulatedList(95); // jdj: I think below might be wrong - see how I handled grade override in BLSuspensions.cs et al if (ViewBy.Key == GroupKeys.Grade) { if (OrgLevel.Key == OrgLevelKeys.School) { gradeCodeRange = GenericsListHelper.GetPopulatedList(52, 64); } else { gradeCodeRange = GenericsListHelper.GetPopulatedList(44, 64); } } return(gradeCodeRange); }
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_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); }
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); }