DELETE FROM [dbo].[AttachedProduct] WHERE (([Main_Product_ID] = @Original_Main_Product_ID) AND ([Attached_Product_ID] = @Original_Attached_Product_ID)) INSERT INTO [dbo].[AttachedProduct] ([Main_Product_ID]) VALUES (@Main_Product_ID); SELECT Main_Product_ID, Attached_Product_ID FROM AttachedProduct WHERE (Main_Product_ID = @Main_Product_ID) SELECT Main_Product_ID, Attached_Product_ID FROM dbo.AttachedProduct UPDATE [dbo].[AttachedProduct] SET [Main_Product_ID] = @Main_Product_ID WHERE (([Main_Product_ID] = @Original_Main_Product_ID) AND ([Attached_Product_ID] = @Original_Attached_Product_ID)); SELECT Main_Product_ID, Attached_Product_ID FROM AttachedProduct WHERE (Main_Product_ID = @Main_Product_ID) INSERT INTO [dbo].[Avtorizacia] ([Login], [Password]) VALUES (@Login, @Password) SELECT Login, Password FROM dbo.Avtorizacia 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] ([ID], [Фамилия], [Имя], [Отчество], [Пол], [Телефон], [Дата_рождения], [Email], [Дата_регистрации]) VALUES (@ID, @Фамилия, @Имя, @Отчество, @Пол, @Телефон, @Дата_рождения, @Email, @Дата_регистрации); SELECT ID, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM client WHERE (ID = @ID) SELECT ID, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM dbo.client UPDATE [dbo].[client] SET [ID] = @ID, [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Пол] = @Пол, [Телефон] = @Телефон, [Дата_рождения] = @Дата_рождения, [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].[client Service ] WHERE (([ID] = @Original_ID) AND ([ID_client] = @Original_ID_client) AND ([ID_service] = @Original_ID_service) AND ([StartTime] = @Original_StartTime)) INSERT INTO [dbo].[client Service ] ([ID], [ID_client], [ID_service], [StartTime], [Comments]) VALUES (@ID, @ID_client, @ID_service, @StartTime, @Comments); SELECT ID, ID_client, ID_service, StartTime, Comments FROM [client Service ] WHERE (ID = @ID) SELECT ID, ID_client, ID_service, StartTime, Comments FROM dbo.[client Service ] UPDATE [dbo].[client Service ] SET [ID] = @ID, [ID_client] = @ID_client, [ID_service] = @ID_service, [StartTime] = @StartTime, [Comments] = @Comments WHERE (([ID] = @Original_ID) AND ([ID_client] = @Original_ID_client) AND ([ID_service] = @Original_ID_service) AND ([StartTime] = @Original_StartTime)); SELECT ID, ID_client, ID_service, StartTime, Comments FROM [client Service ] WHERE (ID = @ID) DELETE FROM [dbo].[DocumentService] WHERE (([ID] = @Original_ID) AND ([ID_client_service] = @Original_ID_client_service)) INSERT INTO [dbo].[DocumentService] ([ID], [ID_client_service], [DocumentPath]) VALUES (@ID, @ID_client_service, @DocumentPath); SELECT ID, ID_client_service, DocumentPath FROM DocumentService WHERE (ID = @ID) SELECT ID, ID_client_service, DocumentPath FROM dbo.DocumentService UPDATE [dbo].[DocumentService] SET [ID] = @ID, [ID_client_service] = @ID_client_service, [DocumentPath] = @DocumentPath WHERE (([ID] = @Original_ID) AND ([ID_client_service] = @Original_ID_client_service)); SELECT ID, ID_client_service, DocumentPath FROM DocumentService 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].[Manufacture] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Date_Start = 1 AND [Date_Start] IS NULL) OR ([Date_Start] = @Original_Date_Start))) INSERT INTO [dbo].[Manufacture] ([ID], [Name], [Date_Start]) VALUES (@ID, @Name, @Date_Start); SELECT ID, Name, Date_Start FROM Manufacture WHERE (ID = @ID) SELECT ID, Name, Date_Start FROM dbo.Manufacture UPDATE [dbo].[Manufacture] SET [ID] = @ID, [Name] = @Name, [Date_Start] = @Date_Start WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Date_Start = 1 AND [Date_Start] IS NULL) OR ([Date_Start] = @Original_Date_Start))); SELECT ID, Name, Date_Start FROM Manufacture WHERE (ID = @ID) DELETE FROM [dbo].[Photo prouct] WHERE (([ID] = @Original_ID) AND ([ID_product] = @Original_ID_product) AND ([Path_photo] = @Original_Path_photo)) INSERT INTO [dbo].[Photo prouct] ([ID], [ID_product], [Path_photo]) VALUES (@ID, @ID_product, @Path_photo); SELECT ID, ID_product, Path_photo FROM [Photo prouct] WHERE (ID = @ID) SELECT ID, ID_product, Path_photo FROM dbo.[Photo prouct] UPDATE [dbo].[Photo prouct] SET [ID] = @ID, [ID_product] = @ID_product, [Path_photo] = @Path_photo WHERE (([ID] = @Original_ID) AND ([ID_product] = @Original_ID_product) AND ([Path_photo] = @Original_Path_photo)); SELECT ID, ID_product, Path_photo FROM [Photo prouct] WHERE (ID = @ID) DELETE FROM [dbo].[Product] WHERE (([ID] = @Original_ID) AND ([Cost] = @Original_Cost) AND ([Active] = @Original_Active) AND ((@IsNull_ID_manufacturer = 1 AND [ID_manufacturer] IS NULL) OR ([ID_manufacturer] = @Original_ID_manufacturer))) INSERT INTO [dbo].[Product] ([ID], [Title], [Cost], [Description], [Path_MainImage], [Active], [ID_manufacturer]) VALUES (@ID, @Title, @Cost, @Description, @Path_MainImage, @Active, @ID_manufacturer); SELECT ID, Title, Cost, Description, Path_MainImage, Active, ID_manufacturer FROM Product WHERE (ID = @ID) SELECT ID, Title, Cost, Description, Path_MainImage, Active, ID_manufacturer FROM dbo.Product UPDATE [dbo].[Product] SET [ID] = @ID, [Title] = @Title, [Cost] = @Cost, [Description] = @Description, [Path_MainImage] = @Path_MainImage, [Active] = @Active, [ID_manufacturer] = @ID_manufacturer WHERE (([ID] = @Original_ID) AND ([Cost] = @Original_Cost) AND ([Active] = @Original_Active) AND ((@IsNull_ID_manufacturer = 1 AND [ID_manufacturer] IS NULL) OR ([ID_manufacturer] = @Original_ID_manufacturer))); SELECT ID, Title, Cost, Description, Path_MainImage, Active, ID_manufacturer FROM Product WHERE (ID = @ID) DELETE FROM [dbo].[Sale] WHERE (([ID] = @Original_ID) AND ([Date_Sale] = @Original_Date_Sale) AND ([ID_Product] = @Original_ID_Product) AND ([Quantity] = @Original_Quantity) AND ((@IsNull_ID_client_service = 1 AND [ID_client_service] IS NULL) OR ([ID_client_service] = @Original_ID_client_service))) INSERT INTO [dbo].[Sale] ([ID], [Date_Sale], [ID_Product], [Quantity], [ID_client_service]) VALUES (@ID, @Date_Sale, @ID_Product, @Quantity, @ID_client_service); SELECT ID, Date_Sale, ID_Product, Quantity, ID_client_service FROM Sale WHERE (ID = @ID) SELECT ID, Date_Sale, ID_Product, Quantity, ID_client_service FROM dbo.Sale UPDATE [dbo].[Sale] SET [ID] = @ID, [Date_Sale] = @Date_Sale, [ID_Product] = @ID_Product, [Quantity] = @Quantity, [ID_client_service] = @ID_client_service WHERE (([ID] = @Original_ID) AND ([Date_Sale] = @Original_Date_Sale) AND ([ID_Product] = @Original_ID_Product) AND ([Quantity] = @Original_Quantity) AND ((@IsNull_ID_client_service = 1 AND [ID_client_service] IS NULL) OR ([ID_client_service] = @Original_ID_client_service))); SELECT ID, Date_Sale, ID_Product, Quantity, ID_client_service FROM Sale WHERE (ID = @ID) DELETE FROM [dbo].[service] WHERE (([ID] = @Original_ID) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Главное_изображение] = @Original_Главное_изображение) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)) INSERT INTO [dbo].[service] ([ID], [Наименование_услуги], [Главное_изображение], [Длительность], [Стоимость], [Действующая_скидка]) VALUES (@ID, @Наименование_услуги, @Главное_изображение, @Длительность, @Стоимость, @Действующая_скидка); SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM service WHERE (ID = @ID) SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM dbo.service UPDATE [dbo].[service] SET [ID] = @ID, [Наименование_услуги] = @Наименование_услуги, [Главное_изображение] = @Главное_изображение, [Длительность] = @Длительность, [Стоимость] = @Стоимость, [Действующая_скидка] = @Действующая_скидка WHERE (([ID] = @Original_ID) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Главное_изображение] = @Original_Главное_изображение) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)); SELECT ID, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM service WHERE (ID = @ID) DELETE FROM [dbo].[Service photo] WHERE (([ID] = @Original_ID) AND ([ID_Service] = @Original_ID_Service)) INSERT INTO [dbo].[Service photo] ([ID], [ID_Service], [Path_photo]) VALUES (@ID, @ID_Service, @Path_photo); SELECT ID, ID_Service, Path_photo FROM [Service photo] WHERE (ID = @ID) SELECT ID, ID_Service, Path_photo FROM dbo.[Service photo] UPDATE [dbo].[Service photo] SET [ID] = @ID, [ID_Service] = @ID_Service, [Path_photo] = @Path_photo WHERE (([ID] = @Original_ID) AND ([ID_Service] = @Original_ID_Service)); SELECT ID, ID_Service, Path_photo FROM [Service photo] WHERE (ID = @ID) DELETE FROM [dbo].[Tag] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[Tag] ([ID], [Title], [Color]) VALUES (@ID, @Title, @Color); SELECT ID, Title, Color FROM Tag WHERE (ID = @ID) SELECT ID, Title, Color FROM dbo.Tag UPDATE [dbo].[Tag] SET [ID] = @ID, [Title] = @Title, [Color] = @Color WHERE (([ID] = @Original_ID)); SELECT ID, Title, Color FROM Tag WHERE (ID = @ID) DELETE FROM [dbo].[Tag client] WHERE (([ID_client] = @Original_ID_client) AND ([ID_Tag] = @Original_ID_Tag)) INSERT INTO [dbo].[Tag client] ([ID_client], [ID_Tag]) VALUES (@ID_client, @ID_Tag); SELECT ID_client, ID_Tag FROM [Tag client] WHERE (ID_client = @ID_client) SELECT ID_client, ID_Tag FROM dbo.[Tag client] UPDATE [dbo].[Tag client] SET [ID_client] = @ID_client, [ID_Tag] = @ID_Tag WHERE (([ID_client] = @Original_ID_client) AND ([ID_Tag] = @Original_ID_Tag)); SELECT ID_client, ID_Tag FROM [Tag client] WHERE (ID_client = @ID_client)