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."); }
public override List <string> GetVisibleColumns() { TQShow show = GlobalValues.TQShow; List <string> retval = base.GetVisibleColumns(); if (GlobalValues.TQShow.Key == TQShowKeys.ESEAQualified && GlobalValues.TQSubjects.Key == TQSubjectsKeys.SoclStd) { retval.Add(v_TeacherQualifications.ESEA_Core_FTE_Total); } else { retval.Add(v_TeacherQualifications.FTETotal); } bool statewide = (GlobalValues.SuperDownload.Key == SupDwnldKeys.True); if (statewide || show.Key == TQShowKeys.WisconsinLicenseStatus) { retval.Add(v_TeacherQualifications.FTELicenseFull); retval.Add(v_TeacherQualifications.LicenseFullFTEPercentage); retval.Add(v_TeacherQualifications.LicenseEmerFTE); retval.Add(v_TeacherQualifications.LicenseEmerFTEPercentage); retval.Add(v_TeacherQualifications.LicenseNoFTE); retval.Add(v_TeacherQualifications.LicenseNoFTEPercentage); } if (statewide || show.Key == TQShowKeys.DistrictExperience) { retval.Add(v_TeacherQualifications.LocalExperience5YearsOrLessFTE); retval.Add(v_TeacherQualifications.LocalExperience5YearsOrMoreFTE); retval.Add(v_TeacherQualifications.LocalExperience5YearsOrMoreFTEPercentage); } if (statewide || show.Key == TQShowKeys.TotalExperience) { retval.Add(v_TeacherQualifications.TotalExperience5YearsOrLessFTE); retval.Add(v_TeacherQualifications.TotalExperience5YearsOrMoreFTE); retval.Add(v_TeacherQualifications.TotalExperience5YearsOrMoreFTEPercentage); } if (statewide || show.Key == TQShowKeys.HighestDegree) { retval.Add(v_TeacherQualifications.DegreeMastersOrHigherFTE); retval.Add(v_TeacherQualifications.DegreeMastersOrHigherFTEPercentage); } if (statewide || show.Key == TQShowKeys.ESEAQualified) { if (GlobalValues.TQSubjects.Key == TQSubjectsKeys.SoclStd) { retval.Add(v_TeacherQualifications.FTE_ESEACore_HQYes); retval.Add(v_TeacherQualifications.ESEA_Core_HQYesFTEPercentage); retval.Add(v_TeacherQualifications.FTE_ESEACore_HQNo); retval.Add(v_TeacherQualifications.ESEA_Core_HQNoFTEPercentage); } else { retval.Add(v_TeacherQualifications.FTE_ESEA_HQYes); retval.Add(v_TeacherQualifications.EHQYesFTEPercentage); retval.Add(v_TeacherQualifications.FTE_ESEA_HQNo); retval.Add(v_TeacherQualifications.EHQNoFTEPercentage); } } return(retval); }