public string GetData(int value)
{
List<BBandPassRate> lstPassRates = new List<BBandPassRate>();
using (NetaDBEntities neta = new NetaDBEntities())
{
var myData = from p in neta.view_passrates_by_broadband select p;
foreach(view_passrates_by_broadband viewItem in myData)
{
BBandPassRate bbRate = Utils.CreteBBandPassRateFromDBView(viewItem);
//Class methods used to assign DataContract object variables to database fields
public static BBandPassRate CreteBBandPassRateFromDBView(view_passrates_by_broadband view)
{
BBandPassRate ret = new BBandPassRate();
ret.PostCode = view.postcode;
ret.SchoolName = view.school_name;
ret.PassRate = view.percent_5_pass_grades_gcse;
ret.AverageSpeed = (decimal)view.average_speed_mbps;
return ret;
}
public List<BBandPassRate> MyView()
{
List<BBandPassRate> lstPassRates = new List<BBandPassRate>();
using (NetaDBEntities neta = new NetaDBEntities())
{
var myData = from p in neta.view_passrates_by_broadband select p;
foreach (view_passrates_by_broadband viewItem in myData)
{
BBandPassRate bbRate = Utils.CreteBBandPassRateFromDBView(viewItem);
lstPassRates.Add(bbRate);
}
}
return lstPassRates;
}
