public void SetGraphForCPU(string paramGraph, string serverName)
        {
            DataTable dt     = VSWebBL.ConfiguratorBL.DominoServerDetails_BL.Ins.SetGraphForCPU(paramGraph, serverName);
            Series    series = null;

            if (series == null)
            {
                series                    = new Series("DominoServer", ViewType.Spline);
                series.Visible            = true;
                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
                cpuWebChartControl.Series.Add(series);

                XYDiagram seriesXY = (XYDiagram)cpuWebChartControl.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "StatValue";
                seriesXY.AxisY.Title.Visible = true;

                cpuWebChartControl.Legend.Visible = false;
                //WebChartControl1.Series[0].ValueDataMembers = dt.Columns["StatValue"].ToString();
                cpuWebChartControl.DataSource = dt;
                cpuWebChartControl.DataBind();
            }
            //cpuWebChartControl.DataSource = dt;
            //cpuWebChartControl.DataBind();
        }
Example #2
0
        //6/2/2016 NS added for VSPLUS-3011
        private void SetGraphForMostActiveCommunity()
        {
            MostActiveCommunityChart.Series.Clear();
            ChartTitle title = new ChartTitle();

            title.Text = "Most Active Community";
            System.Drawing.Font font = new System.Drawing.Font(title.Font.FontFamily.Name, 12);
            title.Font = font;
            MostActiveCommunityChart.Titles.Clear();
            MostActiveCommunityChart.Titles.Add(title);
            MostActiveCommunityChart.DataBind();
            DataTable dt = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetMostActiveCommunity(selectedServer);

            if (dt.Rows.Count > 0)
            {
                Series series = new Series("Type", ViewType.Doughnut);

                series.ArgumentDataMember = dt.Columns["Type"].ToString();
                series.LabelsVisibility   = DevExpress.Utils.DefaultBoolean.True;
                DoughnutSeriesLabel label = (DoughnutSeriesLabel)series.Label;
                label.TextPattern        = "{A}: {VP:P0}";
                series.LegendTextPattern = "{A}: {V}";

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["Total"].ToString());
                MostActiveCommunityChart.Series.Add(series);

                title.Text = "Most Active Community is \"" + dt.Rows[0]["Name"].ToString() + "\"";

                MostActiveCommunityChart.Titles.Clear();
                MostActiveCommunityChart.Titles.Add(title);
                MostActiveCommunityChart.DataSource = dt;
                MostActiveCommunityChart.DataBind();
            }
        }
