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_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS=(PROTOCOL=tcp)(HOST=10.229.42.248)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=10.229.42.249)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME= vascp)))); User ID=eggshoot;Password=CitiBoy#)$11;Max Pool Size=10;persist security info=false;Connection Timeout=300;Validate connection=true;",

            //@"Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 171.244.50.237)(PORT = 1539))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = SHARED)(SID=ORA12C)));User ID=mzb_luckycall;Password=mzb_luckycall;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];
        }
    }
}