public List <Dog> GetDogs()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT Id, Name, OwnerId, Breed, Notes, ImageUrl
FROM Dog
";
SqlDataReader reader = cmd.ExecuteReader();
List <Dog> dogs = new List <Dog>();
while (reader.Read())
{
Dog dog = new Dog
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
OwnerId = reader.GetInt32(reader.GetOrdinal("OwnerId")),
Breed = reader.GetString(reader.GetOrdinal("Breed")),
Notes = ReaderUtils.GetNullableString(reader, "Notes"),
ImageUrl = ReaderUtils.GetNullableString(reader, "ImageUrl"),
};
dogs.Add(dog);
}
reader.Close();
return(dogs);
}
}
}
public void AddDog(Dog dog)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
INSERT INTO Dog ([Name], OwnerId, Breed, Notes, ImageUrl)
OUTPUT INSERTED.ID
VALUES (@name, @ownerId, @breed, @notes, @imageUrl);
";
cmd.Parameters.AddWithValue("@name", ReaderUtils.GetNullableParam(dog.Name));
cmd.Parameters.AddWithValue("@ownerId", ReaderUtils.GetNullableParam(dog.OwnerId));
cmd.Parameters.AddWithValue("@breed", ReaderUtils.GetNullableParam(dog.Breed));
cmd.Parameters.AddWithValue("@notes", ReaderUtils.GetNullableParam(dog.Notes));
cmd.Parameters.AddWithValue("@imageUrl", ReaderUtils.GetNullableParam(dog.ImageURL));
int id = (int)cmd.ExecuteScalar();
dog.Id = id;
}
}
}