/// <summary>
/// Read a list of Reptiles from the database with search parameters
/// </summary>
/// <param name="search">The search parameters</param>
/// <returns>A list of Reptiles matching the search parameters. Empty list of no matches</returns>
public List<ReptileClass> ReadReptile(BasicSearch search)
{
throw new NotImplementedException();
}
public List<PlantClass> ReadPlant(BasicSearch search)
{
throw new NotImplementedException();
}
public List<GastropodaClass> ReadGastropoda(BasicSearch search)
{
throw new NotImplementedException();
}
/// <summary>
/// Reads a list of fish based on search
/// </summary>
/// <param name="search">Search pattern</param>
/// <returns>A list of fish. Empty list if no fish was found</returns>
public List<FishClass> ReadFish(BasicSearch search)
{
throw new NotImplementedException();
}
/// <summary>
/// Reads a list of crustacean based on search
/// </summary>
/// <param name="search">Search pattern</param>
/// <returns>A list of crustacean. Empty list if no crustaceans was found</returns>
public List<CrustaceanClass> ReadCrustacean(BasicSearch search)
{
throw new NotImplementedException();
}
/// <summary>
/// Reads a list of creature items from database
/// </summary>
/// <param name="search">The search pattern</param>
/// <returns>A list of Creatures. Empty list if no Creatures was found</returns>
public List<Creatures> Read(BasicSearch search)
{
List<Creatures> theList = new List<Creatures>();
using (MySqlConnection conn = getAConnection())
{
if (conn.State != System.Data.ConnectionState.Open)
{
using (MySqlCommand cmd = new MySqlCommand(SELECT_CREATURE, conn))
{
cmd.CommandText = SELECT_CREATURE + search.GetWhereClause();
try
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Creatures item = null;
CreatureTypes ct = (CreatureTypes)reader.GetInt32("creatuteType");
switch(ct)
{
case CreatureTypes.Crustacean:
item = new CrustaceanClass();
break;
case CreatureTypes.Fish:
item = new FishClass();
break;
case CreatureTypes.Gastropoda:
item = new GastropodaClass();
break;
case CreatureTypes.Plant:
item = new PlantClass();
break;
case CreatureTypes.Reptile:
item = new ReptileClass();
break;
}
if (item != null)
{
//CreatureIdentification
item.CurrentVersion = reader.GetDecimal("currentVersion");
item.Description.Danish = reader.GetString("danishDescription");
item.Description.English = reader.GetString("englishDescription");
item.Description.German = reader.GetString("germanDescription");
item.ID = reader.GetInt32("id");
item.ScientificName = this.ReadLatinName(reader.GetInt32("scientificNameId"));
item.Tradenames.Danish = reader.GetString("danishTradenames");
item.Tradenames.English = reader.GetString("englishTradenames");
item.Tradenames.German = reader.GetString("germanTradenames");
//Creatures
item.AquaLogCode = reader.GetString("aqualogCode");
item.CreatedByUser = reader.GetString("createdUser");
item.CreatedDateTime = reader.GetDateTime("createdDateTime");
item.DataSource = (EnumDataSource)reader.GetInt32("dataSource");
item.Family = this.ReadFamily(reader.GetInt32("familyId"));
item.Group = this.ReadGroup(reader.GetInt32("groupTypeId"));
item.Hardness.MaxValue = reader.GetDecimal("maxHardness");
item.Hardness.MinValue = reader.GetDecimal("minHardness");
item.Light.MaxLight = (EnumLight)reader.GetInt32("maxLight");
item.Light.MinLight = (EnumLight)reader.GetInt32("minLight");
item.OtherLiterature = this.ReadBook(item, BookListType.Other);
item.PH.MaxValue = reader.GetDecimal("maxPh");
item.PH.MinValue = reader.GetDecimal("minPh");
item.Pictures = this.ReadPicture(item);
item.Protected = this.ReadProtection(reader.GetInt32("protected"));
item.ReferenceBooks = this.ReadBook(item, BookListType.Reference);
item.Region = this.ReadRegion(reader.GetInt32("regionId"));
//item.Synonyms = this.reads // Missing from IDatabase
if (item is Animal)
{
//
}
theList.Add(item);
}
}
}
}
catch (SqlException ex)
{
handleDBError(new Delegates.DatabaseArgs(ex));
}
}
}
else
{
handleDBError(new Delegates.DatabaseArgs("Connection not open"));
}
}
return theList;
}