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