Example #3
0
        //2/13/2015 NS added for VSPLUS-1358
        public void SetGraphForMailDeliverySuccess(string ServerName)
        {
            DeliveryRateWebChart.Series.Clear();

            DataTable dt     = VSWebBL.DashboardBL.ExchangeServerDetailsBL.Ins.SetMailDeliveryRateGraph(ServerName);
            Series    series = null;

            series                    = new Series("MailDelivered", ViewType.Line);
            series.Visible            = true;
            series.DataSource         = dt;
            series.ArgumentDataMember = dt.Columns["Date"].ToString();

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            DeliveryRateWebChart.Series.Add(series);

            ((XYDiagram)DeliveryRateWebChart.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

            DeliveryRateWebChart.SeriesTemplate.ArgumentScaleType = ScaleType.DateTime;
            XYDiagram seriesXY = (XYDiagram)DeliveryRateWebChart.Diagram;

            seriesXY.AxisX.Title.Text    = "Time";
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisY.Title.Text    = "Delivery Rate";
            seriesXY.AxisY.Title.Visible = true;

            ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
            ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

            AxisBase axis = ((XYDiagram)DeliveryRateWebChart.Diagram).AxisX;

            //4/18/2014 NS commented out for VSPLUS-312
            //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
            axis.GridSpacing = 1;
            axis.Range.SideMarginsEnabled = false;

            AxisBase axisy = ((XYDiagram)DeliveryRateWebChart.Diagram).AxisY;

            axisy.Range.AlwaysShowZeroLevel = false;
            axisy.Range.SideMarginsEnabled  = true;
            axisy.GridLines.Visible         = true;
            double min = Convert.ToDouble(((XYDiagram)DeliveryRateWebChart.Diagram).AxisY.Range.MinValue);
            double max = Convert.ToDouble(((XYDiagram)DeliveryRateWebChart.Diagram).AxisY.Range.MaxValue);

            int gs = (int)((max - min) / 5);

            if (gs == 0)
            {
                gs = 1;
                seriesXY.AxisY.GridSpacingAuto = false;
                seriesXY.AxisY.GridSpacing     = gs;
            }
            else
            {
                seriesXY.AxisY.GridSpacingAuto = true;
            }
        }
Example #4
0
        public void SetGraphForMemory(string paramVal, string serverName)
        {
            webChartMemory.Series.Clear();

            DataTable dt = VSWebBL.DashboardBL.QuickrHealthBLL.Ins.SetGraphForMemory(paramVal, serverName);

            if (dt.Rows.Count <= 0)
            {
            }
            else
            {
                Series series = new Series("Memory", ViewType.Line);

                series.Visible = true;

                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());

                webChartMemory.Series.Add(series);

                XYDiagram seriesXY = (XYDiagram)webChartMemory.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "Memory Used";
                seriesXY.AxisY.Title.Visible = true;

                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axisx = ((XYDiagram)webChartMemory.Diagram).AxisX;
                //axisx.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
                axisx.GridSpacingAuto = false;
                axisx.MinorCount      = 15;
                axisx.GridSpacing     = 1;
                //4/18/2014 NS commented out for VSPLUS-312
                //axisx.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                axisx.DateTimeMeasureUnit    = DateTimeMeasurementUnit.Minute;
                axisx.DateTimeOptions.Format = DateTimeFormat.ShortTime;
                //axisx.DateTimeOptions.Format = DateTimeFormat.Custom;
                //axisx.DateTimeOptions.FormatString = "dd/MM HH:mm";
                axisx.Range.SideMarginsEnabled = true;
                axisx.GridLines.Visible        = false;

                AxisBase axisy = ((XYDiagram)webChartMemory.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel     = false;
                axisy.Range.SideMarginsEnabled      = true;
                axisy.GridLines.Visible             = true;
                ((LineSeriesView)series.View).Color = Color.Blue;

                webChartMemory.Legend.Visible = false;

                webChartMemory.DataSource = dt;
                webChartMemory.DataBind();
            }
        }
Example #5
0
        public void SetGraphforMailRouted(string DeviceName)
        {
            MailRoutedWebChartControl.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.MailHealthBL.Ins.SetGraphForMailRouted(DeviceName);

            Series series = null;

            series                    = new Series("DominoServer", ViewType.Line);
            series.Visible            = true;
            series.ArgumentDataMember = dt.Columns["Date"].ToString();

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            MailRoutedWebChartControl.Series.Add(series);

            ((XYDiagram)MailRoutedWebChartControl.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

            XYDiagram seriesXY = (XYDiagram)MailRoutedWebChartControl.Diagram;

            seriesXY.AxisX.Title.Text    = "Time";
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisY.Title.Text    = "Count";
            seriesXY.AxisY.Title.Visible = true;

            MailRoutedWebChartControl.Legend.Visible = false;

            //((SplineSeriesView)series.View).LineTensionPercent = 100;
            ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
            ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

            AxisBase axis = ((XYDiagram)MailRoutedWebChartControl.Diagram).AxisX;

            //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
            axis.GridSpacingAuto = true;
            //axis.MinorCount = 15;
            //axis.GridSpacing = 1;
            axis.Range.SideMarginsEnabled = false;
            axis.GridLines.Visible        = false;
            //4/18/2014 NS commented out for VSPLUS-312
            //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
            axis.DateTimeMeasureUnit    = DateTimeMeasurementUnit.Minute;
            axis.DateTimeOptions.Format = DateTimeFormat.ShortTime;
            //axis.DateTimeOptions.FormatString = "dd/MM HH:mm";
            //((LineSeriesView)series.View).Color = Color.Blue;

            AxisBase axisy = ((XYDiagram)MailRoutedWebChartControl.Diagram).AxisY;

            axisy.Range.AlwaysShowZeroLevel      = false;
            axisy.Range.SideMarginsEnabled       = true;
            axisy.GridLines.Visible              = true;
            MailRoutedWebChartControl.DataSource = dt;
            MailRoutedWebChartControl.DataBind();
        }
Example #6
0
        public void SetGraphForMailTraffic(string serverName)
        {
            MailTraficWebChartControl.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.DashboardBL.Ins.GetMailStatus(serverName);

            Series series = new Series("Mail", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["Mail"].ToString();

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["Value"].ToString());
            MailTraficWebChartControl.Series.Add(series);

            MailTraficWebChartControl.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY = (XYDiagram)MailTraficWebChartControl.Diagram;

            seriesXY.AxisX.Title.Text    = "Mail Status";
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisY.Title.Text    = "Count";
            seriesXY.AxisY.Title.Visible = true;

            MailTraficWebChartControl.DataSource = dt;
            MailTraficWebChartControl.DataBind();

            double min = Convert.ToDouble(((XYDiagram)MailTraficWebChartControl.Diagram).AxisY.Range.MinValue);
            double max = Convert.ToDouble(((XYDiagram)MailTraficWebChartControl.Diagram).AxisY.Range.MaxValue);

            int gs = (int)((max - min) / 5);

            if (gs == 0)
            {
                gs = 1;
                seriesXY.AxisY.GridSpacingAuto = false;
                seriesXY.AxisY.GridSpacing     = gs;
            }
            else
            {
                seriesXY.AxisY.GridSpacingAuto        = true;
                seriesXY.AxisY.Tickmarks.MinorVisible = false;
                seriesXY.AxisY.GridLines.MinorVisible = false;
            }

            AxisBase axisy = ((XYDiagram)MailTraficWebChartControl.Diagram).AxisY;

            axisy.Range.AlwaysShowZeroLevel = false;
            axisy.GridLines.Visible         = true;
        }
        //protected void EXGHeatGridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
        //{
        //    ASPxGridView gridView = (ASPxGridView)sender;
        //    string[] data = e.Parameters.Split(new char[] { '|' });
        //    //DateTime dt1 = System.DateTime.Now;
        //    DateTime dt1 = Convert.ToDateTime("2014-12-12 18:59:41.000");
        //    string fullName = data[1];
        //    var names = fullName.Split(' ');
        //    string firstName = names[0];
        //    string lastName = names[1];
        //    //string sname1 = "JNITTECH-EXCHG1";
        //    //string dname1 = "JNITTECH-EXCHG1";
        //    //DateTime startdate = Convert.ToDateTime("2014-12-10 00:50:52.000");

        //    //SetGraphForLatency(dt1, data[0], lastName);
        //    //fillgraph from MailLatencyDailyStats,[sourceserver]      ,[DestinationServer]      ,[Latency]      ,[Date]
        //    //Date last 24hrs
        //    //string sname = "JNITTECH-EXCHG1";
        //    //string dname = "JNITTECH-EXCHG2";
        //}
        public void SetGraphForLatency(DateTime dt1, string sname, string dname)
        {
            LatencyWebChartControl.Series.Clear();
            //DataTable dt = VSWebBL.DashboardBL.SharepointDetailsBL.Ins.SetGraphForCPUsharepoint(paramGraph, serverName, ServerTypeId);

            DataTable dt = VSWebBL.DashboardBL.ExchangeHeatBL.Ins.SetGraphForLatency(dt1, sname, dname);

            if (dt.Rows.Count > 0)
            {
                Series series = null;
                series                    = new Series("LyncServer", ViewType.Line);
                series.Visible            = true;
                series.ArgumentDataMember = dt.Columns["dtfrom"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["maxval"].ToString());
                LatencyWebChartControl.Series.Add(series);

                ((XYDiagram)LatencyWebChartControl.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                XYDiagram seriesXY = (XYDiagram)LatencyWebChartControl.Diagram;
                seriesXY.AxisY.Title.Text             = "Latency";
                seriesXY.AxisY.Title.Visible          = true;
                seriesXY.AxisX.Title.Text             = "Date/Time";
                seriesXY.AxisX.Title.Visible          = true;
                LatencyWebChartControl.Legend.Visible = false;

                // ((SplineSeriesView)series.View).LineTensionPercent = 100;
                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axis = ((XYDiagram)LatencyWebChartControl.Diagram).AxisX;
                //4/18/2014 NS commented out for VSPLUS-312
                //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                //5/13/2014 NS commented out for VSPLUS-621
                //axis.GridSpacingAuto = false;
                //axis.MinorCount = 15;
                //axis.GridSpacing = 0.5;
                axis.Range.SideMarginsEnabled = false;
                axis.GridLines.Visible        = false;
                //axis.DateTimeOptions.Format = DateTimeFormat.Custom;
                //axis.DateTimeOptions.FormatString = "dd/MM HH:mm";
                ((LineSeriesView)series.View).Color = Color.Blue;

                AxisBase axisy = ((XYDiagram)LatencyWebChartControl.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel   = false;
                axisy.Range.SideMarginsEnabled    = true;
                axisy.GridLines.Visible           = true;
                LatencyWebChartControl.DataSource = dt;
                LatencyWebChartControl.DataBind();
                LatencyWebChartControl.Visible = true;
            }
            //return dt;
        }
Example #8
0
        private void xrChart1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            DataTable dt = new DataTable();

            dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetTravelerHTTPSessions(this.Parameters["TravelerName"].Value.ToString());
            if (dt.Rows.Count > 0)
            {
                xrChart1.DataSource = dt;
            }
            Series series = new Series("HttpSessions", ViewType.Line);

            series.Visible            = true;
            series.ArgumentDataMember = dt.Columns["Date"].ToString();
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;

            xrChart1.Series.Add(series);
            xrChart1.SeriesTemplate.View = new SideBySideBarSeriesView();
            xrChart1.SeriesTemplate.ChangeView(ViewType.Line);
            LineSeriesView view = (LineSeriesView)xrChart1.SeriesTemplate.View;

            view.LineMarkerOptions.Visible = true;
            view.LineMarkerOptions.Size    = 8;
            xrChart1.Legend.Visible        = false;

            XYDiagram seriesXY = (XYDiagram)xrChart1.Diagram;

            seriesXY.AxisX.Title.Text    = "Time";
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            //4/18/2014 NS commented out for VSPLUS-312
            //seriesXY.AxisX.DateTimeGridAlignment = DateTimeMeasurementUnit.Minute;
            seriesXY.AxisX.DateTimeMeasureUnit       = DateTimeMeasurementUnit.Minute;
            seriesXY.AxisX.DateTimeOptions.Format    = DateTimeFormat.ShortTime;
            seriesXY.AxisY.Range.AlwaysShowZeroLevel = false;
            seriesXY.AxisY.Title.Text    = "Sessions";
            seriesXY.AxisY.Title.Visible = true;

            double min = Convert.ToDouble(((XYDiagram)xrChart1.Diagram).AxisY.Range.MinValue);
            double max = Convert.ToDouble(((XYDiagram)xrChart1.Diagram).AxisY.Range.MaxValue);

            int gs = (int)((max - min) / 5);

            if (gs == 0)
            {
                gs = 1;
                seriesXY.AxisY.GridSpacingAuto = false;
                seriesXY.AxisY.GridSpacing     = gs;
            }
        }
Example #9
0
        public DataTable SetGraph(string paramValue, string servername)
        {
            DataTable dt = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraph(paramValue, servername);


            if (series == null)
            {
                series                    = new Series("DominoServer", ViewType.Line);
                series.Visible            = true;
                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
                dominoServerWebChart.Series.Add(series);

                ((XYDiagram)dominoServerWebChart.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                XYDiagram seriesXY = (XYDiagram)dominoServerWebChart.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "Performance";
                seriesXY.AxisY.Title.Visible = true;

                dominoServerWebChart.Legend.Visible = false;

                //((SplineSeriesView)series.View).LineTensionPercent = 100;
                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axis = ((XYDiagram)dominoServerWebChart.Diagram).AxisX;
                //4/18/2014 NS commented out for VSPLUS-312
                //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                axis.GridSpacingAuto          = false;
                axis.MinorCount               = 50;
                axis.GridSpacing              = 5.0;
                axis.Range.SideMarginsEnabled = false;
                axis.GridLines.Visible        = false;
                //axis.DateTimeOptions.Format = DateTimeFormat.Custom;
                //axis.DateTimeOptions.FormatString = "dd/MM HH:mm";

                ((LineSeriesView)series.View).Color = Color.Blue;

                AxisBase axisy = ((XYDiagram)dominoServerWebChart.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel = false;
                axisy.Range.SideMarginsEnabled  = true;
                axisy.GridLines.Visible         = false;
                dominoServerWebChart.DataSource = dt;
                dominoServerWebChart.DataBind();
            }
            return(dt);
        }
Example #10
0
        public void SetBarGraphForItemSizeDatabase(string servername)
        {
            chartItemSizeDatabase.Series.Clear();
            DataTable dt      = VSWebBL.DashboardBL.ExchangeServerDetailsBL.Ins.SetBarGraphForTopMailDatabase(servername, "FileSize");
            Series    series1 = new Series("Mail Server", ViewType.Bar);

            series1.ArgumentDataMember = dt.Columns["Title"].ToString();
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series1.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["ItemCount"].ToString());
            //Addnig series to mailchartbox control
            chartItemSizeDatabase.Series.Add(series1);
            ((XYDiagram)chartItemSizeDatabase.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;
            XYDiagram seriesXY = (XYDiagram)chartItemSizeDatabase.Diagram;

            //X and Y aixs detals
            seriesXY.AxisY.Title.Text    = "Message Count";
            seriesXY.AxisX.Title.Text    = "Mail User";
            seriesXY.AxisY.Title.Visible = true;
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide    = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate  = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowStagger = true;
            //12/11/2013 NS added
            seriesXY.AxisY.Label.ResolveOverlappingOptions.AllowRotate = false;

            //Enabling the series
            chartItemSizeDatabase.Legend.Visible = false;
            ChartTitle title = new ChartTitle();

            if (servername == "All")
            {
                title.Text = "All Servers Top 20 Biggest Message Count";
            }
            else
            {
                title.Text = servername + " Top 20 Biggest Message Count";
            }

            chartItemSizeDatabase.Titles.Clear();
            chartItemSizeDatabase.Titles.Add(title);
            AxisBase axis = ((XYDiagram)chartItemSizeDatabase.Diagram).AxisX;

            ((BarSeriesView)series1.View).ColorEach = false;
            chartItemSizeDatabase.DataSource        = dt;
            chartItemSizeDatabase.DataBind();
        }
Example #11
0
        //1/2/2014 NS added
        public void SetBarGraphForTopQuota(string servername)
        {
            BiggestQuotaWebChart.Series.Clear();
            DataTable dt      = VSWebBL.DashboardBL.DominoServerHealthBLL.Ins.SetBarGraphForTopQuota(servername);
            Series    series1 = new Series("Mail File", ViewType.Bar);

            series1.ArgumentDataMember = dt.Columns["Title"].ToString();
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series1.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["PercentQuota"].ToString());
            //Addnig series to mailchartbox control
            BiggestQuotaWebChart.Series.Add(series1);
            ((XYDiagram)BiggestQuotaWebChart.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;
            XYDiagram seriesXY = (XYDiagram)BiggestQuotaWebChart.Diagram;

            //X and Y aixs detals
            seriesXY.AxisY.Title.Text    = "Percent of Quota";
            seriesXY.AxisX.Title.Text    = "Database Name";
            seriesXY.AxisY.Title.Visible = true;
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide    = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate  = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowStagger = true;
            //12/11/2013 NS added
            seriesXY.AxisY.Label.ResolveOverlappingOptions.AllowRotate = false;

            //Enabling the series
            BiggestQuotaWebChart.Legend.Visible = false;
            ChartTitle title = new ChartTitle();

            if (servername == "All" || servername == "")
            {
                title.Text = "All Servers - Top 20 Largest Mail Files as a % of Quota";
            }
            else
            {
                title.Text = servername + " - Top 20 Largest Mail Files as a % of Quota";
            }

            BiggestQuotaWebChart.Titles.Clear();
            BiggestQuotaWebChart.Titles.Add(title);
            AxisBase axis = ((XYDiagram)BiggestQuotaWebChart.Diagram).AxisX;

            ((BarSeriesView)series1.View).ColorEach = false;
            BiggestQuotaWebChart.DataSource         = dt;
            BiggestQuotaWebChart.DataBind();
        }
Example #12
0
        private void SetGraphForCommunityTypes()
        {
            CommunitiesByTypeChart.Series.Clear();
            string    statname = "COMMUNITY_TYPE_";
            DataTable dt       = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetStatByName(selectedServer, statname, false);
            Series    series   = new Series("StatName", ViewType.Pie);

            series.ArgumentDataMember = dt.Columns["StatName"].ToString();
            series.LabelsVisibility   = DevExpress.Utils.DefaultBoolean.True;
            PieSeriesLabel label = (PieSeriesLabel)series.Label;

            label.TextPattern        = "{A}: {VP:P0}";
            series.LegendTextPattern = "{A}: {V}";

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            CommunitiesByTypeChart.Series.Add(series);

            CommunitiesByTypeChart.DataSource = dt;
            CommunitiesByTypeChart.DataBind();
        }
Example #13
0
        public DataTable SetGraphForPictures()
        {
            PicturesWebChart.Series.Clear();
            DataTable dt     = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetProfileStats("NUM_OF_PROFILES_WITH_NO_PICTURE", "NUM_OF_PROFILES_PROFILES", selectedServer, "No Picture", "Picture", false);
            Series    series = new Series("StatName", ViewType.Doughnut);

            series.ArgumentDataMember = dt.Columns["StatName"].ToString();
            series.LabelsVisibility   = DevExpress.Utils.DefaultBoolean.True;
            DoughnutSeriesLabel label = (DoughnutSeriesLabel)series.Label;

            label.TextPattern        = "{A}: {VP:P0}";
            series.LegendTextPattern = "{A}: {V}";

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            PicturesWebChart.Series.Add(series);

            PicturesWebChart.DataSource = dt;
            PicturesWebChart.DataBind();
            return(dt);
        }
Example #14
0
        public DataTable SetGraphForDeviceType(string servername)
        {
            deviceTypeWebChart.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.LotusTravelerHealthBLL.Ins.SetGraphForDeviceType(servername);


            Series series = new Series("DeviceType", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["DeviceName"].ToString();

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["No_of_Users"].ToString());
            deviceTypeWebChart.Series.Add(series);

            deviceTypeWebChart.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            XYDiagram seriesXY = (XYDiagram)deviceTypeWebChart.Diagram;

            seriesXY.AxisX.Title.Text    = "Device Type";
            seriesXY.AxisX.Title.Visible = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            seriesXY.AxisY.Title.Text    = "Users";
            seriesXY.AxisY.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)deviceTypeWebChart.Diagram).AxisY;

            axisy.Range.AlwaysShowZeroLevel = false;

            deviceTypeWebChart.DataSource = dt;
            deviceTypeWebChart.DataBind();

            return(dt);
        }
Example #15
0
        public void GraphforResponseTime()
        {
            ResponseWebChartControl.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.ActiveDirectoryServerDetailsBL.Ins.GetResponseTime();

            Series series = new Series("usercount", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["Server"].ToString();
            //10/30/2013 NS added - point labels on series
            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["ResponseTime"].ToString());
            ResponseWebChartControl.Series.Add(series);

            ResponseWebChartControl.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY = (XYDiagram)ResponseWebChartControl.Diagram;

            // seriesXY.AxisX.Title.Text = "Milliseconds";
            // seriesXY.AxisX.Title.Visible = true;
            ((DevExpress.XtraCharts.XYDiagram)ResponseWebChartControl.Diagram).Rotated = true;
            //11/16/2013 NS modified the AllowRotate option to false, otherwise the server names were unreadable
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            seriesXY.AxisY.Title.Text    = "Milliseconds";
            seriesXY.AxisY.Title.Visible = true;
            seriesXY.AxisX.Title.Text    = " Servers";
            seriesXY.AxisX.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)ResponseWebChartControl.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;

            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 4)
                {
                    ResponseWebChartControl.Height = 200;
                }
                else
                {
                    if (dt.Rows.Count >= 4 && dt.Rows.Count < 10)
                    {
                        ResponseWebChartControl.Height = ((dt.Rows.Count) * 50) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                        {
                            ResponseWebChartControl.Height = ((dt.Rows.Count) * 40) + 20;
                        }
                        else
                        {
                            if (dt.Rows.Count >= 100)
                            {
                                ResponseWebChartControl.Height = ((dt.Rows.Count) * 20) + 20;
                            }
                        }
                    }
                }
            }
            //ResponseWebChartControl.Width = new Unit(1000);
            ResponseWebChartControl.DataSource = dt;
            ResponseWebChartControl.DataBind();
        }
