protected void Page_Load(object sender, EventArgs e) { Image1.Attributes.Add(Constants.UseMapKey, Constants.UseMapDistricSecretaryValue); if (!IsPostBack) { string pgConnectionString = ConfigurationManager.AppSettings[PgConnectionKey]; PgConnection pgCon = new PgConnection(pgConnectionString); DataTable table = pgCon.RunSql(GetYearsSql); DropDownList2.DataSource = table; DropDownList2.DataTextField = table.Columns[0].ToString(); DropDownList2.DataValueField = table.Columns[0].ToString(); DropDownList2.DataBind(); string sqlConnectionString = ConfigurationManager.AppSettings[SqlConnectionKey]; SqlServerConnection sqlCon = new SqlServerConnection(sqlConnectionString); table = sqlCon.RunSql(GetDieseasesSql); DropDownList1.DataSource = table; DropDownList1.DataTextField = table.Columns[1].ToString(); DropDownList1.DataValueField = table.Columns[0].ToString(); DropDownList1.DataBind(); selectMostSuitableDiesease(); } }
private DataTable getData() { string sqlConnectionString = ConfigurationManager.AppSettings[Constants.SqlConnectionKey]; SqlServerConnection sqlCon = new SqlServerConnection(sqlConnectionString); DataTable table = sqlCon.RunSql(Convert.ToString(ChartConfigurations[ChartConfigurationKeys.QUERY.ToString()])); return(table); }
protected void Page_Load(object sender, EventArgs e) { dic = new Dictionary <string, object>(); dic = new Dictionary <string, object>(); dic[ChartConfigurationKeys.HEIGHT.ToString()] = 500; dic[ChartConfigurationKeys.WIDTH.ToString()] = 800; dic[ChartConfigurationKeys.XVALARRAY.ToString()] = "MONTH"; dic[ChartConfigurationKeys.YVALARRAY.ToString()] = new List <string> { "MALECOUNT", "FEMALECOUNT", "CHILDCOUNT" }; dic[ChartConfigurationKeys.XTITLE.ToString()] = "Month"; dic[ChartConfigurationKeys.YTITLE.ToString()] = "Patients"; dic[ChartConfigurationKeys.TYPE.ToString()] = SeriesChartType.Column; dic[ChartConfigurationKeys.LEGEND.ToString()] = "Gender"; dic[ChartConfigurationKeys.VIEWLEGEND.ToString()] = true; dic[ChartConfigurationKeys.NOOFCHARTSERIES.ToString()] = 3; dic[ChartConfigurationKeys.SERIESNAMES.ToString()] = new List <string> { "Male", "Female", "Children" }; if (!IsPostBack) { string sqlConnectionString = ConfigurationManager.AppSettings[SqlConnectionKey]; SqlServerConnection sqlCon = new SqlServerConnection(sqlConnectionString); DataTable table = sqlCon.RunSql(Constants.GetDieseasesSql); DropDownList1.DataSource = table; DropDownList1.DataTextField = table.Columns[1].ToString(); DropDownList1.DataValueField = table.Columns[0].ToString(); DropDownList1.DataBind(); DropDownList1.Items.Insert(0, new ListItem() { Value = "ALL", Text = "All" }); table = sqlCon.RunSql(Constants.GetYearsStatSql); DropDownList2.DataSource = table; DropDownList2.DataTextField = table.Columns[0].ToString(); DropDownList2.DataValueField = table.Columns[0].ToString(); DropDownList2.DataBind(); dic[ChartConfigurationKeys.QUERY.ToString()] = string.Format(ChartDataSql, DropDownList2.Items[0].Value, "ALL"); dic[ChartConfigurationKeys.TITLE.ToString()] = string.Format(TitleFormat, DropDownList1.Items[0].Text, DropDownList2.Items[0].Value); ChartContainer1.ChartConfigurations = dic; } if (IsPostBack) { dic[ChartConfigurationKeys.QUERY.ToString()] = string.Format(ChartDataSql, DropDownList2.SelectedValue, DropDownList1.SelectedValue); dic[ChartConfigurationKeys.TITLE.ToString()] = string.Format(TitleFormat, DropDownList1.SelectedItem.Text, DropDownList2.SelectedValue); ChartContainer1.ChartConfigurations = dic; } dic = new Dictionary <string, object>(); dic[ChartConfigurationKeys.QUERY.ToString()] = string.Format(Constants.GetDieseaseVsPcountForCurrentYear, DateTime.Now.Year); dic[ChartConfigurationKeys.HEIGHT.ToString()] = 500; dic[ChartConfigurationKeys.WIDTH.ToString()] = 700; dic[ChartConfigurationKeys.XVALARRAY.ToString()] = "NAME"; dic[ChartConfigurationKeys.YVALARRAY.ToString()] = new List <string> { "PCOUNT" }; dic[ChartConfigurationKeys.XTITLE.ToString()] = "Diesease"; dic[ChartConfigurationKeys.YTITLE.ToString()] = "Patients"; dic[ChartConfigurationKeys.TYPE.ToString()] = SeriesChartType.Pie; dic[ChartConfigurationKeys.LEGEND.ToString()] = "Diesease"; dic[ChartConfigurationKeys.TITLE.ToString()] = "Dieseases Vs. Patients"; dic[ChartConfigurationKeys.VIEWLEGEND.ToString()] = true; dic[ChartConfigurationKeys.PIELABELSTYLE.ToString()] = "Outside"; dic[ChartConfigurationKeys.NOOFCHARTSERIES.ToString()] = 1; dic[ChartConfigurationKeys.SERIESNAMES.ToString()] = new List <string> { "DieseasesVsPatients" }; ChartContainer2.ChartConfigurations = dic; dic = new Dictionary <string, object>(); dic[ChartConfigurationKeys.QUERY.ToString()] = Constants.GetPatientBreakDownAgeGenderAndYear; dic[ChartConfigurationKeys.HEIGHT.ToString()] = 500; dic[ChartConfigurationKeys.WIDTH.ToString()] = 700; dic[ChartConfigurationKeys.XVALARRAY.ToString()] = "YEAR"; dic[ChartConfigurationKeys.YVALARRAY.ToString()] = new List <string> { "MALECOUNT", "FEMALECOUNT", "CHILDCOUNT" }; dic[ChartConfigurationKeys.XTITLE.ToString()] = "Year"; dic[ChartConfigurationKeys.YTITLE.ToString()] = "Patients"; dic[ChartConfigurationKeys.TYPE.ToString()] = SeriesChartType.Column; dic[ChartConfigurationKeys.LEGEND.ToString()] = "Gender"; dic[ChartConfigurationKeys.TITLE.ToString()] = "Year Vs. Patients"; dic[ChartConfigurationKeys.VIEWLEGEND.ToString()] = true; dic[ChartConfigurationKeys.NOOFCHARTSERIES.ToString()] = 3; dic[ChartConfigurationKeys.SERIESNAMES.ToString()] = new List <string> { "Male", "Female", "Children" }; ChartContainer3.ChartConfigurations = dic; }