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