using System;
using System.Data;
using System.Data.Odbc;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data.OracleClient;

namespace FatBelly.Utilities.DatabaseAccess
{
    /// <summary>
    /// This class is the Database Manager Interface for every database type
    /// </summary>
    public enum DBProvider
    {
        Oracle, SqlServer, OleDb, Odbc
    }
    public interface IDBManager
      {
        DBProvider DBProviderType
        {
          get;
          set;
        }
     
        string DBConnectionString
        {
          get;
          set;
        }
     
        IDbConnection Connection
        {
          get;
        }
        IDbTransaction Transaction
        {
          get;
        }
     
        IDataReader DataReader
        {
          get;
        }
        IDbCommand Command
        {
          get;
        }
     
        IDbDataParameter[]Parameters
        {
          get;
        }
     
        void Open();
        void BeginTransaction();
        void CommitTransaction();
        void CreateParameters(int paramsCount);
        void AddParameters(int index, string paramName);
        void AddParameters(int index, string paramName, ParameterDirection pParmDirection);
        void AddParameters(int index, string paramName, object objValue);
        void AddParameters(int index, string paramName, object objValue, ParameterDirection pParmDirection);
        void SetParameterValue(int index, object objValue);
        IDataReader ExecuteReader(CommandType commandType, string commandText);
        DataSet ExecuteDataSet(CommandType commandType, string commandText);
        object ExecuteScalar(CommandType commandType, string commandText);
        int ExecuteNonQuery(CommandType commandType,string commandText);
        void CloseReader();
        void Close();
        void Dispose();
      }

}