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