public Walker GetWalkerById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT *
FROM Walker WHERE Id = @id
";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Walker walker = new Walker
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
ImageUrl = ReaderUtil.GetNullableString(reader, "ImageUrl"),
NeighborhoodId = reader.GetInt32(reader.GetOrdinal("NeighborhoodId")),
Neighborhood = _neighborhoodrepo.GetNeighborhoodById(reader.GetInt32(reader.GetOrdinal("NeighborhoodId")))
};
reader.Close();
return(walker);
}
else
{
reader.Close();
return(null);
}
}
}
}