private TableRow GetSecondSuperHeader()
{
TableRow tr = new TableRow();
TQRelateTo relateTo = GlobalValues.TQRelateTo;
WinssDataGrid.AddTableCell(tr, " ", 1); //first label column is always blank
string wkcewsas = GlobalValues.WOW.Key;
string grade = ((GlobalValues.Grade.Key != GradeKeys.Combined_PreK_12 && GlobalValues.Grade.Key != GradeKeys.AllDisAgg)
? "Grade " : String.Empty)
+ GlobalValues.Grade.Key;
int fayColSpan = 2;
// (GlobalValues.Level.Key == LevelKeys.WAA_ELL || GlobalValues.Level.Key == LevelKeys.WAA_SwD)
// ? 6 : 2;
if (GlobalValues.SIZE.Key == SIZEKeys.Off &&
GlobalValues.SPEND.Key == SPENDKeys.Off)
{
fayColSpan++;
}
if (GlobalValues.SIZE.Key == SIZEKeys.On)
{
WinssDataGrid.AddTableCell(tr, RelKeys.DistrictSize, 1);
}
if (GlobalValues.SPEND.Key == SPENDKeys.On)
{
WinssDataGrid.AddTableCell(tr, RelKeys.DistrictSpending, 1);
}
if (GlobalValues.ECON.Key == ECONKeys.On)
{
fayColSpan++;
}
if (GlobalValues.LEP.Key == LEPKeys.On)
{
fayColSpan++;
}
if (GlobalValues.DISABILITY.Key == DISABILITYKeys.On)
{
fayColSpan++;
}
WinssDataGrid.AddTableCell(tr, wkcewsas + " -- All Students Enrolled FAY -- " + grade, fayColSpan);
foreach (TableCell cell in tr.Cells)
{
cell.BorderColor = System.Drawing.Color.Gray;
cell.BorderWidth = 4;
}
return(tr);
}
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);
}
private TableRow GetSecondSuperHeader()
{
TableRow tr = new TableRow();
TQRelateTo relateTo = GlobalValues.TQRelateTo;
WinssDataGrid.AddTableCell(tr, " ", 1); //first label column is always blank
string wkcewsas = GlobalValues.WOW.Key;
string grade = ((GlobalValues.Grade.Key != GradeKeys.Combined_PreK_12 && GlobalValues.Grade.Key != GradeKeys.AllDisAgg)
? "Grade " : String.Empty)
+ GlobalValues.Grade.Key;
int fayColSpan =
(GlobalValues.Level.Key == LevelKeys.WAA_ELL || GlobalValues.Level.Key == LevelKeys.WAA_SwD)
? 6 : 2;
if (GlobalValues.Level.Key == LevelKeys.NoWSAS)
{
fayColSpan = fayColSpan + 2;
}
if ((GlobalValues.Rel.Key != RelKeys.DistrictSize &&
GlobalValues.Rel.Key != RelKeys.DistrictSpending) ||
(GlobalValues.Group2.Key != Group2Keys.DistrictSize &&
GlobalValues.Group2.Key != Group2Keys.DistrictSpending)
)
{
fayColSpan++;
}
if (GlobalValues.Rel.Key == RelKeys.DistrictSize ||
GlobalValues.Group2.Key == Group2Keys.DistrictSize)
{
WinssDataGrid.AddTableCell(tr, RelKeys.DistrictSize, 1);
}
if (GlobalValues.Rel.Key == RelKeys.DistrictSpending ||
GlobalValues.Group2.Key == Group2Keys.DistrictSpending)
{
WinssDataGrid.AddTableCell(tr, RelKeys.DistrictSpending, 1);
}
WinssDataGrid.AddTableCell(tr, wkcewsas + " -- All Students Enrolled FAY -- " + grade, fayColSpan);
foreach (TableCell cell in tr.Cells)
{
cell.BorderColor = System.Drawing.Color.Gray;
cell.BorderWidth = 4;
}
return(tr);
}
private TableRow GetSecondSuperHeader()
{
TableRow tr = new TableRow();
int span = 0;
span = CountDimensions(SetIsDisaggFlags(GlobalValues)) + 2;
if (GlobalValues.HighSchoolCompletion.Key == HighSchoolCompletionKeys.All)
{
span--;
}
WinssDataGrid.AddTableCell(tr, " ", span); //first label column is always blank
WinssDataGrid.AddTableCell(tr, "Noncompleters", 3);
WinssDataGrid.AddTableCell(tr, "Completers", 3);
return(tr);
}
private TableRow GetSecondSuperHeader()
{
TableRow tr = new TableRow();
String show = base.GlobalValues.TQShow.Value;
if (show == GlobalValues.TQShow.Range[TQShowKeys.WisconsinLicenseStatus])
{
WinssDataGrid.AddTableCell(tr, string.Empty, CountVisibleColumns() - 7);
WinssDataGrid.AddTableCell(tr, "Total", 1);
WinssDataGrid.AddTableCell(tr, "Full License", 2);
WinssDataGrid.AddTableCell(tr, "Emergency License", 2);
WinssDataGrid.AddTableCell(tr, "No License For Assignment", 2);
}
else if (show == GlobalValues.TQShow.Range[TQShowKeys.HighestDegree])
{
//tr = new TableRow();
WinssDataGrid.AddTableCell(tr, string.Empty, 1);
WinssDataGrid.AddTableCell(tr, "Total", 1);
WinssDataGrid.AddTableCell(tr, "Masters or Higher", 2);
}
else if (show == GlobalValues.TQShow.Range[TQShowKeys.ESEAQualified])
{
// Total ESEA Qualified Not ESEA Qualified
//tr = new TableRow();
WinssDataGrid.AddTableCell(tr, string.Empty, 1);
WinssDataGrid.AddTableCell(tr, "Total", 1);
WinssDataGrid.AddTableCell(tr, TQShowKeys.ESEAQualified, 2);
WinssDataGrid.AddTableCell(tr, "Not ESEA Qualified", 2);
}
foreach (TableCell cell in tr.Cells)
{
cell.BorderColor = System.Drawing.Color.Gray;
cell.BorderStyle = BorderStyle.Double;
cell.BorderWidth = 4;
}
return(tr);
}
private TableRow BuildSecondaryTableTitleRow()
{
TableRow tr = new TableRow();
String dis = GlobalValues.PrDis.Key;
int spacer = base.GetVisibleColumns().Count + 1;
WinssDataGrid.AddTableCell(tr, String.Empty, spacer);
WinssDataGrid.AddTableCell(tr, GetMeasureLabel(), 2);
if (dis == PrDisKeys.Combined)
{
WinssDataGrid.AddTableCell(tr, "Students w/o Disabilities", 2);
}
//Common Columns
if (dis != PrDisKeys.AllDisabilities &&
dis != PrDisKeys.Combined)
{
WinssDataGrid.AddTableCell(tr, "Other Primary Disability", 2);
WinssDataGrid.AddTableCell(tr, "Students w/o Disability", 2);
}
return(tr);
}
public static StringBuilder PrintSortProps(Page argPage)
{
if (argPage == null)
{
return(null);
}
if (!(argPage is SligoCS.Web.Base.PageBase.WI.PageBaseWI))
{
throw new Exception("not PageBaseWI");
}
StringBuilder sb = new StringBuilder();
sb.Append("<br />");
SligoCS.Web.Base.PageBase.WI.PageBaseWI page = (SligoCS.Web.Base.PageBase.WI.PageBaseWI)argPage;
if (page.DataSet.Tables.Count < 1)
{
return(sb);
}
sb.Append("[Default Order By]");
sb.Append("[" +
String.Join("],[",
page.QueryMarshaller.BuildOrderByList(page.DataSet.Tables[0].Columns).ToArray()
) + "]"
).Append("<br /><br />");
if (page.DataGrid is WinssDataGrid)
{
WinssDataGrid grid = (WinssDataGrid)page.DataGrid;
sb.Append("[Page.DataGrid.OrderBy] ");
sb.Append("[" + String.Join("],[", grid.OrderBy.Split(",".ToCharArray())) + "]").Append("<br /><br />");
}
else
{
sb.Append("Could not get Sort from DataGrid: not WinssDataGrid");
}
if (page.Graph is WebUserControls.GraphBarChart ||
page.Graph is WebUserControls.GraphHorizBarChart ||
page.Graph is WebUserControls.GraphScatterplot)
{
String orderBy = String.Empty;
if (page.Graph is WebUserControls.GraphBarChart)
{
orderBy = ((WebUserControls.GraphBarChart)page.Graph).OrderBy;
}
else if (page.Graph is WebUserControls.GraphHorizBarChart)
{
orderBy = ((WebUserControls.GraphHorizBarChart)page.Graph).OrderBy;
}
else if (page.Graph is WebUserControls.GraphScatterplot)
{
orderBy = "Scatterplot Control doesn't support Sorting";
}
sb.Append("[Page.Graph.OrderBy] ");
sb.Append((orderBy == null)? "NULL" : "[" + String.Join("],[", orderBy.Split(",".ToCharArray())) + "]").Append("<br /><br />");
}
else
{
sb.Append("Could not get Sort from Graph. Control is of unexpected type, " + page.Graph.GetType().ToString());
}
return(sb);
}
