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_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_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 List <String> BuildFullKeyList(String fullkey)
{
List <String> keylist = new List <string>();
fullkey = FullKeyUtils.GetMaskedFullkey(fullkey, globals.OrgLevel);
if ((globals.CompareTo.Key == CompareToKeys.Years) || (globals.CompareTo.Key == CompareToKeys.Current))
{
//When comparing to Prior Years or Current School Data,
keylist.Add(fullkey);
}
else if (globals.CompareTo.Key == CompareToKeys.OrgLevel)
{
//always add the State fullkey to the list.
keylist.Add(FullKeyUtils.StateFullKey(fullkey));
if (globals.OrgLevel.Key != OrgLevelKeys.State)
{
//org level is District or School
keylist.Add(FullKeyUtils.DistrictFullKey(fullkey));
}
if (globals.OrgLevel.Key == OrgLevelKeys.School)
{
//org level is school
keylist.Add(FullKeyUtils.SchoolFullKey(fullkey));
}
}
return(keylist);
}
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 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_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_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_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_Districts GetDistric(string fullKey, int year)
{
DALDistrict district = new DALDistrict();
string masked = FullKeyUtils.DistrictFullKey(fullKey);
v_Districts ds = district.GetDistrict(masked, year);
return(ds);
}
private String CompareSelectedClauseTemplate(String Operator, String Name, String Value)
{
String template = " ( ( {0} in ('{1}') and right(fullkey,1){2}'X' ) or FullKey in ('{3}')) ";
return(String.Format(template,
Name, Value, Operator,
FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel)
));
}
public String BuildClauseForCompareToSelected()
{
String clause = String.Empty;
String region = String.Empty;
String value = String.Empty;
String comparison =
(globals.OrgLevel.Key == OrgLevelKeys.School) ?
"<>" : "=";
if (globals.S4orALL.Key == S4orALLKeys.AllSchoolsOrDistrictsIn)
{
if (globals.SRegion.Key == SRegionKeys.County)
{
region = "County";
value = globals.SCounty;
}
else if (globals.SRegion.Key == SRegionKeys.CESA)
{
region = "CESA";
value = globals.SCESA;
}
else if (globals.SRegion.Key == SRegionKeys.AthleticConf)
{
region = "ConferenceKey";
value = globals.SAthleticConf;
}
if (globals.SRegion.Key == SRegionKeys.Statewide)
{
clause = CompareSelectedClauseStatewideTemplate(comparison);
}
else
{
clause = CompareSelectedClauseTemplate(comparison, region, value);
}
}
else
{
region = "fullkey";
List <String> keylist = new List <String>();
//add the original fullkey
keylist.Add(FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel));
keylist.AddRange(
FullKeyUtils.ParseFullKeyString(
globals.SFullKeys(globals.OrgLevel)
)
);
clause = SQLHelper.WhereClauseValuesInList(SQLHelper.WhereClauseJoiner.NONE, region, keylist);
}
return(clause);
}
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));
}
private String CompareSelectedClauseStatewideTemplate(String Operator)
{
String template = " ( ( right(fullkey,1){0}'X' ) or FullKey in ('{1}')) ";
//return an inocuous where clause:
if (GlobalValues.SuperDownload.Key == SupDwnldKeys.True)
{
return(" 1=1 ");
}
return(String.Format(template,
Operator,
FullKeyUtils.GetMaskedFullkey(globals.FULLKEY, globals.OrgLevel)
));
}
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);
}
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);
}
public v_TeacherQualifications GetTeacherQualifications(string subjectCode)
{
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);
bool useFullkeys = true; //
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALTeacherQualifications teachers = new DALTeacherQualifications();
v_TeacherQualifications ds = new v_TeacherQualifications();
List <string> orderBy = GetOrderByList(ds._v_TeacherQualifications,
CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));
ds = teachers.GetTeacherQualifications(
raceCodes, sexCodes, Years,
FullKeyUtils.FullKeyDecode(_fullKeys), schoolTypes,
subjectCode,
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy
);
this.sql = teachers.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);
}
public static String GetMaskedFullkey(string origFullKey, String desiredOrgLevelKey)
{
string retval = origFullKey;
OrgLevel origOrgLevel = FullKeyUtils.GetOrgLevelFromFullKeyX(origFullKey);
if (desiredOrgLevelKey == OrgLevelKeys.School)
{
if ((origOrgLevel.Key == OrgLevelKeys.District) || (origOrgLevel.Key == OrgLevelKeys.State))
{
//cannot create a school's fullkey from a District or State fullky.
retval = string.Empty;
}
//otherwise, continue using default value
}
else if (desiredOrgLevelKey == OrgLevelKeys.District)
{
if (origOrgLevel.Key == OrgLevelKeys.State)
{
//cannot create s District fullkey given a State fullkey.
retval = string.Empty;
}
else
{
//otherwise, replace the last 4 digits of the fullkey
//retval = origFullKey.Substring(0, 7) + "3XXXX"; //BR: shoulb be "3ZZZZ" for out going URL
//to fix Charter school issues
retval = origFullKey.Substring(0, 6) + "03XXXX"; //BR: shoulb be "03ZZZZ" for out going URL
}
}
else
{
//orglevel == State
retval = "XXXXXXXXXXXX"; //BR: shoulb be "ZZZZZZZZZZZZ" for out going URL 6/08
}
return(retval);
}
//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);
}
