namespace 
{
    using †;
    using MySql.Data.MySqlClient;
    using System;
    using System.Data;

    internal class “ : IDisposable
    {
        private uint 
;
        private DateTime ;
        private  ;
        private MySqlConnection ;
        private MySqlCommand ;

        public void ()
        {
            try
            {
                this..Close();
            }
            catch
            {
            }
        }

        public DataTable (string sQuery)
        {
            DataTable dataTable = new DataTable();
            try
            {
                this..CommandText = sQuery;
                using (MySqlDataAdapter adapter = new MySqlDataAdapter(this.))
                {
                    adapter.Fill(dataTable);
                }
                this..CommandText = null;
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return dataTable;
        }

        public DataSet (string sQuery)
        {
            DataSet dataSet = new DataSet();
            try
            {
                this..CommandText = sQuery;
                using (MySqlDataAdapter adapter = new MySqlDataAdapter(this.))
                {
                    adapter.Fill(dataSet);
                }
                this..CommandText = null;
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return dataSet;
        }

        public void „()
        {
            if (this. == null)
            {
                throw new ("Connection instance of database client " + this.
 + " holds no value.");
            }
            if (this..State != ConnectionState.Closed)
            {
                throw new ("Connection instance of database client " + this.
 + " requires to be closed before it can open again.");
            }
            try
            {
                this..Open();
            }
            catch (MySqlException exception)
            {
                throw new (string.Concat(new object[] { "Failed to open connection for database client ", this.
, ", exception message: ", exception.Message }));
            }
        }

        public void †()
        {
            this.();
            this..Dispose();
            this. = null;
            this..Dispose();
            this. = null;
            this. = null;
        }

        public void ‡()
        {
            this. = DateTime.Now;
        }

        public void ˆ(string sParam, object val)
        {
            this..Parameters.AddWithValue(sParam, val);
        }

        public void ‰(string sQuery)
        {
            try
            {
                this..CommandText = sQuery;
                this..ExecuteScalar();
                this..CommandText = null;
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
        }

        public DataRow Š(string sQuery)
        {
            DataRow row = new DataTable().NewRow();
            try
            {
                this..CommandText = sQuery;
                DataSet dataSet = new DataSet();
                using (MySqlDataAdapter adapter = new MySqlDataAdapter(this.))
                {
                    adapter.Fill(dataSet);
                }
                row = dataSet.Tables[0].Rows[0];
            }
            catch
            {
            }
            return row;
        }

        public DataColumn ‹(string sQuery)
        {
            DataColumn column = new DataTable().Columns.Add();
            try
            {
                DataSet dataSet = new DataSet();
                this..CommandText = sQuery;
                using (MySqlDataAdapter adapter = new MySqlDataAdapter(this.))
                {
                    adapter.Fill(dataSet);
                }
                column = dataSet.Tables[0].Columns[0];
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return column;
        }

        public string Œ(string sQuery)
        {
            string str = "";
            try
            {
                this..CommandText = sQuery;
                str = this..ExecuteScalar().ToString();
                this..CommandText = null;
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return str;
        }

        public int (string sQuery)
        {
            int result = 0;
            try
            {
                this..CommandText = sQuery;
                try
                {
                    bool flag = int.TryParse(this..ExecuteScalar().ToString(), out result);
                }
                catch
                {
                }
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return result;
        }

        public bool Ž(string sQuery)
        {
            bool hasRows = false;
            try
            {
                this..CommandText = sQuery;
                MySqlDataReader reader = this..ExecuteReader();
                hasRows = reader.HasRows;
                reader.Close();
            }
            catch (Exception exception)
            {
                Ž.(exception.Message + "\n(^^" + sQuery + "^^)");
            }
            return hasRows;
        }

        public  ”()
        {
            return this.;
        }

        public “(uint Handle,  pManager)
        {
            if (pManager == null)
            {
                throw new ArgumentNullException("pManager");
            }
            this.
 = Handle;
            this. = pManager;
            this. = new MySqlConnection(this..());
            this. = this..CreateCommand();
            this.‡();
        }

        public void Dispose()
        {
            if (!this.‚())
            {
                this..CommandText = null;
                this..Parameters.Clear();
                this..Ÿ(this.
);
            }
            else
            {
                this.†();
            }
        }

        public uint Handle
        {
            get
            {
                return this.
;
            }
        }

        public int Inactivity
        {
            get
            {
                TimeSpan span = (TimeSpan) (DateTime.Now - this.);
                return (int) span.TotalSeconds;
            }
        }

        public bool isAnonymous
        {
            get
            {
                return (this.
 == 0);
            }
        }

        public DateTime lastActivity
        {
            get
            {
                return this.;
            }
        }

        public ConnectionState State
        {
            get
            {
                return ((this. != null) ? this..State : ConnectionState.Broken);
            }
        }
    }
}