/// --- Population ---
public ArrayList noPredictPopulation(PopulationPredict myNoPredictPopulation)
{
SqlConnection sqlConn = new SqlConnection(DL.SQL.conn);
SqlDataReader sqlRdr = null;
try
{
sqlConn.Open();
//-------------------
SqlCommand sqlCom = new SqlCommand("PopulationPredictor", sqlConn);
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.Parameters.Add("@SelectedRegion", myNoPredictPopulation.strPredictDistrict);
sqlRdr = sqlCom.ExecuteReader();
//-------------------
while (sqlRdr.Read())
{
ArrayPopulation objPopulation = new ArrayPopulation();
objPopulation.intPopulationYear = Convert.ToInt32(sqlRdr["tempYear"]);
objPopulation.doublePopulationCount = Convert.ToInt32(sqlRdr["tempCount"]);
myPopulationArray.Insert(p, objPopulation);
p = p + 1;
}
}
catch (Exception ex)
{
}
return(myPopulationArray);
}
/// --- Birth ---
/// <summary>
/// -------------
/// </summary>
public ArrayList FindBirth(PopulationPredict myFindBirth)
{
SqlConnection sqlConn = new SqlConnection(DL.SQL.conn);
SqlDataReader sqlRdr = null;
try
{
sqlConn.Open();
//-------------
SqlCommand sqlCom = new SqlCommand("BirthPredictor", sqlConn);
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.Parameters.Add("@SelectedRegion", myFindBirth.strPredictDistrict);
sqlRdr = sqlCom.ExecuteReader();
//------------
while (sqlRdr.Read())
{
ArrayBirth objArrBirth = new ArrayBirth();
objArrBirth.intBirthYear = Convert.ToInt32(sqlRdr["tempYear"]);
objArrBirth.doubleBirthCount = Convert.ToInt32(sqlRdr["tempCount"]);
myBirthArray.Insert(b, objArrBirth);
b = b + 1;
}
/// Close The Connections
sqlRdr.Close();
sqlConn.Close();
/// --- Find Oldest Year & Value ---
ArrayBirth objOldBirthFind = (ArrayBirth)(myBirthArray[0]);
int DB_Old_BirthYear = objOldBirthFind.intBirthYear;
double DB_Old_BirthCount = objOldBirthFind.doubleBirthCount;
/// --- Find Newest year & Value ---
int NoOf_tblBirth_DB_Row = myBirthArray.Count;
int NoOf_Rows = NoOf_tblBirth_DB_Row - 1;
ArrayBirth objNewBirthFind = (ArrayBirth)(myBirthArray[NoOf_Rows]);
int DB_New_BirthYear = objNewBirthFind.intBirthYear;
double DB_New_BirthCount = objNewBirthFind.doubleBirthCount;
/// --- Predict Future ---
int FindYear = myFindBirth.intPredictYear;
int t = FindYear - DB_New_BirthYear;
int CalcYear = CurrentYear;
for (int i = 0; i < t; i++)
{
if (CalcYear <= 2022)
{
/// Algo For Birth
double NFuture = DB_New_BirthCount * Math.Exp((Math.Log((DB_New_BirthCount / DB_Old_BirthCount), Math.Exp(1)) / 4) * 1);
/// Algo For Birth
ArrayBirth objPredictArrBirth = new ArrayBirth();
objPredictArrBirth.intBirthYear = CalcYear;
objPredictArrBirth.doubleBirthCount = Math.Ceiling(NFuture);
myBirthArray.Insert(b, objPredictArrBirth);
b = b + 1;
// Copy Predicted value to calc next year value
DB_New_BirthCount = NFuture;
// Increment The Year
CalcYear++;
}
else
{
//DB_New_BirthCount = DB_New_BirthCount - 302;
ArrayBirth objPredictArrBirth = new ArrayBirth();
objPredictArrBirth.intBirthYear = CalcYear;
objPredictArrBirth.doubleBirthCount = Math.Ceiling(DB_New_BirthCount);
myBirthArray.Insert(b, objPredictArrBirth);
b = b + 1;
CalcYear++;
}
}
}
catch (Exception ex)
{
}
return(myBirthArray);
}
/// --- Population ---
/// <summary>
/// ------------
/// </summary>
public ArrayList FindPopulation(PopulationPredict myFindPopulation)
{
/// --- Get the Newest Value from DB -->> tblPopulation
SqlConnection sqlConn = new SqlConnection(DL.SQL.conn);
SqlDataReader sqlRdr = null;
try
{
sqlConn.Open();
//-------------
SqlCommand sqlCom = new SqlCommand("PopulationPredictor", sqlConn);
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.Parameters.Add("@SelectedRegion", myFindPopulation.strPredictDistrict);
sqlRdr = sqlCom.ExecuteReader();
//------------
while (sqlRdr.Read())
{
ArrayPopulation objArrPopulation = new ArrayPopulation();
objArrPopulation.intPopulationYear = Convert.ToInt32(sqlRdr["tempYear"]);
objArrPopulation.doublePopulationCount = Convert.ToInt32(sqlRdr["tempCount"]);
myPopulationArray.Insert(p, objArrPopulation);
p = p + 1;
}
/// Close The Connections
sqlRdr.Close();
sqlConn.Close();
/// --- Find Newest year & Value ---
int NoOf_tblPopulation_DB_Row = myPopulationArray.Count;
int NoOf_Rows = NoOf_tblPopulation_DB_Row - 1;
ArrayPopulation objNewPopulationFind = (ArrayPopulation)(myPopulationArray[NoOf_Rows]);
int DB_New_PopulationYear = objNewPopulationFind.intPopulationYear;
double DB_New_PopulationCount = objNewPopulationFind.doublePopulationCount;
/// --- Predict Future ---
int FindYear = myFindPopulation.intPredictYear;
int t = FindYear - DB_New_PopulationYear;
int CalcYear = CurrentYear;
for (int i = 0; i < t; i++)
{
/// --- Birth Of The Year ---
ArrayBirth objGetBirth = (ArrayBirth)(myBirthArray[NoOf_Rows]);
double GetBirth = objGetBirth.doubleBirthCount;
/// --- Death Of The Year ---
ArrayDeath objGetdeath = (ArrayDeath)(myDeathArray[NoOf_Rows]);
double GetDeath = objGetdeath.doubleDeathCount;
/// Population Predict Algo
double FuturePopulation = DB_New_PopulationCount + GetBirth - GetDeath;
/// Population Predict Algo
ArrayPopulation objPredictArrPopulation = new ArrayPopulation();
objPredictArrPopulation.intPopulationYear = CalcYear;
objPredictArrPopulation.doublePopulationCount = Math.Ceiling(FuturePopulation);
myPopulationArray.Insert(p, objPredictArrPopulation);
p = p + 1;
// Copy Predicted value to calc next year value
DB_New_PopulationCount = FuturePopulation;
// Increment The Year
CalcYear++;
// Increment The Birth & Death Year Value
NoOf_Rows++;
}
}
catch (Exception ex)
{
}
return(myPopulationArray);
}