using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DarkWynter.Engine.Networking.Database
{
    public class DataBaseConnection
    {

        private System.Data.Odbc.OdbcConnection OdbcCon;
        private System.Data.Odbc.OdbcCommand OdbcCom;
        private System.Data.Odbc.OdbcDataReader OdbcDR;
        private string ConStr;

        public DataBaseConnection(string IPAddr, string Port, string DBName, string userID, string password)
        {
            ConStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + IPAddr +
                ";PORT=" + Port + ";DATABASE=" + DBName +
                ";UID=" + userID + ";PWD=" + password + ";OPTION=3";
            OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr);
        }

        public bool Connect()
        {
            try
            {
                if (OdbcCon.State == ConnectionState.Closed)
                {
                    OdbcCon.Open();
                }
            }
            catch (System.Data.Odbc.OdbcException Ex)
            {
                return false;
            }
            return true;
        }

        public bool Disconnect()
        {
            if (OdbcCon.State == ConnectionState.Open)
            {
                OdbcCon.Close();
            }
            return true;
        }

        public string ListTables()
        {
            string text = "";
            if (OdbcCon.State == ConnectionState.Open)
            {
                OdbcCom = new System.Data.Odbc.OdbcCommand("SHOW TABLES", OdbcCon);
                OdbcDR = OdbcCom.ExecuteReader();

                text += "Tables inside database:\r\n";
                while (OdbcDR.Read())
                {
                    text += ">> " + OdbcDR[0] + "\r\n";
                }
            }
            return text;
        }

    }
}