Example #16
0
        public void GraphForDaysUp(string sortby, string stype)
        {
            ServerUpWebChartControl.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.KeyMetricsBL.Ins.GetServerDaysUp(sortby, stype);

            Series series = new Series("Duration", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["Server"].ToString();
            series.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.General;

            ((SideBySideBarSeriesView)series.View).ColorEach                = true;
            ((SideBySideBarSeriesLabel)series.Label).LineVisible            = true;
            ((SideBySideBarSeriesLabel)series.Label).TextOrientation        = TextOrientation.Horizontal;
            ((SideBySideBarSeriesLabel)series.Label).PointOptions.PointView = PointView.Values;
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["Duration"].ToString());

            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ServerUpWebChartControl.Series.Add(series);
            ServerUpWebChartControl.SeriesTemplate.Label.PointOptions.PointView = PointView.Values;
            ServerUpWebChartControl.SeriesTemplate.LabelsVisibility             = DevExpress.Utils.DefaultBoolean.True;
            ServerUpWebChartControl.Legend.Visible = false;

            XYDiagram seriesXY = (XYDiagram)ServerUpWebChartControl.Diagram;

            ((DevExpress.XtraCharts.XYDiagram)ServerUpWebChartControl.Diagram).Rotated = true;
            //11/16/2013 NS modified the AllowRotate option to false, otherwise the server names were unreadable
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;

            AxisBase axisy = ((XYDiagram)ServerUpWebChartControl.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;

            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 10)
                {
                    if (dt.Rows.Count == 1)
                    {
                        ServerUpWebChartControl.Height = 100;
                    }
                    else
                    {
                        ServerUpWebChartControl.Height = ((dt.Rows.Count) * 60) + 20;
                    }
                }
                else
                {
                    if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                    {
                        ServerUpWebChartControl.Height = ((dt.Rows.Count) * 40) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 100)
                        {
                            //11/18/2013 NS modified - the height needs to be greater than *10
                            //ServerUpWebChartControl.Height = ((dt.Rows.Count) * 10) + 20;
                            ServerUpWebChartControl.Height = ((dt.Rows.Count) * 20) + 20;
                        }
                    }
                }
            }
            ServerUpWebChartControl.DataSource = dt;
            ServerUpWebChartControl.DataBind();
        }
Example #17
0
        public void GraphforResponseTime(string param, string sname, string stype, string UserType)
        {
            CostperUserservedWebChartControl.Series.Clear();
            DataTable dt = new DataTable();

            if (TypeComboBox.Text == "Exchange")
            {
                UserType = UserTypeComboBox.Text;

                dt = VSWebBL.DashboardBL.KeyMetricsBL.Ins.GetCostperuserserveddata(param, sname, stype, UserType);
            }
            else
            {
                dt = VSWebBL.DashboardBL.KeyMetricsBL.Ins.GetCostperuserserveddataForDomino(param, sname, stype);
            }


            for (int i = 0; i < dt.Rows.Count; i++)
            {
                decimal avgusers             = Convert.ToDecimal(dt.Rows[i]["StatValue"].ToString() == "" ? "0" : dt.Rows[i]["StatValue"].ToString());//dt.Rows[i]["MonthlyOperatingCost"]
                decimal MonthlyopeartingCost = Convert.ToDecimal(dt.Rows[i]["MonthlyOperatingCost"].ToString() == "" ? "0" : dt.Rows[i]["MonthlyOperatingCost"].ToString());
                if (avgusers != 0)
                {
                    dt.Rows[i]["StatValue"] = Math.Round((MonthlyopeartingCost / avgusers), 2);
                }
                else
                {
                    dt.Rows[i]["StatValue"] = "0";
                }
            }
            DataView dv = dt.AsDataView();

            if (SortRadioButtonList1.Value.ToString() == "1")
            {
                dv.Sort = "ServerName DESC";
            }
            else
            {
                dv.Sort = "StatValue ASC";
            }

            DataTable sortedDT = dv.ToTable();
            Series    series   = new Series("usercount", ViewType.Bar);

            series.ArgumentDataMember = "servername";
            //10/30/2013 NS added - point labels on series
            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange("StatValue");
            CostperUserservedWebChartControl.Series.Add(series);

            CostperUserservedWebChartControl.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY = (XYDiagram)CostperUserservedWebChartControl.Diagram;

            // seriesXY.AxisX.Title.Text = "Milliseconds";
            // seriesXY.AxisX.Title.Visible = true;
            ((DevExpress.XtraCharts.XYDiagram)CostperUserservedWebChartControl.Diagram).Rotated = true;
            //11/16/2013 NS modified the AllowRotate option to false, otherwise the server names were unreadable
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            seriesXY.AxisY.Title.Text    = "Cost Per User Served";
            seriesXY.AxisY.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)CostperUserservedWebChartControl.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;
            //series.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
            //series.Label.PointOptions.ValueNumericOptions.Precision = 0;
            axisy.Range.AlwaysShowZeroLevel = true;
            seriesXY.AxisY.GridSpacingAuto  = true;
            //double min = Convert.ToDouble(((XYDiagram)CostperUserservedWebChartControl.Diagram).AxisY.Range.MinValue);
            //double max = Convert.ToDouble(((XYDiagram)CostperUserservedWebChartControl.Diagram).AxisY.Range.MaxValue);

            //int gs = (int)((max - min) / 5);

            //if (gs == 0)
            //    gs = 1;

            //((XYDiagram)CostperUserservedWebChartControl.Diagram).AxisY.GridSpacingAuto = false;
            //((XYDiagram)CostperUserservedWebChartControl.Diagram).AxisY.GridSpacing = gs;

            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (sortedDT.Rows.Count > 0)
            {
                if (sortedDT.Rows.Count < 4)
                {
                    CostperUserservedWebChartControl.Height = 200;
                }
                else
                {
                    if (sortedDT.Rows.Count >= 4 && sortedDT.Rows.Count < 10)
                    {
                        CostperUserservedWebChartControl.Height = ((sortedDT.Rows.Count) * 50) + 20;
                    }
                    else
                    {
                        if (sortedDT.Rows.Count >= 10 && sortedDT.Rows.Count < 100)
                        {
                            CostperUserservedWebChartControl.Height = ((sortedDT.Rows.Count) * 40) + 20;
                        }
                        else
                        {
                            if (sortedDT.Rows.Count >= 100)
                            {
                                CostperUserservedWebChartControl.Height = ((sortedDT.Rows.Count) * 20) + 20;
                            }
                        }
                    }
                }
            }


            //10/20/2015 NS modified for VSPLUS-2072
            UI uiobj = new UI();

            uiobj.RecalibrateChartAxes(CostperUserservedWebChartControl.Diagram, "Y", "int", "int");
            CostperUserservedWebChartControl.DataSource = sortedDT;
            CostperUserservedWebChartControl.DataBind();
        }
