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;
            }
        }