public Animal SelectAnimalById(int id)
{
Animal animal = null;
DBUtil dbUtil = new DBUtil();
MySqlDataAdapter adp = dbUtil.getConnectionSelect($"SELECT * FROM animals_with_descriptions WHERE species_id = {id}", "wildlife_reserve");
DataTable table = new DataTable();
adp.Fill(table);
if (table.Rows.Count > 0)
{
DataRow datarow = table.Rows[0];
int speciesId = int.Parse(datarow["species_id"].ToString());
string species = datarow["species_name"].ToString();
int population = int.Parse(datarow["population"].ToString());
string descLong = datarow["long_desc"].ToString();
string descShort = datarow["short_desc"].ToString();
DateTime breedStart = DateTime.Parse(datarow["breeding_season_start"].ToString());
DateTime breedEnd = DateTime.Parse(datarow["breeding_season_end"].ToString());
AnimalDescription description = new AnimalDescription(descLong, descShort, breedStart, breedEnd);
animal = new Animal(speciesId, species, population, description);
MySqlDataAdapter adp2 = dbUtil.getConnectionSelect($"SELECT * FROM animal_images WHERE species_id = {speciesId}", "wildlife_reserve");
DataTable photoTable = new DataTable();
adp2.Fill(photoTable);
foreach (DataRow datarow2 in photoTable.Rows)
{
int photoId = int.Parse(datarow2["image_id"].ToString());
string fileName = datarow2["file_name"].ToString();
DateTime dateTaken = DateTime.Parse(datarow2["date_taken"].ToString());
AnimalPhoto animalPhoto = new AnimalPhoto(photoId, fileName, dateTaken);
animal.AddPhoto(animalPhoto);
}
}
else
{
throw new NotFoundQueryException();
}
return(animal);
}
public List <Animal> SelectAllAnimals()
{
List <Animal> animalList = new List <Animal>();
DBUtil dbUtil = new DBUtil();
MySqlDataAdapter adp = dbUtil.getConnectionSelect("SELECT * FROM animals_with_descriptions ORDER BY species_name ASC", "wildlife_reserve");
DataTable animalTable = new DataTable();
adp.Fill(animalTable);
foreach (DataRow datarow in animalTable.Rows)
{
int speciesId = int.Parse(datarow["species_id"].ToString());
string species = datarow["species_name"].ToString();
int population = int.Parse(datarow["population"].ToString());
string descLong = datarow["long_desc"].ToString();
string descShort = datarow["short_desc"].ToString();
DateTime breedStart = DateTime.Parse(datarow["breeding_season_start"].ToString());
DateTime breedEnd = DateTime.Parse(datarow["breeding_season_end"].ToString());
AnimalDescription description = new AnimalDescription(descLong, descShort, breedStart, breedEnd);
Animal animal = new Animal(speciesId, species, population, description);
MySqlDataAdapter adp2 = dbUtil.getConnectionSelect($"SELECT * FROM animal_images WHERE species_id = {speciesId}", "wildlife_reserve");
DataTable photoTable = new DataTable();
adp2.Fill(photoTable);
foreach (DataRow datarow2 in photoTable.Rows)
{
int photoId = int.Parse(datarow2["image_id"].ToString());
string fileName = datarow2["file_name"].ToString();
DateTime dateTaken = DateTime.Parse(datarow2["date_taken"].ToString());
AnimalPhoto animalPhoto = new AnimalPhoto(photoId, fileName, dateTaken);
animal.AddPhoto(animalPhoto);
}
animalList.Add(animal);
}
return(animalList);
}