Example #18
0
        public void GraphForClusterRepDBSizeProblems(string ClusterName)
        {
            DataTable dt2 = VSWebBL.ReportsBL.ReportsBL.Ins.GetDBClusterServers(ClusterName);

            ClusterRepWebChartControl2.Series.Clear();
            DataTable dtraw = VSWebBL.ReportsBL.ReportsBL.Ins.GetDBClusterInfo(ClusterName);
            DataTable dt    = GetThresholdList(dtraw, "DocCountA", "DocCountB", "DocCountC", "DBSizeA", "DBSizeB", "DBSizeC", false);

            if (dt.Rows.Count > 0)
            {
                ClusterRepWebChartControl2.DataSource = dt;
            }
            //ClusterRepWebChartControl.SeriesDataMember = dt.Columns["ServerNameA"].ToString();
            //ClusterRepWebChartControl.SeriesTemplate.ArgumentDataMember = "DatabaseName";
            //ClusterRepWebChartControl.SeriesTemplate.ValueDataMembers.AddRange(new string[] { dt.Columns["DocCountA"].ToString() });

            Series seriesA = new Series("ServerNameA", ViewType.Bar);

            seriesA.DataSource         = dt;
            seriesA.ArgumentDataMember = "DatabaseName";
            ValueDataMemberCollection seriesValueDataMembersA = (ValueDataMemberCollection)seriesA.ValueDataMembers;

            seriesValueDataMembersA.AddRange(dt.Columns["DBSizeA"].ToString());
            seriesA.Visible = true;
            if (dt2.Rows.Count > 0)
            {
                seriesA.Name = dt2.Rows[0]["ServerNameA"].ToString();
            }
            ClusterRepWebChartControl2.Series.Add(seriesA);

            Series seriesB = new Series("ServerNameB", ViewType.Bar);

            seriesB.DataSource         = dt;
            seriesB.ArgumentDataMember = "DatabaseName";
            ValueDataMemberCollection seriesValueDataMembersB = (ValueDataMemberCollection)seriesB.ValueDataMembers;

            seriesValueDataMembersB.AddRange(dt.Columns["DBSizeB"].ToString());
            seriesB.Visible = true;
            if (dt2.Rows.Count > 0)
            {
                seriesB.Name = dt2.Rows[0]["ServerNameB"].ToString();
            }
            ClusterRepWebChartControl2.Series.Add(seriesB);
            if (Session["ServerCName"] != "")
            {
                Series seriesC = new Series("ServerNameC", ViewType.Bar);
                seriesC.DataSource         = dt;
                seriesC.ArgumentDataMember = "DatabaseName";
                ValueDataMemberCollection seriesValueDataMembersC = (ValueDataMemberCollection)seriesC.ValueDataMembers;
                seriesValueDataMembersC.AddRange(dt.Columns["DBSizeC"].ToString());
                seriesC.Visible = true;

                if (dt2.Rows.Count > 0)
                {
                    seriesC.Name = dt2.Rows[0]["ServerNameC"].ToString();
                }
                ClusterRepWebChartControl2.Series.Add(seriesC);
            }
            //10/30/2013 NS added - point labels on series
            //series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ClusterRepWebChartControl2.Legend.Visible = true;

            //((SideBySideBarSeriesView)series.View).ColorEach = true;

            XYDiagram seriesXY = (XYDiagram)ClusterRepWebChartControl2.Diagram;

            // seriesXY.AxisX.Title.Text = "Milliseconds";
            // seriesXY.AxisX.Title.Visible = true;
            ((DevExpress.XtraCharts.XYDiagram)ClusterRepWebChartControl2.Diagram).Rotated = true;
            //11/16/2013 NS modified the AllowRotate option to false, otherwise the server names were unreadable
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            seriesXY.AxisY.Title.Text    = "DB Size (MB)";
            seriesXY.AxisY.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)ClusterRepWebChartControl2.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;
            //9/2/2015 NS commented out for VSPLUS-2117

            /*
             * double min = Convert.ToDouble(((XYDiagram)ClusterRepWebChartControl2.Diagram).AxisY.Range.MinValue);
             * double max = Convert.ToDouble(((XYDiagram)ClusterRepWebChartControl2.Diagram).AxisY.Range.MaxValue);
             *
             * int gs = (int)((max - min) / 5);
             *
             * if (gs == 0)
             * {
             *  gs = 1;
             *  seriesXY.AxisY.GridSpacingAuto = false;
             *  seriesXY.AxisY.GridSpacing = gs;
             * }
             * else
             * {
             *  seriesXY.AxisY.GridSpacingAuto = true;
             * }
             */
            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 4)
                {
                    ClusterRepWebChartControl2.Height = 200;
                }
                else
                {
                    if (dt.Rows.Count >= 4 && dt.Rows.Count < 10)
                    {
                        ClusterRepWebChartControl2.Height = ((dt.Rows.Count) * 50) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                        {
                            ClusterRepWebChartControl2.Height = ((dt.Rows.Count) * 40) + 20;
                        }
                        else
                        {
                            if (dt.Rows.Count >= 100)
                            {
                                //10/13/2015 NS modified
                                //ClusterRepWebChartControl2.Height = ((dt.Rows.Count) * 20) + 20;
                                ClusterRepWebChartControl2.Height = 10000;
                            }
                        }
                    }
                }
            }
            ClusterRepWebChartControl2.DataSource = dt;
            ClusterRepWebChartControl2.DataBind();
        }
        public DataTable SetGraphForDeviceType()
        {
            deviceTypeWebChart.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.Office365BL.Ins.SetGraphDeviceTypes(accountName);

            Series series = new Series("DeviceType", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["DeviceType"].ToString();
            //10/30/2013 NS added - point labels on series
            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["No_of_Users"].ToString());
            deviceTypeWebChart.Series.Add(series);

            deviceTypeWebChart.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY = (XYDiagram)deviceTypeWebChart.Diagram;

            // seriesXY.AxisX.Title.Text = "Milliseconds";
            // seriesXY.AxisX.Title.Visible = true;
            ((DevExpress.XtraCharts.XYDiagram)deviceTypeWebChart.Diagram).Rotated = true;
            //11/16/2013 NS modified the AllowRotate option to false, otherwise the server names were unreadable
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;
            seriesXY.AxisY.Title.Text    = "Users";
            seriesXY.AxisY.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)deviceTypeWebChart.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;
            double min = Convert.ToDouble(((XYDiagram)deviceTypeWebChart.Diagram).AxisY.Range.MinValue);
            double max = Convert.ToDouble(((XYDiagram)deviceTypeWebChart.Diagram).AxisY.Range.MaxValue);

            int gs = (int)((max - min) / 5);

            if (gs == 0)
            {
                gs = 1;
                seriesXY.AxisY.GridSpacingAuto = false;
                seriesXY.AxisY.GridSpacing     = gs;
            }
            else
            {
                seriesXY.AxisY.GridSpacingAuto = true;
            }

            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 4)
                {
                    deviceTypeWebChart.Height = 200;
                }
                else
                {
                    if (dt.Rows.Count >= 4 && dt.Rows.Count < 10)
                    {
                        deviceTypeWebChart.Height = ((dt.Rows.Count) * 50) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                        {
                            deviceTypeWebChart.Height = ((dt.Rows.Count) * 40) + 20;
                        }
                        else
                        {
                            if (dt.Rows.Count >= 100)
                            {
                                deviceTypeWebChart.Height = ((dt.Rows.Count) * 20) + 20;
                            }
                        }
                    }
                }
            }
            //ResponseWebChartControl.Width = new Unit(1000);
            deviceTypeWebChart.DataSource = dt;
            deviceTypeWebChart.DataBind();
            ChartTitle title = new ChartTitle();

            title.Text = "Mobile Devices ";
            deviceTypeWebChart.Titles.Clear();
            deviceTypeWebChart.Titles.Add(title);
            return(dt);
        }
Example #20
0
        public void SetGraphForHttpSessions(string paramValue, string serverName)
        {
            httpSessionsWebChart.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.QuickrHealthBLL.Ins.SetGraphForHttpSessions(paramValue, serverName);

            if (dt.Rows.Count <= 0)
            {
            }
            else
            {
                Series series = new Series("HttpSessions", ViewType.Line);

                series.Visible = true;

                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());

                httpSessionsWebChart.Series.Add(series);

                XYDiagram seriesXY = (XYDiagram)httpSessionsWebChart.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "Value";
                seriesXY.AxisY.Title.Visible = true;

                //1/9/2013 NS commented out constant line for Quickr server since there is no HTTP_MaxConfiguredConnections
                //value anywhere in the Quickr table

                /*
                 * ConstantLine constantLine1 = new ConstantLine("Constant Line 1");
                 * seriesXY.AxisY.ConstantLines.Add(constantLine1);
                 * constantLine1.AxisValue = dt.Rows[0][2].ToString();
                 * constantLine1.Visible = true;
                 * constantLine1.ShowBehind = false;
                 * constantLine1.Title.Visible = true;
                 * constantLine1.Title.Text = "Threshold : " + dt.Rows[0][2].ToString();
                 * constantLine1.Title.TextColor = Color.Red;
                 * constantLine1.Title.Antialiasing = false;
                 * constantLine1.Title.Font = new Font("Tahoma", 10, FontStyle.Regular);
                 * constantLine1.Title.ShowBelowLine = false;
                 * constantLine1.Title.Alignment = ConstantLineTitleAlignment.Near;
                 * constantLine1.Color = Color.Red;
                 * constantLine1.LineStyle.DashStyle = DashStyle.Solid;
                 */
                //constantLine1.LineStyle.Thickness = 2;

                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axisx = ((XYDiagram)httpSessionsWebChart.Diagram).AxisX;
                //axisx.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
                axisx.GridSpacingAuto = false;
                axisx.MinorCount      = 15;
                axisx.GridSpacing     = 1;
                //axisx.DateTimeOptions.Format = DateTimeFormat.Custom;
                //axisx.DateTimeOptions.FormatString = "dd/MM HH:mm";
                if (paramValue == "hh")
                {
                    //4/18/2014 NS commented out for VSPLUS-312
                    //axisx.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                    axisx.DateTimeMeasureUnit    = DateTimeMeasurementUnit.Minute;
                    axisx.DateTimeOptions.Format = DateTimeFormat.ShortTime;
                }
                else
                {
                    //4/18/2014 NS commented out for VSPLUS-312
                    //axisx.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
                    axisx.DateTimeOptions.Format = DateTimeFormat.ShortDate;
                }
                axisx.Range.SideMarginsEnabled = true;
                axisx.GridLines.Visible        = false;

                AxisBase axisy = ((XYDiagram)httpSessionsWebChart.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel     = false;
                axisy.Range.SideMarginsEnabled      = true;
                axisy.GridLines.Visible             = true;
                ((LineSeriesView)series.View).Color = Color.Blue;

                httpSessionsWebChart.Legend.Visible = false;

                httpSessionsWebChart.DataSource = dt;
                httpSessionsWebChart.DataBind();
            }
        }
