/// <summary>
        /// Draw the chart according to user selection and display it in the WPFChartViewer.
        /// </summary>
        /// <param name="viewer">The WPFChartViewer object to display the chart.</param>
        private void drawChart(WPFChartViewer viewer)
        {
            // Use InvariantCulture to draw the chart. This ensures the chart will look the
            // same on any computer.
            System.Threading.Thread.CurrentThread.CurrentCulture =
                System.Globalization.CultureInfo.InvariantCulture;

            // In this demo, we just assume we plot up to the latest time. So endDate is now.
            DateTime endDate = DateTime.Now;

            // If the trading day has not yet started (before 9:30am), or if the end date is
            // on on Sat or Sun, we set the end date to 4:00pm of the last trading day
            while ((endDate.TimeOfDay.CompareTo(new TimeSpan(9, 30, 0)) < 0) || (
                       endDate.DayOfWeek == DayOfWeek.Sunday) || (endDate.DayOfWeek ==
                                                                  DayOfWeek.Saturday))
            {
                endDate = endDate.Date.AddDays(-1).Add(new TimeSpan(16, 0, 0));
            }

            // The duration selected by the user
            int durationInDays = int.Parse(((ListItem)timeRange.SelectedItem).Key);

            // Compute the start date by subtracting the duration from the end date.
            DateTime startDate;

            if (durationInDays >= 30)
            {
                // More or equal to 30 days - so we use months as the unit
                startDate = new DateTime(endDate.Year, endDate.Month, 1).AddMonths(
                    -durationInDays / 30);
            }
            else
            {
                // Less than 30 days - use day as the unit. Note that we use trading days
                // below. For less than 30 days, the starting point of the axis is always at
                // the start of the day.
                startDate = endDate.Date;
                for (int i = 1; i < durationInDays; ++i)
                {
                    startDate = startDate.AddDays(
                        (startDate.DayOfWeek == DayOfWeek.Monday) ? -3 : -1);
                }
            }

            // The first moving average period selected by the user.
            int avgPeriod1;

            try { avgPeriod1 = int.Parse(movAvg1.Text); }
            catch { avgPeriod1 = 0; }
            avgPeriod1 = Math.Max(0, Math.Min(300, avgPeriod1));

            // The second moving average period selected by the user.
            int avgPeriod2;

            try { avgPeriod2 = int.Parse(movAvg2.Text); }
            catch { avgPeriod2 = 0; }
            avgPeriod2 = Math.Max(0, Math.Min(300, avgPeriod2));

            // We need extra leading data points in order to compute moving averages.
            int extraPoints = Math.Max(20, Math.Max(avgPeriod1, avgPeriod2));

            // Get the data series to compare with, if any.
            compareKey  = compareWith.Text.Trim();
            compareData = null;
            if (getData(compareKey, startDate, endDate, durationInDays, extraPoints))
            {
                compareData = closeData;
            }

            // The data series we want to get.
            tickerKey = tickerSymbol.Text.Trim();
            if (!getData(tickerKey, startDate, endDate, durationInDays, extraPoints))
            {
                errMsg(viewer, "Please enter a valid ticker symbol");
                return;
            }

            // We now confirm the actual number of extra points (data points that are before
            // the start date) as inferred using actual data from the database.
            extraPoints = timeStamps.Length;
            for (int i = 0; i < timeStamps.Length; ++i)
            {
                if (timeStamps[i] >= startDate)
                {
                    extraPoints = i;
                    break;
                }
            }

            // Check if there is any valid data
            if (extraPoints >= timeStamps.Length)
            {
                // No data - just display the no data message.
                errMsg(viewer, "No data available for the specified time period");
                return;
            }

            // In some finance chart presentation style, even if the data for the latest day
            // is not fully available, the axis for the entire day will still be drawn, where
            // no data will appear near the end of the axis.
            if (resolution < 86400)
            {
                // Add extra points to the axis until it reaches the end of the day. The end
                // of day is assumed to be 4:00pm (it depends on the stock exchange).
                DateTime lastTime            = timeStamps[timeStamps.Length - 1];
                int      extraTrailingPoints = (int)(new TimeSpan(16, 0, 0).Subtract(
                                                         lastTime.TimeOfDay).TotalSeconds / resolution);

                if (extraTrailingPoints > 0)
                {
                    DateTime[] extendedTimeStamps = new DateTime[timeStamps.Length +
                                                                 extraTrailingPoints];
                    Array.Copy(timeStamps, 0, extendedTimeStamps, 0, timeStamps.Length);
                    for (int i = 0; i < extraTrailingPoints; ++i)
                    {
                        extendedTimeStamps[i + timeStamps.Length] = lastTime.AddSeconds(
                            resolution * i);
                    }
                    timeStamps = extendedTimeStamps;
                }
            }

            //
            // At this stage, all data is available. We can draw the chart as according to
            // user input.
            //

            //
            // Determine the chart size. In this demo, user can select 4 different chart
            // sizes. Default is the large chart size.
            //
            int width           = 780;
            int mainHeight      = 255;
            int indicatorHeight = 80;

            string selectedSize = ((ListItem)chartSize.SelectedItem).Key;

            if (selectedSize == "S")
            {
                // Small chart size
                width           = 450;
                mainHeight      = 160;
                indicatorHeight = 60;
            }
            else if (selectedSize == "M")
            {
                // Medium chart size
                width           = 620;
                mainHeight      = 215;
                indicatorHeight = 70;
            }
            else if (selectedSize == "H")
            {
                // Huge chart size
                width           = 1000;
                mainHeight      = 320;
                indicatorHeight = 90;
            }

            // Create the chart object using the selected size
            FinanceChart m = new FinanceChart(width);

            // Set the data into the chart object
            m.setData(timeStamps, highData, lowData, openData, closeData, volData, extraPoints);

            //
            // We configure the title of the chart. In this demo chart design, we put the
            // company name as the top line of the title with left alignment.
            //
            m.addPlotAreaTitle(Chart.TopLeft, tickerKey);

            // We displays the current date as well as the data resolution on the next line.
            string resolutionText = "";

            if (resolution == 30 * 86400)
            {
                resolutionText = "Monthly";
            }
            else if (resolution == 7 * 86400)
            {
                resolutionText = "Weekly";
            }
            else if (resolution == 86400)
            {
                resolutionText = "Daily";
            }
            else if (resolution == 900)
            {
                resolutionText = "15-min";
            }

            m.addPlotAreaTitle(Chart.BottomLeft, "<*font=Arial,size=8*>" + m.formatValue(
                                   DateTime.Now, "mmm dd, yyyy") + " - " + resolutionText + " chart");

            // A copyright message at the bottom left corner the title area
            m.addPlotAreaTitle(Chart.BottomRight,
                               "<*font=arial.ttf,size=8*>(c) Advanced Software Engineering");

            //
            // Add the first techical indicator according. In this demo, we draw the first
            // indicator on top of the main chart.
            //
            addIndicator(m, ((ListItem)indicator1.SelectedItem).Key, indicatorHeight);

            //
            // Add the main chart
            //
            m.addMainChart(mainHeight);

            //
            // Set log or linear scale according to user preference
            //
            m.setLogScale(logScale.IsChecked.GetValueOrDefault());

            //
            // Set axis labels to show data values or percentage change to user preference
            //
            if (percentageScale.IsChecked.GetValueOrDefault())
            {
                m.setPercentageAxis();
            }

            //
            // Draw any price line the user has selected
            //
            string mainType = ((ListItem)chartType.SelectedItem).Key;

            if (mainType == "Close")
            {
                m.addCloseLine(0x000040);
            }
            else if (mainType == "TP")
            {
                m.addTypicalPrice(0x000040);
            }
            else if (mainType == "WC")
            {
                m.addWeightedClose(0x000040);
            }
            else if (mainType == "Median")
            {
                m.addMedianPrice(0x000040);
            }

            //
            // Add comparison line if there is data for comparison
            //
            if ((compareData != null) && (compareData.Length > extraPoints))
            {
                m.addComparison(compareData, 0x0000ff, compareKey);
            }

            //
            // Add moving average lines.
            //
            addMovingAvg(m, ((ListItem)avgType1.SelectedItem).Key, avgPeriod1, 0x663300);
            addMovingAvg(m, ((ListItem)avgType2.SelectedItem).Key, avgPeriod2, 0x9900ff);

            //
            // Draw candlesticks or OHLC symbols if the user has selected them.
            //
            if (mainType == "CandleStick")
            {
                m.addCandleStick(0x33ff33, 0xff3333);
            }
            else if (mainType == "OHLC")
            {
                m.addHLOC(0x008800, 0xcc0000);
            }

            //
            // Add parabolic SAR if necessary
            //
            if (parabolicSAR.IsChecked.GetValueOrDefault())
            {
                m.addParabolicSAR(0.02, 0.02, 0.2, Chart.DiamondShape, 5, 0x008800, 0x000000);
            }

            //
            // Add price band/channel/envelop to the chart according to user selection
            //
            string selectedBand = ((ListItem)priceBand.SelectedItem).Key;

            if (selectedBand == "BB")
            {
                m.addBollingerBand(20, 2, 0x9999ff, unchecked ((int)(0xc06666ff)));
            }
            else if (selectedBand == "DC")
            {
                m.addDonchianChannel(20, 0x9999ff, unchecked ((int)(0xc06666ff)));
            }
            else if (selectedBand == "Envelop")
            {
                m.addEnvelop(20, 0.1, 0x9999ff, unchecked ((int)(0xc06666ff)));
            }

            //
            // Add volume bars to the main chart if necessary
            //
            if (volumeBars.IsChecked.GetValueOrDefault())
            {
                m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
            }

            //
            // Add additional indicators as according to user selection.
            //
            addIndicator(m, ((ListItem)indicator2.SelectedItem).Key, indicatorHeight);
            addIndicator(m, ((ListItem)indicator3.SelectedItem).Key, indicatorHeight);
            addIndicator(m, ((ListItem)indicator4.SelectedItem).Key, indicatorHeight);

            //
            // output the chart
            //
            viewer.Chart = m;

            //
            // tooltips for the chart
            //
            viewer.ImageMap = m.getHTMLImageMap("", "", "title='" + m.getToolTipDateFormat()
                                                + " {value|P}'");
        }
        /// <summary>
        /// Create a financial chart according to user selections. The user selections are
        /// encoded in the query parameters.
        /// </summary>
        public BaseChart drawChart()
        {
            // In this demo, we just assume we plot up to the latest time. So end date is now.
            DateTime endDate = DateTime.Now;

            // If the trading day has not yet started (before 9:30am), or if the end date is on on Sat or
            // Sun, we set the end date to 4:00pm of the last trading day
            while ((endDate.TimeOfDay.CompareTo(new TimeSpan(9, 30, 0)) < 0) || (endDate.DayOfWeek ==
                                                                                 DayOfWeek.Sunday) || (endDate.DayOfWeek == DayOfWeek.Saturday))
            {
                endDate = endDate.Date.AddDays(-1).Add(new TimeSpan(16, 0, 0));
            }

            // The duration selected by the user
            int durationInDays = int.Parse(Request["TimeRange"]);

            // Compute the start date by subtracting the duration from the end date.
            DateTime startDate = endDate;

            if (durationInDays >= 30)
            {
                // More or equal to 30 days - so we use months as the unit
                startDate = new DateTime(endDate.Year, endDate.Month, 1).AddMonths(-durationInDays / 30);
            }
            else
            {
                // Less than 30 days - use day as the unit. The starting point of the axis is always at
                // the start of the day (9:30am). Note that we use trading days, so we skip Sat and Sun
                // in counting the days.
                startDate = endDate.Date;
                for (int i = 1; i < durationInDays; ++i)
                {
                    if (startDate.DayOfWeek == DayOfWeek.Monday)
                    {
                        startDate = startDate.AddDays(-3);
                    }
                    else
                    {
                        startDate = startDate.AddDays(-1);
                    }
                }
            }

            // The moving average periods selected by the user.
            int avgPeriod1 = 0;

            try { avgPeriod1 = int.Parse(Request["movAvg1"]);; }
            catch { avgPeriod1 = 0;; }
            int avgPeriod2 = 0;

            try { avgPeriod2 = int.Parse(Request["movAvg2"]);; }
            catch { avgPeriod2 = 0;; }

            if (avgPeriod1 < 0)
            {
                avgPeriod1 = 0;
            }
            else if (avgPeriod1 > 300)
            {
                avgPeriod1 = 300;
            }

            if (avgPeriod2 < 0)
            {
                avgPeriod2 = 0;
            }
            else if (avgPeriod2 > 300)
            {
                avgPeriod2 = 300;
            }

            // We need extra leading data points in order to compute moving averages.
            int extraPoints = 20;

            if (avgPeriod1 > extraPoints)
            {
                extraPoints = avgPeriod1;
            }
            if (avgPeriod2 > extraPoints)
            {
                extraPoints = avgPeriod2;
            }

            // Get the data series to compare with, if any.
            string compareKey = Request["CompareWith"].Trim();

            compareData = null;
            if (getData(compareKey, startDate, endDate, durationInDays, extraPoints))
            {
                compareData = closeData;
            }

            // The data series we want to get.
            string tickerKey = Request["TickerSymbol"].Trim();

            if (!getData(tickerKey, startDate, endDate, durationInDays, extraPoints))
            {
                return(errMsg("Please enter a valid ticker symbol"));
            }

            // We now confirm the actual number of extra points (data points that are before the start
            // date) as inferred using actual data from the database.
            extraPoints = timeStamps.Length;
            for (int i = 0; i < timeStamps.Length; ++i)
            {
                if (timeStamps[i] >= startDate)
                {
                    extraPoints = i;
                    break;
                }
            }

            // Check if there is any valid data
            if (extraPoints >= timeStamps.Length)
            {
                // No data - just display the no data message.
                return(errMsg("No data available for the specified time period"));
            }

            // In some finance chart presentation style, even if the data for the latest day is not fully
            // available, the axis for the entire day will still be drawn, where no data will appear near
            // the end of the axis.
            if (resolution < 86400)
            {
                // Add extra points to the axis until it reaches the end of the day. The end of day is
                // assumed to be 16:00 (it depends on the stock exchange).
                DateTime lastTime            = timeStamps[timeStamps.Length - 1];
                int      extraTrailingPoints = (int)(new TimeSpan(16, 0, 0).Subtract(lastTime.TimeOfDay
                                                                                     ).TotalSeconds / resolution);
                if (extraTrailingPoints > 0)
                {
                    DateTime[] extendedTimeStamps = new DateTime[timeStamps.Length + extraTrailingPoints
                                                    ];
                    Array.Copy(timeStamps, 0, extendedTimeStamps, 0, timeStamps.Length);
                    for (int i = 0; i < extraTrailingPoints; ++i)
                    {
                        extendedTimeStamps[i + timeStamps.Length] = lastTime.AddSeconds(resolution * (i +
                                                                                                      1));
                    }
                    timeStamps = extendedTimeStamps;
                }
            }

            //
            // At this stage, all data are available. We can draw the chart as according to user input.
            //

            //
            // Determine the chart size. In this demo, user can select 4 different chart sizes. Default
            // is the large chart size.
            //
            int width           = 780;
            int mainHeight      = 255;
            int indicatorHeight = 80;

            string size = Request["ChartSize"];

            if (size == "S")
            {
                // Small chart size
                width           = 450;
                mainHeight      = 160;
                indicatorHeight = 60;
            }
            else if (size == "M")
            {
                // Medium chart size
                width           = 620;
                mainHeight      = 215;
                indicatorHeight = 70;
            }
            else if (size == "H")
            {
                // Huge chart size
                width           = 1000;
                mainHeight      = 320;
                indicatorHeight = 90;
            }

            // Create the chart object using the selected size
            FinanceChart m = new FinanceChart(width);

            // Set the data into the chart object
            m.setData(timeStamps, highData, lowData, openData, closeData, volData, extraPoints);

            //
            // We configure the title of the chart. In this demo chart design, we put the company name as
            // the top line of the title with left alignment.
            //
            m.addPlotAreaTitle(Chart.TopLeft, tickerKey);

            // We displays the current date as well as the data resolution on the next line.
            string resolutionText = "";

            if (resolution == 30 * 86400)
            {
                resolutionText = "Monthly";
            }
            else if (resolution == 7 * 86400)
            {
                resolutionText = "Weekly";
            }
            else if (resolution == 86400)
            {
                resolutionText = "Daily";
            }
            else if (resolution == 900)
            {
                resolutionText = "15-min";
            }

            m.addPlotAreaTitle(Chart.BottomLeft, "<*font=Arial,size=8*>" + m.formatValue(DateTime.Now,
                                                                                         "mmm dd, yyyy") + " - " + resolutionText + " chart");

            // A copyright message at the bottom left corner the title area
            m.addPlotAreaTitle(Chart.BottomRight,
                               "<*font=Arial,size=8*>(c) Advanced Software Engineering");

            //
            // Add the first techical indicator according. In this demo, we draw the first indicator on
            // top of the main chart.
            //
            addIndicator(m, Request["Indicator1"], indicatorHeight);

            //
            // Add the main chart
            //
            m.addMainChart(mainHeight);

            //
            // Set log or linear scale according to user preference
            //
            if (Request["LogScale"] == "1")
            {
                m.setLogScale(true);
            }

            //
            // Set axis labels to show data values or percentage change to user preference
            //
            if (Request["PercentageScale"] == "1")
            {
                m.setPercentageAxis();
            }

            //
            // Draw any price line the user has selected
            //
            string mainType = Request["ChartType"];

            if (mainType == "Close")
            {
                m.addCloseLine(0x000040);
            }
            else if (mainType == "TP")
            {
                m.addTypicalPrice(0x000040);
            }
            else if (mainType == "WC")
            {
                m.addWeightedClose(0x000040);
            }
            else if (mainType == "Median")
            {
                m.addMedianPrice(0x000040);
            }

            //
            // Add comparison line if there is data for comparison
            //
            if (compareData != null)
            {
                if (compareData.Length > extraPoints)
                {
                    m.addComparison(compareData, 0x0000ff, compareKey);
                }
            }

            //
            // Add moving average lines.
            //
            addMovingAvg(m, Request["avgType1"], avgPeriod1, 0x663300);
            addMovingAvg(m, Request["avgType2"], avgPeriod2, 0x9900ff);

            //
            // Draw candlesticks or OHLC symbols if the user has selected them.
            //
            if (mainType == "CandleStick")
            {
                m.addCandleStick(0x33ff33, 0xff3333);
            }
            else if (mainType == "OHLC")
            {
                m.addHLOC(0x008800, 0xcc0000);
            }

            //
            // Add parabolic SAR if necessary
            //
            if (Request["ParabolicSAR"] == "1")
            {
                m.addParabolicSAR(0.02, 0.02, 0.2, Chart.DiamondShape, 5, 0x008800, 0x000000);
            }

            //
            // Add price band/channel/envelop to the chart according to user selection
            //
            string bandType = Request["Band"];

            if (bandType == "BB")
            {
                m.addBollingerBand(20, 2, 0x9999ff, unchecked ((int)0xc06666ff));
            }
            else if (bandType == "DC")
            {
                m.addDonchianChannel(20, 0x9999ff, unchecked ((int)0xc06666ff));
            }
            else if (bandType == "Envelop")
            {
                m.addEnvelop(20, 0.1, 0x9999ff, unchecked ((int)0xc06666ff));
            }

            //
            // Add volume bars to the main chart if necessary
            //
            if (Request["Volume"] == "1")
            {
                m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
            }

            //
            // Add additional indicators as according to user selection.
            //
            addIndicator(m, Request["Indicator2"], indicatorHeight);
            addIndicator(m, Request["Indicator3"], indicatorHeight);
            addIndicator(m, Request["Indicator4"], indicatorHeight);

            return(m);
        }