public void getSumStatusEDW()
{
List <Chart> lst = new List <Chart>();
OracleReportDAO oraReportDao = new OracleReportDAO();
lst = oraReportDao.getSumStatusEDW();
if (lst.Count > 0)
{
h_num_completed.InnerText = lst[0].Completed.ToString();
probar_completed.Style.Add("width", lst[0].Completed_percent.ToString() + "%");
p_completed_p.InnerText = lst[0].Completed_percent.ToString() + "%";
h_num_running.InnerText = lst[0].Running.ToString();
probar_running.Style.Add("width", lst[0].Running_percent.ToString() + "%");
p_running_p.InnerText = lst[0].Running_percent.ToString() + "%";
h_num_monitor.InnerText = lst[0].Monitor.ToString();
probar_monitor.Style.Add("width", lst[0].Monitor_percent.ToString() + "%");
p_monitor_p.InnerText = lst[0].Monitor_percent.ToString() + "%";
h_num_total.InnerText = lst[0].Total.ToString();
probar_total.Style.Add("width", "100%");
p_total_p.InnerText = "100%";
h_num_meet.InnerText = lst[0].Meet.ToString();
probar_meet.Style.Add("width", lst[0].Meet_percent.ToString() + "%");
p_meet_p.InnerText = lst[0].Meet_percent.ToString() + "%";
h_num_miss.InnerText = lst[0].Miss.ToString();
probar_miss.Style.Add("width", lst[0].Miss_percent.ToString() + "%");
p_miss_p.InnerText = lst[0].Miss_percent.ToString() + "%";
h_num_na.InnerText = lst[0].Na.ToString();
probar_na.Style.Add("width", lst[0].Na_percent.ToString() + "%");
p_na_p.InnerText = lst[0].Na_percent.ToString() + "%";
h_num_total_sla.InnerText = lst[0].Total_sla.ToString();
probar_total_sla.Style.Add("width", "100%");
p_total_sla_p.InnerText = "100%";
}
}
public void getSumStatusEDW()
{
List <Chart> lst = new List <Chart>();
OracleReportDAO oraReportDao = new OracleReportDAO();
lst = oraReportDao.getSumStatusEDW();
if (lst.Count > 0)
{
// div_num_completed.InnerText = lst[0].Completed.ToString();
div_num_completed.InnerText = lst[0].Completed.ToString();
h_num_completed.InnerText = lst[0].Completed.ToString();
probar_completed.Style.Add("width", lst[0].Completed_percent.ToString() + "%");
p_completed_p.InnerText = lst[0].Completed_percent.ToString() + "%";
div_num_running.InnerText = lst[0].Running.ToString();
h_num_running.InnerText = lst[0].Running.ToString();
probar_running.Style.Add("width", lst[0].Running_percent.ToString() + "%");
p_running_p.InnerText = lst[0].Running_percent.ToString() + "%";
div_num_monitor.InnerText = lst[0].Monitor.ToString();
h_num_monitor.InnerText = lst[0].Monitor.ToString();
probar_monitor.Style.Add("width", lst[0].Monitor_percent.ToString() + "%");
p_monitor_p.InnerText = lst[0].Monitor_percent.ToString() + "%";
div_num_total.InnerText = lst[0].Total.ToString();
h_num_total.InnerText = lst[0].Total.ToString();
probar_total.Style.Add("width", "100%");
p_total_p.InnerText = "100%";
div_num_meet.InnerText = lst[0].Meet.ToString();
h_num_meet.InnerText = lst[0].Meet.ToString();
probar_meet.Style.Add("width", lst[0].Meet_percent.ToString() + "%");
p_meet_p.InnerText = lst[0].Meet_percent.ToString() + "%";
div_num_miss.InnerText = lst[0].Miss.ToString();
h_num_miss.InnerText = lst[0].Miss.ToString();
probar_miss.Style.Add("width", lst[0].Miss_percent.ToString() + "%");
p_miss_p.InnerText = lst[0].Miss_percent.ToString() + "%";
h_num_na.InnerText = lst[0].Na.ToString();
probar_na.Style.Add("width", lst[0].Na_percent.ToString() + "%");
p_na_p.InnerText = lst[0].Na_percent.ToString() + "%";
h_num_total_sla.InnerText = lst[0].Total_sla.ToString();
probar_total_sla.Style.Add("width", "100%");
p_total_sla_p.InnerText = "100%";
// -- init data for pie chart ---
StringBuilder js_json = new StringBuilder();
string str_monitor = lst[0].Monitor.ToString();
string str_running = lst[0].Running.ToString();
string str_complete = lst[0].Completed.ToString();
string str_na = lst[0].Na.ToString();
string str_miss = lst[0].Miss.ToString();
string str_meet = lst[0].Meet.ToString();
js_json.Append("<script>");
js_json.Append(" var vaSeries = [");
js_json.Append("{ value:'").Append(str_monitor).Append("',name:'Monitor : ").Append(str_monitor).Append("'}");
js_json.Append(",{ value:'").Append(str_running).Append("',name:'Running : ").Append(str_running).Append("'}");
js_json.Append(",{ value:'").Append(str_complete).Append("',name:'Complete : ").Append(str_complete).Append("'}");
js_json.Append("];");
js_json.Append(" var vaLegendData = [");
js_json.Append("'Monitor : ").Append(str_monitor).Append("'");
js_json.Append(",'Running : ").Append(str_running).Append("'");
js_json.Append(",'Complete : ").Append(str_complete).Append("'] ; ");
js_json.Append(" var vaSeriesSla = [");
js_json.Append("{ value:'").Append(str_monitor).Append("',name:'Na : ").Append(str_na).Append("'}");
js_json.Append(",{ value:'").Append(str_running).Append("',name:'Miss : ").Append(str_miss).Append("'}");
js_json.Append(",{ value:'").Append(str_complete).Append("',name:'Meet : ").Append(str_meet).Append("'}");
js_json.Append("];");
js_json.Append(" var vaLegendDataSla = [");
js_json.Append("'Na : ").Append(str_na).Append("'");
js_json.Append(",'Miss : ").Append(str_miss).Append("'");
js_json.Append(",'Meet : ").Append(str_meet).Append("'] ; ");
js_json.Append("</script>");
lt_dataPieChart.Text = js_json.ToString();
}
}
public void getSumStatusEDW()
{
List <Chart> lst = new List <Chart>();
OracleReportDAO oraReportDao = new OracleReportDAO();
lst = oraReportDao.getSumStatusEDW();
if (lst.Count > 0)
{
// div_num_completed.InnerText = lst[0].Completed.ToString();
div_num_completed.InnerText = lst[0].Completed.ToString();
//h_num_completed.InnerText = lst[0].Completed.ToString();
//probar_completed.Style.Add("width", lst[0].Completed_percent.ToString() + "%");
//p_completed_p.InnerText = lst[0].Completed_percent.ToString() + "%";
div_num_running.InnerText = lst[0].Running.ToString();
//h_num_running.InnerText = lst[0].Running.ToString();
//probar_running.Style.Add("width", lst[0].Running_percent.ToString() + "%");
//p_running_p.InnerText = lst[0].Running_percent.ToString() + "%";
div_num_monitor.InnerText = lst[0].Monitor.ToString();
//h_num_monitor.InnerText = lst[0].Monitor.ToString();
//probar_monitor.Style.Add("width", lst[0].Monitor_percent.ToString() + "%");
//p_monitor_p.InnerText = lst[0].Monitor_percent.ToString() + "%";
div_num_total.InnerText = lst[0].Total.ToString();
//h_num_total.InnerText = lst[0].Total.ToString();
//probar_total.Style.Add("width", "100%");
//p_total_p.InnerText = "100%";
div_num_meet.InnerText = lst[0].Meet.ToString();
// h_num_meet.InnerText = lst[0].Meet.ToString();
//probar_meet.Style.Add("width", lst[0].Meet_percent.ToString() + "%");
//p_meet_p.InnerText = lst[0].Meet_percent.ToString() + "%";
div_num_miss.InnerText = lst[0].Miss.ToString();
// h_num_miss.InnerText = lst[0].Miss.ToString();
//probar_miss.Style.Add("width", lst[0].Miss_percent.ToString() + "%");
//p_miss_p.InnerText = lst[0].Miss_percent.ToString() + "%";
//h_num_na.InnerText = lst[0].Na.ToString();
//probar_na.Style.Add("width", lst[0].Na_percent.ToString() + "%");
//p_na_p.InnerText = lst[0].Na_percent.ToString() + "%";
//h_num_total_sla.InnerText = lst[0].Total_sla.ToString();
//probar_total_sla.Style.Add("width", "100%");
//p_total_sla_p.InnerText = "100%";
// -- init data for pie chart ---
StringBuilder str_dataMorrisPieDonut = new StringBuilder();
StringBuilder js_json = new StringBuilder();
string str_monitor = lst[0].Monitor.ToString();
string str_running = lst[0].Running.ToString();
string str_complete = lst[0].Completed.ToString();
string str_na = lst[0].Na.ToString();
string str_miss = lst[0].Miss.ToString();
string str_meet = lst[0].Meet.ToString();
js_json.Append("<script>");
js_json.Append(" var vaSeries = [");
js_json.Append("{ value:'").Append(str_monitor).Append("',name:'Monitor : ").Append(str_monitor).Append("'}");
js_json.Append(",{ value:'").Append(str_running).Append("',name:'Running : ").Append(str_running).Append("'}");
js_json.Append(",{ value:'").Append(str_complete).Append("',name:'Complete : ").Append(str_complete).Append("'}");
js_json.Append("];");
js_json.Append(" var vaLegendData = [");
js_json.Append("'Monitor : ").Append(str_monitor).Append("'");
js_json.Append(",'Running : ").Append(str_running).Append("'");
js_json.Append(",'Complete : ").Append(str_complete).Append("'] ; ");
js_json.Append(" var vaSeriesSla = [");
js_json.Append("{ value:'").Append(str_monitor).Append("',name:'Na : ").Append(str_na).Append("'}");
js_json.Append(",{ value:'").Append(str_running).Append("',name:'Miss : ").Append(str_miss).Append("'}");
js_json.Append(",{ value:'").Append(str_complete).Append("',name:'Meet : ").Append(str_meet).Append("'}");
js_json.Append("];");
js_json.Append(" var vaLegendDataSla = [");
js_json.Append("'Na : ").Append(str_na).Append("'");
js_json.Append(",'Miss : ").Append(str_miss).Append("'");
js_json.Append(",'Meet : ").Append(str_meet).Append("'] ; ");
js_json.Append("</script>");
// -- int data morris pie donut chart ---
str_dataMorrisPieDonut.Append("<script>");
str_dataMorrisPieDonut.Append(" var vaDataMrrisDonut = ").Append(lst[0].Completed_percent.ToString());
str_dataMorrisPieDonut.Append("</script>");
h_total_on_pie.InnerText = lst[0].Total.ToString();
b_completed_job.InnerText = lst[0].Completed.ToString();
//lt_dataPieChart.Text = js_json.ToString();
lt_dataPieChart.Text = str_dataMorrisPieDonut.ToString();
// ----- set value to pie chart ------
//span_bar_circle.InnerText = lst[0].Completed_percent.ToString();
string str_comple_p = "";
if (lst[0].Completed_percent < 51)
{
str_comple_p = "progress-circle p" + lst[0].Completed_percent;
}
else
{
str_comple_p = "progress-circle over50 p" + lst[0].Completed_percent;
}
//div_bar_circle.Attributes.Add("class", str_comple_p);
//h_total_on_pie.InnerText = lst[0].Total.ToString();
//h_complete_on_pie.InnerText = lst[0].Completed_percent.ToString() + "%";
//h_running_on_pie.InnerText = lst[0].Running_percent.ToString() + "%"; ;
//h_monitor_on_pie.InnerText = lst[0].Monitor_percent.ToString() + "%"; ;
}
}