Example #21
0
        public void SetGraph(string DeviceName, System.DateTime starttime, System.DateTime endtime)
        {
            try
            {
                DBPerformanceWebChartControl.Series.Clear();
                DataTable dt = VSWebBL.DashboardBL.DatabaseHealthBL.Ins.SetGraph(DeviceName, starttime, endtime);

                Series series = null;
                series                    = new Series("DominoServer", ViewType.Line);
                series.Visible            = true;
                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
                DBPerformanceWebChartControl.Series.Add(series);

                // Constant Line

                // Cast the chart's diagram to the XYDiagram type, to access its axes.
                XYDiagram diagram = (XYDiagram)DBPerformanceWebChartControl.Diagram;

                // Create a constant line.
                ConstantLine constantLine1 = new ConstantLine("Constant Line 1");
                diagram.AxisY.ConstantLines.Add(constantLine1);

                // Define its axis value.
                constantLine1.AxisValue = 25000;

                // Customize the behavior of the constant line.
                // constantLine1.Visible = true;
                //constantLine1.ShowInLegend = true;
                // constantLine1.LegendText = "Some Threshold";
                constantLine1.ShowBehind = true;

                // Customize the constant line's title.
                constantLine1.Title.Visible   = true;
                constantLine1.Title.Text      = "Threshold:25000";
                constantLine1.Title.TextColor = Color.Red;
                // constantLine1.Title.Antialiasing = false;
                //constantLine1.Title.Font = new Font("Tahoma", 14, FontStyle.Bold);
                constantLine1.Title.ShowBelowLine = true;
                constantLine1.Title.Alignment     = ConstantLineTitleAlignment.Far;

                // Customize the appearance of the constant line.
                constantLine1.Color = Color.Red;
                constantLine1.LineStyle.DashStyle = DashStyle.Solid;
                constantLine1.LineStyle.Thickness = 4;



                ((XYDiagram)DBPerformanceWebChartControl.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                XYDiagram seriesXY = (XYDiagram)DBPerformanceWebChartControl.Diagram;
                seriesXY.AxisY.Title.Text    = "ResponseTme";
                seriesXY.AxisY.Title.Visible = true;

                DBPerformanceWebChartControl.Legend.Visible = false;

                // ((SplineSeriesView)series.View).LineTensionPercent = 100;
                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axis = ((XYDiagram)DBPerformanceWebChartControl.Diagram).AxisX;
                //4/18/2014 NS commented out for VSPLUS-312
                //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
                axis.GridSpacingAuto                = false;
                axis.MinorCount                     = 15;
                axis.GridSpacing                    = 0.5;
                axis.Range.SideMarginsEnabled       = false;
                axis.GridLines.Visible              = true;
                axis.DateTimeOptions.Format         = DateTimeFormat.Custom;
                axis.DateTimeOptions.FormatString   = "dd/MM HH:mm";
                ((LineSeriesView)series.View).Color = Color.Blue;

                AxisBase axisy = ((XYDiagram)DBPerformanceWebChartControl.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel = false;
                axisy.Range.SideMarginsEnabled  = true;

                DBPerformanceWebChartControl.DataSource = dt;
                DBPerformanceWebChartControl.DataBind();
            }
            catch (Exception ex)
            {
                Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                throw ex;
            }
        }
        public DataTable SetGraph(string paramGraph, string serverName)
        {
            try
            {
                performanceWebChartControl.Series.Clear();
                DataTable dt = VSWebBL.DashboardBL.ExchangeServerDetailsBL.Ins.SetGraphforExchange(paramGraph, serverName, ServerTypeId);

                Series series = null;
                series                    = new Series("ExchangeServer", ViewType.Line);
                series.Visible            = true;
                series.ArgumentDataMember = dt.Columns["dtfrom"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["maxval"].ToString());
                performanceWebChartControl.Series.Add(series);

                // Constant Line

                // Cast the chart's diagram to the XYDiagram type, to access its axes.
                XYDiagram diagram = (XYDiagram)performanceWebChartControl.Diagram;

                // Create a constant line.
                ConstantLine constantLine1 = new ConstantLine("Constant Line 1");
                diagram.AxisY.ConstantLines.Add(constantLine1);

                // Define its axis value.
                constantLine1.AxisValue = 2;

                // Customize the behavior of the constant line.
                // constantLine1.Visible = true;
                //constantLine1.ShowInLegend = true;
                // constantLine1.LegendText = "Some Threshold";
                constantLine1.ShowBehind = true;

                // Customize the constant line's title.
                constantLine1.Title.Visible   = true;
                constantLine1.Title.Text      = "Threshold:2";
                constantLine1.Title.TextColor = Color.Red;
                // constantLine1.Title.Antialiasing = false;
                //constantLine1.Title.Font = new Font("Tahoma", 14, FontStyle.Bold);
                constantLine1.Title.ShowBelowLine = true;
                constantLine1.Title.Alignment     = ConstantLineTitleAlignment.Far;

                // Customize the appearance of the constant line.
                constantLine1.Color = Color.Red;
                constantLine1.LineStyle.DashStyle = DashStyle.Solid;
                constantLine1.LineStyle.Thickness = 2;

                ((XYDiagram)performanceWebChartControl.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                XYDiagram seriesXY = (XYDiagram)performanceWebChartControl.Diagram;
                seriesXY.AxisY.Title.Text    = "Response Time";
                seriesXY.AxisY.Title.Visible = true;
                seriesXY.AxisX.Title.Text    = "Date/Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowStagger = true;

                performanceWebChartControl.Legend.Visible = false;

                // ((SplineSeriesView)series.View).LineTensionPercent = 100;
                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axis = ((XYDiagram)performanceWebChartControl.Diagram).AxisX;
                //4/18/2014 NS commented out for VSPLUS-312
                //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                axis.Range.SideMarginsEnabled = false;
                axis.GridLines.Visible        = false;
                //axis.DateTimeOptions.Format = DateTimeFormat.Custom;
                //axis.DateTimeOptions.FormatString = "MM/dd/yyyy HH:mm";
                ((LineSeriesView)series.View).Color = Color.Blue;

                AxisBase axisy = ((XYDiagram)performanceWebChartControl.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel       = false;
                axisy.Range.SideMarginsEnabled        = true;
                axisy.GridLines.Visible               = true;
                performanceWebChartControl.DataSource = dt;
                performanceWebChartControl.DataBind();

                return(dt);
            }
            catch (Exception ex)
            {
                Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
                throw ex;
            }
        }
        private void IBMConnectionsUserAdoptionOverallXtraRpt_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            DataTable dt         = new DataTable();
            Series    series     = null;
            string    servername = "";

            servername = this.ServerName.Value.ToString();
            dt         = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetTop5MostActiveCommunities(servername);
            string seriesname = "";
            string seriesarg  = "";
            int    seriesval  = -1;

            if (dt.Rows.Count > 0)
            {
                xrChart1.Series.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    seriesarg  = dt.Rows[i]["Name"].ToString();
                    seriesname = dt.Rows[i]["Type"].ToString();
                    seriesval  = Convert.ToInt32(dt.Rows[i]["Total"].ToString());
                    series     = xrChart1.Series[seriesname];
                    if (series == null)
                    {
                        series = new Series(seriesname, ViewType.StackedBar);
                        series.Points.Add(new SeriesPoint(seriesarg, seriesval));
                        series.SeriesPointsSortingKey = SeriesPointKey.Value_1;
                        series.ShowInLegend           = true;
                        series.LabelsVisibility       = DevExpress.Utils.DefaultBoolean.True;
                        xrChart1.Series.Add(series);
                    }
                    else
                    {
                        series.Points.Add(new SeriesPoint(seriesarg, seriesval));
                        series.SeriesPointsSortingKey = SeriesPointKey.Value_1;
                        series.ShowInLegend           = true;
                        series.LabelsVisibility       = DevExpress.Utils.DefaultBoolean.True;
                    }
                }
                UI uiobj = new UI();
                uiobj.RecalibrateChartAxes(xrChart1.Diagram, "Y", "int", "int");
                xrChart1.SeriesSorting = SortingMode.None;
                xrChart1.DataSource    = dt;
            }

            xrChart2.Series.Clear();
            string statname = "COMMUNITY_TYPE_";

            dt     = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetStatByName(servername, statname, false);
            series = new Series("StatName", ViewType.Pie);

            series.ArgumentDataMember = dt.Columns["StatName"].ToString();
            series.LabelsVisibility   = DevExpress.Utils.DefaultBoolean.True;
            PieSeriesLabel label = (PieSeriesLabel)series.Label;

            label.TextPattern        = "{A}: {VP:P0}";
            series.LegendTextPattern = "{A}: {V}";

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());
            xrChart2.Series.Add(series);

            xrChart2.DataSource = dt;

            xrChart3.Series.Clear();
            dt = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetCommunitiesMonthly(servername);
            if (dt.Rows.Count > 0)
            {
                xrChart3.SeriesDataMember = "MName";
                xrChart3.SeriesTemplate.ArgumentDataMember = "MName";
                xrChart3.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "Total" });
                XYDiagram d = (XYDiagram)xrChart3.Diagram;
                d.AxisX.Label.TextPattern = "{A:MMMM, yyyy}";
                xrChart3.DataSource       = dt;
            }

            xrChart4.Series.Clear();
            dt = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetCommunityItemsMonthly(servername);
            if (dt.Rows.Count > 0)
            {
                xrChart4.SeriesDataMember = "MName";
                xrChart4.SeriesTemplate.ArgumentDataMember = "MName";
                xrChart4.SeriesTemplate.ValueDataMembers.AddRange(new string[] { "Total" });
                ((BarSeriesView)xrChart4.SeriesTemplate.View).BarWidth = 0.5;
                XYDiagram d = (XYDiagram)xrChart4.Diagram;
                xrChart4.DataSource = dt;
                UI uiobj = new UI();
                uiobj.RecalibrateChartAxes(xrChart4.Diagram, "Y", "int", "int");
            }

            dt     = new DataTable();
            dt     = VSWebBL.DashboardBL.ConnectionsBL.Ins.GetCommunityItemsMonthlyByType(servername);
            series = null;
            xrChart5.Series.Clear();
            if (dt.Rows.Count > 0)
            {
                seriesname = "";
                seriesarg  = "";
                seriesval  = -1;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    seriesarg  = dt.Rows[i]["MonthYear"].ToString();
                    seriesname = dt.Rows[i]["Type"].ToString();
                    seriesval  = Convert.ToInt32(dt.Rows[i]["Total"].ToString());
                    series     = xrChart5.Series[seriesname];
                    if (series == null)
                    {
                        series = new Series(seriesname, ViewType.StackedBar);
                        series.Points.Add(new SeriesPoint(seriesarg, seriesval));
                        //((StackedBarSeriesView)series.View).BarWidth = 8;
                        series.ShowInLegend     = true;
                        series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
                        xrChart5.Series.Add(series);
                    }
                    else
                    {
                        series.Points.Add(new SeriesPoint(seriesarg, seriesval));
                        series.ShowInLegend     = true;
                        series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
                    }
                }
                if (xrChart5.Series[0].Points.Count > 1)
                {
                    for (int i = 0; i < xrChart5.Series.Count; i++)
                    {
                        series = xrChart5.Series[i];
                        ((StackedBarSeriesView)series.View).BarWidth = 8;
                    }
                }
                xrChart5.DataSource = dt;
            }
        }
