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