/// <summary>
/// Converts the enumerated type into a user friendly string.
/// </summary>
/// <param name="schoolType"></param>
/// <returns></returns>
public String SchoolTypeLabel(STYP schoolType)
{
string label = string.Empty;
if (schoolType.Key == STYPKeys.AllTypes)
{
label = "(All School Types)";
}
else if (schoolType.Key == STYPKeys.Elem)
{
label = "Elem. Schools";
}
else if (schoolType.Key == STYPKeys.ElSec)
{
label = "El/Sec Combined Schls";
}
else if (schoolType.Key == STYPKeys.Hi)
{
label = "High Schools";
}
else if (schoolType.Key == STYPKeys.Mid)
{
label = "Mid/Jr Hi Schools";
}
else if (schoolType.Key == STYPKeys.StateSummary)
{
label = "Summary - All School Types Combined";
}
return(label);
}
/// <summary>
/// Get STYP In Title
/// </summary>
/// <param name="orgLevelKey"></param>
/// <param name="compareTo"></param>
/// <param name="schoolType"></param>
/// <param name="s4orALL"></param>
/// <returns></returns>
public String GetSchoolTypeInTitle(STYP styp)
{
return
((globals.OrgLevel.Key == OrgLevelKeys.School &&
((globals.CompareTo.Key == CompareToKeys.SelDistricts || globals.CompareTo.Key == CompareToKeys.SelSchools)
)
)?
String.Empty
: SchoolTypeLabel(styp));
}
/// <summary>
/// Get CompareToEnum In Title
/// </summary>
/// <param name="orgLevelKey"></param>
/// <param name="compareTo"></param>
/// <param name="schoolType"></param>
/// <param name="s4orALL"></param>
/// <param name="regionString"></param>
/// <returns></returns>
public String GetCompareToInTitle(
OrgLevel orgLevel,
CompareTo compareTo,
STYP schoolType,
S4orALL s4orALL,
string regionString)
{
StringBuilder sb = new StringBuilder();
if (compareTo.Key == CompareToKeys.SelSchools ||
compareTo.Key == CompareToKeys.SelDistricts)
{
if (s4orALL.Key == S4orALLKeys.AllSchoolsOrDistrictsIn)
{
if (orgLevel.Key == OrgLevelKeys.School)
{
sb.AppendFormat(" Compared to All {0} in {1} ",
SchoolTypeLabel(schoolType), regionString);
}
else if (orgLevel.Key == OrgLevelKeys.District)
{
sb.AppendFormat(" Compared to All Districts in {0} ", regionString);
}
}
else
{
if (orgLevel.Key == OrgLevelKeys.School)
{
sb.AppendFormat(" Compared to Selected {0} ", SchoolTypeLabel(schoolType));
}
else if (orgLevel.Key == OrgLevelKeys.District)
{
sb.AppendFormat(" Compared to Selected Districts ");
}
}
}
else
{
if (compareTo.Key == CompareToKeys.OrgLevel && orgLevel.Key == OrgLevelKeys.District)
{
sb.AppendFormat(" Compared to {0} ", compareTo.Key.Replace("District/", String.Empty));
}
else if (compareTo.Key != CompareToKeys.Current)
{
sb.AppendFormat(" Compared to {0} ", compareTo.Key);
}
}
return(sb.ToString());
}
public String GetTitleWithoutGroupForSchoolTypeUnsupported(String prefix, GlobalValues globals, QueryMarshaller qm)
{
String styp = String.Empty;
//capture prefix in Public Property
Prefix = prefix;
if (!(globals.OrgLevel.Key == OrgLevelKeys.School &&
(globals.CompareTo.Key == CompareToKeys.Years ||
globals.CompareTo.Key == CompareToKeys.SimSchools))
)
{
STYP summary = new STYP();
summary.Value = globals.STYP.Range[STYPKeys.StateSummary];
styp = newline + GetSchoolTypeInTitle(summary);
}
return(GetTitleBase(prefix, globals, qm) + styp);
}
public override List <string> GetVisibleColumns(Group viewBy, OrgLevel orgLevel, CompareTo compareTo, STYP schoolType)
{
List <string> cols = base.GetVisibleColumns(viewBy, orgLevel, compareTo, schoolType);
if ((compareTo.Key == CompareToKeys.SelSchools) || (compareTo.Key == CompareToKeys.Current))
{
//When user selects "Compare To = Selected Schools" the first column in the grid
//should show the school name, but with no header.
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.NameColumn.ColumnName);
}
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.EnrollmentColumn.ColumnName);
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.Students_expected_to_complete_the_school_termColumn.ColumnName);
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.Students_who_completed_the_school_termColumn.ColumnName);
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.Drop_OutsColumn.ColumnName);
cols.Add(_ds._v_DropoutsWWoDisEconELPSchoolDistState.Drop_Out_RateColumn.ColumnName);
return(cols);
}
public static List <string> GetVisibleColumns(Group viewBy,
OrgLevel orgLevel,
CompareTo compareTo,
STYP schoolType)
{
////Notes for graph : Can't reuse this function in graph, because the visible column is used in the Grade Display(Grade Column paramName)
//the grap need the Data Set Column paramName, there is a little difference betwen theem. So can't reuse it in graph
List <string> retval = new List <string>();
Dictionary <String, String> map = new Dictionary <string, string>();
map.Add(GroupKeys.Race, CommonNames.RaceLabel.ToString());
map.Add(GroupKeys.Gender, CommonNames.SexLabel.ToString());
map.Add(GroupKeys.Grade, CommonNames.GradeLabel.ToString());
map.Add(GroupKeys.Disability, CommonNames.DisabilityLabel.ToString());
map.Add(GroupKeys.EconDisadv, CommonNames.EconDisadvLabel.ToString());
map.Add(GroupKeys.EngLangProf, CommonNames.ELPLabel.ToString());
//not all values result in adding a column
if (map.ContainsKey(viewBy.Key))
{
retval.Add(map[viewBy.Key]);
}
if (viewBy.Key == GroupKeys.RaceGender)
{
retval.Add(CommonNames.RaceLabel.ToString());
retval.Add(CommonNames.SexLabel.ToString());
}
//Note that when "OrgLevel <> SC" and "Schooltype = 1 (all types)", we add
//another column, SchooltypeLabel, to label the schooltype itemization...
if ((orgLevel.Key != OrgLevelKeys.School) && (schoolType.Key == STYPKeys.AllTypes))
{
retval.Add(CommonNames.SchooltypeLabel.ToString());
}
if (compareTo.Key == CompareToKeys.OrgLevel)
{
if (orgLevel.Key != OrgLevelKeys.School && schoolType.Key == STYPKeys.AllTypes)
{
retval.Add(CommonNames.OrgLevelLabel.ToString());
}
else
{
retval.Add(CommonNames.OrgSchoolTypeLabel.ToString());
}
}
if ((compareTo.Key == CompareToKeys.SelSchools || compareTo.Key == CompareToKeys.SelDistricts) || (compareTo.Key == CompareToKeys.Current))
{
//When user selects "Compare To = Selected Schools" the first column in the grid
//should show the school name, but with no header.
retval.Add(CommonNames.LinkedName.ToString());
}
//only show Year column when CompareToEnum == Prior Years
if (compareTo.Key == CompareToKeys.Years)
{
retval.Add(CommonNames.YearFormatted.ToString());
}
return(retval);
}
public override List <string> GetVisibleColumns(Group viewBy,
OrgLevel orgLevel, CompareTo compareTo, STYP schoolType)
{
List <string> retval = base.GetVisibleColumns(viewBy, orgLevel, compareTo, schoolType);
retval.Add(_ds._v_RetentionWWoDisEconELPSchoolDistState._Total_Enrollment__K_12_Column.ColumnName);
retval.Add(_ds._v_RetentionWWoDisEconELPSchoolDistState.Completed_School_TermColumn.ColumnName);
retval.Add(_ds._v_RetentionWWoDisEconELPSchoolDistState.Number_of_RetentionsColumn.ColumnName);
retval.Add(_ds._v_RetentionWWoDisEconELPSchoolDistState.Retention_RateColumn.ColumnName);
return(retval);
}
protected List <int> GetSchoolTypesList(STYP type)
{
return(new List <int>());
}
