public AgencyFull GetCESAList(int year)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetCESAList(year);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetCountyBySubstr(string county_substr)
{
DALAgencyFull county = DALAgencyFull;
_ds = county.GetCountyBySubstr(county_substr, CurrentYear);
this.sql = this.sql + "||" + county.SQL;
return(_ds);
}
public AgencyFull GetCountyByName(string name_first_alpha)
{
DALAgencyFull county = DALAgencyFull;
_ds = county.GetCountyByName(name_first_alpha, CurrentYear);
this.sql = this.sql + "||" + county.SQL;
return(_ds);
}
public AgencyFull GetSchoolBySubstr(string school_substr)
{
DALAgencyFull school = DALAgencyFull;
_ds = school.GetSchoolBySubstr(school_substr, CurrentYear);
this.sql = this.sql + "||" + school.SQL;
return(_ds);
}
public AgencyFull GetDistrictByCESA(string cesa_number, string var_hs)
{
DALAgencyFull district = DALAgencyFull;
_ds = district.GetDistrictByCESA(cesa_number, var_hs, CurrentYear);
this.sql = this.sql + "||" + district.SQL;
return((AgencyFull)_ds);
}
public AgencyFull GetSchoolByDistrictKey(string District_Key)
{
DALAgencyFull school = DALAgencyFull;
_ds = school.GetSchoolByDistrictKey(District_Key, CurrentYear);
this.sql = this.sql + "||" + school.SQL;
return(_ds);
}
public AgencyFull GetDistrictByName(string name_first_alpha)
{
DALAgencyFull district = DALAgencyFull;
_ds = district.GetDistrictByName(name_first_alpha, CurrentYear);
this.sql = this.sql + "||" + district.SQL;
return(_ds);
}
public AgencyFull GetDistrictBySubstr(string district_substr)
{
DALAgencyFull district = DALAgencyFull;
_ds = district.GetDistrictBySubstr(district_substr, CurrentYear);
this.sql = this.sql + "||" + district.SQL;
return(_ds);
}
public AgencyFull GetSchoolByName(string name_first_alpha)
{
DALAgencyFull school = DALAgencyFull;
_ds = school.GetSchoolByName(name_first_alpha, CurrentYear);
this.sql = this.sql + "||" + school.SQL;
return(_ds);
}
public AgencyFull GetSelectedDistricts
(int year, string selectedDistricts)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetSelectedDistricts(year, selectedDistricts);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetAllSchoolsInCounty
(int county, string fullKey, int year)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetAllSchoolsInCounty(county, fullKey, year);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetSchool(string fullKey, int year)
{
DALAgencyFull school = DALAgencyFull;
// string masked = FullKeyUtils.GetMaskedFullkey(fullKey, OrgLevel.School);
// AgencyFull ds = school.GetSchool(masked, year);
_ds = school.GetSchool(fullKey, year);
this.sql = this.sql + "||" + school.SQL;
return(_ds);
}
public AgencyFull GetAgencyByFullKey
(string fullkey, int year)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetAgencyByFullKey
(fullkey, year);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetDistrictsInCounty
(string county, int year, string selectedAndCurrentDistricts)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetDistrictsInCounty(
county, year, selectedAndCurrentDistricts);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetSchoolsInCounty
(string county, int schoolType, int year, string selectedAndCurrentSchools)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetSchoolsInCounty(
county, schoolType, year, selectedAndCurrentSchools);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetDistrictsInAthlicConf
(int conferenceKey,
string selectedAndCurrentDistricts)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetDistrictsInAthlicConf(
conferenceKey,
selectedAndCurrentDistricts);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public AgencyFull GetSchoolsInAthlicConf
(int conferenceKey, int schoolType,
int year, string selectedAndCurrentSchools)
{
DALAgencyFull agency = DALAgencyFull;
_ds = agency.GetSchoolsInAthlicConf(
conferenceKey, schoolType,
selectedAndCurrentSchools);
this.sql = this.sql + "||" + agency.SQL;
return(_ds);
}
public string GetCESANameByID(string cesa)
{
DALAgencyFull agency = DALAgencyFull;
return(agency.GetCESANameByID(cesa, CurrentYear));
}
//********************************************************************************
public string GetCountyNameByID(string county)
{
DALAgencyFull agency = DALAgencyFull;
return(agency.GetCountyNameByID(county, CurrentYear));
}
