public void InsertAnimal(string animalName, string animalGender, string room, string food, string animalType, string shots)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(DbConnect.ConVal("HumaneSocietyDB")))
{
//Animal newAnimal = new HumaneSocietyFormApp.Animal { AnimalID = animalID, AnimalName = animalName, AnimalGender = animalGender, Room = room, Food = food, AnimalType = animalType, Shots = shots };
List <Animal> animals = new List <Animal>();
animals.Add(new Animal {
AnimalName = animalName, AnimalGender = animalGender, Room = room, Food = food, AnimalType = animalType, Shots = shots
});
connection.Execute("dbo.Animal_Insert @AnimalName, @AnimalGender, @Room, @Food, @AnimalType, @Shots", animals);
}
}
public List <Animal> GetAnimals(string animalName)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(DbConnect.ConVal("HumaneSocietyDB")))
{
var output = connection.Query <Animal>($"select * from Animal where AnimalName = '{animalName}'").ToList();
//var output = connection.Query<Animal>("dbo.Animal_GetAnimalByName @AnimalName", new { AnimalName = animalName }).ToList();
// above using stored procedure
return(output);
}
}
