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].[Clientservic] WHERE (([id] = @Original_id) AND ((@IsNull_Clientid = 1 AND [Clientid] IS NULL) OR ([Clientid] = @Original_Clientid)) AND ((@IsNull_Serviceid = 1 AND [Serviceid] IS NULL) OR ([Serviceid] = @Original_Serviceid)) AND ([Услуга] = @Original_Услуга) AND ([Начало_оказания_услуги] = @Original_Начало_оказания_услуги) AND ([Клиент] = @Original_Клиент)) INSERT INTO [dbo].[Clientservic] ([Clientid], [Serviceid], [Услуга], [Начало_оказания_услуги], [Клиент]) VALUES (@Clientid, @Serviceid, @Услуга, @Начало_оказания_услуги, @Клиент); SELECT id, Clientid, Serviceid, Услуга, Начало_оказания_услуги, Клиент FROM Clientservic WHERE (id = SCOPE_IDENTITY()) SELECT id, Clientid, Serviceid, Услуга, Начало_оказания_услуги, Клиент FROM dbo.Clientservic UPDATE [dbo].[Clientservic] SET [Clientid] = @Clientid, [Serviceid] = @Serviceid, [Услуга] = @Услуга, [Начало_оказания_услуги] = @Начало_оказания_услуги, [Клиент] = @Клиент WHERE (([id] = @Original_id) AND ((@IsNull_Clientid = 1 AND [Clientid] IS NULL) OR ([Clientid] = @Original_Clientid)) AND ((@IsNull_Serviceid = 1 AND [Serviceid] IS NULL) OR ([Serviceid] = @Original_Serviceid)) AND ([Услуга] = @Original_Услуга) AND ([Начало_оказания_услуги] = @Original_Начало_оказания_услуги) AND ([Клиент] = @Original_Клиент)); SELECT id, Clientid, Serviceid, Услуга, Начало_оказания_услуги, Клиент FROM Clientservic 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].[Loginpass] WHERE (([id] = @Original_id) AND ([Login] = @Original_Login) AND ([Pass] = @Original_Pass)) INSERT INTO [dbo].[Loginpass] ([Login], [Pass]) VALUES (@Login, @Pass); SELECT id, Login, Pass FROM Loginpass WHERE (id = SCOPE_IDENTITY()) SELECT id, Login, Pass FROM dbo.Loginpass UPDATE [dbo].[Loginpass] SET [Login] = @Login, [Pass] = @Pass WHERE (([id] = @Original_id) AND ([Login] = @Original_Login) AND ([Pass] = @Original_Pass)); SELECT id, Login, Pass FROM Loginpass WHERE (id = @id) 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_Стоимость) 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_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)); SELECT Id, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Service WHERE (Id = @Id) DELETE FROM [dbo].[ServicePhoto] WHERE (([ID] = @Original_ID) AND ([ServiceID] = @Original_ServiceID) AND ([PhotoPath] = @Original_PhotoPath)) 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) AND ([PhotoPath] = @Original_PhotoPath)); 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].[Кли33ент] 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].[Кли33ент] ([id], [Фамилия], [Имя], [Отчество], [Пол], [Телефон], [Дата_рождения], [Email], [Дата_регистрации]) VALUES (@id, @Фамилия, @Имя, @Отчество, @Пол, @Телефон, @Дата_рождения, @Email, @Дата_регистрации); SELECT id, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM Кли33ент WHERE (id = @id) SELECT id, Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрации FROM dbo.Кли33ент UPDATE [dbo].[Кли33ент] 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 Кли33ент WHERE (id = @id)