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