/// <summary> /// This Method is Used To Convert the Loaded India State Code Data into List /// </summary> /// <param name="csvStateCodeData">Parameter contains the Loaded Data of Indian State Code in DataTable Format</param> /// <param name="censusList">It is an object of list to store the data in list </param> /// <returns>It returns the Converted data in List Format</returns> public static List <CensusDAO> IndiaStateDataInList(DataTable csvStateCodeData, List <CensusDAO> censusList) { // For Loop is Used To Iterate through DataTable for (int counter = 0; counter < csvStateCodeData.Rows.Count; counter++) { CensusDAO censusDAO = new CensusDAO(); censusDAO.SrNo = Convert.ToInt32(csvStateCodeData.Rows[counter]["SrNo"].ToString()); censusDAO.State = csvStateCodeData.Rows[counter]["StateName"].ToString(); censusDAO.Tin = Convert.ToInt32(csvStateCodeData.Rows[counter]["TIN"].ToString()); censusDAO.StateCode = csvStateCodeData.Rows[counter]["StateCode"].ToString(); censusList.Add(censusDAO); } return(censusList); }
/// <summary> /// This Method is Used To Convert the Loaded India Census Data into List /// </summary> /// <param name="csvCensusData">Parameter contains the Loaded Data of Indian Census in DataTable Format</param> /// <param name="censusList">It is an object of list to store the data in list </param> /// <returns>It returns the Converted data in List Format</returns> public static List <CensusDAO> IndiaCensusDataInList(DataTable csvCensusData, List <CensusDAO> censusList) { // For Loop is Used To Iterate through DataTable for (int counter = 0; counter < csvCensusData.Rows.Count; counter++) { CensusDAO censusDAO = new CensusDAO(); censusDAO.State = csvCensusData.Rows[counter]["State"].ToString(); censusDAO.Population = Convert.ToInt32(csvCensusData.Rows[counter]["Population"].ToString()); censusDAO.DensityPerSqKm = Convert.ToInt32(csvCensusData.Rows[counter]["DensityPerSqKm"].ToString()); censusDAO.AreaInSqKm = Convert.ToInt32(csvCensusData.Rows[counter]["AreaInSqKm"].ToString()); censusList.Add(censusDAO); } return(censusList); }
/// <summary> /// This Method is Used To Convert the Loaded US Census Data into List /// </summary> /// <param name="unitedStateCensusData">Parameter contains the Loaded Data of US Census in DataTable Format</param> /// <param name="unitedStateCensusList">It gives the Converted data in List Format</param> /// <returns>It returns the Converted data in List Format</returns> public static List <CensusDAO> USCensusDataInList(DataTable unitedStateCensusData, List <CensusDAO> unitedStateCensusList) { // For Loop is Used To Iterate through DataTable for (int counter = 0; counter < unitedStateCensusData.Rows.Count; counter++) { CensusDAO censusDAO = new CensusDAO(); censusDAO.StateId = unitedStateCensusData.Rows[counter]["StateId"].ToString(); censusDAO.State = unitedStateCensusData.Rows[counter]["State"].ToString(); censusDAO.Population = Convert.ToDouble(unitedStateCensusData.Rows[counter]["Population"].ToString()); censusDAO.HousingUnits = Convert.ToDouble(unitedStateCensusData.Rows[counter]["Housingunits"].ToString()); censusDAO.TotalArea = Convert.ToDouble(unitedStateCensusData.Rows[counter]["Totalarea"].ToString()); censusDAO.WaterArea = Convert.ToDouble(unitedStateCensusData.Rows[counter]["Waterarea"].ToString()); censusDAO.LandArea = Convert.ToDouble(unitedStateCensusData.Rows[counter]["Landarea"].ToString()); censusDAO.PopulationDensity = Convert.ToDouble(unitedStateCensusData.Rows[counter]["PopulationDensity"].ToString()); censusDAO.HousingDensity = Convert.ToDouble(unitedStateCensusData.Rows[counter]["HousingDensity"].ToString()); unitedStateCensusList.Add(censusDAO); } return(unitedStateCensusList); }