protected void LoadChartData(string dst_id, string cso_id, string report_type) { #region Clear Chart foreach (var series in OVCReferralChart.Series) { series.Points.Clear(); } #endregion dt = Result_Area_three_reports.GetOVCReferral_graph_data(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { string[] x = new string[dt.Rows.Count]; int[] y = new int[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { x[i] = dt.Rows[i][0].ToString(); y[i] = Convert.ToInt32(dt.Rows[i][1]); } OVCReferralChart.Series[0].Points.DataBindXY(x, y); OVCReferralChart.Series[0].ChartType = SeriesChartType.StackedColumn; OVCReferralChart.Series[0].LegendText = "Referral Completion Rate:"; OVCReferralChart.Legends[0].Enabled = true; OVCReferralChart.Visible = true; } }
protected void LoadResultArea01Reports(string dst_id, string cso_id, string report_type) { #region Dates if (txtCreateDateFrom.Text != string.Empty) { string short_date = Convert.ToDateTime(txtCreateDateFrom.Text).ToShortDateString(); datefrom = Convert.ToDateTime(short_date); } else { datefrom = null; } if (txtCreateDateTo.Text != string.Empty) { dateTo = Convert.ToDateTime(txtCreateDateTo.Text); } else { dateTo = null; } #endregion Dates switch (report_type) { case "ovc_refferals_made": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_refferals_made.DataSource = dt; gdv_ovc_refferals_made.DataBind(); } else { dt = null; gdv_ovc_refferals_made.DataSource = dt; gdv_ovc_refferals_made.DataBind(); } break; case "ov_refferals_completed": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_refferals_completed.DataSource = dt; gdv_ovc_refferals_completed.DataBind(); } else { dt = null; gdv_ovc_refferals_completed.DataSource = dt; gdv_ovc_refferals_completed.DataBind(); } break; } }
protected void LoadResultArea01Reports(string dst_id, string cso_id, string report_type) { #region Dates if (txtCreateDateFrom.Text != string.Empty) { string short_date = Convert.ToDateTime(txtCreateDateFrom.Text).ToShortDateString(); datefrom = Convert.ToDateTime(short_date); } else { datefrom = null; } if (txtCreateDateTo.Text != string.Empty) { dateTo = Convert.ToDateTime(txtCreateDateTo.Text); } else { dateTo = null; } #endregion Dates switch (report_type) { case "ovc_served": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_served.DataSource = dt; gdv_ovc_served.DataBind(); } else { dt = null; gdv_ovc_served.DataSource = dt; gdv_ovc_served.DataBind(); } break; case "ovc_more_than_one_service_received": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_more_than_one_service.DataSource = dt; gdv_more_than_one_service.DataBind(); } else { dt = null; gdv_more_than_one_service.DataSource = dt; gdv_more_than_one_service.DataBind(); } break; case "number_of_home_visits_conducted": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_total_home_visits.DataSource = dt; gdv_total_home_visits.DataBind(); } else { dt = null; gdv_total_home_visits.DataSource = dt; gdv_total_home_visits.DataBind(); } break; case "ovc_known_hiv_status": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_known_hiv_status.DataSource = dt; gdv_ovc_known_hiv_status.DataBind(); } else { dt = null; gdv_ovc_known_hiv_status.DataSource = dt; gdv_ovc_known_hiv_status.DataBind(); } break; case "caregiver_known_hiv_status": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_caregiver_known_hiv_status.DataSource = dt; gdv_caregiver_known_hiv_status.DataBind(); } else { dt = null; gdv_caregiver_known_hiv_status.DataSource = dt; gdv_caregiver_known_hiv_status.DataBind(); } break; case "ovc_hiv_positive": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_hiv_positive.DataSource = dt; gdv_ovc_hiv_positive.DataBind(); } else { dt = null; gdv_ovc_hiv_positive.DataSource = dt; gdv_ovc_hiv_positive.DataBind(); } break; case "caregiver_hiv_positive": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_caregiver_hiv_positive.DataSource = dt; gdv_caregiver_hiv_positive.DataBind(); } else { dt = null; gdv_caregiver_hiv_positive.DataSource = dt; gdv_caregiver_hiv_positive.DataBind(); } break; case "ovc_linked_to_care": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_ovc_linked_to_care.DataSource = dt; gdv_ovc_linked_to_care.DataBind(); } else { dt = null; gdv_ovc_linked_to_care.DataSource = dt; gdv_ovc_linked_to_care.DataBind(); } break; case "caregiver_linked_to_care": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_caregiver_linked_to_care.DataSource = dt; gdv_caregiver_linked_to_care.DataBind(); } else { dt = null; gdv_caregiver_linked_to_care.DataSource = dt; gdv_caregiver_linked_to_care.DataBind(); } break; } }
protected void LoadResultArea01Reports(string dst_id, string cso_id, string report_type) { #region Dates if (txtCreateDateFrom.Text != string.Empty) { string short_date = Convert.ToDateTime(txtCreateDateFrom.Text).ToShortDateString(); datefrom = Convert.ToDateTime(short_date); } else { datefrom = null; } if (txtCreateDateTo.Text != string.Empty) { dateTo = Convert.ToDateTime(txtCreateDateTo.Text); } else { dateTo = null; } #endregion Dates switch (report_type) { case "total_girls_enrolled_in_dreams": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_drm_girls.DataSource = dt; gdv_drm_girls.DataBind(); } else { dt = null; gdv_drm_girls.DataSource = dt; gdv_drm_girls.DataBind(); } break; case "girls_completing_14_sessions": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_drm_all_sessions.DataSource = dt; gdv_drm_all_sessions.DataBind(); } else { dt = null; gdv_drm_all_sessions.DataSource = dt; gdv_drm_all_sessions.DataBind(); } break; case "total_groups_receiving_sinovuyo": dt = Result_Area_three_reports.GetRsesultArea01Report(dst_id, cso_id, report_type, datefrom, dateTo); if (dt.Rows.Count > 0) { gdv_drm_groups.DataSource = dt; gdv_drm_groups.DataBind(); } else { dt = null; gdv_drm_groups.DataSource = dt; gdv_drm_groups.DataBind(); } break; } }