public void Bug844_PostGrad_Columns()
{
PostGradIntentPage postGrad = new PostGradIntentPage();
PostGradPlan plan = new PostGradPlan();
Group group = new Group();
group.Value = group.Range[GroupKeys.All];
plan.Value = plan.Range[PostGradPlanKeys.All];
//RULE: Show=all, ViewBy=All Students, CompareToEnum=PriorYears:
//select PriorYear as ' '
//, [Number of Graduates]
//, [% 4-Year College]
//, [% Voc/Tech College]
//, [% Employment] as [% Emp.]
//, [% Military]
//, [% Job Training]
//, [% Miscellaneous] as [% Misc.]
List <string> cols = postGrad.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.School, SligoCS.BL.WI.CompareToEnum.PRIORYEARS, SchoolType.AllTypes, plan);
AssertColumns(cols, 8);
AssertColumn(cols, "PriorYear");
AssertColumn(cols, "Number of Graduates");
AssertColumn(cols, "% 4-Year College");
AssertColumn(cols, "% Voc/Tech College");
AssertColumn(cols, "% Employment");
AssertColumn(cols, "% Military");
AssertColumn(cols, "% Job Training");
AssertColumn(cols, "% Miscellaneous");
//RULE: Show=4-year college, ViewBy=AllStudents, CompareToEnum=PriorYears:
//select PriorYear as ' '
//, [Number of Graduates]
//, [Number 4-Year College]
//, [% 4-Year College]
plan.Value = plan.Range[PostGradPlanKeys.FourYr];
cols = postGrad.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.School, SligoCS.BL.WI.CompareToEnum.PRIORYEARS, SchoolType.AllTypes, plan);
AssertColumns(cols, 4);
AssertColumn(cols, "PriorYear");
AssertColumn(cols, "Number of Graduates");
AssertColumn(cols, "Number 4-Year College");
AssertColumn(cols, "% 4-Year College");
}
public void Bug898E_OrgLevelDistrict()
{
string url = "http://localhost:31489/SligoWI/PostGradIntentPage.aspx?PLAN=All&FULLKEY=013619040022&GraphFile=AP&CompareTo=DISTSTATE&ORGLEVEL=District&Group=RaceEthnicity&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=SQLStatement";
Browser.GetPage(url);
//If org level = district, should not see fullkey 013619040022 in sql statement.
Assert.IsTrue(!Browser.CurrentPageText.Contains("'013619040022'"), "should not see fullkey for school level when orglevel = district.");
//select rtrim(racedesc) as ' '
//, v_POST_GRAD_INTENT.diststate as ' '
//, [Number of Graduates]
//, [% 4-Year College]
//, [% Voc/Tech College]
//, [% Employment] as [% Emp.]
//, [% Military]
//, [% Job Training]
//, [% Miscellaneous] as [% Misc.]
PostGradIntentPage pgp = new PostGradIntentPage();
PostGradPlan plan = new PostGradPlan();
plan.Value = plan.Range[PostGradPlanKeys.All];
Group group = new Group();
group.Value = group.Range[GroupKeys.Race];
List <string> cols = pgp.GetVisibleColumns(group, SligoCS.BL.WI.OrgLevel.District, SligoCS.BL.WI.CompareToEnum.DISTSTATE, SchoolType.AllTypes, plan);
AssertColumns(cols, 9);
AssertColumn(cols, "racedesc");
AssertColumn(cols, "diststate");
AssertColumn(cols, "Number of Graduates");
AssertColumn(cols, "% 4-Year College");
AssertColumn(cols, "% Voc/Tech College");
AssertColumn(cols, "% Employment");
AssertColumn(cols, "% Military");
AssertColumn(cols, "% Job Training");
AssertColumn(cols, "% Miscellaneous");
}