public void Bug841_TeacherQual_CheckColumns()
{
//RULE: if orglevel = district, school type = 'Elem', columns should be:
// OrgLevelLabel
//, SchooltypeLabel as 'School Type'
//, [FTETotal] as '# of FTE teachers'
//, [FTELicenseFull] as '# FTE'
//, [LicenseFullFTEPercentage] as '% of Total'
//, [LicenseEmerFTE] as '# FTE'
//, [LicenseEmerFTEPercentage] as '% of Total'
//, [LicenseNoFTE] as '# FTE'
//, [LicenseNoFTEPercentage] as '% of Total'
//string url = "http://localhost:31489/SligoWI/TeacherQualifications.aspx?TQShow=LICSTAT&TQSubjects=SUMALL&FULLKEY=01361903XXXX&GraphFile=HIGHSCHOOLCOMPLETION&CompareToEnum=PRIORYEARS&ORGLEVEL=SC&Group=AllStudentsFAY&DN=Milwaukee&SN=Madison%20Hi&DETAIL=YES&NumSchools=4&ZBackTo=performance.aspx&FileName=c:\\sample.txt&SchoolWebaddress=http://mpsportal.milwaukee.k12.wi.us&DistrictWebaddress=http://www.milwaukee.k12.wi.us&STYP=6&COUNTY=40&YearLocal=2007&TrendStartYearLocal=1997&WhichSchool=4&ConferenceKey=27&DistrictID=3619&GradeBreakout=999&GradeBreakoutLAG=555&GradeBreakoutEDISA=212&TraceLevels=None";
Group group = new Group();
group.Value = group.Range[GroupKeys.All];
TQShow show = new TQShow();
show.Value = show.Range[TQShowKeys.WisconsinLicenseStatus];
TeacherQualifications tqPage = new TeacherQualifications();
List <string> cols = tqPage.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.District, SligoCS.BL.WI.CompareToEnum.CURRENTONLY, SligoCS.DAL.WI.SchoolType.Elem, show);
AssertColumns(cols, 9);
AssertColumn(cols, "OrgLevelLabel");
AssertColumn(cols, "SchooltypeLabel");
AssertColumn(cols, "FTETotal");
AssertColumn(cols, "FTELicenseFull");
AssertColumn(cols, "LicenseFullFTEPercentage");
AssertColumn(cols, "LicenseEmerFTE");
AssertColumn(cols, "LicenseEmerFTEPercentage");
AssertColumn(cols, "LicenseNoFTE");
AssertColumn(cols, "LicenseNoFTEPercentage");
//RULE: if show= District Experience, columns should be:
//select YearFormatted as ' '
//, [FTETotal] as '# of FTE teachers'
//, [LocalExperience5YearsOrLessFTE] as '# FTE with less than 5 years experience in this district'
//, [LocalExperience5YearsOrMoreFTE] as '# FTE with at least 5 years experience in this district'
//, [LocalExperience5YearsOrMoreFTEPercentage] as '% with at least 5 years experience in this district'
show.Value = show.Range[TQShowKeys.DistrictExperience];
cols = tqPage.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.School, SligoCS.BL.WI.CompareToEnum.PRIORYEARS, SligoCS.DAL.WI.SchoolType.AllTypes, show);
AssertColumns(cols, 5);
AssertColumn(cols, "YearFormatted");
AssertColumn(cols, "FTETotal");
AssertColumn(cols, "LocalExperience5YearsOrLessFTE");
AssertColumn(cols, "LocalExperience5YearsOrMoreFTE");
AssertColumn(cols, "LocalExperience5YearsOrMoreFTEPercentage");
}
public void Bug910_TQPage_DistrictLevel()
{
//RULE, when orglevel=District, full key should be masked (e.g. '01361903XXXX')
string url = "http://localhost:31489/SligoWI/TeacherQualifications.aspx?TQShow=LICSTAT&TQSubjects=SUMALL&FULLKEY=013619040022&GraphFile=HIGHSCHOOLCOMPLETION&CompareTo=PRIORYEARS&ORGLEVEL=District&Group=AllStudentsFAY&DN=Milwaukee&SN=Madison%20Hi&DETAIL=YES&NumSchools=4&ZBackTo=performance.aspx&FileName=c:\\sample.txt&SchoolWebaddress=http://mpsportal.milwaukee.k12.wi.us&DistrictWebaddress=http://www.milwaukee.k12.wi.us&STYP=6&COUNTY=40&YearLocal=2007&TrendStartYearLocal=1997&WhichSchool=4&ConferenceKey=27&DistrictID=3619&GradeBreakout=999&GradeBreakoutLAG=555&GradeBreakoutEDISA=212&TraceLevels=4";
Browser.GetPage(url);
AssertString("01361903XXXX", true, false);
//also check the Graph title.
AssertString("Wisconsin Teacher License Status", true, true);
AssertString("Summary All Subjects", true, true);
AssertString("Milwaukee: Elementary Schools", true, true);
AssertString("2007-07 Compared To Prior Years", true, false);
//select YearFormatted as ' '
//, SchooltypeLabel as 'School Type'
//, [FTETotal] as '# of FTE teachers'
//, [FTELicenseFull] as '# FTE'
//, [LicenseFullFTEPercentage] as '% of Total'
//, [LicenseEmerFTE] as '# FTE'
//, [LicenseEmerFTEPercentage] as '% of Total'
//, [LicenseNoFTE] as '# FTE'
//, [LicenseNoFTEPercentage] as '% of Total'
Group group = new Group();
group.Value = group.Range[GroupKeys.All];
TQShow show = new TQShow();
show.Value = show.Range[TQShowKeys.WisconsinLicenseStatus];
TeacherQualifications tq = new TeacherQualifications();
List <string> cols = tq.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.District, SligoCS.BL.WI.CompareToEnum.PRIORYEARS, SligoCS.DAL.WI.SchoolType.Elem, show);
AssertColumns(cols, 9);
AssertColumn(cols, "YearFormatted");
AssertColumn(cols, "SchooltypeLabel");
AssertColumn(cols, "FTETotal");
AssertColumn(cols, "FTELicenseFull");
AssertColumn(cols, "LicenseFullFTEPercentage");
AssertColumn(cols, "LicenseEmerFTE");
AssertColumn(cols, "LicenseEmerFTEPercentage");
AssertColumn(cols, "LicenseNoFTE");
AssertColumn(cols, "LicenseNoFTEPercentage");
}
public void Bug895B_TeacherQual_CheckColumns()
{
//RULE: if orglevel = school, show=Wis state licens, subject = ELA, compareTo= current school:
//should see 8 cols, starting with OrgLevelLabel
Group group = new Group();
group.Value = group.Range[GroupKeys.All];
TQShow show = new TQShow();
show.Value = show.Range[TQShowKeys.WisconsinLicenseStatus];
TeacherQualifications tqPage = new TeacherQualifications();
List <string> cols = tqPage.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.School, SligoCS.BL.WI.CompareToEnum.CURRENTONLY, SligoCS.DAL.WI.SchoolType.AllTypes, show);
AssertColumns(cols, 8);
AssertColumn(cols, "OrgLevelLabel");
}
public void Bug895_TeacherQual_CheckColumns()
{
//RULE: if orglevel = school, show=Wis state licens, subject = ELA, compareTo= prioryears:
//select YearFormatted as ' '
//, [FTETotal] as '# of FTE teachers'
//, [FTELicenseFull] as '# FTE'
//, [LicenseFullFTEPercentage] as '% of Total'
//, [LicenseEmerFTE] as '# FTE'
//, [LicenseEmerFTEPercentage] as '% of Total'
//, [LicenseNoFTE] as '# FTE'
//, [LicenseNoFTEPercentage] as '% of Total'
//, YearFormatted
Group group = new Group();
group.Value = group.Range[GroupKeys.All];
TQShow show = new TQShow();
show.Value = show.Range[TQShowKeys.WisconsinLicenseStatus];
TeacherQualifications tqPage = new TeacherQualifications();
List <string> cols = tqPage.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.School, SligoCS.BL.WI.CompareToEnum.PRIORYEARS, SligoCS.DAL.WI.SchoolType.AllTypes, show);
AssertColumns(cols, 8);
AssertColumn(cols, "YearFormatted");
AssertColumn(cols, "FTETotal");
AssertColumn(cols, "FTELicenseFull");
AssertColumn(cols, "LicenseFullFTEPercentage");
AssertColumn(cols, "LicenseEmerFTE");
AssertColumn(cols, "LicenseEmerFTEPercentage");
AssertColumn(cols, "LicenseNoFTE");
AssertColumn(cols, "LicenseNoFTEPercentage");
string url = "http://localhost:31489/SligoWI/TeacherQualifications.aspx?TQShow=LICSTAT&TQSubjects=ELA&FULLKEY=013619040022&GraphFile=HIGHSCHOOLCOMPLETION&CompareTo=PRIORYEARS&ORGLEVEL=School&Group=AllStudentsFAY&DN=Milwaukee&SN=Madison%20Hi&DETAIL=YES&NumSchools=4&ZBackTo=performance.aspx&FileName=c:\\sample.txt&SchoolWebaddress=http://mpsportal.milwaukee.k12.wi.us&DistrictWebaddress=http://www.milwaukee.k12.wi.us&STYP=3&COUNTY=40&YearLocal=2007&TrendStartYearLocal=1997&WhichSchool=4&ConferenceKey=27&DistrictID=3619&GradeBreakout=999&GradeBreakoutLAG=555&GradeBreakoutEDISA=212&TraceLevels=None";
Browser.GetPage(url);
Assert.IsTrue(!Browser.CurrentPageText.Contains(">School Type<"), "Should not contain School Type column with these params.");
}
