public object LoadCensusData()
{
//Load file path from the source DAO class
CsvDataSourceDAO csvDataSource = new CsvDataSourceDAO("C:/Users/User/source/repos/USCensusData.csv");
string path = csvDataSource.Record;
//Initialize variable
int count = 0;
//instance variabe created
CsvUSCensusData csv = new CsvUSCensusData();
//Read and load csv data from file
List <CsvUSCensusData> values = File.ReadAllLines(path)
.Select(v => csv.FromCsv(v)).ToList();
//Iterate elements from csv file
foreach (var element in values)
{
Console.WriteLine(element.stateId + "|" + element.state + "|" + element.population + "|"
+ element.housingUnits + "|" + element.totalArea + "|" + element.waterArea + "|" + element.landArea
+ "|" + element.populationDensity + "|" + element.housingDensity);
count++;
}
//display total number of records
Console.WriteLine("Total number of records : " + count);
//returns total number of records in csv file
return(count);
}
//Declare columns and headers of Census data.
public CsvUSCensusData FromCsv(string csvLine)
{
string[] values = csvLine.Split(',');
CsvUSCensusData csvUSCensusData = new CsvUSCensusData();
csvUSCensusData.StateId = Convert.ToString(values[0]);
csvUSCensusData.State = Convert.ToString(values[1]);
csvUSCensusData.Population = Convert.ToString(values[2]);
csvUSCensusData.HousingUnits = Convert.ToString(values[3]);
csvUSCensusData.TotalArea = Convert.ToString(values[4]);
csvUSCensusData.WaterArea = Convert.ToString(values[5]);
csvUSCensusData.LandArea = Convert.ToString(values[6]);
csvUSCensusData.PopulationDensity = Convert.ToString(values[7]);
csvUSCensusData.HousingDensity = Convert.ToString(values[8]);
return(csvUSCensusData);
}