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);
        }
        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;
        }