/// <summary> /// BindChart :Private method used to bind chart based on the parameter /// </summary> /// <param name="chartModule">dotnetCHARTING.Chart</param> /// <param name="query">String Sql Query</param> /// <param name="title">title</param> /// <param name="format">format</param> private void BindChart(dotnetCHARTING.Chart chartModule, string query, string title, string format) { dotnetCHARTING.ChartType myChartType; string strFormat = "%YValue"; //dotnetCHARTING.ChartType myChartType = (dotnetCHARTING.ChartType)Enum.Parse(typeof(dotnetCHARTING.ChartType), Session["ChartType"].ToString(), true); dotnetCHARTING.Scale myAxisScale = (dotnetCHARTING.Scale)Enum.Parse(typeof(dotnetCHARTING.Scale), "Range", true); dotnetCHARTING.SeriesType mySeriesType = (dotnetCHARTING.SeriesType)Enum.Parse(typeof(dotnetCHARTING.SeriesType), "Column", true); dotnetCHARTING.LegendBoxPosition myLegendBoxPosition = dotnetCHARTING.LegendBoxPosition.BottomMiddle; if (Request.QueryString["ChartPalette"] == null && Request.QueryString["ChartType"] == null) { chartModule.PaletteName = customerActivitySheet.GetPaletteName(Session["ChartPalette"].ToString()); myChartType = (dotnetCHARTING.ChartType)Enum.Parse(typeof(dotnetCHARTING.ChartType), Session["ChartType"].ToString(), true); } else { chartModule.PaletteName = customerActivitySheet.GetPaletteName(Request.QueryString["ChartPalette"].ToString()); myChartType = (dotnetCHARTING.ChartType)Enum.Parse(typeof(dotnetCHARTING.ChartType), Request.QueryString["ChartType"].ToString(), true); } //General settings chartModule.DefaultSeries.ConnectionString = Global.ReportsConnectionString.ToString(); chartModule.DefaultSeries.LimitMode = (dotnetCHARTING.LimitMode)Enum.Parse(typeof(dotnetCHARTING.LimitMode), "Top", true); chartModule.DefaultSeries.DefaultElement.ShowValue = true; chartModule.DefaultAxis.NumberPercision = 0; chartModule.Mentor = false; chartModule.TempDirectory = "temp"; chartModule.Visible = true; chartModule.Type = myChartType; chartModule.Height = 210; chartModule.Width = 300; chartModule.UseFile = true; chartModule.Debug = false; chartModule.DonutHoleSize = 50; chartModule.LegendBox.Template = "%icon%name"; chartModule.LegendBox.Position = myLegendBoxPosition; chartModule.Use3D = true; chartModule.Transpose = true; chartModule.DefaultSeries.ShowOther = true; chartModule.DefaultSeries.Type = mySeriesType; chartModule.DefaultAxis.Scale = myAxisScale; chartModule.Series.Name = ""; chartModule.AutoNameLabels = true; chartModule.Title = ""; chartModule.Series.SqlStatement = query; chartModule.SeriesCollection.Add(); chartModule.PrinterOptimizedText = true; chartModule.ChartArea.ClearColors(); chartModule.DefaultSeries.DefaultElement.ShowValue = true; if (format == "$") { strFormat = "$ %YValue"; chartModule.YAxis.NumberPrecision = 0; } else if (format == "%") { strFormat = "%YValue %"; chartModule.YAxis.NumberPrecision = 1; } else chartModule.YAxis.NumberPrecision = 0; chartModule.DefaultSeries.DefaultElement.SmartLabel.Text = strFormat; chartModule.PieLabelMode = dotnetCHARTING.PieLabelMode.Inside; chartModule.DefaultSeries.DefaultElement.Transparency = 10; }
/// <summary> /// BindChart : Method used to bind valus in Chart /// </summary> /// <param name="chartModule">dotnetCHARTING.Chart</param> /// <param name="dtTable">datasource DataTable</param> /// <param name="strColumn">Filter Column </param> private void BindChart(dotnetCHARTING.Chart chartModule, DataTable dtTable, string[] strColumn, bool isexplode) { dotnetCHARTING.ChartType myChartType; dotnetCHARTING.Scale myAxisScale = (dotnetCHARTING.Scale)Enum.Parse(typeof(dotnetCHARTING.Scale), "Normal", true); dotnetCHARTING.SeriesType mySeriesType = (dotnetCHARTING.SeriesType)Enum.Parse(typeof(dotnetCHARTING.SeriesType), "Column", true); dotnetCHARTING.PieLabelMode myPieLabelMode = dotnetCHARTING.PieLabelMode.Outside; dotnetCHARTING.LegendBoxPosition myLegendBoxPosition = dotnetCHARTING.LegendBoxPosition.None; if (Request.QueryString["ChartPalette"] == null && Request.QueryString["ChartType"] == null) { chartModule.PaletteName = customerActivitySheet.GetPaletteName(Session["ChartPalette"].ToString()); myChartType = (dotnetCHARTING.ChartType)Enum.Parse(typeof(dotnetCHARTING.ChartType), Session["ChartType"].ToString(), true); } else { chartModule.PaletteName = customerActivitySheet.GetPaletteName(Request.QueryString["ChartPalette"].ToString()); myChartType = (dotnetCHARTING.ChartType)Enum.Parse(typeof(dotnetCHARTING.ChartType), Request.QueryString["ChartType"].ToString(), true); } //General settings chartModule.DefaultSeries.LimitMode = (dotnetCHARTING.LimitMode)Enum.Parse(typeof(dotnetCHARTING.LimitMode), "Top", true); chartModule.DefaultSeries.DefaultElement.ShowValue = true; chartModule.DefaultAxis.NumberPercision = 0; chartModule.Mentor = false; chartModule.TempDirectory = "temp"; chartModule.Visible = true; chartModule.Type = myChartType; chartModule.Height = 220; chartModule.Width = 600; chartModule.UseFile = true; chartModule.Debug = false; chartModule.DonutHoleSize = 50; chartModule.LegendBox.Template = "%icon%name"; chartModule.LegendBox.Position = myLegendBoxPosition; chartModule.Use3D = true; chartModule.Transpose = true; chartModule.DefaultSeries.ShowOther = true; chartModule.DefaultSeries.Type = mySeriesType; chartModule.DefaultAxis.Scale = myAxisScale; chartModule.PieLabelMode = myPieLabelMode; chartModule.Series.Name = ""; chartModule.AutoNameLabels = true; chartModule.Title = ""; chartModule.Series.Data = dtTable.DefaultView.ToTable(false, strColumn); chartModule.SeriesCollection.Add(); chartModule.PrinterOptimizedText = true; chartModule.ChartArea.ClearColors(); chartModule.DefaultSeries.DefaultElement.ExplodeSlice = isexplode; chartModule.DefaultSeries.DefaultElement.Transparency = 10; chartModule.DefaultSeries.DefaultElement.ShowValue = true; if (isexplode) { chartModule.DefaultSeries.DefaultElement.SmartLabel.Text = "%Name \n %YValue "; chartModule.YAxis.NumberPrecision = 0; } else { chartModule.DefaultSeries.DefaultElement.SmartLabel.Text = "%Name \n %YValue %"; chartModule.YAxis.NumberPrecision = 1; } }