/// /// <summary> /// Returns the CTA Stops associated with a given station, /// ordered by name. /// </summary> /// <returns>Read-only list of CTAStop objects</returns> /// public IReadOnlyList <CTAStop> GetStops(int stationID) { List <CTAStop> list = new List <CTAStop>(); try { String sql = string.Format(@" Select * From Stops Where StationID = {0} Order by Name ", stationID); DataSet stops = dataTier.ExecuteNonScalarQuery(sql); foreach (DataRow row in stops.Tables["TABLE"].Rows) { var stop = new BusinessTier.CTAStop(Convert.ToInt32(row["StopID"]), Convert.ToString(row["Name"]), Convert.ToInt32(row["StationID"]), Convert.ToString(row["Direction"]), Convert.ToBoolean(row["ADA"]), Convert.ToDouble(row["Latitude"]), Convert.ToDouble(row["Longitude"])); list.Add(stop); } } catch (Exception ex) { string msg = string.Format("Error in Business.GetStops: '{0}'", ex.Message); throw new ApplicationException(msg); } return(list); }
/// /// <summary> /// Returns the CTA Stops associated with a given station, /// ordered by name. /// </summary> /// <returns>Read-only list of CTAStop objects</returns> /// public IReadOnlyList <CTAStop> GetStops(int stationID) { List <CTAStop> stops = new List <CTAStop>(); DataSet result; try { // // TODO! // DataAccessTier.Data dataTier = new DataAccessTier.Data(_DBFile); string sql = string.Format(@"SELECT * FROM Stops WHERE Stops.StationID = '{0}'; ", stationID); result = dataTier.ExecuteNonScalarQuery(sql); foreach (DataRow row in result.Tables["TABLE"].Rows) { int Stationid = Convert.ToInt32(row["StationID"]); int Stopid = Convert.ToInt32(row["StopID"]); string name = string.Format("{0}", Convert.ToString(row["Name"])); string direction = string.Format("{0}", Convert.ToString(row["Direction"])); bool ada = Convert.ToBoolean(row["ADA"]); double lat = Convert.ToDouble(row["Latitude"]); double lon = Convert.ToDouble(row["Longitude"]); var s = new BusinessTier.CTAStop(Stopid, name, Stationid, direction, ada, lat, lon); stops.Add(s); } } catch (Exception ex) { string msg = string.Format("Error in Business.GetStops: '{0}'", ex.Message); throw new ApplicationException(msg); } return(stops); }