DELETE FROM [dbo].[ColorProfiles] WHERE (([Id] = @Original_Id) AND ([ProfileName] = @Original_ProfileName) AND ([ArcWidth] = @Original_ArcWidth) AND ([LayerId] = @Original_LayerId)) INSERT INTO [dbo].[ColorProfiles] ([ProfileName], [TraceProfile], [KeyPoints], [ArcWidth], [LayerId]) VALUES (@ProfileName, @TraceProfile, @KeyPoints, @ArcWidth, @LayerId); SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM ColorProfiles WHERE (Id = SCOPE_IDENTITY()) SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM dbo.ColorProfiles UPDATE [dbo].[ColorProfiles] SET [ProfileName] = @ProfileName, [TraceProfile] = @TraceProfile, [KeyPoints] = @KeyPoints, [ArcWidth] = @ArcWidth, [LayerId] = @LayerId WHERE (([Id] = @Original_Id) AND ([ProfileName] = @Original_ProfileName) AND ([ArcWidth] = @Original_ArcWidth) AND ([LayerId] = @Original_LayerId)); SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM ColorProfiles WHERE (Id = @Id) DELETE FROM [dbo].[Layers] WHERE (([Id] = @Original_Id) AND ([Order] = @Original_Order) AND ([LayerName] = @Original_LayerName) AND ([TechnologyName] = @Original_TechnologyName) AND ([OpticalSchema] = @Original_OpticalSchema) AND ([ProjectId] = @Original_ProjectId) AND ([TechnologyId] = @Original_TechnologyId) AND ([ArcWidth] = @Original_ArcWidth) AND ([RadiusMax] = @Original_RadiusMax) AND ([Step] = @Original_Step) AND ((@IsNull_FullMask = 1 AND [FullMask] IS NULL) OR ([FullMask] = @Original_FullMask)) AND ((@IsNull_TileMask = 1 AND [TileMask] IS NULL) OR ([TileMask] = @Original_TileMask))) INSERT INTO [dbo].[Layers] ([Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (@Order, @LayerName, @TechnologyName, @OpticalSchema, @ProjectId, @TechnologyId, @ArcWidth, @RadiusMax, @Step, @SourceFilePath, @AnglesFilePath, @FullMask, @TileMask); SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM Layers WHERE (Id = SCOPE_IDENTITY()) SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM dbo.Layers UPDATE [dbo].[Layers] SET [Order] = @Order, [LayerName] = @LayerName, [TechnologyName] = @TechnologyName, [OpticalSchema] = @OpticalSchema, [ProjectId] = @ProjectId, [TechnologyId] = @TechnologyId, [ArcWidth] = @ArcWidth, [RadiusMax] = @RadiusMax, [Step] = @Step, [SourceFilePath] = @SourceFilePath, [AnglesFilePath] = @AnglesFilePath, [FullMask] = @FullMask, [TileMask] = @TileMask WHERE (([Id] = @Original_Id) AND ([Order] = @Original_Order) AND ([LayerName] = @Original_LayerName) AND ([TechnologyName] = @Original_TechnologyName) AND ([OpticalSchema] = @Original_OpticalSchema) AND ([ProjectId] = @Original_ProjectId) AND ([TechnologyId] = @Original_TechnologyId) AND ([ArcWidth] = @Original_ArcWidth) AND ([RadiusMax] = @Original_RadiusMax) AND ([Step] = @Original_Step) AND ((@IsNull_FullMask = 1 AND [FullMask] IS NULL) OR ([FullMask] = @Original_FullMask)) AND ((@IsNull_TileMask = 1 AND [TileMask] IS NULL) OR ([TileMask] = @Original_TileMask))); SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM Layers WHERE (Id = @Id) DELETE FROM [dbo].[Projects] WHERE (([Id] = @Original_Id) AND ([ProjectName] = @Original_ProjectName) AND ([Created] = @Original_Created) AND ([LastUpdated] = @Original_LastUpdated) AND ([HologramWidth] = @Original_HologramWidth) AND ([HologramHeight] = @Original_HologramHeight) AND ([FrameWidth] = @Original_FrameWidth) AND ([FrameHeight] = @Original_FrameHeight) AND ([FrameResolutionX] = @Original_FrameResolutionX) AND ([FrameResolutionY] = @Original_FrameResolutionY) AND ([GrayRangeHigh] = @Original_GrayRangeHigh) AND ([GrayRangeLow] = @Original_GrayRangeLow)) INSERT INTO [dbo].[Projects] ([ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (@ProjectName, @OutPath, @Created, @LastUpdated, @HologramWidth, @HologramHeight, @FrameWidth, @FrameHeight, @FrameResolutionX, @FrameResolutionY, @GrayRangeHigh, @GrayRangeLow); SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM Projects WHERE (Id = SCOPE_IDENTITY()) SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM dbo.Projects UPDATE [dbo].[Projects] SET [ProjectName] = @ProjectName, [OutPath] = @OutPath, [Created] = @Created, [LastUpdated] = @LastUpdated, [HologramWidth] = @HologramWidth, [HologramHeight] = @HologramHeight, [FrameWidth] = @FrameWidth, [FrameHeight] = @FrameHeight, [FrameResolutionX] = @FrameResolutionX, [FrameResolutionY] = @FrameResolutionY, [GrayRangeHigh] = @GrayRangeHigh, [GrayRangeLow] = @GrayRangeLow WHERE (([Id] = @Original_Id) AND ([ProjectName] = @Original_ProjectName) AND ([Created] = @Original_Created) AND ([LastUpdated] = @Original_LastUpdated) AND ([HologramWidth] = @Original_HologramWidth) AND ([HologramHeight] = @Original_HologramHeight) AND ([FrameWidth] = @Original_FrameWidth) AND ([FrameHeight] = @Original_FrameHeight) AND ([FrameResolutionX] = @Original_FrameResolutionX) AND ([FrameResolutionY] = @Original_FrameResolutionY) AND ([GrayRangeHigh] = @Original_GrayRangeHigh) AND ([GrayRangeLow] = @Original_GrayRangeLow)); SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM Projects WHERE (Id = @Id) DELETE FROM [dbo].[Technology] WHERE (([Id] = @Original_Id) AND ([TechnologyName] = @Original_TechnologyName) AND ([Step] = @Original_Step) AND ([Radius] = @Original_Radius) AND ([ArcWidth] = @Original_ArcWidth)) INSERT INTO [dbo].[Technology] ([TechnologyName], [ImagePath], [AnglesPath], [Step], [Radius], [ArcWidth]) VALUES (@TechnologyName, @ImagePath, @AnglesPath, @Step, @Radius, @ArcWidth); SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM Technology WHERE (Id = SCOPE_IDENTITY()) SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM dbo.Technology UPDATE [dbo].[Technology] SET [TechnologyName] = @TechnologyName, [ImagePath] = @ImagePath, [AnglesPath] = @AnglesPath, [Step] = @Step, [Radius] = @Radius, [ArcWidth] = @ArcWidth WHERE (([Id] = @Original_Id) AND ([TechnologyName] = @Original_TechnologyName) AND ([Step] = @Original_Step) AND ([Radius] = @Original_Radius) AND ([ArcWidth] = @Original_ArcWidth)); SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM Technology WHERE (Id = @Id)