DELETE FROM [dbo].[Agent] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([AgentTypeID] = @Original_AgentTypeID) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([INN] = @Original_INN) AND ((@IsNull_KPP = 1 AND [KPP] IS NULL) OR ([KPP] = @Original_KPP)) AND ((@IsNull_DirectorName = 1 AND [DirectorName] IS NULL) OR ([DirectorName] = @Original_DirectorName)) AND ([Phone] = @Original_Phone) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Logo = 1 AND [Logo] IS NULL) OR ([Logo] = @Original_Logo)) AND ([Priority] = @Original_Priority)) INSERT INTO [dbo].[Agent] ([Title], [AgentTypeID], [Address], [INN], [KPP], [DirectorName], [Phone], [Email], [Logo], [Priority]) VALUES (@Title, @AgentTypeID, @Address, @INN, @KPP, @DirectorName, @Phone, @Email, @Logo, @Priority); SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM Agent WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM dbo.Agent UPDATE [dbo].[Agent] SET [Title] = @Title, [AgentTypeID] = @AgentTypeID, [Address] = @Address, [INN] = @INN, [KPP] = @KPP, [DirectorName] = @DirectorName, [Phone] = @Phone, [Email] = @Email, [Logo] = @Logo, [Priority] = @Priority WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([AgentTypeID] = @Original_AgentTypeID) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([INN] = @Original_INN) AND ((@IsNull_KPP = 1 AND [KPP] IS NULL) OR ([KPP] = @Original_KPP)) AND ((@IsNull_DirectorName = 1 AND [DirectorName] IS NULL) OR ([DirectorName] = @Original_DirectorName)) AND ([Phone] = @Original_Phone) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Logo = 1 AND [Logo] IS NULL) OR ([Logo] = @Original_Logo)) AND ([Priority] = @Original_Priority)); SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM Agent WHERE (ID = @ID) DELETE FROM [dbo].[AgentType] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image))) INSERT INTO [dbo].[AgentType] ([Title], [Image]) VALUES (@Title, @Image); SELECT ID, Title, Image FROM AgentType WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, Image FROM dbo.AgentType UPDATE [dbo].[AgentType] SET [Title] = @Title, [Image] = @Image WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image))); SELECT ID, Title, Image FROM AgentType WHERE (ID = @ID) DELETE FROM [dbo].[Product] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_ProductTypeID = 1 AND [ProductTypeID] IS NULL) OR ([ProductTypeID] = @Original_ProductTypeID)) AND ([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ((@IsNull_ProductionPersonCount = 1 AND [ProductionPersonCount] IS NULL) OR ([ProductionPersonCount] = @Original_ProductionPersonCount)) AND ((@IsNull_ProductionWorkshopNumber = 1 AND [ProductionWorkshopNumber] IS NULL) OR ([ProductionWorkshopNumber] = @Original_ProductionWorkshopNumber)) AND ([MinCostForAgent] = @Original_MinCostForAgent)) INSERT INTO [dbo].[Product] ([Title], [ProductTypeID], [ArticleNumber], [Description], [Image], [ProductionPersonCount], [ProductionWorkshopNumber], [MinCostForAgent]) VALUES (@Title, @ProductTypeID, @ArticleNumber, @Description, @Image, @ProductionPersonCount, @ProductionWorkshopNumber, @MinCostForAgent); SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM Product WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM dbo.Product UPDATE [dbo].[Product] SET [Title] = @Title, [ProductTypeID] = @ProductTypeID, [ArticleNumber] = @ArticleNumber, [Description] = @Description, [Image] = @Image, [ProductionPersonCount] = @ProductionPersonCount, [ProductionWorkshopNumber] = @ProductionWorkshopNumber, [MinCostForAgent] = @MinCostForAgent WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_ProductTypeID = 1 AND [ProductTypeID] IS NULL) OR ([ProductTypeID] = @Original_ProductTypeID)) AND ([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ((@IsNull_ProductionPersonCount = 1 AND [ProductionPersonCount] IS NULL) OR ([ProductionPersonCount] = @Original_ProductionPersonCount)) AND ((@IsNull_ProductionWorkshopNumber = 1 AND [ProductionWorkshopNumber] IS NULL) OR ([ProductionWorkshopNumber] = @Original_ProductionWorkshopNumber)) AND ([MinCostForAgent] = @Original_MinCostForAgent)); SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM Product WHERE (ID = @ID) DELETE FROM [dbo].[ProductSale] WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ProductID] = @Original_ProductID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductCount] = @Original_ProductCount)) INSERT INTO [dbo].[ProductSale] ([AgentID], [ProductID], [SaleDate], [ProductCount]) VALUES (@AgentID, @ProductID, @SaleDate, @ProductCount); SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM ProductSale WHERE (ID = SCOPE_IDENTITY()) SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM dbo.ProductSale UPDATE [dbo].[ProductSale] SET [AgentID] = @AgentID, [ProductID] = @ProductID, [SaleDate] = @SaleDate, [ProductCount] = @ProductCount WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ProductID] = @Original_ProductID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductCount] = @Original_ProductCount)); SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM ProductSale WHERE (ID = @ID) DELETE FROM [dbo].[ProductType] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([DefectedPercent] = @Original_DefectedPercent)) INSERT INTO [dbo].[ProductType] ([Title], [DefectedPercent]) VALUES (@Title, @DefectedPercent); SELECT ID, Title, DefectedPercent FROM ProductType WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, DefectedPercent FROM dbo.ProductType UPDATE [dbo].[ProductType] SET [Title] = @Title, [DefectedPercent] = @DefectedPercent WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([DefectedPercent] = @Original_DefectedPercent)); SELECT ID, Title, DefectedPercent FROM ProductType WHERE (ID = @ID)