DELETE FROM [dbo].[AttachedProduct] WHERE (([MainProductID] = @Original_MainProductID) AND ([AttachedProductID] = @Original_AttachedProductID)) INSERT INTO [dbo].[AttachedProduct] ([MainProductID], [AttachedProductID]) VALUES (@MainProductID, @AttachedProductID); SELECT MainProductID, AttachedProductID FROM AttachedProduct WHERE (AttachedProductID = @AttachedProductID) AND (MainProductID = @MainProductID) SELECT MainProductID, AttachedProductID FROM dbo.AttachedProduct UPDATE [dbo].[AttachedProduct] SET [MainProductID] = @MainProductID, [AttachedProductID] = @AttachedProductID WHERE (([MainProductID] = @Original_MainProductID) AND ([AttachedProductID] = @Original_AttachedProductID)); SELECT MainProductID, AttachedProductID FROM AttachedProduct WHERE (AttachedProductID = @AttachedProductID) AND (MainProductID = @MainProductID) DELETE FROM [dbo].[Client] WHERE (([ID] = @Original_ID) AND ([Фамилия] = @Original_Фамилия) AND ([Имя] = @Original_Имя) AND ([Отчество] = @Original_Отчество) AND ([Пол] = @Original_Пол) AND ([Телефон] = @Original_Телефон) AND ([Дата_рождения] = @Original_Дата_рождения) AND ([Email] = @Original_Email) AND ([Дата_регистрации] = @Original_Дата_регистрации)) INSERT INTO [dbo].[Client] ([Фамилия], [Имя], [Отчество], [Пол], [Телефон], [Дата_рождения], [Email], [Дата_регистрации]) VALUES (@Фамилия, @Имя, @Отчество, @Пол, @Телефон, @Дата_рождения, @Email, @Дата_регистрации); SELECT ID, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM Client WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM dbo.Client UPDATE [dbo].[Client] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Пол] = @Пол, [Телефон] = @Телефон, [Дата_рождения] = @Дата_рождения, [Email] = @Email, [Дата_регистрации] = @Дата_регистрации WHERE (([ID] = @Original_ID) AND ([Фамилия] = @Original_Фамилия) AND ([Имя] = @Original_Имя) AND ([Отчество] = @Original_Отчество) AND ([Пол] = @Original_Пол) AND ([Телефон] = @Original_Телефон) AND ([Дата_рождения] = @Original_Дата_рождения) AND ([Email] = @Original_Email) AND ([Дата_регистрации] = @Original_Дата_регистрации)); SELECT ID, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM Client WHERE (ID = @ID) DELETE FROM [dbo].[ClientService] WHERE (([ID] = @Original_ID) AND ([Услуга] = @Original_Услуга) AND ([Дата] = @Original_Дата) AND ([Клиент] = @Original_Клиент)) INSERT INTO [dbo].[ClientService] ([Услуга], [Дата], [Клиент], [Comment]) VALUES (@Услуга, @Дата, @Клиент, @Comment); SELECT ID, Услуга, Дата, Клиент, Comment FROM ClientService WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Услуга, Дата, Клиент, Comment FROM dbo.ClientService UPDATE [dbo].[ClientService] SET [Услуга] = @Услуга, [Дата] = @Дата, [Клиент] = @Клиент, [Comment] = @Comment WHERE (([ID] = @Original_ID) AND ([Услуга] = @Original_Услуга) AND ([Дата] = @Original_Дата) AND ([Клиент] = @Original_Клиент)); SELECT ID, Услуга, Дата, Клиент, Comment FROM ClientService WHERE (ID = @ID) DELETE FROM [dbo].[DocumentByService] WHERE (([ID] = @Original_ID) AND ([ClientServiceID] = @Original_ClientServiceID) AND ([DocumentPath] = @Original_DocumentPath)) INSERT INTO [dbo].[DocumentByService] ([ClientServiceID], [DocumentPath]) VALUES (@ClientServiceID, @DocumentPath); SELECT ID, ClientServiceID, DocumentPath FROM DocumentByService WHERE (ID = SCOPE_IDENTITY()) SELECT ID, ClientServiceID, DocumentPath FROM dbo.DocumentByService UPDATE [dbo].[DocumentByService] SET [ClientServiceID] = @ClientServiceID, [DocumentPath] = @DocumentPath WHERE (([ID] = @Original_ID) AND ([ClientServiceID] = @Original_ClientServiceID) AND ([DocumentPath] = @Original_DocumentPath)); SELECT ID, ClientServiceID, DocumentPath FROM DocumentByService WHERE (ID = @ID) DELETE FROM [dbo].[Gender] WHERE (([Code] = @Original_Code) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))) INSERT INTO [dbo].[Gender] ([Code], [Name]) VALUES (@Code, @Name); SELECT Code, Name FROM Gender WHERE (Code = @Code) SELECT Code, Name FROM dbo.Gender UPDATE [dbo].[Gender] SET [Code] = @Code, [Name] = @Name WHERE (([Code] = @Original_Code) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))); SELECT Code, Name FROM Gender WHERE (Code = @Code) DELETE FROM [dbo].[Manufacturer] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate))) INSERT INTO [dbo].[Manufacturer] ([Name], [StartDate]) VALUES (@Name, @StartDate); SELECT ID, Name, StartDate FROM Manufacturer WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Name, StartDate FROM dbo.Manufacturer UPDATE [dbo].[Manufacturer] SET [Name] = @Name, [StartDate] = @StartDate WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate))); SELECT ID, Name, StartDate FROM Manufacturer WHERE (ID = @ID) DELETE FROM [dbo].[Product] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([Cost] = @Original_Cost) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath)) AND ([IsActive] = @Original_IsActive) AND ((@IsNull_ManufacturerID = 1 AND [ManufacturerID] IS NULL) OR ([ManufacturerID] = @Original_ManufacturerID))) INSERT INTO [dbo].[Product] ([Title], [Cost], [Description], [MainImagePath], [IsActive], [ManufacturerID]) VALUES (@Title, @Cost, @Description, @MainImagePath, @IsActive, @ManufacturerID); SELECT ID, Title, Cost, Description, MainImagePath, IsActive, ManufacturerID FROM Product WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, Cost, Description, MainImagePath, IsActive, ManufacturerID FROM dbo.Product UPDATE [dbo].[Product] SET [Title] = @Title, [Cost] = @Cost, [Description] = @Description, [MainImagePath] = @MainImagePath, [IsActive] = @IsActive, [ManufacturerID] = @ManufacturerID WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([Cost] = @Original_Cost) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath)) AND ([IsActive] = @Original_IsActive) AND ((@IsNull_ManufacturerID = 1 AND [ManufacturerID] IS NULL) OR ([ManufacturerID] = @Original_ManufacturerID))); SELECT ID, Title, Cost, Description, MainImagePath, IsActive, ManufacturerID FROM Product WHERE (ID = @ID) DELETE FROM [dbo].[ProductPhoto] WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([PhotoPath] = @Original_PhotoPath)) INSERT INTO [dbo].[ProductPhoto] ([ProductID], [PhotoPath]) VALUES (@ProductID, @PhotoPath); SELECT ID, ProductID, PhotoPath FROM ProductPhoto WHERE (ID = SCOPE_IDENTITY()) SELECT ID, ProductID, PhotoPath FROM dbo.ProductPhoto UPDATE [dbo].[ProductPhoto] SET [ProductID] = @ProductID, [PhotoPath] = @PhotoPath WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([PhotoPath] = @Original_PhotoPath)); SELECT ID, ProductID, PhotoPath FROM ProductPhoto WHERE (ID = @ID) DELETE FROM [dbo].[ProductSale] WHERE (([ID] = @Original_ID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductID] = @Original_ProductID) AND ([Quantity] = @Original_Quantity) AND ((@IsNull_ClientServiceID = 1 AND [ClientServiceID] IS NULL) OR ([ClientServiceID] = @Original_ClientServiceID))) INSERT INTO [dbo].[ProductSale] ([SaleDate], [ProductID], [Quantity], [ClientServiceID]) VALUES (@SaleDate, @ProductID, @Quantity, @ClientServiceID); SELECT ID, SaleDate, ProductID, Quantity, ClientServiceID FROM ProductSale WHERE (ID = SCOPE_IDENTITY()) SELECT ID, SaleDate, ProductID, Quantity, ClientServiceID FROM dbo.ProductSale UPDATE [dbo].[ProductSale] SET [SaleDate] = @SaleDate, [ProductID] = @ProductID, [Quantity] = @Quantity, [ClientServiceID] = @ClientServiceID WHERE (([ID] = @Original_ID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductID] = @Original_ProductID) AND ([Quantity] = @Original_Quantity) AND ((@IsNull_ClientServiceID = 1 AND [ClientServiceID] IS NULL) OR ([ClientServiceID] = @Original_ClientServiceID))); SELECT ID, SaleDate, ProductID, Quantity, ClientServiceID FROM ProductSale WHERE (ID = @ID) DELETE FROM [dbo].[Service] WHERE (([ID] = @Original_ID) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)) INSERT INTO [dbo].[Service] ([Наименование_услуги], [Главное_изображение], [Длительность], [Стоимость], [Действующая_скидка]) VALUES (@Наименование_услуги, @Главное_изображение, @Длительность, @Стоимость, @Действующая_скидка); SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Service WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM dbo.Service UPDATE [dbo].[Service] SET [Наименование_услуги] = @Наименование_услуги, [Главное_изображение] = @Главное_изображение, [Длительность] = @Длительность, [Стоимость] = @Стоимость, [Действующая_скидка] = @Действующая_скидка WHERE (([ID] = @Original_ID) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)); SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Service WHERE (ID = @ID) DELETE FROM [dbo].[ServicePhoto] WHERE (([ID] = @Original_ID) AND ([ServiceID] = @Original_ServiceID)) INSERT INTO [dbo].[ServicePhoto] ([ServiceID], [PhotoPath]) VALUES (@ServiceID, @PhotoPath); SELECT ID, ServiceID, PhotoPath FROM ServicePhoto WHERE (ID = SCOPE_IDENTITY()) SELECT ID, ServiceID, PhotoPath FROM dbo.ServicePhoto UPDATE [dbo].[ServicePhoto] SET [ServiceID] = @ServiceID, [PhotoPath] = @PhotoPath WHERE (([ID] = @Original_ID) AND ([ServiceID] = @Original_ServiceID)); SELECT ID, ServiceID, PhotoPath FROM ServicePhoto WHERE (ID = @ID) DELETE FROM [dbo].[Tag] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([Color] = @Original_Color)) INSERT INTO [dbo].[Tag] ([Title], [Color]) VALUES (@Title, @Color); SELECT ID, Title, Color FROM Tag WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, Color FROM dbo.Tag UPDATE [dbo].[Tag] SET [Title] = @Title, [Color] = @Color WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([Color] = @Original_Color)); SELECT ID, Title, Color FROM Tag WHERE (ID = @ID) DELETE FROM [dbo].[TagOfClient] WHERE (([ClientID] = @Original_ClientID) AND ([TagID] = @Original_TagID)) INSERT INTO [dbo].[TagOfClient] ([ClientID], [TagID]) VALUES (@ClientID, @TagID); SELECT ClientID, TagID FROM TagOfClient WHERE (ClientID = @ClientID) AND (TagID = @TagID) SELECT ClientID, TagID FROM dbo.TagOfClient UPDATE [dbo].[TagOfClient] SET [ClientID] = @ClientID, [TagID] = @TagID WHERE (([ClientID] = @Original_ClientID) AND ([TagID] = @Original_TagID)); SELECT ClientID, TagID FROM TagOfClient WHERE (ClientID = @ClientID) AND (TagID = @TagID) DELETE FROM [dbo].[Учетки] WHERE (([Логин] = @Original_Логин) AND ([Пароль] = @Original_Пароль)) INSERT INTO [dbo].[Учетки] ([Логин], [Пароль]) VALUES (@Логин, @Пароль); SELECT Логин, Пароль FROM Учетки WHERE (Логин = @Логин) SELECT Логин, Пароль FROM dbo.Учетки UPDATE [dbo].[Учетки] SET [Логин] = @Логин, [Пароль] = @Пароль WHERE (([Логин] = @Original_Логин) AND ([Пароль] = @Original_Пароль)); SELECT Логин, Пароль FROM Учетки WHERE (Логин = @Логин)