public String FindAndFormatRange(String format, String find, SimilarRanges ranges, String field)
{
SimilarRange range = ranges.Find(find);
return
(String.Format(format,
field, range.Min, range.Max)
);
}
private SimilarRange InitDemographicsRange(SligoCS.BL.WI.QueryMarshaller Marshaller, String Name, String Column)
{
String strMeasure = Marshaller.Database.GetStringColumn(Column);
double meas = Double.Parse(strMeasure);
double min, max;
if (meas < 10.01)
{
min = 0;
max = 10;
}
else if (meas < 25.01)
{
min = 10.01;
max = 25;
}
else if (meas < 50.01)
{
min = 25.01;
max = 50;
}
else //if (meas > 50)
{
if (Name == Marshaller.GlobalValues.ECON.Name &&
meas > 75)
{
min = 75.01;
}
else
{
min = 50.01;
}
if (Name == Marshaller.GlobalValues.ECON.Name &&
meas < 75.01)
{
max = 75;
}
else
{
max = 100; // "infinity"
}
}
SimilarRange range = new SimilarRange();
range.MeasureName = Name;
range.Min = min.ToString();
range.Max = max.ToString();
return(range);
}
private SimilarRange InitSizeRange(SligoCS.BL.WI.QueryMarshaller Marshaller)
{
String strSize = Marshaller.Database.GetStringColumn(v_WSASDemographics.District_Size);
Int32 size = Int32.Parse(strSize);
Int32 min, max;
if (size < 501)
{
min = 1;
max = 500;
}
else if (size < 1001)
{
min = 501;
max = 1000;
}
else if (size < 2001)
{
min = 1001;
max = 2000;
}
else if (size < 10001)
{
min = 2001;
max = 10000;
}
else
{
min = 10001;
max = Int32.MaxValue; //"infinity"
}
SimilarRange range = new SimilarRange();
range.MeasureName = Marshaller.GlobalValues.SIZE.Name;
range.Min = min.ToString();
range.Max = max.ToString();
return(range);
}
//http://dpi.wi.gov/oea_similar
private SimilarRange InitSpendingRange(SligoCS.BL.WI.QueryMarshaller Marshaller)
{
String strSpend = Marshaller.Database.GetStringColumn(v_WSASDemographics.Cost_Per_Member);
Double spend;
int min, max;
if (!Double.TryParse(strSpend, out spend))
{
spend = 0;
}
min = 0;
if (spend < 9500.01)
{
max = 9500;
}
else if (spend < 10500.01)
{
max = 10500;
}
else if (spend < 11500.01)
{
max = 11500;
}
else
{
max = Int32.MaxValue;
}
SimilarRange range = new SimilarRange();
range.MeasureName = Marshaller.GlobalValues.SPEND.Name;
range.Min = min.ToString() + ".0";
range.Max = max.ToString() + ".0";
return(range);
}
public String SimilarDefinitionDescription()
{
System.Text.StringBuilder definition = new System.Text.StringBuilder("Criteria Selected for Defining Similar**:");
/*if (GlobalValues.SPEND.Key == SPENDKeys.On) definition.Append("\n" + RelKeys.DistrictSpending + " <= 1000000");
* if (GlobalValues.SIZE.Key == SIZEKeys.On) definition.Append("\n" + RelKeys.DistrictSize + " <= 1000000");
* if (GlobalValues.ECON.Key == ECONKeys.On) definition.Append("\n" + RelKeys.EconDisadvantaged + " <= 1600");
* if (GlobalValues.DISABILITY.Key == DISABILITYKeys.On) definition.Append("\n" + RelKeys.Disabilities + " <= 1600");
* if (GlobalValues.LEP.Key == LEPKeys.On) definition.Append("\n" + RelKeys.LEP + " <= 1600");
*/
DALWSASSimilarSchools dal = (DALWSASSimilarSchools)Database;
dal.Ranges = dal.InitSimilarRanges(QueryMarshaller);
String frmtDemographics = (GlobalValues.Sim.Key != SimKeys.AllSimilar)
? "\n {0} >= {1}%"
: "\n {0} >= {1}% and <= {2}%"
;
if (dal.Ranges.Exists(GlobalValues.SPEND.Name))
{
SimilarRange range = dal.Ranges.Find(GlobalValues.SPEND.Name);
String spendFrmt = "\n {0}";
if (GlobalValues.Sim.Key == SimKeys.AllSimilar)
{
spendFrmt += " >= ${1:#,###} and";
}
spendFrmt += (Double.Parse(range.Max) < 11500.01)
? " <= ${2:#,###}"
: " <= Any"
;
definition.Append(String.Format(spendFrmt, "District Current Education Cost Per Member ", range.Min, range.Max));
}
if (dal.Ranges.Exists(GlobalValues.SIZE.Name))
{
SimilarRange range = dal.Ranges.Find(GlobalValues.SIZE.Name);
String sizeFrmt =
(Decimal.Parse(range.Max) >= 10001)
? "\n {0} is greater than 10,000 Students"
: "\n {0} is between {1:#,###} and {2:#,###} Students";
definition.Append(String.Format(sizeFrmt, "District Size – Fall Enrollment"
, Int32.Parse(dal.Ranges.Find(GlobalValues.SIZE.Name).Min)
, Int32.Parse(dal.Ranges.Find(GlobalValues.SIZE.Name).Max)));
}
if (dal.Ranges.Exists(GlobalValues.ECON.Name))
{
definition.Append(
String.Format(frmtDemographics, RelKeys.EconDisadvantaged,
dal.Ranges.Find(GlobalValues.ECON.Name).Min,
dal.Ranges.Find(GlobalValues.ECON.Name).Max
));
}
if (dal.Ranges.Exists(GlobalValues.DISABILITY.Name))
{
definition.Append(
String.Format(frmtDemographics, RelKeys.Disabilities,
dal.Ranges.Find(GlobalValues.DISABILITY.Name).Min,
dal.Ranges.Find(GlobalValues.DISABILITY.Name).Max
));
}
if (dal.Ranges.Exists(GlobalValues.LEP.Name))
{
definition.Append
(String.Format(frmtDemographics, RelKeys.LEP,
dal.Ranges.Find(GlobalValues.LEP.Name).Min,
dal.Ranges.Find(GlobalValues.LEP.Name).Max
));
}
if (GlobalValues.NoChce.Key == NoChceKeys.On)
{
definition.Append("\n" + "No Criteria Chosen");
}
return(definition.ToString());
}
