/// <summary> /// Gets all the states /// </summary> /// <exception cref="CityManagerException">Thrown when unable to get states</exception> /// <returns>Returns the list of states from database</returns> public List <State> GetStates() { List <State> states = null; try { DataSet ds = cityDAO.GetStates(); states = new List <State>(); foreach (DataRow rw in ds.Tables[0].Rows) { State state = new State(); state.StateId = Convert.ToInt32(rw["StateId"]); state.Name = rw["StateName"].ToString(); states.Add(state); } } catch (CityDAOException ex) { throw new CityManagerException("Unable to get states", ex); } return(states); }
/// <summary> /// Gets all the states /// </summary> /// <exception cref="CityManagerException">Thrown when unable to get states</exception> /// <returns>Returns the list of states from database</returns> public List <State> GetStates() { try { return(cityDAO.GetStates()); } catch (CityDAOException ex) { throw new CityManagerException("Unable to get states", ex); } }
/// <summary> /// Gets all the states /// </summary> /// <exception cref="CityManagerException">Thrown when unable to get states</exception> /// <returns>Returns the list of states from database</returns> public List <State> GetStates() { try { DataSet ds = cityDAO.GetStates(); var states = from state in ds.Tables[0].AsEnumerable().Distinct() orderby state["StateName"] select new State { StateId = Convert.ToInt64(state["StateId"]), Name = state["StateName"].ToString() }; return(states.ToList <State>()); } catch (CityDAOException ex) { throw new CityManagerException("Unable to get states", ex); } }