/// <summary> /// /// </summary> /// <param name="cityID"></param> /// <returns></returns> public SVGCartography SVGMap(int cityID) { SqlCommand command; SVGCartography cartography = new SVGCartography(); List <SVGRoadSegment> l = new List <SVGRoadSegment>(); SVGRoadSegment s; SqlParameter p1 = new SqlParameter("@IDCidade", SqlDbType.Int); p1.Value = cityID; command = new SqlCommand("SegmentosComInterseccoes", this.connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(p1); this.reader = command.ExecuteReader(); while (this.reader.Read()) { s = new SVGRoadSegment(); s.id = Int32.Parse(reader["ID"].ToString()); s.name = reader["NOME"].ToString(); // TODO: Faz um translate no XML em vez de adicionar 50.0 para retirar as posições negativas s.begin = new Vector3D(Double.Parse(reader["XInicio"].ToString()), Double.Parse(reader["YInicio"].ToString()), Double.Parse(reader["ZInicio"].ToString())); s.end = new Vector3D(Double.Parse(reader["XFim"].ToString()), Double.Parse(reader["YFim"].ToString()), Double.Parse(reader["ZFim"].ToString())); l.Add(s); } this.reader.Close(); List <PointOfInterest> p = new List <PointOfInterest>(); p = this.PointsOfInterest(cityID, true); cartography.segments = l; cartography.pointsOfInterest = p; cartography.cityName = "Nao Implementado"; return(cartography); }
/// <summary> /// /// </summary> /// <param name="cityID"></param> /// <returns></returns> public SVGCartography SVGMap(int cityID) { SqlCommand command; SVGCartography cartography = new SVGCartography(); List<SVGRoadSegment> l = new List<SVGRoadSegment>(); SVGRoadSegment s; SqlParameter p1 = new SqlParameter("@IDCidade", SqlDbType.Int); p1.Value = cityID; command = new SqlCommand("SegmentosComInterseccoes", this.connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(p1); this.reader = command.ExecuteReader(); while (this.reader.Read()) { s = new SVGRoadSegment(); s.id = Int32.Parse(reader["ID"].ToString()); s.name = reader["NOME"].ToString(); // TODO: Faz um translate no XML em vez de adicionar 50.0 para retirar as posições negativas s.begin = new Vector3D(Double.Parse(reader["XInicio"].ToString()), Double.Parse(reader["YInicio"].ToString()), Double.Parse(reader["ZInicio"].ToString())); s.end = new Vector3D(Double.Parse(reader["XFim"].ToString()), Double.Parse(reader["YFim"].ToString()), Double.Parse(reader["ZFim"].ToString())); l.Add(s); } this.reader.Close(); List<PointOfInterest> p = new List<PointOfInterest>(); p = this.PointsOfInterest(cityID, true); cartography.segments = l; cartography.pointsOfInterest = p; cartography.cityName = "Nao Implementado"; return cartography; }