#region DotNetNamespaces
using System;
using System.Data;
using System.Collections;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Drawing;
using ZedGraph;
using ZedGraph.Web;
#endregion

#region About Page
/*************************************************************
    Page Name:TrafficHourlyReport.aspx
    Description:Hourly Traffic Report
    Created On:
    Created By: Vipul Limbachiya 
    Usage Inuctions:
    Edit History:
    Change No.    Date    Version     ChangeBy    
*************************************************************/
#endregion

public partial class RetailWeb_RetailHome_TrafficReport : 
{
    #region PageEvents

    //The Events fired by controls in page
    #region Page Load
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }
    #endregion
    #region Render Graph
    protected void ZedGraphWeb1_RenderGraph(System.Drawing.Graphics g, ZedGraph.MasterPane pane)
    {
        //---------------------------------------------------------------------------------
        //Function Name:ZedGraphWeb1_RenderGraph
        //Description:Render Graph
        //Created On: 
        //Created By: Vipul Limbachiya
        //Usage Inuctions:
        //Edit History:
        //Change No.    Date    Version     ChangeBy 
        //---------------------------------------------------------------------------------

        //Object and Variable Declarations
        GraphPane mypane = pane[0];
        DateTime dt = DateTime.Now;
        string strDate = "";

        //Method Logic
        try
        {
            
            if (Request.QueryString["date"] != null)
            {
                strDate = Request.QueryString["date"];
                dt = DateTime.Parse(strDate);
            }
            else
            {
                strDate = DateTime.Now.ToShortDateString();
            }
            mypane.Title.Text = "justOnDemand Traffic Hourly Report (Date : " + dt.ToString("dd MMM yyyy") + ")";
            mypane.XAxis.Title.Text = "Hour";
            mypane.YAxis.Title.Text = "Visits";
            string[] labels = new string[24];
            double[] y = new double[24];
            DataSet dstTemp = new DataSet();
			
            //Set dataset values using your SQL IAL class
			
            int i = 0;
            int j = 0;
            for (i = 0; i < 24; i++)
            {
                labels[i] = i.ToString();
                y[i] = 0;
            }
            for (j = 0; j < dstTemp.Tables[0].Rows.Count; j++)
            {
                y[int.Parse(dstTemp.Tables[0].Rows[j].ItemArray.GetValue(1).ToString())] = double.Parse(dstTemp.Tables[0].Rows[j].ItemArray.GetValue(0).ToString());
            }
            if (Request.QueryString["type"] != null)
            {
                if (Request.QueryString["type"] == "1")
                {
                    BarItem myBar = mypane.AddBar("Traffic",
                                                   null,
                                                   y,
                                                   Color.Olive);

                    myBar.Bar.Fill = new Fill(Color.PaleGoldenrod,
                                              Color.White,
                                              Color.Olive);
                }
                else if (Request.QueryString["type"] == "2")
                {
                    LineItem myCurve = mypane.AddCurve("Traffic",
                                                        null,
                                                        y,
                                                        Color.Black,
                                                        SymbolType.Circle);

                    myCurve.Line.Fill = new Fill(Color.White,
                                                 Color.PaleGoldenrod,
                                                 -45F);
                    myCurve.Symbol.Size = 8.0F;
                    myCurve.Symbol.Fill = new Fill(Color.White);
                    myCurve.Line.Width = 2.0F;
                }
                else
                {
                    BarItem myBar = mypane.AddBar("Traffic",
                                                   null,
                                                   y,
                                                   Color.Olive);
                    myBar.Bar.Fill = new Fill(Color.PaleGoldenrod,
                                              Color.White,
                                              Color.Olive);

                    LineItem myCurve = mypane.AddCurve("Traffic",
                                                        null,
                                                        y,
                                                        Color.Black,
                                                        SymbolType.Circle);
                    myCurve.Line.Fill = new Fill(Color.White,
                                                 Color.PaleGoldenrod,
                                                 -45F);
                    myCurve.Symbol.Size = 8.0F;
                    myCurve.Symbol.Fill = new Fill(Color.White);
                    myCurve.Line.Width = 2.0F;
                }
            }
            else
            {
                BarItem myBar = mypane.AddBar("Traffic",
                                               null,
                                               y,
                                               Color.Olive);
                myBar.Bar.Fill = new Fill(Color.PaleGoldenrod,
                                          Color.White,
                                          Color.Olive);
            }

            mypane.XAxis.MajorTic.IsBetweenLabels = true;
            mypane.XAxis.Scale.TextLabels = labels;
            mypane.YAxis.Scale.MajorStepAuto = true;
            mypane.YAxis.Scale.MinorStepAuto = true;
            mypane.XAxis.Type = AxisType.Text;
            mypane.XAxis.Scale.FontSpec.IsBold = false;
            mypane.XAxis.Scale.FontSpec.Size = 9;


            mypane.Chart.Fill = new Fill(Color.White,
                                         Color.FromArgb(255, 255, 166),
                                         90F);
            mypane.Fill = new Fill(Color.FromArgb(250, 250, 255));
            mypane.AxisChange(g);

            BarItem.CreateBarLabels(mypane, 
                                    false, 
                                    "f0");
            
        }
        catch (Exception)
        {
            Response.Write("Invalid Request, ask administrator for further help");
        }
}
    #endregion
    #endregion
}