static decimal GetBbprCorrelation()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
bbprCorrelation = proxy.GetSchoolPR_BroadbandCorrelation();
}
return(bbprCorrelation);
}
static decimal GetApbCorrelation()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
apbCorrelation = proxy.GetCountyAveragePerformance_BroadbandCorrelation();
}
return(apbCorrelation);
}
static decimal GetAesCorrelation()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
aesCorrelation = proxy.GetAuthoritySpeed_EmploymentCorrelation();
}
return(aesCorrelation);
}
static decimal GetApssCorrelation()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
apssCorrelation = proxy.GetAuthorityPop_SyncSpeedCorrelation();
}
return(apssCorrelation);
}
public void PassRatesBroadband()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
allBBandPRItems = proxy.MyView();
var serilizer = new System.Web.Script.Serialization.JavaScriptSerializer();
}
DataTable dt = new DataTable();
dt = ConvertToDatatable(allBBandPRItems);
StringBuilder str = new StringBuilder();
str.Append(@"<script type = 'text/javascript'>
google.load('visualization', '1', { packages: ['corechart']});
function drawVisualization() {
var data = google.visualization.arrayToDataTable([
['SchoolName','PercentPassed','AverageSpeed'],");
int count = dt.Rows.Count - 1;
for (int i = 0; i <= count; i++)
{
if (count == i)
{
str.Append("['"
+ dt.Rows[i]["SchoolName"].ToString()
+ "',"
+ dt.Rows[i]["PercentPassed"].ToString()
+ ","
+ dt.Rows[i]["AverageSpeed"].ToString()
+ "]]);");
}
else
{
str.Append("['"
+ dt.Rows[i]["SchoolName"].ToString()
+ "',"
+ dt.Rows[i]["PercentPassed"].ToString()
+ ","
+ dt.Rows[i]["AverageSpeed"].ToString()
+ "],");
}
}
str.Append("var options = {vAxes: {0: { title: 'Percent', format: ''},1: { title: 'Average Speed (mbps)', format: '##'}},hAxis: { title: 'School Name', format: ''},seriesType: 'bars',series:{ 0:{ type: 'bars', targetAxisIndex: 0}, 1: { type: 'line', targetAxisIndex: 1}}, };");
str.Append(" var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } google.setOnLoadCallback(drawVisualization);");
bbprScripts.Text = str.ToString() + "</script>";
}//PassRatesBroadband
}//PassRatesBroadband
public void AveragePerformanceInFiveGCSEs_Average_BBand_ByCounty()
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
allItems = proxy.getAverages();
var serilizer = new System.Web.Script.Serialization.JavaScriptSerializer();
}
DataTable dt = new DataTable();
dt = ConvertToDatatable(allItems);
StringBuilder str = new StringBuilder();
str.Append(@"<script type = 'text/javascript'>
google.load('visualization', '1', {packages: ['corechart']});
function drawVisualization(){
var data = google.visualization.arrayToDataTable([
['CountyID', 'PercentPassed', 'AverageSpeed'],");
int count = dt.Rows.Count - 1;
for (int i = 0; i <= count; i++)
{
if (count == i)
{
str.Append("["
+ dt.Rows[i]["CountyID"].ToString()
+ ","
+ dt.Rows[i]["PercentPassed"].ToString()
+ ","
+ dt.Rows[i]["AverageSpeed"].ToString()
+ "]]);");
}//if
else
{
str.Append("["
+ dt.Rows[i]["CountyID"].ToString()
+ ","
+ dt.Rows[i]["PercentPassed"].ToString()
+ ","
+ dt.Rows[i]["AverageSpeed"].ToString()
+ "],");
} //else
} //for
str.Append("var options = {vAxes: {0: {title: 'Percent', format: ''},1: {title: 'Average Speed(mbps)', format: '##'}}, hAxis: {title: 'County', format: ''}, seriesType: 'bars', series:{0:{type: 'line', targetAxisIndex: 0 }, 1: {type: 'bars', targetAxisIndex: 1}}, }; ");
str.Append(" var chart = new google.visualization.ComboChart(document.getElementById('chart_div_1')); chart.draw(data, options); } google.setOnLoadCallback(drawVisualization);");
apbLiteral.Text = str.ToString() + "</script>";
}//AvgPerformance_Bband_ByCounty
}//AvgPop_SyncSpeed
public void AuthorityEmployment_SyncSpeed()//AuthorityEmployment_SyncSpeed
{
using (NetaServiceClient proxy = new NetaServiceClient())
{
allEmploymentSpeedItems = proxy.GetAuthorityEmployment_Speed();
var serilizer = new System.Web.Script.Serialization.JavaScriptSerializer();
}
DataTable dt = new DataTable();
dt = ConvertToDatatable(allEmploymentSpeedItems);
StringBuilder str = new StringBuilder();
str.Append(@"<script type = 'text/javascript'>
google.load('visualization', '1', {packages: ['corechart']});
function drawVisualization(){
var data = google.visualization.arrayToDataTable([
['Authority', 'EmploymentRate', 'SyncSpeed'],");
int count = dt.Rows.Count - 1;
for (int i = 0; i <= count; i++)
{
if (count == i)
{
str.Append("['"
+ dt.Rows[i]["Authority"].ToString()
+ "',"
+ dt.Rows[i]["EmploymentRate"].ToString()
+ ","
+ dt.Rows[i]["SyncSpeed"].ToString()
+ "]]);");
}//if
else
{
str.Append("['"
+ dt.Rows[i]["Authority"].ToString()
+ "',"
+ dt.Rows[i]["EmploymentRate"].ToString()
+ ","
+ dt.Rows[i]["SyncSpeed"].ToString()
+ "],");
} //else
} //for
str.Append("var options = {vAxes: {0: {title: 'Employment Rate', format: '##'},1: {title: 'Sync Speed mbits', format: '##'}}, hAxis: {title: 'Authority', format: ''}, seriesType: 'bars', series:{0:{type: 'bars', targetAxisIndex: 0 }, 1: {type: 'line', targetAxisIndex: 1}}, }; ");
str.Append(" var chart = new google.visualization.ComboChart(document.getElementById('chart_div_3')); chart.draw(data, options); } google.setOnLoadCallback(drawVisualization);");
AesLiteral.Text = str.ToString() + "</script>";
}
