DELETE FROM [dbo].[Клиент] WHERE (([ID_client] = @Original_ID_client) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ([Patronymic] = @Original_Patronymic) AND ([GenderCode] = @Original_GenderCode) AND ([Phone] = @Original_Phone) AND ([Birthday] = @Original_Birthday) AND ([Email] = @Original_Email) AND ([RegistrationDate] = @Original_RegistrationDate)) INSERT INTO [dbo].[Клиент] ([FirstName], [LastName], [Patronymic], [GenderCode], [Phone], [Birthday], [Email], [RegistrationDate]) VALUES (@FirstName, @LastName, @Patronymic, @GenderCode, @Phone, @Birthday, @Email, @RegistrationDate); SELECT ID_client, FirstName, LastName, Patronymic, GenderCode, Phone, Birthday, Email, RegistrationDate FROM Клиент WHERE (ID_client = SCOPE_IDENTITY()) SELECT ID_client, FirstName, LastName, Patronymic, GenderCode, Phone, Birthday, Email, RegistrationDate FROM dbo.Клиент UPDATE [dbo].[Клиент] SET [FirstName] = @FirstName, [LastName] = @LastName, [Patronymic] = @Patronymic, [GenderCode] = @GenderCode, [Phone] = @Phone, [Birthday] = @Birthday, [Email] = @Email, [RegistrationDate] = @RegistrationDate WHERE (([ID_client] = @Original_ID_client) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ([Patronymic] = @Original_Patronymic) AND ([GenderCode] = @Original_GenderCode) AND ([Phone] = @Original_Phone) AND ([Birthday] = @Original_Birthday) AND ([Email] = @Original_Email) AND ([RegistrationDate] = @Original_RegistrationDate)); SELECT ID_client, FirstName, LastName, Patronymic, GenderCode, Phone, Birthday, Email, RegistrationDate FROM Клиент WHERE (ID_client = @ID_client) DELETE FROM [dbo].[Клиент_Сервис] WHERE (([ID] = @Original_ID) AND ((@IsNull_Client = 1 AND [Client] IS NULL) OR ([Client] = @Original_Client)) AND ((@IsNull_Service = 1 AND [Service] IS NULL) OR ([Service] = @Original_Service)) AND ((@IsNull_StartTime = 1 AND [StartTime] IS NULL) OR ([StartTime] = @Original_StartTime))) INSERT INTO [dbo].[Клиент_Сервис] ([Client], [Service], [StartTime]) VALUES (@Client, @Service, @StartTime); SELECT ID, Client, Service, StartTime FROM Клиент_Сервис WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Client, Service, StartTime FROM dbo.Клиент_Сервис UPDATE [dbo].[Клиент_Сервис] SET [Client] = @Client, [Service] = @Service, [StartTime] = @StartTime WHERE (([ID] = @Original_ID) AND ((@IsNull_Client = 1 AND [Client] IS NULL) OR ([Client] = @Original_Client)) AND ((@IsNull_Service = 1 AND [Service] IS NULL) OR ([Service] = @Original_Service)) AND ((@IsNull_StartTime = 1 AND [StartTime] IS NULL) OR ([StartTime] = @Original_StartTime))); SELECT ID, Client, Service, StartTime FROM Клиент_Сервис WHERE (ID = @ID) DELETE FROM [dbo].[Поставщики] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)) INSERT INTO [dbo].[Поставщики] ([Name]) VALUES (@Name); SELECT ID, Name FROM Поставщики WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Name FROM dbo.Поставщики UPDATE [dbo].[Поставщики] SET [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)); SELECT ID, Name FROM Поставщики WHERE (ID = @ID) DELETE FROM [dbo].[Сервис] WHERE (([ID_service] = @Original_ID_service) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Главное_изображение] = @Original_Главное_изображение) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)) INSERT INTO [dbo].[Сервис] ([Наименование_услуги], [Главное_изображение], [Длительность], [Стоимость], [Действующая_скидка]) VALUES (@Наименование_услуги, @Главное_изображение, @Длительность, @Стоимость, @Действующая_скидка); SELECT ID_service, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Сервис WHERE (ID_service = SCOPE_IDENTITY()) SELECT ID_service, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM dbo.Сервис UPDATE [dbo].[Сервис] SET [Наименование_услуги] = @Наименование_услуги, [Главное_изображение] = @Главное_изображение, [Длительность] = @Длительность, [Стоимость] = @Стоимость, [Действующая_скидка] = @Действующая_скидка WHERE (([ID_service] = @Original_ID_service) AND ([Наименование_услуги] = @Original_Наименование_услуги) AND ([Главное_изображение] = @Original_Главное_изображение) AND ([Длительность] = @Original_Длительность) AND ([Стоимость] = @Original_Стоимость) AND ([Действующая_скидка] = @Original_Действующая_скидка)); SELECT ID_service, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Сервис WHERE (ID_service = @ID_service) DELETE FROM [dbo].[Товары] WHERE (([ID] = @Original_ID) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Count = 1 AND [Count] IS NULL) OR ([Count] = @Original_Count)) AND ((@IsNull_ManufacturerID = 1 AND [ManufacturerID] IS NULL) OR ([ManufacturerID] = @Original_ManufacturerID))) INSERT INTO [dbo].[Товары] ([Title], [Cost], [Description], [Count], [ManufacturerID]) VALUES (@Title, @Cost, @Description, @Count, @ManufacturerID); SELECT ID, Title, Cost, Description, Count, ManufacturerID FROM Товары WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, Cost, Description, Count, ManufacturerID FROM dbo.Товары UPDATE [dbo].[Товары] SET [Title] = @Title, [Cost] = @Cost, [Description] = @Description, [Count] = @Count, [ManufacturerID] = @ManufacturerID WHERE (([ID] = @Original_ID) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Count = 1 AND [Count] IS NULL) OR ([Count] = @Original_Count)) AND ((@IsNull_ManufacturerID = 1 AND [ManufacturerID] IS NULL) OR ([ManufacturerID] = @Original_ManufacturerID))); SELECT ID, Title, Cost, Description, Count, ManufacturerID FROM Товары WHERE (ID = @ID)