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