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;
}
}
