private StringBuilder getEDWFrequency(string frequency) { List <MonitorStatus> lst = new List <MonitorStatus>(); OracleReportDAO oraReportDao = new OracleReportDAO(); StringBuilder strBld = new StringBuilder(); lst = oraReportDao.getReportEDWFreqency(frequency); for (int i = 0; i < lst.Count; i++) { strBld.Append("<tr>"); strBld.Append("<td>").Append("<button type = 'button' class='button_status ").Append(lst[i].Status).Append("'></button>").Append("</td>"); strBld.Append("<td>").Append(lst[i].Status_name.Substring(2)).Append("</td>"); strBld.Append("<td>").Append(lst[i].Sla).Append("</td>"); strBld.Append("<td>").Append(lst[i].Work_name).Append("</td>"); strBld.Append("<td>").Append(lst[i].Batch_name).Append("</td>"); strBld.Append("<td>").Append(lst[i].Business_date).Append("</td>"); strBld.Append("<td>").Append(lst[i].Job_start_date).Append("</td>"); strBld.Append("<td>").Append(lst[i].Job_end_date).Append("</td>"); if (frequency == "") { strBld.Append("<td>").Append(lst[i].Frequency).Append("</td>"); } strBld.Append("</tr>"); } return(strBld); }
private void getDataBarChart() { List <MonitorStatus> lst = new List <MonitorStatus>(); OracleReportDAO oraReportDao = new OracleReportDAO(); List <string> lst_batch_name = new List <string>(); List <string> lst_c_sla = new List <string>(); List <string> lst_est_hours = new List <string>(); lst = oraReportDao.dataBarChart(); StringBuilder js_json = new StringBuilder(); for (int i = 0; i < lst.Count; i++) { lst_batch_name.Add(lst[i].Batch_name); lst_c_sla.Add(lst[i].C_sla); lst_est_hours.Add(lst[i].Est_hours); } js_json.Append(" <script>"); js_json.Append(" var vaBatch_name = "); js_json.Append((new JavaScriptSerializer()).Serialize(lst_batch_name)).Append(" ; "); js_json.Append(" var vaC_sla = "); js_json.Append((new JavaScriptSerializer()).Serialize(lst_c_sla)).Append(" ; "); js_json.Append(" var vaEst_hours = "); js_json.Append((new JavaScriptSerializer()).Serialize(lst_est_hours)).Append(" ; "); js_json.Append(" </script> "); lt_dataBarChart.Text = js_json.ToString(); Console.WriteLine(""); }
public static string getDataMorrisLineChart() { OracleReportDAO oratDao = new OracleReportDAO(); string str_data = ""; str_data = new JavaScriptSerializer().Serialize(oratDao.dataMorrisLineChart()); return(str_data); }
public StringBuilder getEDWStatus(string status, string nameJson) { List <MonitorStatus> lst = new List <MonitorStatus>(); OracleReportDAO oraReportDao = new OracleReportDAO(); StringBuilder strBld = new StringBuilder(); lst = oraReportDao.getReportEDWStatus_v2(status); //(new JavaScriptSerializer()).Serialize(streamDao.getStreamHealthy(project, tier, status)); StringBuilder js_json = new StringBuilder(); js_json.Append("<script>"); js_json.Append(" var ").Append(nameJson).Append(" = "); js_json.Append((new JavaScriptSerializer()).Serialize(lst)); js_json.Append(";</script> "); //string chk_c_sla=""; //for (int i = 0; i < lst.Count; i++) //{ // if (lst[i].C_sla == "Meet") { // chk_c_sla = "<td><span class='badge badge-pill badge-success'>Meet</span></td>" ; // } else if (lst[i].C_sla == "Miss") { // chk_c_sla = "<td><span class='badge badge-pill badge-danger'>Miss</span></td>"; // } // else { chk_c_sla = "<td></td>"; } // strBld.Append("<tr>"); // strBld.Append("<td>").Append("<button type = 'button' class='button_status ").Append(lst[i].Status).Append("'></button>").Append("</td>"); // strBld.Append("<td>").Append(lst[i].Status_name).Append("</td>"); // strBld.Append("<td>").Append(lst[i].Sla).Append("</td>"); // strBld.Append("<td>").Append(lst[i].C_sla).Append("</td>"); // //strBld.Append("<td>").Append(lst[i].Work_name).Append("</td>"); // strBld.Append("<td>").Append(lst[i].Batch_name).Append("</td>"); // strBld.Append("<td>").Append(lst[i].Business_date).Append("</td>"); // strBld.Append("<td>").Append(lst[i].Job_start_date).Append("</td>"); // strBld.Append("<td>").Append(lst[i].Job_end_date).Append("</td>"); // strBld.Append("<td></td>"); // strBld.Append("<td></td>"); // strBld.Append("<td>").Append(lst[i].Frequency).Append("</td>"); // strBld.Append("</tr>"); //} return(js_json); }
private void dataTimelineSla() { List <MonitorStatus> lst = new List <MonitorStatus>(); OracleReportDAO oraReportDao = new OracleReportDAO(); lst = oraReportDao.dataTimelineSla(); string str_timeline1 = "", str_timeline2 = "", str_timeline3 = "", str_timeline4 = "", str_timeline5 = "", str_timeline6 = ""; for (int i = 0; i < lst.Count(); i++) { switch (lst[i].Timeline) { case "00:00 - 03:59": str_timeline1 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; case "04:00 - 07:59": str_timeline2 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; case "08:00 - 11:59": str_timeline3 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; case "12:00 - 15:59": str_timeline4 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; case "16:00 - 19:59": str_timeline5 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; case "20:00 - 23:59": str_timeline6 += "<div>" + lst[i].Status_sla + " " + lst[i].Batch_name + "</div>"; break; } } lt_timeline_sla_1.Text = str_timeline1; lt_timeline_sla_2.Text = str_timeline2; lt_timeline_sla_3.Text = str_timeline3; lt_timeline_sla_4.Text = str_timeline4; lt_timeline_sla_5.Text = str_timeline5; lt_timeline_sla_6.Text = str_timeline6; }
public StringBuilder getEDWStatus(string status, string nameJson) { List <MonitorStatus> lst = new List <MonitorStatus>(); OracleReportDAO oraReportDao = new OracleReportDAO(); StringBuilder strBld = new StringBuilder(); lst = oraReportDao.getReportSASStatus_v2(status); //(new JavaScriptSerializer()).Serialize(streamDao.getStreamHealthy(project, tier, status)); StringBuilder js_json = new StringBuilder(); js_json.Append("<script>"); js_json.Append(" var ").Append(nameJson).Append(" = "); js_json.Append((new JavaScriptSerializer()).Serialize(lst)); js_json.Append(";</script> "); return(js_json); }
private void getDataMorrisLineChartSum() { OracleReportDAO oratDao = new OracleReportDAO(); List <MorrisLineChart> lst_obj = new List <MorrisLineChart>(); lst_obj = oratDao.dataMorrisLineChartSum(); Console.Out.WriteLine(""); int value = 1234567890; Console.WriteLine(value.ToString("0,0", CultureInfo.InvariantCulture)); div_today.InnerText = lst_obj[0].Today.ToString("0,0", CultureInfo.InvariantCulture); div_yesterday.InnerText = lst_obj[0].Yesterday.ToString("0,0", CultureInfo.InvariantCulture); div_average.InnerText = lst_obj[0].Average.ToString("0,0", CultureInfo.InvariantCulture); }
public void getSumStatusSAS() { List <Chart> lst = new List <Chart>(); OracleReportDAO oraReportDao = new OracleReportDAO(); lst = oraReportDao.getSumStatusSAS(); 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 getSumStatusHmlEDW() { List <Chart> lst = new List <Chart>(); OracleReportDAO oraReportDao = new OracleReportDAO(); lst = oraReportDao.getSumStatusHmlEDW(); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { switch (lst[i].Priority_hml.ToString()) { case "H": monitor_h.InnerText = lst[i].Monitor.ToString(); running_h.InnerText = lst[i].Running.ToString(); complete_h.InnerText = lst[i].Completed.ToString(); total_h.InnerText = lst[i].Total.ToString(); break; case "M": monitor_m.InnerText = lst[i].Monitor.ToString(); running_m.InnerText = lst[i].Running.ToString(); complete_m.InnerText = lst[i].Completed.ToString(); total_m.InnerText = lst[i].Total.ToString(); break; case "L": monitor_l.InnerText = lst[i].Monitor.ToString(); running_l.InnerText = lst[i].Running.ToString(); complete_l.InnerText = lst[i].Completed.ToString(); total_l.InnerText = lst[i].Total.ToString(); break; } } } }
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() + "%"; ; } }