private TableRow GetSecondSuperHeader()
{
TableRow tr = new TableRow();
TQRelateTo relateTo = GlobalValues.TQRelateTo;
string org = (GlobalValues.OrgLevel.Key == OrgLevelKeys.School) ? "School" : "District";
string schoolType = TitleBuilder.GetSchoolTypeInTitle(GlobalValues.STYP);
if (relateTo.CompareToKey(TQRelateToKeys.Spending))
{
WinssDataGrid.AddTableCell(tr, org, 1);
WinssDataGrid.AddTableCell(tr, "District Spending", 1);
WinssDataGrid.AddTableCell(tr, "Teacher Data: " + schoolType, 3);
//relateToDenominatorLabel = "Current Education Cost Per Member";
relateToLabel = "Current Education Cost Per Member";
}
else if (relateTo.CompareToKey(TQRelateToKeys.DistrictSize))
{
WinssDataGrid.AddTableCell(tr, org, 1);
WinssDataGrid.AddTableCell(tr, "District Size", 1);
WinssDataGrid.AddTableCell(tr, "Teacher Data: " + schoolType, 3);
relateToDenominatorLabel = "Total Number Enrolled";
}
else if (relateTo.CompareToKey(TQRelateToKeys.SchoolSize))
{
WinssDataGrid.AddTableCell(tr, org, 1);
WinssDataGrid.AddTableCell(tr, "School Size: " + schoolType, 1);
WinssDataGrid.AddTableCell(tr, "Teacher Data: " + schoolType, 3);
relateToDenominatorLabel = "Total Number Enrolled";
}
else
{
WinssDataGrid.AddTableCell(tr, org, 1);
WinssDataGrid.AddTableCell(tr, "Student Data:" + schoolType, 2);
WinssDataGrid.AddTableCell(tr, "Teacher Data:" + schoolType, 3);
relateToDenominatorLabel = "Total # Enrolled (PreK-12)**";
}
foreach (TableCell cell in tr.Cells)
{
cell.BorderColor = System.Drawing.Color.Gray;
cell.BorderStyle = BorderStyle.Double;
cell.BorderWidth = 4;
}
return(tr);
}
protected void Page_Load(object sender, EventArgs e)
{
String dataType = GlobalValues.HighSchoolCompletion.Key;
if (GlobalValues.HighSchoolCompletion.Key == HighSchoolCompletionKeys.All)
{
dataType = "All Credential Types";
}
String prefix = "High School Completion Rate - " + dataType + TitleBuilder.newline + GlobalValues.TmFrm.Key;
DataSetTitle = GetTitle(prefix);
String sTypeTitle = TitleBuilder.GetSchoolTypeInTitle(GlobalValues.STYP);
if (TitleBuilder.GetSchoolTypeInTitle(GlobalValues.STYP) != String.Empty)
{
DataSetTitle = DataSetTitle.Replace(sTypeTitle, String.Empty);
}
((WinssDataGrid)DataGrid).AddSuperHeader(DataSetTitle);
((WinssDataGrid)DataGrid).AddSuperHeader(GetSecondSuperHeader());
List <String> dgOrder = QueryMarshaller.BuildOrderByList(DataSet.Tables[0].Columns);
//timeframe should be the second sort factor
dgOrder.Insert(1, v_HSCWWoDisSchoolDistStateEconELPXYearRate.TimeFrameSort);
barChart.OrderBy = TimeFrameDataGrid.OrderBy = String.Join(",", dgOrder.ToArray());
set_state();
if (CountDimensions(SetIsDisaggFlags(GlobalValues)) > 2)
{
HideGraphForDisAggOverflow();
}
else
{
SetUpChart(DataSet);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//show message if the graph is not visible
pnlMessage.Visible = (Graph.Visible == false);
DataSetTitle = GetTitleWithoutGroupForSchoolTypeUnsupported(
((GlobalValues.WOW.Key == WOWKeys.WSASCombined) ?
WOWKeys.WSASCombined : WOWKeys.WKCE)
+ " - " + (
(GlobalValues.Grade.Key == GradeKeys.Combined_PreK_12 ||
GlobalValues.Grade.Key == GradeKeys.AllDisAgg)
? String.Empty
: "Grade "
) + GlobalValues.Grade.Key
+ " - " + GlobalValues.SubjectID.Key + WebSupportingClasses.TitleBuilder.newline
+ GlobalValues.Level.Key
)
;
DataSetTitle = DataSetTitle.Replace(
GlobalValues.GetOrgName(),
GlobalValues.GetOrgName() + "Compared to Other "
+ ((GlobalValues.OrgLevel.Key == OrgLevelKeys.School)? "Schools" : "Districts") + " in "
+ ((GlobalValues.LF.Key == LFKeys.State)? "Entire State" :
(GlobalValues.LF.Key == LFKeys.CESA)? "CESA " + GlobalValues.Agency.CESA.Trim() :
GlobalValues.Agency.CountyName.Trim()
)
);
if (GlobalValues.FAYCode.Key == FAYCodeKeys.FAY)
{
DataSetTitle = DataSetTitle.Replace(GlobalValues.GetOrgName(), GlobalValues.GetOrgName().Trim() + " FAY ");
}
if (GlobalValues.WOW.Key == WOWKeys.WSASCombined &&
GlobalValues.Level.Key == LevelKeys.BasicMinSkillEng)
{
DataSetTitle = DataSetTitle.Replace("+ WAA SwD/ELL ", String.Empty);
}
DataSetTitle =
DataSetTitle.Replace(TitleBuilder.GetYearRangeInTitle(QueryMarshaller.years),
"November " + (GlobalValues.Year - 1).ToString() + " Data");
if (GlobalValues.OrgLevel.Key == OrgLevelKeys.School)
{
DataSetTitle = DataSetTitle.Replace(TitleBuilder.GetSchoolTypeInTitle(GlobalValues.STYP), String.Empty);
}
StateTestsScatterDataGrid.AddSuperHeader(DataSetTitle);
StateTestsScatterDataGrid.AddSuperHeader(GetSecondSuperHeader());
List <String> order = QueryMarshaller.BuildOrderByList(DataSet.Tables[0].Columns);
order.Insert(0, v_WSAS.School_Name);
order.Insert(0, v_WSAS.District_Name); //same index is intentional... district, then school
StateTestsScatterDataGrid.OrderBy = String.Join(", ", order.ToArray());
StateTestsScatterDataGrid.ForceCurrentFloatToTopOrdering = true;
SetUpChart();
set_state();
setBottomLink();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSetTitle = GetTitleWithoutGroupForSchoolTypeUnsupported(
((GlobalValues.WOW.Key == WOWKeys.WSASCombined) ?
WOWKeys.WSASCombined : WOWKeys.WKCE)
+ " - " + (
(GlobalValues.Grade.Key == GradeKeys.Combined_PreK_12 ||
GlobalValues.Grade.Key == GradeKeys.AllDisAgg)
? String.Empty
: "Grade "
) + GlobalValues.Grade.Key
+ " - " + GlobalValues.SubjectID.Key
)
;
DataSetTitle = DataSetTitle.Replace(
GlobalValues.GetOrgName(),
"Top Five " + ((GlobalValues.OrgLevel.Key == OrgLevelKeys.School) ? "Schools" : "Districts")
+ " in "
+ ((GlobalValues.LF.Key == LFKeys.State) ? "Entire State" :
(GlobalValues.LF.Key == LFKeys.CESA) ? "CESA " + GlobalValues.Agency.CESA.Trim() :
GlobalValues.Agency.CountyName.Trim()
)
+ ((GlobalValues.Sim.Key == SimKeys.Outperform)? " Outperforming " : " Similar to ")
+ WebSupportingClasses.TitleBuilder.newline + GlobalValues.GetOrgName()
+ WebSupportingClasses.TitleBuilder.newline
+ " Sorted by " + GlobalValues.SORT.Key
);
if (GlobalValues.FAYCode.Key == FAYCodeKeys.FAY)
{
DataSetTitle = DataSetTitle.Replace(GlobalValues.GetOrgName(), GlobalValues.GetOrgName().Trim() + " FAY ");
}
DataSetTitle =
DataSetTitle.Replace(TitleBuilder.GetYearRangeInTitle(QueryMarshaller.years),
"November " + (GlobalValues.Year - 1).ToString() + " Data");
if (GlobalValues.OrgLevel.Key == OrgLevelKeys.School)
{
DataSetTitle = DataSetTitle.Replace(TitleBuilder.GetSchoolTypeInTitle(GlobalValues.STYP), String.Empty);
}
DataSetTitle = DataSetTitle.Replace(TitleBuilder.GetCompareToInTitle(GlobalValues.OrgLevel, GlobalValues.CompareTo, GlobalValues.STYP, GlobalValues.S4orALL, WebSupportingClasses.TitleBuilder.GetRegionString(GlobalValues)), String.Empty);
if (GlobalValues.Sim.Key != SimKeys.Default)
{
DataSetTitle = DataSetTitle
.Replace("Top Five ", "All "
+ ((GlobalValues.Sim.Key == SimKeys.AllSimilar) ? String.Empty : "Similar ")
);
}
SimilarDataGrid.AddSuperHeader(DataSetTitle);
SimilarDataGrid.AddSuperHeader(GetSecondSuperHeader());
SimilarDataGrid.OrderBy = String.Empty; //disable default order by and let SQL take over
SetUpChart();
barChart.OrderBy = String.Empty; //disable default order by and let SQL take over
if (GlobalValues.Sim.Key != SimKeys.Default)
{
barChart.Visible = false;
}
if (GlobalValues.Sim.Key != SimKeys.Default)
{
SimilarDefPanel.Visible = true;
SimilarDefLabel.Text = SimilarDefinitionDescription().Replace("\n", "<br />");
}
set_state();
setBottomLink();
}