public List <GenericObject> GenericObjects(int cityID)
{
SqlCommand command;
List <GenericObject> l = new List <GenericObject>();
GenericObject i;
SqlParameter p1 = new SqlParameter("@IDCidade", SqlDbType.Int);
p1.Value = cityID;
command = new SqlCommand("ObjectosCidade", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(p1);
this.reader = command.ExecuteReader();
while (this.reader.Read())
{
i = new GenericObject();
i.id = Int32.Parse(reader["IDObjecto"].ToString());
i.position = new Vector3D(Double.Parse(reader["X"].ToString()), Double.Parse(reader["Y"].ToString()), Double.Parse(reader["Z"].ToString()));
i.type = reader["ShortCode"].ToString();
l.Add(i);
}
this.reader.Close();
return(l);
}
public List<GenericObject> GenericObjects(int cityID)
{
SqlCommand command;
List<GenericObject> l = new List<GenericObject>();
GenericObject i;
SqlParameter p1 = new SqlParameter("@IDCidade", SqlDbType.Int);
p1.Value = cityID;
command = new SqlCommand("ObjectosCidade", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(p1);
this.reader = command.ExecuteReader();
while (this.reader.Read())
{
i = new GenericObject();
i.id = Int32.Parse(reader["IDObjecto"].ToString());
i.position = new Vector3D(Double.Parse(reader["X"].ToString()), Double.Parse(reader["Y"].ToString()), Double.Parse(reader["Z"].ToString()));
i.type = reader["ShortCode"].ToString();
l.Add(i);
}
this.reader.Close();
return l;
}
