using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ChartDirector;
using System.Data;


public partial class TradingSys_FinanceChartDetails : System.Web.UI.Page
{
    First.CnQry Co = new First.CnQry();
    System.Data.DataSet ds = new System.Data.DataSet();
    System.Data.DataSet ds2 = new System.Data.DataSet();
    string sql;
   
    string msg = "";
    List<DateTime> timeStampsx = new List<DateTime>();
    List<double> highDatax = new List<double>();
    List<double> lowDatax = new List<double>();
    List<double> openDatax = new List<double>();
    List<double> closeDatax = new List<double>();
    List<double> volDatax = new List<double>();
    DateTime res;

    DateTime[] timeStamps = null ;
    double[] volData = null;
    double[] highData = null;
    double[] lowData = null;
    double[] openData = null;
    double[] closeData = null;


    public string cntyN="Saudi Arabia";
    public string mxdt = DateTime.Now.ToString("dddd, MMMM dd, yyyy");
    int TK_ID=2;
    // An extra data series to compare with the close data
    double[] compareData = null;

    // The resolution of the data in seconds. 1 day = 86400 seconds.
    int resolution = 86400 ;

    /// <summary>
    /// Get the timeStamps, highData, lowData, openData, closeData and volData.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    /// <param name="durationInDays">The number of trading days to get.</param>
    /// <param name="extraPoints">The extra leading data points needed in order to
    /// compute moving averages.</param>
    /// <returns>True if successfully obtain the data, otherwise false.</returns>
    protected bool getData(string ticker, DateTime startDate, DateTime endDate,int durationInDays, int extraPoints)
    {
        // This method should return false if the ticker symbol is invalid. In this
        // sample code, as we are using a random number generator for the data, all
        // ticker symbol is allowed, but we still assumed an empty symbol is invalid.
        if (ticker == "")
        {
            return false;
        }

        // In this demo, we can get 15 min, daily, weekly or monthly data depending on
        // the time range.
        resolution = 86400;
        if (durationInDays <= 10)
        {
            // 10 days or less, we assume 15 minute data points are available
            resolution = 900;

            // We need to adjust the startDate backwards for the extraPoints. We assume
            // 6.5 hours trading time per day, and 5 trading days per week.
            double dataPointsPerDay = 6.5 * 3600 / resolution;
            DateTime adjustedStartDate = startDate.AddDays(-Math.Ceiling(extraPoints /
                dataPointsPerDay * 7 / 5) - 2);

            // Get the required 15 min data
            get15MinData(ticker, adjustedStartDate, endDate);

        }
        else if (durationInDays >= 4.5 * 360)
        {
            // 4 years or more - use monthly data points.
            resolution = 30 * 86400;

            // Adjust startDate backwards to cater for extraPoints
            DateTime adjustedStartDate = startDate.Date.AddMonths(-extraPoints);

            // Get the required monthly data
            //getMonthlyData(ticker, adjustedStartDate, endDate);

            if (frequency.SelectedItem.Text == "Daily")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
            }
            else if (frequency.SelectedItem.Text == "Weekly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToWeeklyData();
            }
            else if (frequency.SelectedItem.Text == "Monthly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToMonthlyData();
            }
            else { getDailyData(ticker, adjustedStartDate, endDate); convertDailyToYearlyData(); }

        }
        else if (durationInDays >= 1.5 * 360)
        {
            // 1 year or more - use weekly points.
            resolution = 7 * 86400;

            // Adjust startDate backwards to cater for extraPoints
            DateTime adjustedStartDate = startDate.Date.AddDays(-extraPoints * 7 - 6);

            // Get the required weekly data
            //getWeeklyData(ticker, adjustedStartDate, endDate);

            if (frequency.SelectedItem.Text == "Daily")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
            }
            else if (frequency.SelectedItem.Text == "Weekly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToWeeklyData();
            }
            else if (frequency.SelectedItem.Text == "Monthly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToMonthlyData();
            }
            else { getDailyData(ticker, adjustedStartDate, endDate); convertDailyToYearlyData(); }

        }
        else
        {
            // Default - use daily points
            resolution = 86400;

            // Adjust startDate backwards to cater for extraPoints. We multiply the days
            // by 7/5 as we assume 1 week has 5 trading days.
            DateTime adjustedStartDate = startDate.Date.AddDays(-Math.Ceiling(extraPoints
                 * 7.0 / 5) - 2);

            // Get the required daily data

            if (frequency.SelectedItem.Text == "Daily")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
            }
            else if (frequency.SelectedItem.Text == "Weekly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToWeeklyData();
            }
            else if (frequency.SelectedItem.Text == "Monthly")
            {
                getDailyData(ticker, adjustedStartDate, endDate);
                convertDailyToMonthlyData();
            }
            else { getDailyData(ticker, adjustedStartDate, endDate); convertDailyToYearlyData(); }
            
        }

        return true;
    }

    /// <summary>
    /// Get 15 minutes data series for timeStamps, highData, lowData, openData, closeData
    /// and volData.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    protected void get15MinData(string ticker, DateTime startDate, DateTime endDate)
    {
        //
        // In this demo, we use a random number generator to generate the data. In
        // practice, you may get the data from a database or by other means. If you do
        // not have 15 minute data, you may modify the "drawChart" method below to not
        // using 15 minute data.
        //
        generateRandomData(ticker, startDate, endDate, 900);
    }

    /// <summary>
    /// Get daily data series for timeStamps, highData, lowData, openData, closeData
    /// and volData.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    protected void getDailyData(string ticker, DateTime startDate, DateTime endDate)
    {
        //
        // In this demo, we use a random number generator to generate the data. In
        // practice, you may get the data from a database or by other means.
        //
        // A typical database code example is like below. (This only shows a general
        // idea. The exact details may differ depending on your database brand and
        // schema. The SQL, in particular the date format, may be different depending on
        // which brand of database you use.)
        //
        //    // Open the database connection to MS SQL
        //    System.Data.IDbConnection dbconn = new System.Data.SqlClient.SqlConnection(
        //          "..... put your database connection string here .......");
        //   dbconn.Open();
        //
        //   // SQL statement to get the data
        //   System.Data.IDbCommand sqlCmd = dbconn.CreateCommand();
        //   sqlCmd.CommandText = "Select recordDate, highData, lowData, openData, " +
        //         "closeData, volData From dailyFinanceTable Where ticker = '" + ticker +
        //         "' And recordDate >= '" + startDate.ToString("yyyyMMdd") + "' And " +
        //         "recordDate <= '" + endDate.ToString("yyyyMMdd") + "' Order By recordDate";
        //
        //   // The most convenient way to read the SQL result into arrays is to use the
        //   // ChartDirector DBTable utility.
        //   DBTable table = new DBTable(sqlCmd.ExecuteReader());
        //   dbconn.Close();
        //
        //   // Now get the data into arrays
        //   timeStamps = table.getColAsDateTime(0);
        //   highData = table.getCol(1);
        //   lowData = table.getCol(2);
        //   openData = table.getCol(3);
        //   closeData = table.getCol(4);
        //   volData = table.getCol(5);
        //
        generateRandomData(ticker, startDate, endDate, 86400);
    }

    /// <summary>
    /// Get weekly data series for timeStamps, highData, lowData, openData, closeData
    /// and volData.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    protected void getWeeklyData(string ticker, DateTime startDate, DateTime endDate)
    {
        //
        // If you do not have weekly data, you may call "getDailyData(startDate,
        // endDate)" to get daily data, then call "convertDailyToWeeklyData()" to convert
        // to weekly data.
        //
        generateRandomData(ticker, startDate, endDate, 86400*7);
    }

    /// <summary>
    /// Get monthly data series for timeStamps, highData, lowData, openData, closeData
    /// and volData.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    protected void getMonthlyData(string ticker, DateTime startDate, DateTime endDate)
    {
        //
        // If you do not have weekly data, you may call "getDailyData(startDate,
        // endDate)" to get daily data, then call "convertDailyToMonthlyData()" to
        // convert to monthly data.
        //
        generateRandomData(ticker, startDate, endDate, 86400 * 30);
    }

    /// <summary>
    /// A random number generator designed to generate realistic financial data.
    /// </summary>
    /// <param name="ticker">The ticker symbol for the data series.</param>
    /// <param name="startDate">The starting date/time for the data series.</param>
    /// <param name="endDate">The ending date/time for the data series.</param>
    /// <param name="resolution">The period of the data series.</param>
    protected void generateRandomData(string ticker, DateTime startDate,DateTime endDate, int resolution)
    {
        sql = "SELECT  dbo.Price_Data.TK, dbo.Price_Data.NM, dbo.Prices.dt, dbo.Prices.OP, dbo.Prices.CL, dbo.Prices.HI, dbo.Prices.LO, dbo.Prices.VOL,                       dbo.Prices.PD_TK_ID FROM         dbo.Price_Data INNER JOIN                       dbo.Prices ON dbo.Price_Data.TK_ID = dbo.Prices.PD_TK_ID WHERE     (dbo.Price_Data.TK = '" + ticker + "') AND dt between '" + startDate.ToString("yyyy/MM/dd") + "' and '" + endDate.ToString("yyyy/MM/dd") + "'  ORDER BY dbo.Prices.dt  ";
        ds = Co.Select(sql, "Chart", 102);
        int x = ds.Tables["Chart"].Rows.Count;
       
        for (int i = 0; i < x + (x/20); i++)
        {
           
            if (i < x)
            {
                
                DateTime.TryParse(ds.Tables["Chart"].Rows[i]["dt"].ToString(), out res);

                timeStampsx.Add(res);
                highDatax.Add(Convert.ToDouble(ds.Tables["Chart"].Rows[i]["hi"]));
                lowDatax.Add(Convert.ToDouble(ds.Tables["Chart"].Rows[i]["lo"]));
                openDatax.Add(Convert.ToDouble(ds.Tables["Chart"].Rows[i]["op"]));
                closeDatax.Add(Convert.ToDouble(ds.Tables["Chart"].Rows[i]["cl"]));
                volDatax.Add(Convert.ToDouble(ds.Tables["Chart"].Rows[i]["vol"]));
            }
            else
            {
                timeStampsx.Add(res.AddDays(1));
            }

        }
        
         timeStamps = timeStampsx.ToArray();
        highData = highDatax.ToArray();
       lowData = lowDatax.ToArray();
        openData = openDatax.ToArray();
        closeData = closeDatax.ToArray();
         volData = volDatax.ToArray();

         //FinanceSimulator db = new FinanceSimulator(ticker, startDate, endDate, resolution);

         //timeStamps1 = db.getTimeStamps();
         //highData1 = db.getHighData();
         //lowData1 = db.getLowData();
         //openData1 = db.getOpenData();
         //closeData1 = db.getCloseData();
         //volData1 = db.getVolData();
    }

    /// <summary>
    /// A utility to convert daily to weekly data.
    /// </summary>
    protected void convertDailyToWeeklyData()
    {
        aggregateData(new ArrayMath(timeStamps).selectStartOfWeek());
    }

    /// <summary>
    /// A utility to convert daily to monthly data.
    /// </summary>
    protected void convertDailyToMonthlyData()
    {
        aggregateData(new ArrayMath(timeStamps).selectStartOfMonth());
        
    }

    protected void convertDailyToYearlyData()
    {
        aggregateData(new ArrayMath(timeStamps).selectStartOfYear());

    }

    /// <summary>
    /// An internal method used to aggregate daily data.
    /// </summary>
    protected void aggregateData(ArrayMath aggregator)
    {
        timeStamps = Chart.NTime(aggregator.aggregate(Chart.CTime(timeStamps),
            Chart.AggregateFirst));
        highData = aggregator.aggregate(highData, Chart.AggregateMax);
        lowData = aggregator.aggregate(lowData, Chart.AggregateMin);
        openData = aggregator.aggregate(openData, Chart.AggregateFirst);
        closeData = aggregator.aggregate(closeData, Chart.AggregateLast);
        volData = aggregator.aggregate(volData, Chart.AggregateSum);
    }

    /// <summary>
    /// Create a financial chart according to user selections. The user selections are
    /// encoded in the query parameters.
    /// </summary>
    public void drawChart(WebChartViewer viewer)
    {
        // In this demo, we just assume we plot up to the latest time. So end date is
        // now.
        string sqld = "select max(dt) from  dbo.Prices";
        ds = Co.Select(sqld, "Chartd", 102);
        DateTime.TryParse(ds.Tables["Chartd"].Rows[0][0].ToString(), out res);
        DateTime endDate = res;

        // 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(viewer.GetCustomAttr("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(viewer.GetCustomAttr("movAvg1")); }
        catch { avgPeriod1 = 0; ; }
        int avgPeriod2 = 0;
        try { avgPeriod2 = int.Parse(viewer.GetCustomAttr("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 = CompareWith.Text.Trim();
        //compareData = null;
        //if (getData(compareKey, startDate, endDate, durationInDays, extraPoints))
        //{
        //    compareData = closeData;
        //}

        
        // The data series we want to get.
        string tickerKey="";
        if (name.Text != "")
        {
            sql = "SELECT    dbo.Price_Data.TK FROM         dbo.Price_Data  where dbo.Price_Data.NM='" + name.Text + "'";
            ds = Co.Select(sql, "NMTic", 102);
            string NMTic = ds.Tables["NMTic"].Rows[0][0].ToString();
            TickerSymbol.Text = NMTic.Trim();
            name.Text = "";

            
        }
        initViewer(WebChartViewer1);
        tickerKey = viewer.GetCustomAttr("TickerSymbol").Trim();
        
        if (!getData(tickerKey, startDate, endDate, durationInDays, extraPoints))
        {
            viewer.Image = errMsg("Please enter a valid ticker symbol").makeWebImage(Chart.PNG);
            viewer.ChartModel = null;
            return;
        }

        string sql4 = "SELECT    dbo.Price_Data.NM FROM         dbo.Price_Data  where dbo.Price_Data.TK='" + tickerKey + "'";
        ds = Co.Select(sql4, "NM", 102);
        string NM2 = ds.Tables["NM"].Rows[0][0].ToString();
        ticksymbol.Text = "(" + tickerKey + ") " + NM2;
        //name.Text = NM2;
        // 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.
            viewer.Image = errMsg("No data available for the specified time period").makeWebImage(Chart.PNG);
            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 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 = 320;
        int indicatorHeight = 110;

        string Size = viewer.GetCustomAttr("ChartSize");
        if (Size == "S")
        {
            // Small chart size
            width = 450;
            mainHeight = 160;
            indicatorHeight = 60;
        }
        else if (Size == "M")
        {
            // Medium chart size
            width = 620;
            mainHeight = 280;
            indicatorHeight = 90;
        }
        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);

        // Disable default legend box, as we are using dynamic legend
        m.setLegendStyle("normal", 8, Chart.Transparent, Chart.Transparent);

        // 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) SSE");

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

        //
        // Set log or linear scale according to user preference
        //
        //if (LogScale.Checked)
        //{
        //    m.setLogScale(true);
        //}

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

        //
        // Draw any price line the user has selected
        //
        string mainType = viewer.GetCustomAttr("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, viewer.GetCustomAttr("avgType1"), avgPeriod1, 0x663300);
        addMovingAvg(m, viewer.GetCustomAttr("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
        //

        string upperindicator = viewer.GetCustomAttr("upperind");
        if (upperindicator == "para")
        {
            m.addParabolicSAR(0.02, 0.02, 0.2, Chart.DiamondShape, 5, 0x008800, 0x000000);
        }
        else if (upperindicator == "vol")
        {
            m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
        }
        else if (upperindicator == "log")
        {
            m.setLogScale(true);
        }
        else if (upperindicator == "percent")
        {
            m.setPercentageAxis();
        }
       

        //if (ParabolicSAR.Checked)
        //{
        //    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 = viewer.GetCustomAttr("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));
        }

        
        //if (Volume.Checked)
        //{
        //    m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
        //}


        //msg += "Start Date = " + startDate.ToString() + "\\n";
        //msg += "End Date = " + endDate.ToString() + "\\n";
        //msg += "timeStamps[0] = " + timeStamps[0].ToString() + "\\n";
        //msg += "timeStamps[timeStamps.Length - 1] = " + timeStamps[timeStamps.Length - 1].ToString() + "\\n";
        //msg += "timeStamps.Length = " + timeStamps.Length + "\\n";
        //msg += "extraPoints: " + extraPoints + "\\n";

        //msg += "No data available for the specified time period";
        //Label1.Text = msg;

        //if (frequency.SelectedItem.Text == "Weekly")
        //{
        //    getDailyData(tickerKey,startDate, endDate);
        //    convertDailyToWeeklyData();
        //}
        //else if (frequency.SelectedItem.Text == "Monthly")
        //{
        //    convertDailyToMonthlyData();
        //}

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

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

        // Output the chart
        viewer.Image = m.makeWebImage(Chart.PNG);

        // Output Javascript chart model to the browser to suppport tracking cursor
        viewer.ChartModel = m.getJsChartModel();
    }

    public void initViewer(WebChartViewer viewer)
    {
        viewer.SetCustomAttr("TickerSymbol", TickerSymbol.Text);
        //viewer.SetCustomAttr("CompareWith", CompareWith.Text);
        viewer.SetCustomAttr("TimeRange", TimeRange.SelectedItem.Value);
        viewer.SetCustomAttr("ChartSize", ChartSize.SelectedItem.Value);
        viewer.SetCustomAttr("upperind", upperind.SelectedItem.Value);

        //viewer.SetCustomAttr("Volume", Volume.Checked ? 1 : 0);
        //viewer.SetCustomAttr("LogScale", LogScale.Checked ? 1 : 0);
        //viewer.SetCustomAttr("PercentageScale", PercentageScale.Checked ? 1 : 0);
        //viewer.SetCustomAttr("ParabolicSAR", ParabolicSAR.Checked ? 1 : 0);
        viewer.SetCustomAttr("ChartType", ChartType.SelectedItem.Value);
        viewer.SetCustomAttr("Band", Band.SelectedItem.Value);
        viewer.SetCustomAttr("avgType1", avgType1.SelectedItem.Value);
        viewer.SetCustomAttr("avgType2", avgType2.SelectedItem.Value);
        viewer.SetCustomAttr("movAvg1", movAvg1.Text);
        viewer.SetCustomAttr("movAvg2", movAvg2.Text);
        viewer.SetCustomAttr("Indicator1", Indicator1.SelectedItem.Text);
        viewer.SetCustomAttr("Indicator2", Indicator2.SelectedItem.Text);
        viewer.SetCustomAttr("Indicator3", Indicator3.SelectedItem.Text);
        viewer.SetCustomAttr("Indicator4", Indicator4.SelectedItem.Text);
    }


    /// <summary>
    /// Add a moving average line to the FinanceChart object.
    /// </summary>
    /// <param name="m">The FinanceChart object to add the line to.</param>
    /// <param name="avgType">The moving average type (SMA/EMA/TMA/WMA).</param>
    /// <param name="avgPeriod">The moving average period.</param>
    /// <param name="color">The color of the line.</param>
    /// <returns>The LineLayer object representing line layer created.</returns>
    protected LineLayer addMovingAvg(FinanceChart m, string avgType, int avgPeriod,int color)
    {
        if (avgPeriod > 1)
        {
            if (avgType == "SMA")
            {
                return m.addSimpleMovingAvg(avgPeriod, color);
            }
            else if (avgType == "EMA")
            {
                return m.addExpMovingAvg(avgPeriod, color);
            }
            else if (avgType == "TMA")
            {
                return m.addTriMovingAvg(avgPeriod, color);
            }
            else if (avgType == "WMA")
            {
                return m.addWeightedMovingAvg(avgPeriod, color);
            }
        }
        return null;
    }

    /// <summary>
    /// Add an indicator chart to the FinanceChart object. In this demo example, the
    /// indicator parameters (such as the period used to compute RSI, colors of the lines,
    /// etc.) are hard coded to commonly used values. You are welcome to design a more
    /// complex user interface to allow users to set the parameters.
    /// </summary>
    /// <param name="m">The FinanceChart object to add the line to.</param>
    /// <param name="indicator">The selected indicator.</param>
    /// <param name="height">Height of the chart in pixels</param>
    /// <returns>The XYChart object representing indicator chart.</returns>
    protected XYChart addIndicator(FinanceChart m, string indicator, int height)
    {
        if (indicator == "RSI")
        {
            return m.addRSI(height, 14, 0x800080, 20, 0xff6666, 0x6666ff);
        }
        else if (indicator == "StochRSI")
        {
            return m.addStochRSI(height, 14, 0x800080, 30, 0xff6666, 0x6666ff);
        }
        else if (indicator == "MACD")
        {
            return m.addMACD(height, 26, 12, 9, 0x0000ff, 0xff00ff, 0x008000);
        }
        else if (indicator == "Fast Stochastic")
        {
            return m.addFastStochastic(height, 14, 3, 0x006060, 0x606000);
        }
        else if (indicator == "Slow Stochastic")
        {
            return m.addSlowStochastic(height, 14, 3, 0x006060, 0x606000);
        }
        else if (indicator == "Avg True Range")
        {
            return m.addATR(height, 14, 0x808080, 0x0000ff);
        }
        else if (indicator == "Avg Directional Index")
        {
            return m.addADX(height, 14, 0x008000, 0x800000, 0x000080);
        }
        else if (indicator == "Donchian Channel Width")
        {
            return m.addDonchianWidth(height, 20, 0x0000ff);
        }
        else if (indicator == "Bollinger Band Width")
        {
            return m.addBollingerWidth(height, 20, 2, 0x0000ff);
        }
        else if (indicator == "Detrended Price Osc")
        {
            return m.addDPO(height, 20, 0x0000ff);
        }
        else if (indicator == "Price Volume Trend")
        {
            return m.addPVT(height, 0x0000ff);
        }
        else if (indicator == "Momentum")
        {
            return m.addMomentum(height, 12, 0x0000ff);
        }
        else if (indicator == "Performance")
        {
            return m.addPerformance(height, 0x0000ff);
        }
        else if (indicator == "Rate of Change")
        {
            return m.addROC(height, 12, 0x0000ff);
        }
        else if (indicator == "On Balance Volume")
        {
            return m.addOBV(height, 0x0000ff);
        }
        else if (indicator == "Accumulation/Distribution")
        {
            return m.addAccDist(height, 0x0000ff);
        }
        else if (indicator == "Close Location Value")
        {
            return m.addCLV(height, 0x0000ff);
        }
        else if (indicator == "William's %R")
        {
            return m.addWilliamR(height, 14, 0x800080, 30, 0xff6666, 0x6666ff);
        }
        else if (indicator == "Aroon Up/Down")
        {
            return m.addAroon(height, 14, 0x339933, 0x333399);
        }
        else if (indicator == "Aroon Oscillator")
        {
            return m.addAroonOsc(height, 14, 0x0000ff);
        }
        else if (indicator == "Commodity Channel Index")
        {
            return m.addCCI(height, 20, 0x800080, 100, 0xff6666, 0x6666ff);
        }
        else if (indicator == "Ease of Movement")
        {
            return m.addEaseOfMovement(height, 9, 0x006060, 0x606000);
        }
        else if (indicator == "Mass Index")
        {
            return m.addMassIndex(height, 0x800080, 0xff6666, 0x6666ff);
        }
        else if (indicator == "Chaikin Volatility")
        {
            return m.addChaikinVolatility(height, 10, 10, 0x0000ff);
        }
        else if (indicator == "Chaikin Oscillator")
        {
            return m.addChaikinOscillator(height, 0x0000ff);
        }
        else if (indicator == "Chaikin Money Flow")
        {
            return m.addChaikinMoneyFlow(height, 21, 0x008000);
        }
        else if (indicator == "Neg Volume Index")
        {
            return m.addNVI(height, 255, 0x0000ff, 0x883333);
        }
        else if (indicator == "Pos Volume Index")
        {
            return m.addPVI(height, 255, 0x0000ff, 0x883333);
        }
        else if (indicator == "Money Flow Index")
        {
            return m.addMFI(height, 14, 0x800080, 30, 0xff6666, 0x6666ff);
        }
        else if (indicator == "% Volume Oscillato")
        {
            return m.addPVO(height, 26, 12, 9, 0x0000ff, 0xff00ff, 0x008000);
        }
        else if (indicator == "% Price Oscillator")
        {
            return m.addPPO(height, 26, 12, 9, 0x0000ff, 0xff00ff, 0x008000);
        }
        else if (indicator == "Ultimate Oscillator")
        {
            return m.addUltimateOscillator(height, 7, 14, 28, 0x800080, 20, 0xff6666,
                0x6666ff);
        }
        else if (indicator == "Volume")
        {
            return m.addVolIndicator(height, 0x99ff99, 0xff9999, 0xc0c0c0);
        }
        else if (indicator == "TRIX")
        {
            return m.addTRIX(height, 12, 0x0000ff);
        }
        return null;
    }

    /// <summary>
    /// Creates a dummy chart to show an error message.
    /// </summary>
    /// <param name="msg">The error message.
    /// <returns>The BaseChart object containing the error message.</returns>
    protected BaseChart errMsg(string msg)
    {
        MultiChart m = new MultiChart(400, 200);
        m.addTitle2(Chart.Center, msg, "Arial", 10).setMaxWidth(m.getWidth());
        return m;
    }

    //
    // Page Load event handler
    //
    protected void Page_Load(object sender, EventArgs e)
    {
        //ClientScript.RegisterClientScriptInclude(this.GetType(), "myScript", "jquery/cdjcv.js");
            //sql = "select DTLT ,Country , MT from All_MARKET_LAST_DAY where MKT_ID = '" + TK_ID + "'";
            //ds = Co.Select(sql, "mxdt", TK_ID);

            //cntyN = ds.Tables["mxdt"].Rows[0]["Country"].ToString() + " | " + ds.Tables["mxdt"].Rows[0]["MT"].ToString();
            //mxdt = Convert.ToDateTime(ds.Tables["mxdt"].Rows[0]["DTLT"].ToString()).ToString("dddd, MMMM dd, yyyy");

        if (Page.IsPostBack == false)
        {
            sql = "select TK,NM from Price_Data ";
            ds = Co.Select(sql, "T", 102);
            TickerSymbol.DataSource = ds.Tables["T"];
            name.DataSource = ds.Tables["T"];
            name.DataTextField = "NM";
         
            TickerSymbol.DataTextField = "TK";
            
            TickerSymbol.DataBind();
            name.DataBind();

            if (Request.QueryString["TK"] != null && Request.QueryString["NM"] != null)
            {
                ticksymbol.Text = "(" + Request.QueryString["TK"].ToString() + ") " + Request.QueryString["NM"].ToString();
                TickerSymbol.Text = Request.QueryString["TK"].ToString();
                //name.Text = Request.QueryString["Nm"].ToString();
            }
           
            else{

                string sql2 = "SELECT     dbo.Price_Data.TK,dbo.Price_Data.NM,dbo.Prices.VOL FROM         dbo.Price_Data INNER JOIN dbo.Prices ON dbo.Price_Data.TK_ID = dbo.Prices.PD_TK_ID where dbo.Prices.VOL = (select MAX(dbo.Prices.VOL) FROM dbo.Prices) ";
                ds = Co.Select(sql2, "Sotch", 102);
                string tk2 = ds.Tables["Sotch"].Rows[0][0].ToString();
                string nm2 = ds.Tables["Sotch"].Rows[0][1].ToString();
                ticksymbol.Text = "(" + tk2 + ") " + nm2;
                TickerSymbol.Text = tk2;
                //name.Text = nm2;
                
            }
        }


        //
        // This script handles both the full page request, as well as the subsequent partial updates
        // (AJAX chart updates). We need to determine the type of request first before we processing it.
        //
        if (WebChartViewer.IsPartialUpdateRequest(Page))
        {
            // Is a partial update request.

            // The .NET platform will not restore the states of the controls before or during Page_Load,
            // so we need to restore the state ourselves
            WebChartViewer1.LoadViewerState();

            // Draw the chart in partial update mode
            drawChart(WebChartViewer1);

            // Output the chart immediately and then terminate the page life cycle (PartialUpdateChart
            // will cause Page_Load to terminate immediately without running the following code).
            WebChartViewer1.PartialUpdateChart();
        }

        //
        // If the code reaches here, it is a full page request.
        //

        // In this exapmle, we just need to initialize the WebChartViewer and draw the chart.
        initViewer(WebChartViewer1);
        drawChart(WebChartViewer1);

        
    }

    protected void LinkButton2_Click(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //if (ComboBox1.Text != "")
        //{
        //    sql = "";
        //    sql = "select dbo.Price_Data.TK from dbo.Price_Data where ";
        //    // ds = Co.Select(sql, "T", 102);
        //    //string _nm = ds.Tables["T"].Rows[0][0].ToString();
        //}
    }
    protected void ComboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
    }
}