public List <SpeciesSim> GetSpeciesList()
{
List <SpeciesSim> ReturnObject = new List <SpeciesSim>();
SpeciesSim ins;
DataBaseConnection dbConn = new DataBaseConnection();
using (var con = dbConn.SqlConn())
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.GetAnimalTypes, con))
{
using (var drI = cmd.ExecuteReader())
{
while (drI.Read())
{
ins = new SpeciesSim();
ins.SpeciesId = Convert.ToInt32(drI["AnimalTypeId"]);
ins.SpeciesName = drI["Description"].ToString();
ReturnObject.Add(ins);
}
}
}
}
return(ReturnObject);
}
public List<SpeciesSim> GetSpeciesList()
{
List<SpeciesSim> ReturnObject = new List<SpeciesSim>();
SpeciesSim ins;
DataBaseConnection dbConn = new DataBaseConnection();
using (var con = dbConn.SqlConn())
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.GetAnimalTypes, con))
{
using (var drI = cmd.ExecuteReader())
{
while (drI.Read())
{
ins = new SpeciesSim();
ins.SpeciesId = Convert.ToInt32(drI["AnimalTypeId"]);
ins.SpeciesName = drI["Description"].ToString();
ReturnObject.Add(ins);
}
}
}
}
return ReturnObject;
}
