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);
}
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 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_DropoutsWWoDisEconELPSchoolDistState GetDropoutData2()
{
DALDropouts dropouts = new DALDropouts();
List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);
_fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);
List <int> gradeCodeRange = GetGradeCodes();
Years = base.GetYearList();
List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;
GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);
v_DropoutsWWoDisEconELPSchoolDistState ds = new v_DropoutsWWoDisEconELPSchoolDistState();
List <string> orderBy = GetOrderByList(ds._v_DropoutsWWoDisEconELPSchoolDistState, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));
ds = dropouts.GetDropoutData2(FullKeyUtils.FullKeyDecode(this._fullKeys), schoolTypes,
Years, sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes,
ELPCodes, orderBy);
this.sql = dropouts.SQL;
return(ds);
}
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 v_ActivitiesSchoolDistState getActivitiesQuery(string SHOW)
{
Years = base.GetYearList();
_fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);
List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);
bool useFullkeys;
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
OrigFullKey, S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALActivities dalAO = new DALActivities();
v_ActivitiesSchoolDistState ds = new v_ActivitiesSchoolDistState();
List <string> orderBy = GetOrderByList(ds._v_ActivitiesSchoolDistState, CompareTo, OrigFullKey);
ds = dalAO.GetActivitiesSchoolDistStateData(Years, _fullKeys, schoolTypes, SHOW, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy);
// to get it to compile
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);
}
private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict)
{
string myOrigFullkey = origFullKey;
if (OrgLevel.Key != OrgLevelKeys.School)
{
//On Post Grad Intent page, if org level == district, school level fullkey should not appear.
if (FullKeyUtils.GetOrgLevelFromFullKeyX(origFullKey).Key == OrgLevelKeys.School)
{
myOrigFullkey = FullKeyUtils.DistrictFullKey(origFullKey);
}
}
return(FullKeyUtils.GetFullKeysList(compareTo, orgLevel, myOrigFullkey, compareToSchoolsOrDistrict, S4orALL));
}
public v_ACT GetACTData()
{
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 = FullKeyUtils.GetFullKeysList(
CompareTo, OrgLevel, OrigFullKey,
CompareToSchoolsOrDistrict, S4orALL);
bool useFullkeys = true; //
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALACT act = new DALACT();
v_ACT ds = new v_ACT();
List <string> orderBy = GetOrderByList(
ds._v_ACT, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));
ds = act.GetACTData(
raceCodes, sexCodes, disabilityCodes, Years,
FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes, schoolTypes,
econDisadvCodes, ELPCodes,
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy);
this.sql = act.SQL;
return(ds);
}
public v_Staff GetStaffData()
{
//List<int> schoolTypes = GetSchoolTypesList(this.STYP);
////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 = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);
bool useFullkeys = true; //
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
OrigFullKey, S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALStaff staff = new DALStaff();
v_Staff ds = new v_Staff();
List <string> orderBy = GetOrderByList(ds._v_Staff, CompareTo, OrigFullKey);
//List<string> orderBy = new List<string>();
//orderBy.Add("PRIORYEAR");
if (CompareTo.Key == CompareToKeys.SelSchools ||
CompareTo.Key == CompareToKeys.SelDistricts)
{
orderBy.Add(ds._v_Staff.LinkedDistrictNameColumn.ColumnName);
}
orderBy.Add("Category");
ds = staff.GetStaffData(
Years, _fullKeys,
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy);
this.sql = staff.SQL;
return(ds);
}
private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict)
{
List <string> retval = new List <string>();
if (OrgLevel.Key == OrgLevelKeys.School)
{
//For Grad Requirements page: school level data are not available. Use District instead.
string maskedFullKey = FullKeyUtils.DistrictFullKey(origFullKey);
retval.Add(maskedFullKey);
}
else
{
retval = FullKeyUtils.GetFullKeysList(compareTo, orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL);
}
return(retval);
}
/*public override string GetCompareToColumnName()
* {
* return "Category";
* }*/
public v_Expend_2 GetExpenditureData()
{
Years = base.GetYearList();
//before database view changed, hard code here
//List <string> category = new List<string>();
//category.Add("Food and Comm. Serv.");
//category.Add("Transportation + Facilities");
//category.Add("Current Education Cost");
//category.Add("Total Cost");
List <string> CT = new List <string>();
CT.Add(cost);
CT.Add(SligoCS.BL.WI.Constants.MONEY_PAGE_CURRENT_EDUCATION_COST);
//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);
DALExpenditure dal = new DALExpenditure();
v_Expend_2 ds = new v_Expend_2();
// before database view changed, hard code here. the base orderBy logic does not work here
//List<string> orderBy = GetOrderByList(ds._v_Revenues_2, CompareToEnum, FullKeyUtils.FullKeyDecode(OrigFullKey));
List <string> orderBy = new List <string>();
orderBy.Add("Year desc");
ds = dal.GetExpendData(CT, Years,
FullKeyUtils.FullKeyDecode(_fullKeys),
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy);
this.sql = dal.SQL;
return(ds);
}
protected List <string> MyGetFullKeysList(
CompareTo compareTo, OrgLevel orgLevel, string origFullKey,
List <string> compareToSchoolsOrDistrict)
{
List <string> retval = FullKeyUtils.GetFullKeysList(compareTo,
orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL);
if (this.OrgLevel.Key != OrgLevelKeys.School)
{
List <string> maskedVals = new List <string>();
foreach (string fullkey in retval)
{
string maskedVal = FullKeyUtils.GetMaskedFullkey(fullkey, this.OrgLevel);
maskedVals.Add(maskedVal);
}
retval = maskedVals;
}
return(retval);
}
public v_RetentionWWoDisEconELPSchoolDistState GetRetentionData2()
{
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 = GetYearList(); // base.GetYearList();
_fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel,
OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);
bool useFullkeys = true; //
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
OrigFullKey, S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALRetention retention = new DALRetention();
v_RetentionWWoDisEconELPSchoolDistState ds = new v_RetentionWWoDisEconELPSchoolDistState();
List <string> orderBy = GetOrderByList(ds._v_RetentionWWoDisEconELPSchoolDistState,
CompareTo, OrigFullKey);
ds = retention.GetRetentionData2(
raceCodes, sexCodes, disabilityCodes, Years,
_fullKeys, gradeCodes,
schoolTypes, econDisadvCodes, ELPCodes,
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy);
this.sql = retention.SQL;
return(ds);
}
//Notes for graph
/* public override string GetViewByColumnName()
* {
* //There is no RaceShortLabel column in this page, so we need to use the Full paramName
* if (ViewBy.Key == GroupKeys.Race)
* {
* return "RaceLabel";
* }
* else
* {
* return base.GetViewByColumnName();
* }
* }*/
//Notes for graph
/* public override string GetCompareToColumnName()
* {
* if (CompareTo == CompareToEnum.DISTSTATE)
* {
* return "District paramName";
* }
* else
* {
* return base.GetCompareToColumnName();
* }
* }*/
private List <string> MyGetFullKeysList(
CompareTo compareTo,
OrgLevel orgLevel, string origFullKey,
List <string> compareToSchoolsOrDistrict)
{
List <string> retval = new List <string>();
if (OrgLevel.Key == OrgLevelKeys.School)
{
newOrigFullKey = FullKeyUtils.DistrictFullKey(origFullKey);
newOrgLevel.Value = newOrgLevel.Range[OrgLevelKeys.District];
//convert each school into a district fullkey
foreach (string fullkey in compareToSchoolsOrDistrict)
{
string maskedFullkey = FullKeyUtils.GetMaskedFullkey(fullkey, OrgLevelKeys.District);
newCompareToSchools.Add(maskedFullkey);
}
}
if (orgLevel.Key == OrgLevelKeys.District)
{
newOrgLevel = orgLevel;
newOrigFullKey = origFullKey;
newCompareToSchools = compareToSchoolsOrDistrict;
}
else if (orgLevel.Key == OrgLevelKeys.State)
{
newOrgLevel = orgLevel;
newOrigFullKey = FullKeyUtils.StateFullKey(origFullKey);
}
retval = FullKeyUtils.GetFullKeysList(compareTo, newOrgLevel, newOrigFullKey, newCompareToSchools, S4orALL);
return(retval);
}
