DP44/DataPRO/DASFactoryDb/DAS/DAS.cs

using System;
using System.Data;
using System.Data.SqlClient;

namespace DASFactoryDb.DAS
{
    public static class DAS
    {
        public static int InsertDASSimple(string serialNumber,
            string firmwareVersion,
            string connectString)
        {
            using (var cmd = DbWrapper.GetDASFactoryCommand())
            {
                try
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "sp_IDASCommunicationTableSimpleInsert";
                    cmd.Parameters.Add(new SqlParameter("@SerialNumber", SqlDbType.NVarChar, 50)
                    { Value = serialNumber });
                    cmd.Parameters.Add(new SqlParameter("@FirmwareVersion", SqlDbType.NVarChar, 50)
                    { Value = firmwareVersion });
                    cmd.Parameters.Add(new SqlParameter("ConnectString", SqlDbType.NVarChar, 255)
                    { Value = connectString });

                    var errorNumber = new SqlParameter("@errorNumber", SqlDbType.Int) { Direction = ParameterDirection.Output };
                    cmd.Parameters.Add(errorNumber);

                    var errorMessage = new SqlParameter("@errorMessage", SqlDbType.NVarChar, 255)
                    { Direction = ParameterDirection.Output };
                    cmd.Parameters.Add(errorMessage);

                    var newId = new SqlParameter("@new_id", SqlDbType.Int)
                    { Direction = ParameterDirection.Output };
                    cmd.Parameters.Add(newId);

                    cmd.ExecuteNonQuery();
                    DbWrapper.ProcessReturn(errorNumber, errorMessage);
                    return Convert.ToInt32(newId.Value);
                }
                finally
                {
                    cmd.Connection.Dispose();
                }
            }
        }
    }
}