HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Configuration;

using System.IO;

using ID2.Manager.Dapper;

using ID2.Manager.Data.Models;

using ID2.Manager.Common;

namespace ID2.Manager.Controller.Controllers

{

    public class BaseController

    {

        public Exception Exception;

        public readonly string _MSSQLCONNSTR;

        public readonly string _SQLITECONNSTR;

        public readonly string _MARKUSCONNSTR;

        public readonly string _ID2CONNSTR;

        public BaseController() : this(null) { }

        public BaseController(ID2ProjectInfo id2Info)

        {

            this._MSSQLCONNSTR = ConfigurationManager.ConnectionStrings["ID2Manager"].ConnectionString;

            this._SQLITECONNSTR = Globals.GetProjectDBConnstr(); //String.Format(ConfigurationManager.AppSettings["ID2SQLite"], Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile), ConfigurationManager.AppSettings["ID2SQLiteInfo"]));

            this._MARKUSCONNSTR = ConfigurationManager.ConnectionStrings["Markus"].ToString();

            if (id2Info == null || id2Info.Id <= 0)

            {

                this._ID2CONNSTR = string.Empty;

            }

            else

            {

                DatabaseType DBType = (DatabaseType)Enum.Parse(typeof(DatabaseType), id2Info.DBTypeName.ToUpper());

                switch (DBType)

                {

                    case DatabaseType.MSSQL:

                        this._ID2CONNSTR = String.Format(ConfigurationManager.ConnectionStrings["ID2Project"].ConnectionString, id2Info.Host.Replace(":",","), id2Info.DBPath, id2Info.User, id2Info.Password);

                        break;

                    case DatabaseType.SQLITE:

                        this._ID2CONNSTR = String.Format(ConfigurationManager.AppSettings["ID2SQLite"], id2Info.DBPath);

                        break;

                    default:

                        this._ID2CONNSTR = string.Empty;

                        break;

                }

            }

        }

    }

}