public static List <AnimalType> GetAll()
{
List <AnimalType> allAnimalTypes = new List <AnimalType> {
};
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM animalTypes;", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int animalTypeId = rdr.GetInt32(0);
string animalTypeName = rdr.GetString(1);
AnimalType newAnimalType = new AnimalType(animalTypeName, animalTypeId);
allAnimalTypes.Add(newAnimalType);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(allAnimalTypes);
}
public static AnimalType Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM types WHERE id = @TypeId;", conn);
SqlParameter typeIdParameter = new SqlParameter();
typeIdParameter.ParameterName = "@TypeId";
typeIdParameter.Value = id.ToString();
cmd.Parameters.Add(typeIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int foundTypeId = 0;
string foundTypeDescription = null;
while (rdr.Read())
{
foundTypeId = rdr.GetInt32(0);
foundTypeName = rdr.GetString(1);
}
AnimalType foundType = new AnimalType(foundTypeName, foundTypeId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundType);
}
