protected void GetHES_report(string dst_id, string cso_id, string reportType)
{
#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
#region Load Report
switch (reportType)
{
case "Agronomy Training":
dt = HES_reports.GetHES_report(dst_id, cso_id, "Agronomy", datefrom, dateTo);
break;
case "Apprenticeship":
dt = HES_reports.GetHES_report(dst_id, cso_id, "Apprenticeship", datefrom, dateTo);
break;
case "AFLateen":
dt = HES_reports.GetHES_report(dst_id, cso_id, "AFLateen", datefrom, dateTo);
break;
case "Youth in savings groups":
dt = HES_reports.GetHES_report(dst_id, cso_id, "YouthGroup", datefrom, dateTo);
break;
case "Care giver group":
dt = HES_reports.GetHES_report(dst_id, cso_id, "CaregiverGroup", datefrom, dateTo);
break;
case "Belong to SILC Group":
dt = HES_reports.GetHES_report(dst_id, cso_id, "SILC", datefrom, dateTo);
break;
case "Better Parenting":
dt = HES_reports.GetHES_report(dst_id, cso_id, "better_parenting", datefrom, dateTo);
break;
case "Financial Literacy":
dt = HES_reports.GetHES_report(dst_id, cso_id, "better_parenting", datefrom, dateTo);
break;
case "Faithful house":
dt = HES_reports.GetHES_report(dst_id, cso_id, "faithful_house", datefrom, dateTo);
break;
case "Youth entrepreneurship skills":
dt = HES_reports.GetHES_report(dst_id, cso_id, "entrepreneurship_skills", datefrom, dateTo);
break;
}
if (dt.Rows.Count > 0)
{
gdvHES.DataSource = dt;
gdvHES.DataBind();
#region Set Header
lblGridHeader.Text = "Number of Youth Reached for " + cboReportname.Text;
if (reportType == "Better Parenting")
{
lblGridHeader.Text = "Households reached with:" + reportType;
}
else if (reportType == "Financial Literacy")
{
lblGridHeader.Text = "Households reached with:" + reportType;
}
else if (reportType == "Faithful house")
{
lblGridHeader.Text = "Households reached with:" + reportType;
}
else if (reportType == "Youth entrepreneurship skills")
{
lblGridHeader.Text = "Households reached with:" + reportType;
}
lblgraphHeader.Text = "Visualized Dataset: " + cboReportname.Text;
#endregion Set Header
}
else
{
dt = null;
gdvHES.DataSource = dt;
gdvHES.DataBind();
}
#endregion Load Report
}
protected void Load_Chart(string dst_id, string cso_id, string reportType, string chartType)
{
#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 (reportType)
{
case "Agronomy Training":
dt = HES_reports.GetHES_report(dst_id, cso_id, "Agronomy", datefrom, dateTo);
break;
case "Apprenticeship":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "Apprenticeship", datefrom, dateTo);
break;
case "AFLateen":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "AFLateen", datefrom, dateTo);
break;
case "Youth in savings groups":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "YouthGroup", datefrom, dateTo);
break;
case "Care giver group":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "CaregiverGroup", datefrom, dateTo);
break;
case "Belong to SILC Group":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "SILC", datefrom, dateTo);
break;
case "Better Parenting":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "better_parenting", datefrom, dateTo);
break;
case "Financial Literacy":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "better_parenting", datefrom, dateTo);
break;
case "Faithful house":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "faithful_house", datefrom, dateTo);
break;
case "Youth entrepreneurship skills":
dt = HES_reports.GetHES_report(dst_id, cboCSO.SelectedValue.ToString(), "entrepreneurship_skills", datefrom, dateTo);
break;
}
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]);
}
char_HES.Series[0].Points.DataBindXY(x, y);
if (chartType == "Bar")
{
char_HES.Series[0].ChartType = SeriesChartType.Bar;
}
else if (chartType == "Pie")
{
char_HES.Series[0].ChartType = SeriesChartType.Pie;
}
else if (chartType == "Line")
{
char_HES.Series[0].ChartType = SeriesChartType.Line;
}
// char_HES.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
char_HES.Legends[0].Enabled = true;
char_HES.Visible = true;
}
