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>"; }