/// <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);
}
