/// <summary> /// Updates the integration service. /// </summary> /// <param name="dto">The dto.</param> /// <exception cref="System.ArgumentNullException">dto</exception> /// <exception cref="System.Data.DBConcurrencyException"></exception> public void UpdateIntegrationService(ProcessIntegrationServiceDto dto) { const string CommandText = @" UPDATE [dbo].[IntegrationServices] SET [ProcessId] = @processId ,[Guid] = @guid ,[LastModifiedOn] = GETDATE() ,[Name] = @name ,[Direction] = @direction ,[Documentation] = @documentation WHERE [Id] = @id;"; if (dto == null) throw new ArgumentNullException("dto"); using (var cmd = new SqlCommand(CommandText)) { cmd.Parameters.AddWithValue("@id", dto.Id); cmd.Parameters.AddWithValue("@processId", dto.ProcessId); cmd.Parameters.AddWithValue("@guid", dto.Guid); cmd.Parameters.AddWithValue("@name", dto.Name); cmd.Parameters.AddWithValue("@direction", dto.Direction.ToString()); cmd.Parameters.AddWithValue("@documentation", dto.Documentation); var rowsAffected = Database.Execute(cmd); if (rowsAffected == 0) throw new DBConcurrencyException(ConcurencyException); } }
/// <summary> /// Reads the integration services. /// </summary> /// <param name="process">The process.</param> /// <param name="sr">The sr.</param> private static void ReadIntegrationServices(ProcessEditDto process, SafeDataReader sr) { sr.NextResult(); while (sr.Read()) { var dto = new ProcessIntegrationServiceDto { Id = sr.GetInt32(0), Guid = sr.GetGuid(1), Name = sr.GetString(2), Direction = (IntegrationServiceDirection) Enum.Parse(typeof(IntegrationServiceDirection), sr.GetString(3), true), Documentation = sr.GetString(4) }; process.IntegrationServiceList.Add(dto); } }
/// <summary> /// Inserts the integration service. /// </summary> /// <param name="dto">The dto.</param> /// <exception cref="System.ArgumentNullException">dto</exception> /// <exception cref="System.Data.DBConcurrencyException"></exception> public void InsertIntegrationService(ProcessIntegrationServiceDto dto) { const string CommandText = @" INSERT INTO [dbo].[IntegrationServices] ( [ProcessId] ,[Guid] ,[LastModifiedOn] ,[Name] ,[Direction] ,[Documentation] ) VALUES ( @processId ,@guid ,GETDATE() ,@name ,@direction ,@documentation ); SET @id = SCOPE_IDENTITY();"; if (dto == null) throw new ArgumentNullException("dto"); using (var cmd = new SqlCommand(CommandText)) { var idParam = cmd.Parameters.Add("@id", SqlDbType.Int); idParam.Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@processId", dto.ProcessId); cmd.Parameters.AddWithValue("@guid", dto.Guid); cmd.Parameters.AddWithValue("@name", dto.Name); cmd.Parameters.AddWithValue("@direction", dto.Direction.ToString()); cmd.Parameters.AddWithValue("@documentation", dto.Documentation); var rowsAffected = Database.Execute(cmd); if (rowsAffected == 0) throw new DBConcurrencyException(ConcurencyException); dto.Id = (int)idParam.Value; } }