/// <summary> /// Vehicle Accident /// </summary> public void VehcleAccident() { objAccident.intYear = Convert.ToInt16(txt1.Text); ArrayList FindAcc = objAccident.FindAccident(objAccident); // --- xml Graph--- StringBuilder xmlDataAccident = new StringBuilder(); xmlDataAccident.Append("<chart caption='Year-NoOf Accident Report' subCaption='' Column3DSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=' '>"); int Get = FindAcc.Count; for (int i = 0; i < Get; i++) { BL.ArrayAccident obj = (BL.ArrayAccident)(FindAcc[i]); int yr = obj.intYear; int val = obj.intNoOfAccidents; xmlDataAccident.AppendFormat("<set label='{0}' value='{1}' />", yr.ToString(), val.ToString()); } xmlDataAccident.Append("</chart>"); AccidentGraph.Text = FusionCharts.RenderChart("FusionCharts/Pie3D.swf", "", xmlDataAccident.ToString(), "Column3DAccident", "400", "300", false, true); }
protected void btn_Click(object sender, EventArgs e) { int CurrentYear = DateTime.Now.Year; int Count = Convert.ToInt16(txt1.Text) - CurrentYear; if (0 <= Count && Count < 5) { objAccident.intYear = Convert.ToInt16(txt1.Text); ArrayList FindAcc = objAccident.FindAccident(objAccident); // --- xml Graph--- StringBuilder xmlDataBirth = new StringBuilder(); xmlDataBirth.Append("<chart caption='Year-Birth Report' subCaption='By Value' Column3DSliceDepth='10' showBorder='1' formatNumberScale='0' numberSuffix=' '>"); int Get = FindAcc.Count; for (int i = 0; i < Get; i++) { BL.ArrayAccident obj = (BL.ArrayAccident)(FindAcc[i]); int yr = obj.intYear; int val = obj.intNoOfAccidents; ListBox1.Items.Add("Year : " + yr + " Val" + val); xmlDataBirth.AppendFormat("<set label='{0}' value='{1}' />", yr.ToString(), val.ToString()); } xmlDataBirth.Append("</chart>"); Literal1.Text = FusionCharts.RenderChart("FusionCharts/Column3D.swf", "", xmlDataBirth.ToString(), "Column3DBirth", "430", "200", false, true); } }
public ArrayList FindAccident(AccidentPredict myFindAccident) { // --- DB Connection --- SqlConnection sqlConn = new SqlConnection(DL.SQL.conn); SqlDataReader sqlRdr = null; AccidentPredict objAccidentPredict = new AccidentPredict(); try { sqlConn.Open(); // ----------------- SqlCommand sqlCom = new SqlCommand("AccidentPredictor", sqlConn); sqlCom.CommandType = CommandType.StoredProcedure; sqlRdr = sqlCom.ExecuteReader(); // ----------------- while (sqlRdr.Read()) { ArrayAccident objAccident = new ArrayAccident(); objAccident.intYear = Convert.ToInt16(sqlRdr["Year"]); objAccident.intNoOfAccidents = Convert.ToInt32(sqlRdr["TotalACCIDENT"]); LoopForYr = Convert.ToInt16(sqlRdr["Year"]); myArrayAccident.Insert(indexArrAcc, objAccident); indexArrAcc = indexArrAcc + 1; } // --- Insert Year --- int FutureYr = myFindAccident.intYear; // --- Find The Loop Count --- int loopCount = FutureYr - LoopForYr; for (int j = 0; j < loopCount; j++) { // --- Get the Oldest Value From the ArrayList --- ArrayAccident objOldestVal = (ArrayAccident)(myArrayAccident[0]); double OldestVal = objOldestVal.intNoOfAccidents; // ----------------------------------------------- // --- Get the Newest Value From the ArrayList --- int NearestYrVal = myArrayAccident.Count; NearestYrVal--; ArrayAccident objNewVal = (ArrayAccident)(myArrayAccident[NearestYrVal]); double NewVal = objNewVal.intNoOfAccidents; 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); PredictAcc = Convert.ToInt32(Predicton); // --- Algo --- // --- Insert The Calc Value To Array --- ArrayAccident objArrAccInsert = new ArrayAccident(); objArrAccInsert.intYear = DbYear; objArrAccInsert.intNoOfAccidents = Convert.ToInt32(PredictAcc); myArrayAccident.Insert((myArrayAccident.Count), objArrAccInsert); // --- Insert The Calc Value To Array --- } } catch (Exception ex) { } return(myArrayAccident); }