public UMSContext GetConnection(string databaseId)
        {
            //HttpClient client = new HttpClient();
            //client.DefaultRequestHeaders.Add("Authorization", "Bearer " + accessToken);

            //HttpResponseMessage response = client.GetAsync(ConfigurationManager.AppSettings["UMS_URL"] + "/api/User/GetUserDetailsByID?userId=" + userId).Result;
            //if (response.IsSuccessStatusCode)
            //{
            //    var responseResult = response.Content.ReadAsStringAsync().Result;
            //    if (responseResult != "\"Content not found id = " + userId + "\"" && responseResult != "Content not found id = " + userId)
            //    {
            //        return true;
            //    }
            //}
            //throw new Exception("Invalid userId");

            var db = (from c in _masterDbContext.Clients
                      where c.DBName == databaseId
                      select new DBCredentials
            {
                ClientID = c.ClientID,
                DBName = c.DBName,
                DBPassword = c.DBPassword,
                DBServer = c.DBServer,
                DBUserId = c.DBUserId
            }).FirstOrDefault();

            if (db != null)
            {
                _clientDbContext = new UMSContext(ConnectionTools.GetClientConnection(db));
            }
            return(_clientDbContext);
        }
 public BaseRepository()
 {
     if (Convert.ToBoolean(ConfigurationManager.AppSettings["IsNon_PCRDB"]) == true)
     {
         _masterDbContext = new UMSContext(ConnectionTools.GetMasterConnection());
     }
     else
     {
         _masterDbContext = new UMSContext(ConnectionTools.GetMasterDbConnection());
     }
 }
        /// <summary>
        /// Constructor for public access, creates a connection without an existing PCR-ID
        /// </summary>
        /// <param name="databaseId">DatabaseId to connect to</param>
        public BaseRepository(string databaseId)
        {
            if (Convert.ToBoolean(ConfigurationManager.AppSettings["IsNon_PCRDB"]) == true)
            {
                _masterDbContext = new UMSContext(ConnectionTools.GetMasterConnection());

                GetConnection(databaseId);
            }
            else
            {
                _connectionInfo  = ConnectionTools.GetOnboardingDbConnection(databaseId);
                _masterDbContext = new UMSContext(_connectionInfo.MasterDBConnection);
                _clientDbContext = new UMSContext(_connectionInfo.ClientDBConnection);
            }
        }