CentralMine.NET.EventLog.GetMemberId C# (CSharp) Method

        uint GetMemberId(string memberName)
        {
            if (memberName.Length > 64)
                memberName = memberName.Substring(0, 64);

            if (!mMemberIDs.ContainsKey(memberName))
            {
                string sql = "INSERT INTO members (member_name) VALUES ('" + memberName + "')";
                try
                {

                    MySqlCommand cmd = new MySqlCommand(sql, mSql);
                    cmd.ExecuteNonQuery();

                    // Now querry the database for the index
                    sql = "SELECT * FROM members WHERE member_name='" + memberName + "'";
                    cmd = new MySqlCommand(sql, mSql);
                    MySqlDataReader r = cmd.ExecuteReader();
                    r.Read();
                    uint ID = (uint)r[0];
                    r.Close();

                    mMemberIDs[memberName] = ID;
                }
                catch (Exception ex)
                {
                    Email.SendErrorEmail(sql + "\n\n" + ex.ToString());
                }
            }

            return mMemberIDs[memberName];
        }