public int CreateDog(Dog dog, Breed breed)
{
AddParam("@Name", dog.Name);
AddParam("@Age", dog.Age);
AddParam("@BreedId", breed.Id);
return(Convert.ToInt32(ExecuteScalar("CreateDog")));
}
private List <Breed> Read(string procedure)
{
using (SqlCommand command = new SqlCommand(procedure, connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddRange(this.Parameters.ToArray());
this.Parameters.Clear();
using (SqlDataReader reader = command.ExecuteReader())
{
List <Breed> results = new List <Breed>();
while (reader.Read())
{
Breed breed = new Breed();
breed.Id = Convert.ToInt32(reader["Id"]);
breed.Type = reader["Type"].ToString();
results.Add(breed);
}
return(results);
}
}
}
public void UpdateDogBreed(Dog dog, Breed breed)
{
AddParam("@BreedId", breed.Id);
AddParam("@DogId", dog.Id);
ExecuteScalar("UpdateDogBreed");
}
public List <Dog> GetDogsByBreed(Breed breed)
{
AddParam("@BreedId", breed.Id);
return(Read("GetDogsByBreed"));
}