public static string GetStatusAjax(string project) { ChartDAO chartDao = new ChartDAO(); string str_json = new JavaScriptSerializer().Serialize(chartDao.getTotalStatus(project)); return(str_json); }
private void getStatusSummaryProject() { ChartDAO chartDao = new ChartDAO(); List <Chart> lst_chart = new List <Chart>(); lst_chart = chartDao.getTotalStatus(""); // ----- set value to pie chart ------ span_pie_circle.InnerText = lst_chart[0].Completed_percent.ToString(); string str_comple_p = ""; if (lst_chart[0].Completed_percent < 51) { str_comple_p = "progress-circle p" + lst_chart[0].Completed_percent; } else { str_comple_p = "progress-circle over50 p" + lst_chart[0].Completed_percent; } div_pie_circle.Attributes.Add("class", str_comple_p); h_total_on_pie.InnerText = lst_chart[0].Total.ToString(); h_failed_on_pie.InnerText = lst_chart[0].Failed_percent.ToString() + "%"; h_running_on_pie.InnerText = lst_chart[0].Running_percent.ToString() + "%"; h_notstart_on_pie.InnerText = lst_chart[0].Notstarted_percent.ToString() + "%"; span_running.InnerText = lst_chart[0].Running.ToString(); span_failed.InnerText = lst_chart[0].Failed.ToString(); span_monitor.InnerText = lst_chart[0].Notstarted.ToString(); }
private string ProcessNewMembersVisitorsPerMonthList(string year) { try { //string year = DateTime.Now.ToString("yyyy"); int[] newArrMembers = ChartDAO.GetXXPerMonthList(_context, "Yes", year); int[] newVisitorsArr = ChartDAO.GetXXPerMonthList(_context, "No", year); List <Chart> chartList = new List <Chart> { new Chart { data = newArrMembers, label = "Joined Member" }, new Chart { data = newVisitorsArr, label = "Visitors" } }; string joinedMemberJson = JsonConvert.SerializeObject(chartList); return(joinedMemberJson); } catch (Exception e) { return("ProcessNewMembersVisitorsPerMonthList Exception: " + e.ToString()); } }
public static string dataReportSummaryIssue() { ChartDAO chartDao = new ChartDAO(); List <SummaryIssue> lst = new List <SummaryIssue>(); lst = chartDao.dataReportSummaryIssue(); string str_data = new JavaScriptSerializer().Serialize(lst); return(str_data); }
public static string getDataSummaryProject() { ChartDAO chartDao = new ChartDAO(); List <SummaryProject> lst_ = new List <SummaryProject>(); lst_ = chartDao.getSummaryProjects(); string dataJson = new JavaScriptSerializer().Serialize(lst_); return(dataJson); }
public static string getDataMorrisPie() { ChartDAO chartDao = new ChartDAO(); List <Chart> lst_chart = new List <Chart>(); lst_chart = chartDao.getTotalStatus(""); string str_data = new JavaScriptSerializer().Serialize(lst_chart); return(str_data); }
private string ProcessVisitorsPerMonthList(string year) { try { int[] newVisitorsArr = ChartDAO.GetXXPerMonthList(_context, "No", year); List <Chart> chartList = new List <Chart> { new Chart { data = newVisitorsArr, label = "Visitors" } }; string joinedVisitorsJson = JsonConvert.SerializeObject(chartList); return(joinedVisitorsJson); } catch (Exception e) { return("ProcessVisitorsPerMonthList Exception: " + e.ToString()); } }
private void dataTimeline() { ChartDAO chartDao = new ChartDAO(); List <TimelineEDM> lst_timeline = new List <TimelineEDM>(); lst_timeline = chartDao.getTimelineEDM(); List <string> lst_timeline1 = new List <string>(); List <string> lst_timeline2 = new List <string>(); List <string> lst_timeline3 = new List <string>(); List <string> lst_timeline4 = new List <string>(); List <string> lst_timeline5 = new List <string>(); List <string> lst_timeline6 = new List <string>(); List <string> lst_timeline1_t2 = new List <string>(); List <string> lst_timeline2_t2 = new List <string>(); List <string> lst_timeline3_t2 = new List <string>(); List <string> lst_timeline4_t2 = new List <string>(); List <string> lst_timeline5_t2 = new List <string>(); List <string> lst_timeline6_t2 = new List <string>(); List <string> lst_timeline1_t3 = new List <string>(); List <string> lst_timeline2_t3 = new List <string>(); List <string> lst_timeline3_t3 = new List <string>(); List <string> lst_timeline4_t3 = new List <string>(); List <string> lst_timeline5_t3 = new List <string>(); List <string> lst_timeline6_t3 = new List <string>(); //List<string> lst_timeline1_file_ext = new List<string>(); //List<string> lst_timeline2_file_ext = new List<string>(); //List<string> lst_timeline3_file_ext = new List<string>(); //List<string> lst_timeline4_file_ext = new List<string>(); //List<string> lst_timeline5_file_ext = new List<string>(); //List<string> lst_timeline6_file_ext = new List<string>(); for (int i = 0; i < lst_timeline.Count(); i++) { switch (lst_timeline[i].Timeline) { case "00:00 - 03:59": //lst_timeline1.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline1.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline1_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline1_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; case "04:00 - 07:59": // lst_timeline2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline2_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline2_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; case "08:00 - 11:59": // lst_timeline3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline3_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline3_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; case "12:00 - 15:59": // lst_timeline4.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline4.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline4_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline4_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; case "16:00 - 19:59": // lst_timeline5.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline5.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline5_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline5_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; case "20:00 - 23:59": // lst_timeline6.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); switch (lst_timeline[i].Tier) { case "TIER1": lst_timeline6.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER2": lst_timeline6_t2.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; case "TIER3": lst_timeline6_t3.Add(lst_timeline[i].Group_status + " " + lst_timeline[i].Group_name); break; } break; } //switch (lst_timeline[i].Tier) { // case "TIER1": // break; // case "TIER2": // break; // case "TIER3": // break; //} } lt_timeline_1.Text = timeMore20Row(lst_timeline1).ToString(); lt_timeline_2.Text = timeMore20Row(lst_timeline2).ToString(); lt_timeline_3.Text = timeMore20Row(lst_timeline3).ToString(); lt_timeline_4.Text = timeMore20Row(lst_timeline4).ToString(); lt_timeline_5.Text = timeMore20Row(lst_timeline5).ToString(); lt_timeline_6.Text = timeMore20Row(lst_timeline6).ToString(); lt_timeline_1_tier2.Text = timeMore20Row(lst_timeline1_t2).ToString(); lt_timeline_2_tier2.Text = timeMore20Row(lst_timeline2_t2).ToString(); lt_timeline_3_tier2.Text = timeMore20Row(lst_timeline3_t2).ToString(); lt_timeline_4_tier2.Text = timeMore20Row(lst_timeline4_t2).ToString(); lt_timeline_5_tier2.Text = timeMore20Row(lst_timeline5_t2).ToString(); lt_timeline_6_tier2.Text = timeMore20Row(lst_timeline6_t2).ToString(); lt_timeline_1_tier3.Text = timeMore20Row(lst_timeline1_t3).ToString(); lt_timeline_2_tier3.Text = timeMore20Row(lst_timeline2_t3).ToString(); lt_timeline_3_tier3.Text = timeMore20Row(lst_timeline3_t3).ToString(); lt_timeline_4_tier3.Text = timeMore20Row(lst_timeline4_t3).ToString(); lt_timeline_5_tier3.Text = timeMore20Row(lst_timeline5_t3).ToString(); lt_timeline_6_tier3.Text = timeMore20Row(lst_timeline6_t3).ToString(); }