using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;

namespace Db_Core
{
    public enum SqlConnString
    {
        GAMEPORTAL
    };


    public enum ConnectionType
    {
        ORACLE = 1,
        POSTGRE = 2,
        MYSQL = 3
    }

    public abstract class SqlCommon
    {
        public static string[] ConnectionStrings = new string[]
        {
            //ConfigurationManager.AppSettings["connectionString"]
            @"Data Source=(DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 10.228.101.115)(PORT = 1521))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = pdbvas1)
                )
              ); User ID=lucky_call_app;Password=Lh@aCl#12)pP;Max Pool Size=5;persist security info=false;Connection Timeout=300;Validate connection=true;",

            //@"Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1561))(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1561))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = SHARED)(SERVICE_NAME = pdbvas1)))
            //;User ID=lucky_call_app;Password=Lh@aCl#12)pP;Max Pool Size=10;persist security info=false;Connection Timeout=120;Validate connection=true;"

            //@"Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.228.101.115)(PORT = 1521))(CONNECT_DATA =(SERVER = SHARED)(SERVICE_NAME = pdbvas1)))
            //;User ID=lucky_call_app;Password=Lh@aCl#12)pP;Max Pool Size=5;persist security info=false;Connection Timeout=120;Validate connection=true;"
        };

        public static string GetConnectionString(SqlConnString str)
        {
            return ConnectionStrings[(int)str];
        }
    }
}