C#

write the C# windows form based program that allow user conversion of number system

namespace ATAS.Indicators.Technical
{
	using System;
	using System.ComponentModel;
	using System.ComponentModel.DataAnnotations;
	using System.Windows.Media;

	using ATAS.Indicators.Technical.Properties;

	using OFT.Attributes;

	[DisplayName("5.Heiken Ashi Z")]
    [Category("# 1234")]
    public class HeikenAshiz : Indicator
	{
		private readonly CandleDataSeries _candles = new CandleDataSeries("Heiken Ashi Z"){ Visible = true };
		private readonly PaintbarsDataSeries _bars= new PaintbarsDataSeries("Bars Z"){ Visible = false };
		public HeikenAshiz()
		{	
			Panel = IndicatorDataProvider.NewPanel;
			DataSeries[0]= _bars;
			DataSeries.Add(_candles);
		}

		protected override void OnCalculate(int bar, decimal value)
		{
			var candle = GetCandle(bar);
			_bars[bar] = Colors.Transparent;
			if (bar == 0)
			{
				_candles[bar] = new Candle()
				{
					Close = candle.Close,
					High = candle.High,
					Low = candle.Low,
					Open = candle.Open
				};
			}
			else
			{
				var prevCandle = _candles[bar - 1];
				_candles[bar] = new Candle()
				{
					Close = (candle.Open+candle.Close+candle.High+candle.Low)*0.25m,
					High = candle.High,
					Low = candle.Low,
					Open = (prevCandle.Open+ prevCandle.Close)*0.5m,
				};
			}
			
		}
        protected override void OnApplyDefaultColors()
        {
            if (ChartInfo is null)
                return;

            _candles.UpCandleColor = Color.FromRgb(14, 203, 129);
            _candles.DownCandleColor = Color.FromRgb(246, 70, 93);
            _candles.BorderColor = Color.FromRgb(127, 127, 127);
        }
    }
}

void PlotChart()
        {
            try
            {
                // Clear existing series
                chart1.Series.Clear();

                // Create new series
                Series First = new Series("Series11");
                Series Second = new Series("Series12");

                // Set chart type
                First.ChartType = SeriesChartType.Spline;
                Second.ChartType = SeriesChartType.Spline;

                // Set custom colors for each series
                First.Color = Color.Blue; // Set the color for First series
                Second.Color = Color.Orange; // Set the color for Second series


                // Connect to the database and retrieve data
                using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True"))
                {
                    if(connection.State == ConnectionState.Closed)
                    {
                        connection.Open();
                    }
                    

                    // Select only rows where RawDataOrder is equal to label86 text
                    string query = $"SELECT * FROM Data WHERE RawDataOrder = {Convert.ToInt32(label86.Text.Trim())}";
                    using (SqlCommand command = new SqlCommand(query, connection))
                    {
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                // Assuming the first column is 'ID', the second is '11', and the third is '12'
                                int id = reader.GetInt32(0);
                                int value11 = reader.GetInt32(1);
                                int value12 = reader.GetInt32(8);

                                // Add data points to the series
                                First.Points.AddXY(id, value11);
                                Second.Points.AddXY(id, value12);
                            }
                        }
                    }
                }

                // Add the series to the chart
                chart1.Series.Add(First);
                chart1.Series.Add(Second);

                // Set chart title
                chart1.Titles.Clear();
                chart1.Titles.Add(new Title("Channel 1"));

                // Refresh the chart to update the display
                chart1.Update();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error PlotChart", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }