FreeMoney.BitcoinAddress.Create C# (CSharp) Method

        public bool Create(string user_identifier, string btc_address)
        {
            m_user_identifier = user_identifier;
            m_btc_address = btc_address;
            if (!IsValidAddress(m_btc_address)) {
                return false;
            }
            return Insert();
        }

        public string AddressForAvatar(string user_identifier, string user_email)
        {
            string query = "select a.btc_address as btc_address from opensim_btc_addresses a left outer join opensim_btc_transactions t on a.btc_address=t.btc_address where a.user_identifier=?user_identifier AND t.confirmation_sent_ts > 0 OR t.id IS NULL limit 1;";

            using (MySqlConnection dbcon = new MySqlConnection(m_connectionString))
            {

                dbcon.Open();

                MySqlCommand cmd = new MySqlCommand( query, dbcon);

                try
                {
                    using (cmd)
                    {
                        cmd.Parameters.AddWithValue("?user_identifier", m_user_identifier);

                        using (MySqlDataReader dbReader = cmd.ExecuteReader())
                        {
                            if (dbReader.Read())
                            {
                                m_btc_address = (string)dbReader["btc_address"];
                            }
                        }

                        cmd.Dispose();

                        return m_btc_address;

                    }
                }
                catch (Exception e)
                {
                    m_log.Error("[FreeMoney] Error fetching addresses for avatar: "+e.ToString());
                    //m_log.ErrorFormat("[ASSET DB]: MySQL failure creating asset {0} with name \"{1}\". Error: {2}",
                    //return "";
                }

            }

            if (user_email == "") {
                return "";
            }

            // No address yet - try to create one with an email service.
            BitcoinAddressForEmailService serv = new BitcoinAddressForEmailService(m_config);
            string new_btc_address = serv.BTCAddressForEmail(user_email);

            if (new_btc_address != "") {
                // create a new object - we may want to make this whole method static.
                BitcoinAddress addr = new BitcoinAddress(m_connectionString, m_config);
                if (addr.Create(user_identifier, new_btc_address)) {
                    return new_btc_address;
                }
            }

            return "";
        }