Example #24
0
        public void GraphforUsercount(string param, string stype)
        {
            UserCountWebChartControl.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.KeyMetricsBL.Ins.GetUserCount(param, stype);

            Series series = new Series("usercount", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["Server"].ToString();
            series.Label.PointOptions.ValueNumericOptions.Format    = NumericFormat.Number;
            series.Label.PointOptions.ValueNumericOptions.Precision = 0;
            //10/30/2013 NS added - point labels on series
            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;

            ((SideBySideBarSeriesView)series.View).ColorEach                = true;
            ((SideBySideBarSeriesLabel)series.Label).LineVisible            = true;
            ((SideBySideBarSeriesLabel)series.Label).TextOrientation        = TextOrientation.Horizontal;
            ((SideBySideBarSeriesLabel)series.Label).PointOptions.PointView = PointView.Values;
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["UserCount"].ToString());

            UserCountWebChartControl.Series.Add(series);
            UserCountWebChartControl.SeriesTemplate.Label.PointOptions.PointView = PointView.Values;
            UserCountWebChartControl.SeriesTemplate.LabelsVisibility             = DevExpress.Utils.DefaultBoolean.True;
            UserCountWebChartControl.Legend.Visible = false;



            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY = (XYDiagram)UserCountWebChartControl.Diagram;

            // seriesXY.AxisX.Title.Text = "Date and Time";
            //seriesXY.AxisX.Title.Visible = true;
            ((DevExpress.XtraCharts.XYDiagram)UserCountWebChartControl.Diagram).Rotated = true;

            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide   = false;

            // seriesXY.AxisY.Title.Text = "count";
            //seriesXY.AxisY.Title.Visible = true;

            AxisBase axisy = ((XYDiagram)UserCountWebChartControl.Diagram).AxisY;

            //4/18/2014 NS modified for VSPLUS-312
            axisy.Range.AlwaysShowZeroLevel = true;
            seriesXY.AxisY.GridSpacingAuto  = false;
            //10/20/2015 NS modified for VSPLUS-2072
            UI uiobj = new UI();

            uiobj.RecalibrateChartAxes(UserCountWebChartControl.Diagram);
            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 10)
                {
                    if (dt.Rows.Count == 1)
                    {
                        UserCountWebChartControl.Height = 100;
                    }
                    else
                    {
                        UserCountWebChartControl.Height = ((dt.Rows.Count) * 60) + 20;
                    }
                }
                else
                {
                    if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                    {
                        UserCountWebChartControl.Height = ((dt.Rows.Count) * 40) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 100)
                        {
                            UserCountWebChartControl.Height = ((dt.Rows.Count) * 10) + 20;
                        }
                    }
                }
            }
            UserCountWebChartControl.DataSource = dt;
            UserCountWebChartControl.DataBind();
        }
