Esempio n. 1
0
 /// <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();
 }
Esempio n. 2
0
 public List<PlantClass> ReadPlant(BasicSearch search)
 {
     throw new NotImplementedException();
 }
Esempio n. 3
0
 public List<GastropodaClass> ReadGastropoda(BasicSearch search)
 {
     throw new NotImplementedException();
 }
Esempio n. 4
0
 /// <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();
 }
Esempio n. 5
0
 /// <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();
 }
Esempio n. 6
0
        /// <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;
        }