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