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