/// <summary>
/// This Method is Used to Load Census Data
/// </summary>
/// <param name="csvCensusData">path parameter contains the path of the DataTable</param>
/// <returns>It returns the loaded data List</returns>
public List <CencusDAO> CensusDataAssigned(DataTable csvCensusData)
{
int row = 0;
while (row < csvCensusData.Rows.Count)
{
CencusDAO cencusCsv = new CencusDAO();
cencusCsv.AreaInSqKm = Convert.ToInt32(csvCensusData.Rows[row]["AreaInSqKm"].ToString());
cencusCsv.DencityPerSqKm = Convert.ToInt32(csvCensusData.Rows[row]["DensityPerSqKm"].ToString());
cencusCsv.Population = Convert.ToInt32(csvCensusData.Rows[row]["Population"].ToString());
cencusCsv.State = csvCensusData.Rows[row]["State"].ToString();
this.cencusList.Add(cencusCsv);
row++;
}
return(this.cencusList);
}
/// <summary>
/// This Method is Used to Load Indian State Data
/// </summary>
/// <param name="csvCensusData">path parameter contains the path of the DataTable File</param>
/// <returns>It returns the loaded data List</returns>
public List <CencusDAO> IndianStateDataAssigned(DataTable csvCensusData)
{
int row = 0;
while (row < csvCensusData.Rows.Count)
{
CencusDAO cencusCsv = new CencusDAO();
cencusCsv.SrNo = Convert.ToInt32(csvCensusData.Rows[row]["SrNo"]);
cencusCsv.State = csvCensusData.Rows[row]["State Name"].ToString();
cencusCsv.Tin = Convert.ToInt32(csvCensusData.Rows[row]["TIN"].ToString());
cencusCsv.StateCode = csvCensusData.Rows[row]["StateCode"].ToString();
this.cencusList.Add(cencusCsv);
row++;
}
return(this.cencusList);
}
/// <summary>
/// This Method is Used to Load Us data
/// </summary>
/// <param name="csvCensusData">path parameter contains the path of the DataTable Variable</param>
/// <returns>It returns the loaded data List</returns>
public List <CencusDAO> UsDataAssigned(DataTable csvCensusData)
{
int row = 0;
while (row < csvCensusData.Rows.Count)
{
CencusDAO cencusCsv = new CencusDAO();
cencusCsv.StateId = csvCensusData.Rows[row]["State_Id"].ToString();
cencusCsv.State = csvCensusData.Rows[row]["State"].ToString();
cencusCsv.Population = Convert.ToInt32(csvCensusData.Rows[row]["Population"].ToString());
cencusCsv.TotalArea = Convert.ToDouble(csvCensusData.Rows[row]["Total_area"].ToString());
cencusCsv.PopulationDencity = Convert.ToDouble(csvCensusData.Rows[row]["Population_Density"].ToString());
this.cencusList.Add(cencusCsv);
row++;
}
return(this.cencusList);
}