//Runs the given parameters for the Select Query and returns Bool (true/False_ for results.
        //Results if exists are stored in GlobalSettings.ASqlResultsTable for use later
        public static bool CheckSqlRecordExists(
            string aTableName,
            string aWhereColumn,
            float aValue,
            List<string> aSelectColumn = null)
        {
            //Clear existing Table Results
            GlobalSettings.ASqlResultsTable = null;
            _aConCatSelect = "*";
            _objDataAccess = new DataAccess
                (
                GlobalSettings.AServer,
                GlobalSettings.ADatabase,
                GlobalSettings.AUser,
                GlobalSettings.APassword);
            string aParenttable = aTableName;

            if (aSelectColumn != null)
            {
                _aConCatSelect = "";
                int i = 0;
                int max = aSelectColumn.Count - 1;
                foreach (string aSelect in aSelectColumn)
                {
                    if (i < max)
                    {
                        _aConCatSelect = _aConCatSelect + aSelect + ",";
                        i++;
                    }
                    else
                    {
                        _aConCatSelect = _aConCatSelect + aSelect;
                        i++;
                    }
                }
            }

            DataTable adt =
                _objDataAccess.GetDataTable
                    (
                        "select " + _aConCatSelect + " from " + aParenttable + " where " +
                        aWhereColumn + " = '" + aValue + "'");

            if (adt != null && adt.Rows.Count > 0)
            {
                //Save results information for use later
                GlobalSettings.ASqlResultsTable = adt;
            }
            else
            {
                GlobalSettings.ASqlResultsTable = null;
                return false;
            }
            return true;
        }
        public static int GetSequenceNumber(
            SqlParameter sqlParameter,
            string seqTableName,
            string aTableName)
        {
            var dataAccess = new DataAccess
                (
                _appsettings.AServerAddress,
                _appsettings.ADatabaseName,
                _appsettings.AUserName,
                _appsettings.APassword);
            int nextSequence = dataAccess.GetNextSequence
                (
                    seqTableName,
                    aTableName);

            return nextSequence;
        }