/// <summary> /// Create sales percentage ratio chart for each product in that month. /// </summary> private void SaleRatioChart() { this.salesratiochart.DataBindings.Clear(); this.salesratiochart.SeriesList.Clear(); C1BubbleChartBinding bubbleseries = new C1BubbleChartBinding(); bubbleseries.YField = "SalesRatio"; bubbleseries.YFieldType = ChartDataYFieldType.Number; bubbleseries.XField = "Product"; bubbleseries.Y1Field = "Units"; bubbleseries.XFieldType = ChartDataXFieldType.String; this.salesratiochart.DataBindings.Add(bubbleseries); this.salesratiochart.DataSource = SalesOrderReport.SalesRatio; this.salesratiochart.DataBind(); #region Styles ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); this.salesratiochart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle }); #endregion }
/// <summary> /// Create chart for Existing customer vs New customer /// </summary> private void CreateNewCustomerChart() { C1BarChart1.SeriesList.Clear(); C1BarChart1.DataBindings.Clear(); C1ChartBinding bar = new C1ChartBinding(); bar.XField = "NewProduct"; bar.XFieldType = ChartDataXFieldType.String; bar.YField = "NewCustomer"; bar.YFieldType = ChartDataYFieldType.Number; C1ChartBinding bar1 = new C1ChartBinding(); bar1.XField = "OldProduct"; bar1.XFieldType = ChartDataXFieldType.String; bar1.YField = "OldCustomer"; bar1.YFieldType = ChartDataYFieldType.Number; this.C1BarChart1.Shadow = true; this.C1BarChart1.Axis.X.TextStyle = new ChartStyle { Fill = new ChartStyleFill { Color = Color.BlueViolet } }; this.C1BarChart1.DataBindings.Add(bar); this.C1BarChart1.DataBindings.Add(bar1); this.C1BarChart1.DataSource = SalesOrderReport.CustomerRatio; this.C1BarChart1.DataBind(); this.C1BarChart1.SeriesStyles[0].Fill = new ChartStyleFill { Color = Color.FromName("#ff9900"), Type = ChartStyleFillType.Default }; this.C1BarChart1.ClusterRadius = 12; #region Styles ChartStyleFill chartfill = new ChartStyleFill(); chartfill.Color = Color.Beige; ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); ChartStyle chstyle = new ChartStyle(); chstyle.Fill.Color = Color.FromName("#ff9900"); ChartStyle chstyle1 = new ChartStyle(); chstyle1.Fill.Color = Color.FromName("#ff0000"); #endregion }
/// <summary> /// Create chart showing orderstatus for product /// </summary> private void CreateOrderRatioChart() { this.orderRatioChart.DataBindings.Clear(); C1PieChartBinding pieseries = new C1PieChartBinding(); pieseries.OffsetField = "InOrder"; pieseries.DataField = "Value"; pieseries.LabelField = "Key"; //orderRatioChart.Header.Text = " Monthly Order Ratio"; this.orderRatioChart.DataBindings.Add(pieseries); orderRatioChart.InnerRadius = 20; this.orderRatioChart.DataSource = SalesOrderReport.OrderSatusRatio; this.orderRatioChart.DataBind(); #region Styles ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); ChartStyleFill chartfillstyle2 = new ChartStyleFill(); chartfillstyle2.Type = ChartStyleFillType.Default; chartfillstyle2.Color = Color.FromName("#FFCC66"); ChartStyleFill chartfillstyle3 = new ChartStyleFill(); chartfillstyle3.Type = ChartStyleFillType.Default; chartfillstyle3.Color = Color.FromName("#3399FF"); ChartStyleFill chartfillstyle4 = new ChartStyleFill(); chartfillstyle4.Type = ChartStyleFillType.Default; chartfillstyle4.Color = Color.FromName("#ff6600"); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle2 }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle3 }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle4 }); this.orderRatioChart.SeriesList[2].Offset = 15; #endregion }
/// <summary> /// Create summary data of all products revenue and units sold /// </summary> private void CreateSummary() { //Scale Sales Summary data this.C1RadialGauge1.Value = SalesOrderReport.CategoryRevenue[0].Amount / 1000000; this.C1RadialGauge2.Value = SalesOrderReport.CategoryRevenue[1].Amount / 1000000; this.C1RadialGauge3.Value = SalesOrderReport.CategoryRevenue[2].Amount / 1000000; this.sonysales.Text = ""; this.mssales.Text = ""; this.NVideaSales.Text = ""; this.sonysales.Text = " SONY: " + SalesOrderReport.CategoryRevenue[0].Amount.ToString("C"); this.mssales.Text = "MS: " + SalesOrderReport.CategoryRevenue[1].Amount.ToString("C"); this.NVideaSales.Text = "NVIDEA: " + SalesOrderReport.CategoryRevenue[2].Amount.ToString("C"); // Unit Sold summary C1ChartBinding unitLine = new C1ChartBinding(); unitLine.XField = "Product"; unitLine.YField = "Units"; unitsummarychart.Type = LineChartType.Area; unitsummarychart.ShowChartLabels = false; unitsummarychart.DataBindings.Add(unitLine); unitsummarychart.DataSource = SalesOrderReport.CategoryRevenue; unitsummarychart.DataBind(); unitsummarychart.SeriesList[0].FitType = LineChartFitType.Spline; unitsummarychart.AutoResize = true; #region Styles ChartStyleFill chartfill = new ChartStyleFill(); chartfill.Color = Color.Beige; ChartStyle chstyle = new ChartStyle(); chstyle.Fill.Color = Color.FromName("#ff9900");; chstyle.Fill.Type = ChartStyleFillType.Default; this.unitsummarychart.SeriesStyles.Add(chstyle); #endregion }
/// <summary> /// Create summary data of all products revenue and units sold /// </summary> private void CreateSummary() { //Scale Sales Summary data this.C1RadialGauge1.Value = SalesOrderReport.CategoryRevenue[0].Amount / 1000000; this.C1RadialGauge2.Value = SalesOrderReport.CategoryRevenue[1].Amount / 1000000; this.C1RadialGauge3.Value = SalesOrderReport.CategoryRevenue[2].Amount / 1000000; this.sonysales.Text = ""; this.mssales.Text = ""; this.NVideaSales.Text=""; this.sonysales.Text = " SONY: " + SalesOrderReport.CategoryRevenue[0].Amount.ToString("C"); this.mssales.Text = "MS: " + SalesOrderReport.CategoryRevenue[1].Amount.ToString("C"); this.NVideaSales.Text = "NVIDEA: " +SalesOrderReport.CategoryRevenue[2].Amount.ToString("C"); // Unit Sold summary C1ChartBinding unitLine = new C1ChartBinding(); unitLine.XField = "Product"; unitLine.YField = "Units"; unitsummarychart.Type = LineChartType.Area; unitsummarychart.ShowChartLabels = false; unitsummarychart.DataBindings.Add(unitLine); unitsummarychart.DataSource = SalesOrderReport.CategoryRevenue; unitsummarychart.DataBind(); unitsummarychart.SeriesList[0].FitType = LineChartFitType.Spline; unitsummarychart.AutoResize = true; #region Styles ChartStyleFill chartfill = new ChartStyleFill(); chartfill.Color = Color.Beige; ChartStyle chstyle = new ChartStyle(); chstyle.Fill.Color = Color.FromName("#ff9900"); ; chstyle.Fill.Type = ChartStyleFillType.Default; this.unitsummarychart.SeriesStyles.Add(chstyle); #endregion }
/// <summary> /// Createvenue and unit sold chart for selected product. /// </summary> private void ProductSalesChart() { this.productsaleschart.DataBindings.Clear(); this.productsaleschart.SeriesList.Clear(); this.productsaleschart.YAxes.Clear(); CompositeChartSeries seriesrevenue = new CompositeChartSeries(); seriesrevenue.Data.X.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Day).ToArray()); seriesrevenue.Data.Y.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Amount).ToArray()); seriesrevenue.Type = ChartSeriesType.Bezier; seriesrevenue.Label = "Revenue[In Hundered Thousand]"; seriesrevenue.MarkerStyle.Fill.Color = Color.LightCoral; CompositeChartYAxis y = new CompositeChartYAxis(); y.Text = "Revenue"; y.TextStyle.Fill.Type = ChartStyleFillType.Default; y.AxisStyle.Fill.Type = ChartStyleFillType.Default; CompositeChartYAxis y1 = new CompositeChartYAxis(); y1.Compass = ChartCompass.East; y1.GridMajor.Visible = false; y1.TextStyle.Fill.Type = ChartStyleFillType.Default; y1.AxisStyle.Fill.Type = ChartStyleFillType.Default; y1.Text = "Units"; CompositeChartSeries seriesunit = new CompositeChartSeries(); seriesunit.Data.X.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Day).ToArray()); seriesunit.Data.Y.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Units).ToArray()); seriesunit.Type = ChartSeriesType.Scatter; seriesunit.Label = "Units"; productsaleschart.Axis.X.Text = "Days"; productsaleschart.ShowChartLabels = false; this.productsaleschart.SeriesList.Add(seriesrevenue); this.productsaleschart.SeriesList.Add(seriesunit); this.productsaleschart.Legend.Compass = ChartCompass.North; productsaleschart.YAxes.Add(y); productsaleschart.YAxes.Add(y1); this.productsaleschart.SeriesList[1].YAxis = 1; this.productsaleschart.AutoResize = true; #region Styles ChartStyleFill chartstyle = new ChartStyleFill(); chartstyle.Type = ChartStyleFillType.Default; chartstyle.Color = Color.Beige; ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Color = Color.FromName("#FFCC66"); ChartStyleFill chartfillstyle1 = new ChartStyleFill(); chartfillstyle1.Color = Color.FromName("#FF0000"); chartfillstyle.Type = ChartStyleFillType.Default; this.productsaleschart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle, StrokeWidth = 3, Stroke = Color.FromName("#FF9900") }); this.productsaleschart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle1, Stroke = Color.Red }); #endregion }
/// <summary> /// Create chart showing orderstatus for product /// </summary> private void CreateOrderRatioChart() { this.orderRatioChart.DataBindings.Clear(); C1PieChartBinding pieseries = new C1PieChartBinding(); pieseries.OffsetField = "InOrder"; pieseries.DataField = "Value"; pieseries.LabelField = "Key"; //orderRatioChart.Header.Text = " Monthly Order Ratio"; this.orderRatioChart.DataBindings.Add(pieseries); orderRatioChart.InnerRadius = 20; this.orderRatioChart.DataSource = SalesOrderReport.OrderSatusRatio; this.orderRatioChart.DataBind(); #region Styles ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); ChartStyleFill chartfillstyle2 = new ChartStyleFill(); chartfillstyle2.Type = ChartStyleFillType.Default; chartfillstyle2.Color = Color.FromName("#FFCC66"); ChartStyleFill chartfillstyle3 = new ChartStyleFill(); chartfillstyle3.Type = ChartStyleFillType.Default; chartfillstyle3.Color = Color.FromName("#3399FF"); ChartStyleFill chartfillstyle4 = new ChartStyleFill(); chartfillstyle4.Type = ChartStyleFillType.Default; chartfillstyle4.Color = Color.FromName("#ff6600"); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle2 }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle3 }); this.orderRatioChart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle4 }); this.orderRatioChart.SeriesList[2].Offset = 15; #endregion }
/// <summary> /// Create sales percentage ratio chart for each product in that month. /// </summary> private void SaleRatioChart() { this.salesratiochart.DataBindings.Clear(); this.salesratiochart.SeriesList.Clear(); C1BubbleChartBinding bubbleseries = new C1BubbleChartBinding(); bubbleseries.YField = "SalesRatio"; bubbleseries.YFieldType = ChartDataYFieldType.Number; bubbleseries.XField = "Product"; bubbleseries.Y1Field = "Units"; bubbleseries.XFieldType = ChartDataXFieldType.String; this.salesratiochart.DataBindings.Add(bubbleseries); this.salesratiochart.DataSource = SalesOrderReport.SalesRatio; this.salesratiochart.DataBind(); #region Styles ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); this.salesratiochart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle }); #endregion }
/// <summary> /// Createvenue and unit sold chart for selected product. /// </summary> private void ProductSalesChart() { this.productsaleschart.DataBindings.Clear(); this.productsaleschart.SeriesList.Clear(); this.productsaleschart.YAxes.Clear(); CompositeChartSeries seriesrevenue = new CompositeChartSeries(); seriesrevenue.Data.X.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Day).ToArray()); seriesrevenue.Data.Y.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Amount).ToArray()); seriesrevenue.Type = ChartSeriesType.Bezier; seriesrevenue.Label = "Revenue[In Hundered Thousand]"; seriesrevenue.MarkerStyle.Fill.Color = Color.LightCoral; CompositeChartYAxis y = new CompositeChartYAxis(); y.Text = "Revenue"; y.TextStyle.Fill.Type = ChartStyleFillType.Default; y.AxisStyle.Fill.Type = ChartStyleFillType.Default; CompositeChartYAxis y1 = new CompositeChartYAxis(); y1.Compass = ChartCompass.East; y1.GridMajor.Visible=false; y1.TextStyle.Fill.Type = ChartStyleFillType.Default; y1.AxisStyle.Fill.Type = ChartStyleFillType.Default; y1.Text = "Units"; CompositeChartSeries seriesunit = new CompositeChartSeries(); seriesunit.Data.X.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Day).ToArray()); seriesunit.Data.Y.AddRange(SalesOrderReport.ProductsRevenue.Select(x => x.Units).ToArray()); seriesunit.Type = ChartSeriesType.Scatter; seriesunit.Label = "Units"; productsaleschart.Axis.X.Text = "Days"; productsaleschart.ShowChartLabels = false; this.productsaleschart.SeriesList.Add(seriesrevenue); this.productsaleschart.SeriesList.Add(seriesunit); this.productsaleschart.Legend.Compass = ChartCompass.North; productsaleschart.YAxes.Add(y); productsaleschart.YAxes.Add(y1); this.productsaleschart.SeriesList[1].YAxis = 1; this.productsaleschart.AutoResize = true; #region Styles ChartStyleFill chartstyle = new ChartStyleFill(); chartstyle.Type = ChartStyleFillType.Default; chartstyle.Color = Color.Beige; ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Color = Color.FromName("#FFCC66"); ChartStyleFill chartfillstyle1 = new ChartStyleFill(); chartfillstyle1.Color = Color.FromName("#FF0000"); chartfillstyle.Type = ChartStyleFillType.Default; this.productsaleschart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle, StrokeWidth = 3,Stroke=Color.FromName("#FF9900") }); this.productsaleschart.SeriesStyles.Add(new ChartStyle { Fill = chartfillstyle1,Stroke=Color.Red }); #endregion }
/// <summary> /// Create chart for Existing customer vs New customer /// </summary> private void CreateNewCustomerChart() { C1BarChart1.SeriesList.Clear(); C1BarChart1.DataBindings.Clear(); C1ChartBinding bar = new C1ChartBinding(); bar.XField = "NewProduct"; bar.XFieldType = ChartDataXFieldType.String; bar.YField = "NewCustomer"; bar.YFieldType = ChartDataYFieldType.Number; C1ChartBinding bar1 = new C1ChartBinding(); bar1.XField = "OldProduct"; bar1.XFieldType = ChartDataXFieldType.String; bar1.YField = "OldCustomer"; bar1.YFieldType = ChartDataYFieldType.Number; this.C1BarChart1.Shadow = true; this.C1BarChart1.Axis.X.TextStyle = new ChartStyle { Fill = new ChartStyleFill { Color = Color.BlueViolet } }; this.C1BarChart1.DataBindings.Add(bar); this.C1BarChart1.DataBindings.Add(bar1); this.C1BarChart1.DataSource = SalesOrderReport.CustomerRatio; this.C1BarChart1.DataBind(); this.C1BarChart1.SeriesStyles[0].Fill = new ChartStyleFill { Color = Color.FromName("#ff9900"),Type=ChartStyleFillType.Default }; this.C1BarChart1.ClusterRadius = 12; #region Styles ChartStyleFill chartfill = new ChartStyleFill(); chartfill.Color = Color.Beige; ChartStyleFill chartfillstyle = new ChartStyleFill(); chartfillstyle.Type = ChartStyleFillType.Default; chartfillstyle.Color = Color.FromName("#ff9900"); ChartStyle chstyle = new ChartStyle(); chstyle.Fill.Color = Color.FromName("#ff9900"); ChartStyle chstyle1 = new ChartStyle(); chstyle1.Fill.Color = Color.FromName("#ff0000"); #endregion }