Exemple #1
0
 private void SetContactoEmergenciaUpdateCommandOutputs(SqlCommand cmd, ContactoEmergenciaUpdateOutput output)
 {
     if (cmd.Parameters[4].Value != DBNull.Value)
     {
         output.ReturnValue = (ContactoEmergenciaUpdateOutput.Returns)cmd.Parameters[4].Value;
     }
 }
Exemple #2
0
        /// <summary>
        /// Updates record for the dbo.ContactoEmergencia table.
        /// SQL+ Routine: dbo.ContactoEmergenciaUpdate - Authored by IvoStrficek
        /// </summary>
        public ContactoEmergenciaUpdateOutput ContactoEmergenciaUpdate(IContactoEmergenciaUpdateInput input)
        {
            if (!input.IsValid())
            {
                throw new ArgumentException("ContactoEmergenciaUpdateInput fails validation - use the ContactoEmergenciaUpdateInput.IsValid() method prior to passing the input argument to the ContactoEmergenciaUpdate method.", "input");
            }

            ContactoEmergenciaUpdateOutput output = new ContactoEmergenciaUpdateOutput();

            if (sqlConnection != null)
            {
                using (SqlCommand cmd = GetContactoEmergenciaUpdateCommand(sqlConnection, input))
                {
                    cmd.Transaction = sqlTransaction;
                    ContactoEmergenciaUpdateCommand(cmd, output);
                }
                return(output);
            }
            for (int idx = 0; idx <= retryOptions.RetryIntervals.Count; idx++)
            {
                if (idx > 0)
                {
                    System.Threading.Thread.Sleep(retryOptions.RetryIntervals[idx - 1]);
                }
                try
                {
                    using (SqlConnection cnn = new SqlConnection(connectionString))
                        using (SqlCommand cmd = GetContactoEmergenciaUpdateCommand(cnn, input))
                        {
                            cnn.Open();
                            ContactoEmergenciaUpdateCommand(cmd, output);
                            cnn.Close();
                        }
                    break;
                }
                catch (SqlException sqlException)
                {
                    bool throwException = true;

                    if (retryOptions.TransientErrorNumbers.Contains(sqlException.Number))
                    {
                        throwException = (idx == retryOptions.RetryIntervals.Count);

                        if (retryOptions.Logger != null)
                        {
                            retryOptions.Logger.Log(sqlException);
                        }
                    }
                    if (throwException)
                    {
                        throw;
                    }
                }
            }
            return(output);
        }
Exemple #3
0
        private void ContactoEmergenciaUpdateCommand(SqlCommand cmd, ContactoEmergenciaUpdateOutput output)
        {
            cmd.ExecuteNonQuery();

            SetContactoEmergenciaUpdateCommandOutputs(cmd, output);
        }