ConnectInfo.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace MyCaffe.basecode
{
    [Serializable]
    public class ConnectInfo
    {
        TYPE m_location = TYPE.NONE;
        string m_strServer;
        string m_strUn;
        string m_strPw;
        string m_strDb;
 
        public enum TYPE
        {
            NONE,
            LOCAL,
            REMOTE,
            AZURE
        }
 
        public ConnectInfo(string strServer = null, string strDb = "DNN", string strUn = null, string strPw = null, TYPE location = TYPE.NONE)
        {
            m_strServer = strServer;
            m_strDb = strDb;
            m_strUn = strUn;
            m_strPw = strPw;
            m_location = location;
        }
 
        public bool Compare(ConnectInfo ci)
        {
            if (ci.Server != m_strServer)
                return false;
 
            if (ci.Database != m_strDb)
                return false;
 
            if (ci.Username != m_strUn)
                return false;
 
            if (ci.Password != m_strPw)
                return false;
 
            if (ci.Location != m_location)
                return false;
 
            return true;
        }
 
        public override string ToString()
        {
            if (m_strServer == null)
                return m_strDb;
 
            if (m_strServer == "AZURE")
                return m_strServer;
 
            return m_strServer + "\\" + m_strDb;
        }
 
        public string ToString(string strAzure)
        {
            if (m_strServer.Contains(strAzure))
                return "AZURE";
 
            return ToString();
        }
 
        public TYPE Location
        {
            get { return m_location; }
            set { m_location = value; }
        }
 
        public string Server
        {
            get { return m_strServer; }
            set { m_strServer = value; }
        }
 
        public string Database
        {
            get { return m_strDb; }
            set { m_strDb = value; }
        }
 
        public string Username
        {
            get { return m_strUn; }
        }
 
        public string Password
        {
            get { return m_strPw; }
        }
 
        public string ToInfoString()
        {
            if (Server == "DEFAULT" || Server == "AZURE")
                return Server;
 
            return Server + ";" + Database + ";" + Username + ";" + Password;
        }
 
        public string ToKeyValuePairs()
        {
            string str = "";
 
            str += "Type\t" + Location.ToString() + ";";
            str += "Server\t" + Server + ";";
            str += "Database\t" + Database + ";";
            str += "Username\t" + Username + ";";
            str += "Password\t" + Password + ";";
 
            return str;
        }
 
        public static ConnectInfo ParseKeyValuePairs(string strKeyValPairs)
        {
            string[] rgstr = strKeyValPairs.Split(';');
            string strServer = null;
            string strDatabase = null;
            string strUsername = null;
            string strPassword = null;
            string strType = null;
            TYPE location = TYPE.NONE;
 
            foreach (string str1 in rgstr)
            {
                if (!string.IsNullOrEmpty(str1))
                {
                    string[] rgstr1 = str1.Split('\t');
                    if (rgstr1.Length != 2)
                        throw new Exception("ConnectInfo: Invalid key-value pair!");
 
                    if (rgstr1[0] == "Type")
                        strType = rgstr1[1];
 
                    else if (rgstr1[0] == "Server")
                        strServer = rgstr1[1];
 
                    else if (rgstr1[0] == "Database")
                        strDatabase = rgstr1[1];
 
                    else if (rgstr1[0] == "Username")
                        strUsername = rgstr1[1];
 
                    else if (rgstr1[0] == "Password")
                        strPassword = rgstr1[1];
                }
            }
 
            if (strType == TYPE.AZURE.ToString())
                location = TYPE.AZURE;
            else if (strType == TYPE.REMOTE.ToString())
                location = TYPE.REMOTE;
            else if (strType == TYPE.LOCAL.ToString())
                location = TYPE.LOCAL;
 
            if (strServer.Length == 0)
                strServer = null;
 
            if (strDatabase.Length == 0)
                strDatabase = null;
 
            if (strUsername.Length == 0)
                strUsername = null;
 
            if (strPassword.Length == 0)
                strPassword = null;
 
            return new ConnectInfo(strServer, strDatabase, strUsername, strPassword, location);
        }
    }
}