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();
}
//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();
}
}
//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;
}
}
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();
}
}
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();
}
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;
}
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;
}
}
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);
}
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();
}
//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();
}
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();
}
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);
}
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);
}
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();
}
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();
}
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();
}
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);
}
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();
}
}
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;
}
}
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();
}
//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);
}
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;
}
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;
}
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;
}
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();
}
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;
}
}
}
