public static AllGraphLoading loadAllGraph() { try { AllGraphLoading list = new AllGraphLoading(); if (dt_CC == null) { dt_CC = new DataTable(); } if (dt_IC == null) { dt_IC = new DataTable(); } if (dt_DC == null) { dt_DC = new DataTable(); } if (obj == null) { obj = new MethodCalling(); } dt_CC = obj.GetComplainsViaCustomer(); if (dt_CC.Rows.Count > 0) { foreach (DataRow row in dt_CC.Rows) { BarChart data = new BarChart(); data.y = Convert.ToInt32(row["ComplainsCount"].ToString()); data.label = row["Customer"].ToString(); list.Top10Chart.Add(data); } } dt_DC = obj.GetComplainDetailsviaDepart(); if (dt_DC.Rows.Count > 0) { foreach (DataRow row in dt_DC.Rows) { BarChart data = new BarChart(); data.y = Convert.ToInt32(row["ComplainCount"].ToString()); data.label = row["AssignDepartment"].ToString(); list.DepartChart.Add(data); } } dt_IC = obj.GetComplainsViaInfra(); if (dt_IC.Rows.Count > 0) { foreach (DataRow row in dt_IC.Rows) { PieChart data = new PieChart(); data.y = Convert.ToInt32(row["ComplainsCount"].ToString()); data.indexLabel = row["Infra"].ToString(); list.InfrPieChart.Add(data); } } return(list); } catch (Exception ex) { throw ex; } }
public static ALLDATA loadAllData() { try { ALLDATA list = new ALLDATA(); if (dt_Lob == null) { dt_Lob = new DataTable(); } if (dt_RG == null) { dt_RG = new DataTable(); } if (dt_MD == null) { dt_MD = new DataTable(); } if (dt_SD == null) { dt_SD = new DataTable(); } if (dt_12 == null) { dt_12 = new DataTable(); } if (obj == null) { obj = new MethodCalling(); } dt_Lob = obj.GetDeploymentViaLOB(); foreach (DataColumn column in dt_Lob.Columns) { BarChart data = new BarChart(); data.y = Convert.ToInt32(dt_Lob.Rows[0][column.ColumnName]); data.label = column.ColumnName; list.BarChart.Add(data); } dt_RG = obj.GetDeploymentViaRegion(); foreach (DataColumn column in dt_RG.Columns) { BarChart data = new BarChart(); data.y = Convert.ToInt32(dt_RG.Rows[0][column.ColumnName]); data.label = column.ColumnName; list.Bar1Chart.Add(data); } dt_SD = obj.GetDeploymentViaService(); foreach (DataRow row in dt_SD.Rows) { PieChart data = new PieChart(); data.y = Convert.ToInt32(row["Count"]); data.legend = row["ServiceUnit"].ToString(); data.indexLabel = row["ServiceUnit"].ToString(); list.PieChart.Add(data); } dt_12 = obj.GetDeployofLast12Months(); foreach (DataRow row in dt_12.Rows) { SplineChart data = new SplineChart(); data.y = Convert.ToInt32(row["Count"]); data.x = row["Period"].ToString(); list.SplineChart.Add(data); } dt_MD = obj.GetDeploymentMainDetails(); foreach (DataColumn column in dt_MD.Columns) { list.Lblstrings.Add(dt_MD.Rows[0][column.ColumnName].ToString()); } return(list); } catch (Exception ex) { throw ex; } }