public static CatalogItem GetByItemName(string itemName)
        {
            CatalogItem catalogItem = new CatalogItem();

            using (ObjectConnection objectConnection = new ObjectConnection())
            {
                using (GetCatalogItemByItemNameCommand objectCommand = new GetCatalogItemByItemNameCommand(objectConnection))
                {
                    objectCommand.ItemName = itemName;

                    objectConnection.Open();
                    using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
                    {
                        if (!sqlDataReader.HasRows)
                        {
                            return catalogItem;
                        }

                        using (CatalogItemSqlDataReader objectSqlDataReader = new CatalogItemSqlDataReader(sqlDataReader))
                        {
                            while (objectSqlDataReader.Read())
                            {
                                catalogItem = objectSqlDataReader.CatalogItem;
                            }
                        }
                    }
                }
            }

            return catalogItem;
        }
        public static List<CatalogItem> GetByManufacturer(string manufacturer)
        {
            List<CatalogItem> catalogItemList = new List<CatalogItem>();

            using (ObjectConnection objectConnection = new ObjectConnection())
            {
                using (GetCatalogItemByManufacturerCommand objectCommand = new GetCatalogItemByManufacturerCommand(objectConnection))
                {
                    objectCommand.Manufacturer = manufacturer;

                    objectConnection.Open();
                    using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
                    {
                        if (!sqlDataReader.HasRows)
                        {
                            return catalogItemList;
                        }

                        using (CatalogItemSqlDataReader objectSqlDataReader = new CatalogItemSqlDataReader(sqlDataReader))
                        {
                            while (objectSqlDataReader.Read())
                            {
                                catalogItemList.Add(objectSqlDataReader.CatalogItem);
                            }
                        }
                    }
                }
            }

            return catalogItemList;
        }