HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AVEVA.PID.CustomizationUtility.DB

{

    public class DB

    {

        public static string GetConnectionString()

        {

            string strConn = string.Empty;

            if (Utilities.strSQLWinAuthentication.ToUpper() == "YES")

            {

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Integrated Security=SSPI;Initial Catalog={0};", Utilities.strSQLDatabaseName);

            }

            else if (Utilities.strSQLWinAuthentication.ToUpper() == "NO")

            {

                string strAccessString = "User ID=" + Utilities.strSQLUserName + ";Password=" + Utilities.strSQLPassword;

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Initial Catalog=" + Utilities.strSQLDatabaseName + ";" + strAccessString);

            }

            return strConn;

        }

    }

}