/// <summary>
        /// Tests the DB connection.
        /// </summary>
        /// <param name="connStr">The conn STR.</param>
        /// <returns></returns>
        public bool TestDBConnection(string connStr)
        {
            PostgreSQLDB postDb = new PostgreSQLDB(connStr);

            try
            {
                postDb.OpenConnection();
                postDb.CloseConnection();
                return(true);
            }
            catch (Exception ex)
            {
                postDb.CloseConnection();
                postDb = null;
                return(false);
            }
        }