/// <summary>
/// Helper method that prepares FCC data
/// </summary>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="county"></param>
/// <param name="domain"></param>
/// <returns></returns>
private List <BroadbandSpeedGraph> PrepareFCCData(string city, string state, string domain, County county)
{
//Get the census code
string newCity = char.ToUpper(city[0]) + city.Substring(1);
int code = county.GetCensusCode(city, state, HomeController._database);
//Get list of broadbands in that census code
BroadbandAPI ba = new BroadbandAPI();
List <Broadband> broadbands = (ba.GetBroadbandSpeed(code, city, state)).OrderByDescending(o => o.provider).ToList();
//Prepare graph data
List <BroadbandSpeedGraph> fccData = new List <BroadbandSpeedGraph>();
foreach (Broadband br in broadbands)
{
if (br.speed != 0)
{
fccData.Add(new BroadbandSpeedGraph(br.provider, br.speed));
}
}
//Add user broadband
Broadband b = new Broadband();
List <Broadband> userBroadband = b.GetUserProviderData(city, state, domain, HomeController._database);
foreach (Broadband br in userBroadband)
{
fccData.Add(new BroadbandSpeedGraph(br.provider, br.speed));
}
return(fccData);
}
/// <summary>
/// Load FCC crowd source table partial view
/// </summary>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="ordering"></param>
/// <returns></returns>
public IActionResult FCCTable(string city, string state, bool ordering)
{
//Get census code
County county = new County();
string newCity = char.ToUpper(city[0]) + city.Substring(1);
int code = county.GetCensusCode(city, state, HomeController._database);
//Get list of broadbands
BroadbandAPI ba = new BroadbandAPI();
List <Broadband> broadbands;
//If ordering is ascending
if (ordering)
{
broadbands = (ba.GetBroadbandSpeed(code, city, state)).OrderByDescending(o => o.provider).ToList();
}
else
{
broadbands = (ba.GetBroadbandSpeed(code, city, state)).OrderBy(o => o.provider).ToList();
}
return(PartialView(broadbands));
}
