public void ShowStates(String selectedState)
{
var json = new WebClient().DownloadString("https://data.cdc.gov/resource/9mfq-cb36.json");
//DataTable data = JsonConvert.DeserializeObject<DataTable>(json);
var result = JsonConvert.DeserializeObject <List <CDCobject> >(json);
ConvertToDataTable converter = new ConvertToDataTable();
DataTable data = converter.convertToDataTable(result);
Calculate obj = new Calculate();
DataTable dt = obj.calculate(data);
DataTable table = obj.getState(selectedState, dt);
cdcData.DataSource = table;
cdcData.DataBind();
int sum = obj.getSum();
for (int i = 0; i < cdcData.Rows.Count; i++)
{
int num = Convert.ToInt32(cdcData.Rows[i].Cells[2].Text);
double percentage = num * 100.0 / sum;
percentage = Math.Round(percentage, 2);
cdcData.Rows[i].Cells[3].Text = percentage + " %";
}
}
//DataTable temp = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false) // if it's the first page load
{
var json = new WebClient().DownloadString("https://data.cdc.gov/resource/9mfq-cb36.json");
//DataTable data = JsonConvert.DeserializeObject<DataTable>(json);
var result = JsonConvert.DeserializeObject <List <CDCobject> >(json);
ConvertToDataTable converter = new ConvertToDataTable();
DataTable data = converter.convertToDataTable(result);
Calculate obj = new Calculate();
DataTable dt = obj.calculate(data);
ddlState.DataSource = dt;
ddlState.DataTextField = "state";
ddlState.DataValueField = "state";
ddlState.DataBind();
cdcData.DataSource = dt;
cdcData.DataBind();
//temp = dt.Copy();
int sum = obj.getSum();
for (int i = 0; i < cdcData.Rows.Count; i++)
{
int num = Convert.ToInt32(cdcData.Rows[i].Cells[2].Text);
double percentage = num * 100.0 / sum;
percentage = Math.Round(percentage, 2);
cdcData.Rows[i].Cells[3].Text = percentage + " %";
}
}
}