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")); }