Ejemplo n.º 1
0
    /// <summary>
    /// Traffic
    /// </summary>
    public void Traffic()
    {
        objTrafficPredict.intYear = Convert.ToInt16(txt1.Text);
        ArrayList FindTraffic = objTrafficPredict.FindTraffic(objTrafficPredict);

        // --- xml Graph---
        StringBuilder xmlDataTraffic = new StringBuilder();

        xmlDataTraffic.Append("<chart caption='Year-Traffic Count Report' subCaption='' Column3DSliceDepth='10' showBorder='1' formatNumberScale='0' numberSuffix=' '>");

        int Get = FindTraffic.Count;

        for (int i = 0; i < Get; i++)
        {
            BL.ArrayTraffic obj = (BL.ArrayTraffic)(FindTraffic[i]);
            int             yr  = obj.intYear;
            double          val = Math.Ceiling(obj.doubleNoOfVehicles);

            xmlDataTraffic.AppendFormat("<set label='{0}' value='{1}' />", yr.ToString(), val.ToString());

            //ListBox1.Items.Add("Year --->" + yr + " Value --> " + val);
        }

        xmlDataTraffic.Append("</chart>");
        TrafficGraph.Text = FusionCharts.RenderChart("FusionCharts/Line.swf", "", xmlDataTraffic.ToString(), "Column3DTraffic", "825", "350", false, true);
    }
    /// <summary>
    /// Traffic By Time
    /// </summary>
    public void TrafficByTime()
    {
        // --- xml Graph---
        StringBuilder xmlDataTraffic = new StringBuilder();

        xmlDataTraffic.Append("<chart caption='Split Time-Traffic Status Report' subCaption='' Column3DSliceDepth='10' showBorder='1' formatNumberScale='0' numberSuffix=' '>");
        // ----------------

        objTrafficPredict.strRegion = ddlRegion.SelectedItem.ToString();
        ArrayList DisVehTraffic = objTrafficPredict.DisplyTraffic(objTrafficPredict);

        // Loop only By Traffic
        int Get = DisVehTraffic.Count;

        for (int i = 0; i < Get; i++)
        {
            // --- DisVehPopulation Data To xml ---
            BL.ArrayTraffic objVehicleTraffic = (BL.ArrayTraffic)(DisVehTraffic[i]);
            string          SplitTim          = objVehicleTraffic.strSplitTime;
            double          vehPopValTyp      = objVehicleTraffic.doubleNoOfVehicles;

            xmlDataTraffic.AppendFormat("<set label='{0}' value='{1}' />", SplitTim.ToString(), vehPopValTyp.ToString());
        }

        /// Create The Vehicle Population Chart - Column3D Chart With Data From xmlDataVehPop
        xmlDataTraffic.Append("</chart>");
        LiteralVehicleTrafficByTime.Text = FusionCharts.RenderChart("FusionCharts/Column3D.swf", "", xmlDataTraffic.ToString(), "Column3DTrafficByTime", "810", "300", false, true);
    }
Ejemplo n.º 3
0
        /// <summary>
        /// Traffic By Time...Non Predict
        /// </summary>
        public ArrayList DisplyTraffic(TrafficPredict myTrafficDis)
        {
            // --- DB Connection ---
            SqlConnection sqlConn = new SqlConnection(DL.SQL.conn);

            sqlConn.Open();

            SqlCommand    sqlcom = new System.Data.SqlClient.SqlCommand("Select SplitTime,sum(NoOfVehicles) AS TOTELVehicle From tblTraffic Where Region = '" + myTrafficDis.strRegion + "' Group By SplitTime", sqlConn);
            SqlDataReader sqlred = sqlcom.ExecuteReader();

            while (sqlred.Read())
            {
                ArrayTraffic objTraffic = new ArrayTraffic();

                objTraffic.strSplitTime       = sqlred["SplitTime"].ToString();
                objTraffic.doubleNoOfVehicles = Convert.ToInt32(sqlred["TOTELVehicle"]);

                myArrayTraffic.Insert(indexArrTraffic, objTraffic);
                indexArrTraffic = indexArrTraffic + 1;
            }

            return(myArrayTraffic);
        }
Ejemplo n.º 4
0
        public ArrayList FindTraffic(TrafficPredict myTrafficPredict)
        {
            // --- DB Connection ---
            SqlConnection sqlConn = new SqlConnection(DL.SQL.conn);
            SqlDataReader sqlRdr  = null;

            TrafficPredict objTrafficPredict = new TrafficPredict();

            try
            {
                sqlConn.Open();
                // -----------------
                SqlCommand sqlCom = new SqlCommand("TrafficPredictor", sqlConn);
                sqlCom.CommandType = CommandType.StoredProcedure;
                sqlRdr             = sqlCom.ExecuteReader();
                // -----------------

                while (sqlRdr.Read())
                {
                    ArrayTraffic objTraffic = new ArrayTraffic();

                    objTraffic.intYear            = Convert.ToInt16(sqlRdr["Year"]);
                    objTraffic.doubleNoOfVehicles = Convert.ToDouble(sqlRdr["TotalTraffic"]);

                    LoopForYr = Convert.ToInt16(sqlRdr["Year"]);

                    myArrayTraffic.Insert(indexArrTraffic, objTraffic);
                    indexArrTraffic = indexArrTraffic + 1;
                }

                // --- Insert Year ---
                int FutureYr = myTrafficPredict.intYear;
                // --- Find The Loop Count ---
                int loopCount = FutureYr - LoopForYr;

                for (int j = 0; j < loopCount; j++)
                {
                    // --- Get the Oldest Value From the ArrayList ---
                    ArrayTraffic objOldestVal = (ArrayTraffic)(myArrayTraffic[0]);
                    double       OldestVal    = objOldestVal.doubleNoOfVehicles;
                    // -----------------------------------------------

                    // --- Get the Newest Value From the ArrayList ---
                    int NearestYrVal = myArrayTraffic.Count;
                    NearestYrVal--;
                    ArrayTraffic objNewVal = (ArrayTraffic)(myArrayTraffic[NearestYrVal]);
                    double       NewVal    = objNewVal.doubleNoOfVehicles;
                    DbYear = objNewVal.intYear;
                    // -----------------------------------------------

                    // --- Insert The Calc Value To Array ---
                    DbYear++;

                    // --- Algo ---
                    double Predicton = NewVal * Math.Exp((Math.Log((NewVal / OldestVal), Math.Exp(1)) / 4) * 1);
                    PredictTraffic = Predicton;
                    // --- Algo ---

                    // --- Insert The Calc Value To Array ---
                    ArrayTraffic objArrTrafficInsert = new ArrayTraffic();
                    objArrTrafficInsert.intYear            = DbYear;
                    objArrTrafficInsert.doubleNoOfVehicles = PredictTraffic;
                    myArrayTraffic.Insert((myArrayTraffic.Count), objArrTrafficInsert);
                    // --- Insert The Calc Value To Array ---
                }
            }
            catch (Exception ex)
            {
            }
            return(myArrayTraffic);
        }