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