DELETE FROM [dbo].[Order] WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate)) INSERT INTO [dbo].[Order] ([OrderStatus], [OrderDeliveryDate], [OrderPickupPoint]) VALUES (@OrderStatus, @OrderDeliveryDate, @OrderPickupPoint); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = SCOPE_IDENTITY()) SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM dbo.[Order] UPDATE [dbo].[Order] SET [OrderStatus] = @OrderStatus, [OrderDeliveryDate] = @OrderDeliveryDate, [OrderPickupPoint] = @OrderPickupPoint WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate)); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = @OrderID) DELETE FROM [dbo].[OrderProduct] WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)) INSERT INTO [dbo].[OrderProduct] ([ProductArticleNumber]) VALUES (@ProductArticleNumber); SELECT OrderID, ProductArticleNumber FROM OrderProduct WHERE (OrderID = SCOPE_IDENTITY()) AND (ProductArticleNumber = @ProductArticleNumber) SELECT OrderID, ProductArticleNumber FROM dbo.OrderProduct UPDATE [dbo].[OrderProduct] SET [ProductArticleNumber] = @ProductArticleNumber WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)); SELECT OrderID, ProductArticleNumber FROM OrderProduct WHERE (OrderID = @OrderID) AND (ProductArticleNumber = @ProductArticleNumber) DELETE FROM [dbo].[Product] WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID))) INSERT INTO [dbo].[Product] ([ProductArticleNumber], [ProductName], [ProductDescription], [ProductCategory], [ProductManufacturer], [ProductCost], [ProductDiscountAmount], [ProductQuantityInStock], [ProductStatus], [UserID]) VALUES (@ProductArticleNumber, @ProductName, @ProductDescription, @ProductCategory, @ProductManufacturer, @ProductCost, @ProductDiscountAmount, @ProductQuantityInStock, @ProductStatus, @UserID); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus, UserID FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber) SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus, UserID FROM dbo.Product UPDATE [dbo].[Product] SET [ProductArticleNumber] = @ProductArticleNumber, [ProductName] = @ProductName, [ProductDescription] = @ProductDescription, [ProductCategory] = @ProductCategory, [ProductManufacturer] = @ProductManufacturer, [ProductCost] = @ProductCost, [ProductDiscountAmount] = @ProductDiscountAmount, [ProductQuantityInStock] = @ProductQuantityInStock, [ProductStatus] = @ProductStatus, [UserID] = @UserID WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID))); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus, UserID FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber) DELETE FROM [dbo].[Role] WHERE (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName)) INSERT INTO [dbo].[Role] ([RoleName]) VALUES (@RoleName); SELECT RoleID, RoleName FROM Role WHERE (RoleID = SCOPE_IDENTITY()) SELECT RoleID, RoleName FROM dbo.Role UPDATE [dbo].[Role] SET [RoleName] = @RoleName WHERE (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName)); SELECT RoleID, RoleName FROM Role WHERE (RoleID = @RoleID) DELETE FROM [dbo].[User] WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([RoleID] = @Original_RoleID)) INSERT INTO [dbo].[User] ([UserSurname], [UserName], [UserPatronymic], [UserLogin], [UserPassword], [RoleID]) VALUES (@UserSurname, @UserName, @UserPatronymic, @UserLogin, @UserPassword, @RoleID); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, RoleID FROM [User] WHERE (UserID = SCOPE_IDENTITY()) SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, RoleID FROM dbo.[User] UPDATE [dbo].[User] SET [UserSurname] = @UserSurname, [UserName] = @UserName, [UserPatronymic] = @UserPatronymic, [UserLogin] = @UserLogin, [UserPassword] = @UserPassword, [RoleID] = @RoleID WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([RoleID] = @Original_RoleID)); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, RoleID FROM [User] WHERE (UserID = @UserID)