DELETE FROM [dbo].[Order] WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate) AND ([OrderPickupPoint] = @Original_OrderPickupPoint) AND ((@IsNull_DateZakaza = 1 AND [DateZakaza] IS NULL) OR ([DateZakaza] = @Original_DateZakaza)) AND ((@IsNull_KodPolycheniya = 1 AND [KodPolycheniya] IS NULL) OR ([KodPolycheniya] = @Original_KodPolycheniya))) INSERT INTO [dbo].[Order] ([OrderStatus], [OrderDeliveryDate], [OrderPickupPoint], [DateZakaza], [fioKlienta], [KodPolycheniya]) VALUES (@OrderStatus, @OrderDeliveryDate, @OrderPickupPoint, @DateZakaza, @fioKlienta, @KodPolycheniya); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint, DateZakaza, fioKlienta, KodPolycheniya FROM [Order] WHERE (OrderID = SCOPE_IDENTITY()) SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint, DateZakaza, fioKlienta, KodPolycheniya FROM dbo.[Order] UPDATE [dbo].[Order] SET [OrderStatus] = @OrderStatus, [OrderDeliveryDate] = @OrderDeliveryDate, [OrderPickupPoint] = @OrderPickupPoint, [DateZakaza] = @DateZakaza, [fioKlienta] = @fioKlienta, [KodPolycheniya] = @KodPolycheniya WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate) AND ([OrderPickupPoint] = @Original_OrderPickupPoint) AND ((@IsNull_DateZakaza = 1 AND [DateZakaza] IS NULL) OR ([DateZakaza] = @Original_DateZakaza)) AND ((@IsNull_KodPolycheniya = 1 AND [KodPolycheniya] IS NULL) OR ([KodPolycheniya] = @Original_KodPolycheniya))); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint, DateZakaza, fioKlienta, KodPolycheniya FROM [Order] WHERE (OrderID = @OrderID) DELETE FROM [dbo].[OrderProduct] WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber) AND ((@IsNull_Количество_товара = 1 AND [Количество_товара] IS NULL) OR ([Количество_товара] = @Original_Количество_товара))) INSERT INTO [dbo].[OrderProduct] ([OrderID], [ProductArticleNumber], [Количество_товара]) VALUES (@OrderID, @ProductArticleNumber, @Количество_товара); SELECT OrderID, ProductArticleNumber, Количество_товара FROM OrderProduct WHERE (OrderID = @OrderID) AND (ProductArticleNumber = @ProductArticleNumber) SELECT OrderID, ProductArticleNumber, Количество_товара FROM dbo.OrderProduct UPDATE [dbo].[OrderProduct] SET [OrderID] = @OrderID, [ProductArticleNumber] = @ProductArticleNumber, [Количество_товара] = @Количество_товара WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber) AND ((@IsNull_Количество_товара = 1 AND [Количество_товара] IS NULL) OR ([Количество_товара] = @Original_Количество_товара))); SELECT OrderID, ProductArticleNumber, Количество_товара FROM OrderProduct WHERE (OrderID = @OrderID) AND (ProductArticleNumber = @ProductArticleNumber) DELETE FROM [Product] WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ((@IsNull_ProductMaxDiscount = 1 AND [ProductMaxDiscount] IS NULL) OR ([ProductMaxDiscount] = @Original_ProductMaxDiscount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock) AND ([Id] = @Original_Id) AND ([ProductPhormat] = @Original_ProductPhormat)) INSERT INTO [Product] ([ProductArticleNumber], [ProductName], [ProductDescription], [ProductCategory], [ProductPhoto], [ProductManufacturer], [ProductCost], [ProductDiscountAmount], [ProductMaxDiscount], [ProductQuantityInStock], [ProductStatus], [ProductPhormat]) VALUES (@ProductArticleNumber, @ProductName, @ProductDescription, @ProductCategory, @ProductPhoto, @ProductManufacturer, @ProductCost, @ProductDiscountAmount, @ProductMaxDiscount, @ProductQuantityInStock, @ProductStatus, @ProductPhormat); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductMaxDiscount, ProductQuantityInStock, ProductStatus, Id, ProductPhormat FROM Product WHERE (Id = SCOPE_IDENTITY()) AND (ProductArticleNumber = @ProductArticleNumber) SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductMaxDiscount, ProductQuantityInStock, ProductStatus, Id, ProductPhormat FROM Product UPDATE [Product] SET [ProductArticleNumber] = @ProductArticleNumber, [ProductName] = @ProductName, [ProductDescription] = @ProductDescription, [ProductCategory] = @ProductCategory, [ProductPhoto] = @ProductPhoto, [ProductManufacturer] = @ProductManufacturer, [ProductCost] = @ProductCost, [ProductDiscountAmount] = @ProductDiscountAmount, [ProductMaxDiscount] = @ProductMaxDiscount, [ProductQuantityInStock] = @ProductQuantityInStock, [ProductStatus] = @ProductStatus, [ProductPhormat] = @ProductPhormat WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ((@IsNull_ProductMaxDiscount = 1 AND [ProductMaxDiscount] IS NULL) OR ([ProductMaxDiscount] = @Original_ProductMaxDiscount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock) AND ([Id] = @Original_Id) AND ([ProductPhormat] = @Original_ProductPhormat)); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductMaxDiscount, ProductQuantityInStock, ProductStatus, Id, ProductPhormat FROM Product WHERE (Id = @Id) AND (ProductArticleNumber = @ProductArticleNumber) DELETE FROM [dbo].[punkt_vidachi] WHERE (([id] = @Original_id) AND ([index] = @Original_index) AND ([gorod] = @Original_gorod) AND ([ulica] = @Original_ulica) AND ((@IsNull_dom = 1 AND [dom] IS NULL) OR ([dom] = @Original_dom))) INSERT INTO [dbo].[punkt_vidachi] ([index], [gorod], [ulica], [dom]) VALUES (@index, @gorod, @ulica, @dom); SELECT id, [index], gorod, ulica, dom FROM punkt_vidachi WHERE (id = SCOPE_IDENTITY()) SELECT id, [index], gorod, ulica, dom FROM dbo.punkt_vidachi UPDATE [dbo].[punkt_vidachi] SET [index] = @index, [gorod] = @gorod, [ulica] = @ulica, [dom] = @dom WHERE (([id] = @Original_id) AND ([index] = @Original_index) AND ([gorod] = @Original_gorod) AND ([ulica] = @Original_ulica) AND ((@IsNull_dom = 1 AND [dom] IS NULL) OR ([dom] = @Original_dom))); SELECT id, [index], gorod, ulica, dom FROM punkt_vidachi WHERE (id = @id) 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 ([UserRole] = @Original_UserRole)) INSERT INTO [dbo].[User] ([UserSurname], [UserName], [UserPatronymic], [UserLogin], [UserPassword], [UserRole]) VALUES (@UserSurname, @UserName, @UserPatronymic, @UserLogin, @UserPassword, @UserRole); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM [User] WHERE (UserID = SCOPE_IDENTITY()) SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM dbo.[User] UPDATE [dbo].[User] SET [UserSurname] = @UserSurname, [UserName] = @UserName, [UserPatronymic] = @UserPatronymic, [UserLogin] = @UserLogin, [UserPassword] = @UserPassword, [UserRole] = @UserRole WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([UserRole] = @Original_UserRole)); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM [User] WHERE (UserID = @UserID) DELETE FROM [dbo].[UserTable] WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([UserRole] = @Original_UserRole)) INSERT INTO [dbo].[UserTable] ([UserSurname], [UserName], [UserPatronymic], [UserLogin], [UserPassword], [UserRole]) VALUES (@UserSurname, @UserName, @UserPatronymic, @UserLogin, @UserPassword, @UserRole); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM UserTable WHERE (UserID = SCOPE_IDENTITY()) SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM dbo.UserTable UPDATE [dbo].[UserTable] SET [UserSurname] = @UserSurname, [UserName] = @UserName, [UserPatronymic] = @UserPatronymic, [UserLogin] = @UserLogin, [UserPassword] = @UserPassword, [UserRole] = @UserRole WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([UserRole] = @Original_UserRole)); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM UserTable WHERE (UserID = @UserID)