Example #25
0
        //public void FillUserGridFromSession()
        //{
        //    if (Session["Fillgid"] != "" && Session["Fillgid"] != null)
        //    {
        //        UsersGrid.DataSource = (DataTable)Session["Fillgid"];
        //        UsersGrid.DataBind();
        //    }
        //}

        public DataTable SetGraphForHttpSessions(string paramval, string servername)
        {
            httpSessionsWebChart.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.LotusTravelerHealthBLL.Ins.SetGraphForHttpSessions(paramval, servername);

            if (dt.Rows.Count <= 0)
            {
            }
            else
            {
                Series series = new Series("HttpSessions", ViewType.Spline);

                series.Visible = true;

                series.ArgumentDataMember = dt.Columns["Date"].ToString();

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt.Columns["StatValue"].ToString());

                httpSessionsWebChart.Series.Add(series);

                XYDiagram seriesXY = (XYDiagram)httpSessionsWebChart.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "Sessions";
                seriesXY.AxisY.Title.Visible = true;

                ConstantLine constantLine1 = new ConstantLine("Constant Line 1");
                seriesXY.AxisY.ConstantLines.Add(constantLine1);
                constantLine1.AxisValue           = dt.Rows[0][2].ToString();
                constantLine1.Visible             = true;
                constantLine1.ShowBehind          = false;
                constantLine1.Title.Visible       = true;
                constantLine1.Title.Text          = "Threshold : " + dt.Rows[0][2].ToString();
                constantLine1.Title.TextColor     = Color.Red;
                constantLine1.Title.Antialiasing  = false;
                constantLine1.Title.Font          = new Font("Tahoma", 10, FontStyle.Regular);
                constantLine1.Title.ShowBelowLine = false;
                constantLine1.Title.Alignment     = ConstantLineTitleAlignment.Near;
                constantLine1.Color = Color.Red;
                constantLine1.LineStyle.DashStyle = DashStyle.Solid;
                //constantLine1.LineStyle.Thickness = 2;

                ((SplineSeriesView)series.View).LineTensionPercent      = 100;
                ((SplineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                ((SplineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axisx = ((XYDiagram)httpSessionsWebChart.Diagram).AxisX;
                axisx.DateTimeGridAlignment        = DateTimeMeasurementUnit.Day;
                axisx.GridSpacingAuto              = false;
                axisx.MinorCount                   = 15;
                axisx.GridSpacing                  = 0.5;
                axisx.DateTimeOptions.Format       = DateTimeFormat.Custom;
                axisx.DateTimeOptions.FormatString = "dd/MM HH:mm";
                axisx.Range.SideMarginsEnabled     = true;
                axisx.GridLines.Visible            = true;

                AxisBase axisy = ((XYDiagram)httpSessionsWebChart.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel = false;
                axisy.Range.SideMarginsEnabled  = true;

                ((SplineSeriesView)series.View).Color = Color.Blue;

                httpSessionsWebChart.Legend.Visible = false;

                httpSessionsWebChart.DataSource = dt;
                httpSessionsWebChart.DataBind();
            }
            return(dt);
        }
Example #26
0
        public void SetBarGraphForTopMail(string servername)
        {
            double minLavel = 0, maxlevel = 0;

            TopMailChartControl.Series.Clear();
            string    radiovalue1 = "%" + CountorSizeRadioButtonList.SelectedItem.Value.ToString() + "%";
            string    radiovalue2 = "%" + SentorReceivedRadioButtonList.SelectedItem.Value.ToString() + "%";
            DataTable dt          = VSWebBL.DashboardBL.DominoServerHealthBLL.Ins.SetGraphForTopMailUsers(servername, radiovalue1, radiovalue2);

            if (dt.Rows.Count > 0)
            {
                minLavel = Convert.ToDouble(dt.Select("StatValue=min(StatValue)")[0][0]);
                maxlevel = Convert.ToDouble(dt.Select("StatValue=max(StatValue)")[0][0]);
            }
            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                DataRow dr     = dt.Rows[i];
                string  newrow = dt.Rows[i]["StatName"].ToString();
                newrow = newrow.Split('.')[1];
                dt.Rows[i]["StatName"] = newrow;
            }
            Series series1 = new Series("Mail Server", ViewType.Bar);

            series1.ArgumentDataMember     = "StatName";
            TopMailChartControl.DataSource = dt;
            TopMailChartControl.DataBind();
            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series1.ValueDataMembers;

            seriesValueDataMembers.AddRange("StatValue");
            TopMailChartControl.Series.Add(series1);
            series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
            //series1.CrosshairEnabled = DevExpress.Utils.DefaultBoolean.True;
            //series1.CrosshairLabelVisibility = DevExpress.Utils.DefaultBoolean.True;
            //series1.CrosshairLabelPattern = "{A: V}";
            //series1.CrosshairHighlightPoints = DevExpress.Utils.DefaultBoolean.True;

            XYDiagram seriesXY = (XYDiagram)TopMailChartControl.Diagram;

            if (seriesXY != null)
            {
                seriesXY.AxisY.NumericOptions.Format    = NumericFormat.Number;
                seriesXY.AxisY.NumericOptions.Precision = 0;

                seriesXY.AxisY.Title.Visible = true;
                ChartTitle title = new ChartTitle();
                if (servername == "All")
                {
                    title.Text = "All Servers - Top 10  Mail Users";
                }
                else
                {
                    title.Text = servername + " - Top 10  Mail Users";
                }
                TopMailChartControl.Titles.Clear();
                TopMailChartControl.Titles.Add(title);
                //X and Y aixs detals
                //2/5/2016 NS modified for VSPLUS-2562
                UI uiobj = new UI();
                if (CountorSizeRadioButtonList.SelectedItem.Value.ToString() == "Count")
                {
                    seriesXY.AxisY.Title.Text = SentorReceivedRadioButtonList.SelectedItem.Value.ToString() + "  Mail  " + CountorSizeRadioButtonList.SelectedItem.Value.ToString();
                    uiobj.RecalibrateChartAxes(seriesXY, "Y", "int", "int");
                }
                else
                {
                    seriesXY.AxisY.Title.Text = SentorReceivedRadioButtonList.SelectedItem.Value.ToString() + "  Mail  " + CountorSizeRadioButtonList.SelectedItem.Value.ToString() + " (MB)";
                    uiobj.RecalibrateChartAxes(seriesXY, "Y", "double", "double");
                }
            }
            //((XYDiagram)TopMailChartControl.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;
        }
Example #27
0
        public void PopulateCharts()
        {
            string    Name = Session["Type"].ToString();
            DataTable dtUrlResponsetime = VSWebBL.DashboardBL.URLHealthBL.Ins.GetResponseTimeGraphdata(Name);
            DataTable dtUrlAvailability = VSWebBL.DashboardBL.URLHealthBL.Ins.GetAvailabilityGraphdata(Name);

            WebChartControl1.Series.Clear();
            WebChartControl2.Series.Clear();
            ChartTitle ct = new ChartTitle();

            ct.Text = Name;
            if (WebChartControl1.Titles.Count > 0)
            {
                WebChartControl1.Titles.Clear();
            }
            WebChartControl1.Titles.Add(ct);
            if (WebChartControl2.Titles.Count > 0)
            {
                WebChartControl2.Titles.Clear();
            }
            WebChartControl2.Titles.Add(ct);
            Series series = null;

            series = new Series("URL RP Server", ViewType.Line);
            //series = new Series("URL Avail", ViewType.Bar);
            series.Visible            = true;
            series.DataSource         = dtUrlResponsetime;
            series.ArgumentDataMember = dtUrlResponsetime.Columns["Date"].ToString();

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dtUrlResponsetime.Columns["StatValue"].ToString());
            WebChartControl1.Series.Add(series);

            ((XYDiagram)WebChartControl1.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

            XYDiagram seriesXY = (XYDiagram)WebChartControl1.Diagram;

            seriesXY.AxisY.Title.Text       = "Response Time (ms)";
            seriesXY.AxisY.Title.Visible    = true;
            seriesXY.AxisX.Title.Text       = "Time";
            seriesXY.AxisX.Title.Visible    = true;
            WebChartControl1.Legend.Visible = false;

            //((LineSeriesView)series.View).AxisX = 100;
            //((SplineSeriesView)series.View).LineMarkerOptions.Size = 4;
            //((SplineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

            //((LineSeriesView)series.View).LineStyle.Thickness = 1;
            ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
            ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;
            AxisBase axis = ((XYDiagram)WebChartControl1.Diagram).AxisX;

            //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Day;
            // axis.NumericOptions.Format=DevExpress.XtraCharts.NumericFormat.Number;
            axis.GridSpacingAuto = false;
            axis.MinorCount      = 15;
            //axis.GridSpacing = 5;
            axis.Range.SideMarginsEnabled = false;
            axis.GridLines.Visible        = false;

            //axis.DateTimeOptions.Format = DateTimeFormat.Custom;
            //axis.DateTimeOptions.FormatString = "MM/dd HH:MM";

            ((LineSeriesView)series.View).Color = Color.Blue;

            AxisBase axisy = ((XYDiagram)WebChartControl1.Diagram).AxisY;

            axisy.Range.AlwaysShowZeroLevel = false;
            axisy.Range.SideMarginsEnabled  = true;
            axisy.GridLines.Visible         = true;

            Series series1 = null;

            series1                    = new Series("URL Avail", ViewType.Line);
            series1.DataSource         = dtUrlAvailability;
            series1.ArgumentDataMember = dtUrlAvailability.Columns["Date"].ToString();
            series1.Visible            = true;
            ((LineSeriesView)series1.View).LineMarkerOptions.Size  = 8;
            ((LineSeriesView)series1.View).LineMarkerOptions.Color = Color.White;
            ((LineSeriesView)series1.View).Color = Color.Blue;
            ValueDataMemberCollection seriesValueDataMembers1 = (ValueDataMemberCollection)series1.ValueDataMembers;

            seriesValueDataMembers1.AddRange(dtUrlAvailability.Columns["StatValue"].ToString());
            WebChartControl2.Series.Add(series1);

            WebChartControl2.Legend.Visible = false;

            // ((SideBySideBarSeriesView)series1.View).ColorEach = true;

            //AxisBase axisx = ((XYDiagram)deviceTypeWebChart.Diagram).AxisX;

            XYDiagram seriesXY1 = (XYDiagram)WebChartControl2.Diagram;

            // seriesXY.AxisX.Title.Text = "Date and Time";
            //seriesXY.AxisX.Title.Visible = true;
            seriesXY1.AxisX.Label.ResolveOverlappingOptions.AllowRotate = false;
            seriesXY1.AxisY.Title.Text    = "Hourly Up Percent";
            seriesXY1.AxisY.Title.Visible = true;
            seriesXY1.AxisX.Title.Text    = "Time";
            seriesXY1.AxisX.Title.Visible = true;

            //((SideBySideBarSeriesView)series1.View).BarWidth = 5;
            //((SideBySideBarSeriesView)series1.View).BarDistanceFixed = 10;
            AxisBase axisy1 = ((XYDiagram)WebChartControl2.Diagram).AxisY;

            axisy1.GridLines.Visible         = true;
            axisy1.Range.AlwaysShowZeroLevel = false;
            AxisBase axis1 = ((XYDiagram)WebChartControl2.Diagram).AxisX;

            axis1.GridSpacingAuto = false;
            axis1.MinorCount      = 15;
            // axis1.GridSpacing = 5;
            //axis1.DateTimeOptions.FormatString = "MM/dd HH:MM";
            axis1.GridLines.Visible     = false;
            WebChartControl1.DataSource = dtUrlResponsetime;
            WebChartControl1.DataBind();
            WebChartControl2.DataSource = dtUrlAvailability;
            WebChartControl2.DataBind();
            WebChartControl1.Visible = true;
            WebChartControl2.Visible = true;
        }
Example #28
0
        public void SetGraphForMailQueues(string ServerName)
        {
            QueueWebChart.Series.Clear();

            DataTable dt1 = VSWebBL.DashboardBL.ExchangeServerDetailsBL.Ins.SetMailGraph(ServerName);
            DataTable dt2 = dt1.DefaultView.ToTable(true, "SubCategory");


            if (dt2.Rows.Count > 0)
            {
                for (int i = 0; i < dt2.Rows.Count; i++)
                {
                    DataTable finaldt = new DataTable();
                    finaldt = dt1.Clone();
                    //string str = dt2.Rows[i][0].ToString();
                    DataRow[] dr = dt1.Select("SubCategory = '" + dt2.Rows[i][0].ToString() + "'");
                    for (int c = 0; c < dr.Length; c++)
                    {
                        finaldt.NewRow();
                        finaldt.ImportRow(dr[c]);
                    }

                    Series series = new Series(dt2.Rows[i][0].ToString(), ViewType.Line);

                    series.DataSource = finaldt;

                    series.ArgumentDataMember = dt1.Columns["Date"].ToString();

                    QueueWebChart.SeriesTemplate.ArgumentScaleType = ScaleType.DateTime;

                    ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                    seriesValueDataMembers.AddRange(dt1.Columns["StatValue"].ToString());

                    QueueWebChart.Series.Add(series);

                    XYDiagram seriesXY = (XYDiagram)QueueWebChart.Diagram;
                    seriesXY.AxisX.Title.Text    = "Time";
                    seriesXY.AxisX.Title.Visible = true;
                    seriesXY.AxisY.Title.Text    = "Count";
                    seriesXY.AxisY.Title.Visible = true;

                    ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
                    ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                    AxisBase axis = ((XYDiagram)QueueWebChart.Diagram).AxisX;
                    //4/18/2014 NS commented out for VSPLUS-312
                    //axis.DateTimeGridAlignment = DateTimeMeasurementUnit.Hour;
                    axis.GridSpacing = 1;
                    axis.Range.SideMarginsEnabled = false;

                    AxisBase axisy = ((XYDiagram)QueueWebChart.Diagram).AxisY;
                    axisy.Range.AlwaysShowZeroLevel = false;
                    axisy.Range.SideMarginsEnabled  = true;
                    axisy.GridLines.Visible         = true;
                    double min = Convert.ToDouble(((XYDiagram)QueueWebChart.Diagram).AxisY.Range.MinValue);
                    double max = Convert.ToDouble(((XYDiagram)QueueWebChart.Diagram).AxisY.Range.MaxValue);

                    int gs = (int)((max - min) / 5);

                    if (gs == 0)
                    {
                        gs = 1;
                        seriesXY.AxisY.GridSpacingAuto = false;
                        seriesXY.AxisY.GridSpacing     = gs;
                    }
                    else
                    {
                        seriesXY.AxisY.GridSpacingAuto = true;
                    }
                }
            }
            else
            {
                DataTable finaldt = new DataTable();
                finaldt = dt1.Clone();
                Series series = new Series("Series", ViewType.Line);

                series.DataSource = finaldt;

                series.ArgumentDataMember = "Date";

                QueueWebChart.SeriesTemplate.ArgumentScaleType = ScaleType.DateTime;

                ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                seriesValueDataMembers.AddRange(dt1.Columns["StatValue"].ToString());

                QueueWebChart.Series.Add(series);

                XYDiagram seriesXY = (XYDiagram)QueueWebChart.Diagram;
                seriesXY.AxisX.Title.Text    = "Time";
                seriesXY.AxisX.Title.Visible = true;
                seriesXY.AxisY.Title.Text    = "Count";
                seriesXY.AxisY.Title.Visible = true;

                ((LineSeriesView)series.View).LineMarkerOptions.Size  = 8;
                ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                AxisBase axis = ((XYDiagram)QueueWebChart.Diagram).AxisX;

                axis.GridSpacing = 1;
                axis.Range.SideMarginsEnabled = false;

                AxisBase axisy = ((XYDiagram)QueueWebChart.Diagram).AxisY;
                axisy.Range.AlwaysShowZeroLevel = false;
                axisy.Range.SideMarginsEnabled  = true;
                axisy.GridLines.Visible         = true;
                double min = Convert.ToDouble(((XYDiagram)QueueWebChart.Diagram).AxisY.Range.MinValue);
                double max = Convert.ToDouble(((XYDiagram)QueueWebChart.Diagram).AxisY.Range.MaxValue);

                int gs = (int)((max - min) / 5);

                if (gs == 0)
                {
                    gs = 1;
                    seriesXY.AxisY.GridSpacingAuto = false;
                    seriesXY.AxisY.GridSpacing     = gs;
                }
                else
                {
                    seriesXY.AxisY.GridSpacingAuto = true;
                }
            }

            //myText.Antialiasing = true;
            //myText.Text = "There are no visible series to represent in the chart.";
            //myText.TextColor = Color.Black;
        }
Example #29
0
        public void GraphForDownTime()
        {
            SrvDownTimeWebChart.Series.Clear();
            DataTable dt = VSWebBL.DashboardBL.KeyMetricsBL.Ins.GetServerDownTime();

            Series series = new Series("DownMin", ViewType.Bar);

            series.ArgumentDataMember = dt.Columns["Name"].ToString();
            series.LabelsVisibility   = DevExpress.Utils.DefaultBoolean.True;

            ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;

            seriesValueDataMembers.AddRange(dt.Columns["DownMinutes"].ToString());
            SrvDownTimeWebChart.Series.Add(series);

            SrvDownTimeWebChart.Legend.Visible = false;

            ((SideBySideBarSeriesView)series.View).ColorEach = true;

            XYDiagram seriesXY = (XYDiagram)SrvDownTimeWebChart.Diagram;

            ((DevExpress.XtraCharts.XYDiagram)SrvDownTimeWebChart.Diagram).Rotated = true;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate             = false;
            seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide = false;
            seriesXY.AxisY.Title.Text    = "Minutes";
            seriesXY.AxisY.Title.Visible = true;
            AxisBase axisy = ((XYDiagram)SrvDownTimeWebChart.Diagram).AxisY;
            double   min   = Convert.ToDouble(((XYDiagram)SrvDownTimeWebChart.Diagram).AxisY.Range.MinValue);
            double   max   = Convert.ToDouble(((XYDiagram)SrvDownTimeWebChart.Diagram).AxisY.Range.MaxValue);

            int gs = (int)((max - min) / 5);

            if (gs == 0)
            {
                gs = 1;
                seriesXY.AxisY.GridSpacingAuto  = false;
                seriesXY.AxisY.GridSpacing      = gs;
                axisy.Range.AlwaysShowZeroLevel = false;
            }
            else
            {
                seriesXY.AxisY.GridSpacingAuto = true;
            }

            //2/6/2013 NS modified chart height calculations based on the number of rows
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows.Count < 4)
                {
                    SrvDownTimeWebChart.Height = 200;
                }
                else
                {
                    if (dt.Rows.Count >= 4 && dt.Rows.Count < 10)
                    {
                        SrvDownTimeWebChart.Height = ((dt.Rows.Count) * 50) + 20;
                    }
                    else
                    {
                        if (dt.Rows.Count >= 10 && dt.Rows.Count < 100)
                        {
                            SrvDownTimeWebChart.Height = ((dt.Rows.Count) * 40) + 20;
                        }
                        else
                        {
                            if (dt.Rows.Count >= 100)
                            {
                                SrvDownTimeWebChart.Height = ((dt.Rows.Count) * 20) + 20;
                            }
                        }
                    }
                }
            }
            SrvDownTimeWebChart.DataSource = dt;
            SrvDownTimeWebChart.DataBind();
        }
Example #30
0
        protected void monthASPxCombo_SelectedIndexChanged(object sender, EventArgs e)
        {
            hrASPxCombo.SelectedIndex  = 0;
            dayASPxCombo.SelectedIndex = 0;

            DataTable dt1 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraph("mm", "azphxdom1/RPRWyatt");
            DataTable dt2 = null;

            if (monthASPxCombo.SelectedIndex == 1)
            {
                dt2 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraphForMonthCombo("azphxdom1/RPRWyatt", "mm", monthASPxCombo.Value.ToString());
            }
            else if (monthASPxCombo.SelectedIndex == 2)
            {
                dt2 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraphForMonthCombo("azphxdom1/RPRWyatt", "mm", monthASPxCombo.Value.ToString());
            }
            else if (monthASPxCombo.SelectedIndex == 3)
            {
                dt2 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraphForMonthCombo("azphxdom1/RPRWyatt", "mm", monthASPxCombo.Value.ToString());
            }
            else if (monthASPxCombo.SelectedIndex == 4)
            {
                dt2 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraphForMonthCombo("azphxdom1/RPRWyatt", "mm", monthASPxCombo.Value.ToString());
            }
            else
            {
                dt2 = VSWebBL.DashboardBL.DominoServerStatisticsDetailBLL.Ins.SetGraphForMonthCombo("azphxdom1/RPRWyatt", "mm", monthASPxCombo.Value.ToString());
            }

            bool flag = true;

            Series series = null;

            while (flag)
            {
                if (series == null)
                {
                    series            = new Series("series1", ViewType.Line);
                    series.Visible    = true;
                    series.DataSource = dt1;

                    series.ArgumentDataMember = dt1.Columns["Date"].ToString();

                    ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series.ValueDataMembers;
                    seriesValueDataMembers.AddRange(dt1.Columns["StatValue"].ToString());
                    series.CrosshairEnabled = DevExpress.Utils.DefaultBoolean.True;
                    series.View.Color       = Color.Blue;
                    dominoServerWebChart.Series.Add(series);
                    ((XYDiagram)dominoServerWebChart.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                    XYDiagram seriesXY = (XYDiagram)dominoServerWebChart.Diagram;
                    seriesXY.AxisX.Title.Text    = "Time";
                    seriesXY.AxisX.Title.Visible = true;
                    seriesXY.AxisY.Title.Text    = "Performance";
                    seriesXY.AxisY.Title.Visible = true;

                    dominoServerWebChart.Legend.Visible = true;

                    // ((SplineSeriesView)series.View).LineTensionPercent = 100;
                    ((LineSeriesView)series.View).LineMarkerOptions.Size  = 4;
                    ((LineSeriesView)series.View).LineMarkerOptions.Color = Color.White;

                    //PointSeriesLabel label = (PointSeriesLabel)series.Label;
                    //label.LineLength = 12;
                    //label.LineVisible = true;
                    //label.ResolveOverlappingMode = ResolveOverlappingMode.JustifyAllAroundPoint;

                    AxisBase axis2 = ((XYDiagram)dominoServerWebChart.Diagram).AxisX;
                    //4/18/2014 NS commented out for VSPLUS-312
                    //axis2.DateTimeGridAlignment = DateTimeMeasurementUnit.Month;
                    axis2.GridSpacingAuto = false;
                    axis2.MinorCount      = 15;

                    //axis.GridSpacing = 12;
                    axis2.GridSpacing = 0.5;
                    axis2.Range.SideMarginsEnabled     = false;
                    axis2.GridLines.Visible            = true;
                    axis2.DateTimeOptions.Format       = DateTimeFormat.Custom;
                    axis2.DateTimeOptions.FormatString = "dd/MM HH:mm";

                    //((SplineSeriesView)series.View).Color = Color.Blue;

                    AxisBase axisy = ((XYDiagram)dominoServerWebChart.Diagram).AxisY;
                    axisy.Range.AlwaysShowZeroLevel = false;
                    axisy.Range.SideMarginsEnabled  = true;
                }
                else
                {
                    Series series1 = new Series("series2", ViewType.Line);
                    //Series series2 = new Series("s2", ViewType.Spline);
                    series1.Visible            = true;
                    series1.DataSource         = dt2;
                    series1.ArgumentDataMember = dt2.Columns["Date"].ToString();

                    ValueDataMemberCollection seriesValueDataMembers = (ValueDataMemberCollection)series1.ValueDataMembers;
                    seriesValueDataMembers.AddRange(dt2.Columns["StatValue"].ToString());
                    series1.CrosshairEnabled = DevExpress.Utils.DefaultBoolean.True;
                    series1.View.Color       = Color.SeaGreen;
                    dominoServerWebChart.Series.Add(series1);
                    ((XYDiagram)dominoServerWebChart.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal;

                    XYDiagram seriesXY = (XYDiagram)dominoServerWebChart.Diagram;
                    //seriesXY.AxisX.Title.Text = "Time";
                    //seriesXY.AxisX.Title.Visible = true;
                    seriesXY.AxisY.Title.Text    = "Performance";
                    seriesXY.AxisY.Title.Visible = true;

                    dominoServerWebChart.Legend.Visible = false;

                    //((SplineSeriesView)series1.View).LineTensionPercent = 100;
                    ((LineSeriesView)series1.View).LineMarkerOptions.Size  = 4;
                    ((LineSeriesView)series1.View).LineMarkerOptions.Color = Color.White;

                    // ((SplineSeriesView)series1.View).Color = Color.SeaGreen;
                    //PointSeriesLabel label = (PointSeriesLabel)series.Label;
                    //label.LineLength = 12;
                    //label.LineVisible = true;
                    //label.ResolveOverlappingMode = ResolveOverlappingMode.JustifyAllAroundPoint;

                    AxisBase axis2 = ((XYDiagram)dominoServerWebChart.Diagram).AxisX;
                    //4/18/2014 NS commented out for VSPLUS-312
                    //axis2.DateTimeGridAlignment = DateTimeMeasurementUnit.Month;
                    axis2.GridSpacingAuto = false;
                    axis2.MinorCount      = 15;
                    //axis.GridSpacing = 12;
                    axis2.GridSpacing = 0.5;
                    axis2.Range.SideMarginsEnabled     = false;
                    axis2.GridLines.Visible            = true;
                    axis2.DateTimeOptions.Format       = DateTimeFormat.Custom;
                    axis2.DateTimeOptions.FormatString = "dd/MM HH:mm";

                    AxisBase axisy = ((XYDiagram)dominoServerWebChart.Diagram).AxisY;
                    axisy.Range.AlwaysShowZeroLevel = false;
                    axisy.Range.SideMarginsEnabled  = true;

                    //((SplineSeriesView)series.View).Color = Color.;

                    flag = false;
                }
            }
        }