Ejemplo n.º 1
0
        public async Task <bool> DeleteAsync(BudgetViewObject data)
        {
            var presup1 = new PRESUP1()
            {
                NUMERO_PRE = data.NUMERO_PRE
            };
            var presup2 = new PRESUP2()
            {
                NUMERO_PRE = data.NUMERO_PRE
            };
            var resultValue = false;

            using (var deleter = _sqlExecutor.OpenNewDbConnection())
            {
                using (var transactionScope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
                {
                    resultValue = await DeleteHelper.DeleteAsync <PRESUP1, PRESUP2, PRESUP1>(_sqlExecutor, presup1, presup2);

                    if (resultValue)
                    {
                        transactionScope.Complete();
                    }
                    else
                    {
                        transactionScope.Dispose();
                    }
                }
            }
            return(resultValue);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Get a new identifier.
        /// </summary>
        /// <returns>Returns an unique identifier for the budget.</returns>
        public string NewId()
        {
            string uniqueId = string.Empty;

            using (var connection = SqlExecutor.OpenNewDbConnection())
            {
                if (connection != null)
                {
                    var pet = new PRESUP1();
                    uniqueId = connection.UniqueId(pet);
                    return(uniqueId);
                }
            }
            return(uniqueId);
        }