INSERT INTO [dbo].[Administrator] ([Login], [Password]) VALUES (@Login, @Password) SELECT Login, Password FROM dbo.Administrator 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 ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ([RegistrationDate] = @Original_RegistrationDate) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([Phone] = @Original_Phone) AND ([GenderCode] = @Original_GenderCode) AND ((@IsNull_PhotoPath = 1 AND [PhotoPath] IS NULL) OR ([PhotoPath] = @Original_PhotoPath))) INSERT INTO [dbo].[Client] ([FirstName], [LastName], [Patronymic], [Birthday], [RegistrationDate], [Email], [Phone], [GenderCode], [PhotoPath]) VALUES (@FirstName, @LastName, @Patronymic, @Birthday, @RegistrationDate, @Email, @Phone, @GenderCode, @PhotoPath); SELECT ID, FirstName, LastName, Patronymic, Birthday, RegistrationDate, Email, Phone, GenderCode, PhotoPath FROM Client WHERE (ID = SCOPE_IDENTITY()) SELECT ID, FirstName, LastName, Patronymic, Birthday, RegistrationDate, Email, Phone, GenderCode, PhotoPath FROM dbo.Client UPDATE [dbo].[Client] SET [FirstName] = @FirstName, [LastName] = @LastName, [Patronymic] = @Patronymic, [Birthday] = @Birthday, [RegistrationDate] = @RegistrationDate, [Email] = @Email, [Phone] = @Phone, [GenderCode] = @GenderCode, [PhotoPath] = @PhotoPath WHERE (([ID] = @Original_ID) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ([RegistrationDate] = @Original_RegistrationDate) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([Phone] = @Original_Phone) AND ([GenderCode] = @Original_GenderCode) AND ((@IsNull_PhotoPath = 1 AND [PhotoPath] IS NULL) OR ([PhotoPath] = @Original_PhotoPath))); SELECT ID, FirstName, LastName, Patronymic, Birthday, RegistrationDate, Email, Phone, GenderCode, PhotoPath FROM Client WHERE (ID = @ID) DELETE FROM [dbo].[Clients] WHERE (([ID_Client] = @Original_ID_Client) AND ((@IsNull_Phomilia = 1 AND [Phomilia] IS NULL) OR ([Phomilia] = @Original_Phomilia)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Otchestvo = 1 AND [Otchestvo] IS NULL) OR ([Otchestvo] = @Original_Otchestvo)) AND ((@IsNull_Pol = 1 AND [Pol] IS NULL) OR ([Pol] = @Original_Pol)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Data_Registra = 1 AND [Data_Registra] IS NULL) OR ([Data_Registra] = @Original_Data_Registra))) INSERT INTO [dbo].[Clients] ([ID_Client], [Phomilia], [Name], [Otchestvo], [Pol], [Phone], [Birthday], [Email], [Data_Registra]) VALUES (@ID_Client, @Phomilia, @Name, @Otchestvo, @Pol, @Phone, @Birthday, @Email, @Data_Registra); SELECT ID_Client, Phomilia, Name, Otchestvo, Pol, Phone, Birthday, Email, Data_Registra FROM Clients WHERE (ID_Client = @ID_Client) SELECT ID_Client, Phomilia, Name, Otchestvo, Pol, Phone, Birthday, Email, Data_Registra FROM dbo.Clients UPDATE [dbo].[Clients] SET [ID_Client] = @ID_Client, [Phomilia] = @Phomilia, [Name] = @Name, [Otchestvo] = @Otchestvo, [Pol] = @Pol, [Phone] = @Phone, [Birthday] = @Birthday, [Email] = @Email, [Data_Registra] = @Data_Registra WHERE (([ID_Client] = @Original_ID_Client) AND ((@IsNull_Phomilia = 1 AND [Phomilia] IS NULL) OR ([Phomilia] = @Original_Phomilia)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Otchestvo = 1 AND [Otchestvo] IS NULL) OR ([Otchestvo] = @Original_Otchestvo)) AND ((@IsNull_Pol = 1 AND [Pol] IS NULL) OR ([Pol] = @Original_Pol)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Data_Registra = 1 AND [Data_Registra] IS NULL) OR ([Data_Registra] = @Original_Data_Registra))); SELECT ID_Client, Phomilia, Name, Otchestvo, Pol, Phone, Birthday, Email, Data_Registra FROM Clients WHERE (ID_Client = @ID_Client) DELETE FROM [dbo].[ClientService] WHERE (([ID] = @Original_ID) AND ([ClientID] = @Original_ClientID) AND ([ServiceID] = @Original_ServiceID) AND ([StartTime] = @Original_StartTime)) INSERT INTO [dbo].[ClientService] ([ClientID], [ServiceID], [StartTime], [Comment]) VALUES (@ClientID, @ServiceID, @StartTime, @Comment); SELECT ID, ClientID, ServiceID, StartTime, Comment FROM ClientService WHERE (ID = SCOPE_IDENTITY()) SELECT ID, ClientID, ServiceID, StartTime, Comment FROM dbo.ClientService UPDATE [dbo].[ClientService] SET [ClientID] = @ClientID, [ServiceID] = @ServiceID, [StartTime] = @StartTime, [Comment] = @Comment WHERE (([ID] = @Original_ID) AND ([ClientID] = @Original_ClientID) AND ([ServiceID] = @Original_ServiceID) AND ([StartTime] = @Original_StartTime)); SELECT ID, ClientID, ServiceID, StartTime, 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 ([Title] = @Original_Title) AND ([Cost] = @Original_Cost) AND ([DurationInSeconds] = @Original_DurationInSeconds) AND ((@IsNull_Discount = 1 AND [Discount] IS NULL) OR ([Discount] = @Original_Discount)) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath))) INSERT INTO [dbo].[Service] ([Title], [Cost], [DurationInSeconds], [Description], [Discount], [MainImagePath]) VALUES (@Title, @Cost, @DurationInSeconds, @Description, @Discount, @MainImagePath); SELECT ID, Title, Cost, DurationInSeconds, Description, Discount, MainImagePath FROM Service WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Title, Cost, DurationInSeconds, Description, Discount, MainImagePath FROM dbo.Service UPDATE [dbo].[Service] SET [Title] = @Title, [Cost] = @Cost, [DurationInSeconds] = @DurationInSeconds, [Description] = @Description, [Discount] = @Discount, [MainImagePath] = @MainImagePath WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([Cost] = @Original_Cost) AND ([DurationInSeconds] = @Original_DurationInSeconds) AND ((@IsNull_Discount = 1 AND [Discount] IS NULL) OR ([Discount] = @Original_Discount)) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath))); SELECT ID, Title, Cost, DurationInSeconds, Description, Discount, MainImagePath 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].[Sotrudnik] WHERE (([ID_Sotrudnik] = @Original_ID_Sotrudnik) AND ((@IsNull_Phomilia = 1 AND [Phomilia] IS NULL) OR ([Phomilia] = @Original_Phomilia)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Uslugi = 1 AND [ID_Uslugi] IS NULL) OR ([ID_Uslugi] = @Original_ID_Uslugi))) INSERT INTO [dbo].[Sotrudnik] ([ID_Sotrudnik], [Phomilia], [Name], [ID_Uslugi]) VALUES (@ID_Sotrudnik, @Phomilia, @Name, @ID_Uslugi); SELECT ID_Sotrudnik, Phomilia, Name, ID_Uslugi FROM Sotrudnik WHERE (ID_Sotrudnik = @ID_Sotrudnik) SELECT ID_Sotrudnik, Phomilia, Name, ID_Uslugi FROM dbo.Sotrudnik UPDATE [dbo].[Sotrudnik] SET [ID_Sotrudnik] = @ID_Sotrudnik, [Phomilia] = @Phomilia, [Name] = @Name, [ID_Uslugi] = @ID_Uslugi WHERE (([ID_Sotrudnik] = @Original_ID_Sotrudnik) AND ((@IsNull_Phomilia = 1 AND [Phomilia] IS NULL) OR ([Phomilia] = @Original_Phomilia)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Uslugi = 1 AND [ID_Uslugi] IS NULL) OR ([ID_Uslugi] = @Original_ID_Uslugi))); SELECT ID_Sotrudnik, Phomilia, Name, ID_Uslugi FROM Sotrudnik WHERE (ID_Sotrudnik = @ID_Sotrudnik) 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].[Uslugi] WHERE (([ID_Uslugi] = @Original_ID_Uslugi) AND ((@IsNull_Наименование_услуги = 1 AND [Наименование_услуги] IS NULL) OR ([Наименование_услуги] = @Original_Наименование_услуги)) AND ((@IsNull_Главное_изображение = 1 AND [Главное_изображение] IS NULL) OR ([Главное_изображение] = @Original_Главное_изображение)) AND ((@IsNull_Длительность = 1 AND [Длительность] IS NULL) OR ([Длительность] = @Original_Длительность)) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)) AND ((@IsNull_Действующая_скидка = 1 AND [Действующая_скидка] IS NULL) OR ([Действующая_скидка] = @Original_Действующая_скидка))) INSERT INTO [dbo].[Uslugi] ([ID_Uslugi], [Наименование_услуги], [Главное_изображение], [Длительность], [Стоимость], [Действующая_скидка]) VALUES (@ID_Uslugi, @Наименование_услуги, @Главное_изображение, @Длительность, @Стоимость, @Действующая_скидка); SELECT ID_Uslugi, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Uslugi WHERE (ID_Uslugi = @ID_Uslugi) SELECT ID_Uslugi, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM dbo.Uslugi UPDATE [dbo].[Uslugi] SET [ID_Uslugi] = @ID_Uslugi, [Наименование_услуги] = @Наименование_услуги, [Главное_изображение] = @Главное_изображение, [Длительность] = @Длительность, [Стоимость] = @Стоимость, [Действующая_скидка] = @Действующая_скидка WHERE (([ID_Uslugi] = @Original_ID_Uslugi) AND ((@IsNull_Наименование_услуги = 1 AND [Наименование_услуги] IS NULL) OR ([Наименование_услуги] = @Original_Наименование_услуги)) AND ((@IsNull_Главное_изображение = 1 AND [Главное_изображение] IS NULL) OR ([Главное_изображение] = @Original_Главное_изображение)) AND ((@IsNull_Длительность = 1 AND [Длительность] IS NULL) OR ([Длительность] = @Original_Длительность)) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)) AND ((@IsNull_Действующая_скидка = 1 AND [Действующая_скидка] IS NULL) OR ([Действующая_скидка] = @Original_Действующая_скидка))); SELECT ID_Uslugi, Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действующая_скидка FROM Uslugi WHERE (ID_Uslugi = @ID_Uslugi) DELETE FROM [dbo].[Uslugi_i_Klient] WHERE (([ID] = @Original_ID) AND ((@IsNull_Начало_оказания_услуги = 1 AND [Начало_оказания_услуги] IS NULL) OR ([Начало_оказания_услуги] = @Original_Начало_оказания_услуги)) AND ((@IsNull_Клиент = 1 AND [Клиент] IS NULL) OR ([Клиент] = @Original_Клиент)) AND ((@IsNull_ID_Client = 1 AND [ID_Client] IS NULL) OR ([ID_Client] = @Original_ID_Client)) AND ((@IsNull_ID_Uslugi = 1 AND [ID_Uslugi] IS NULL) OR ([ID_Uslugi] = @Original_ID_Uslugi))) INSERT INTO [dbo].[Uslugi_i_Klient] ([ID], [Услуга], [Начало_оказания_услуги], [Клиент], [ID_Client], [ID_Uslugi]) VALUES (@ID, @Услуга, @Начало_оказания_услуги, @Клиент, @ID_Client, @ID_Uslugi); SELECT ID, Услуга, Начало_оказания_услуги, Клиент, ID_Client, ID_Uslugi FROM Uslugi_i_Klient WHERE (ID = @ID) SELECT ID, Услуга, Начало_оказания_услуги, Клиент, ID_Client, ID_Uslugi FROM dbo.Uslugi_i_Klient UPDATE [dbo].[Uslugi_i_Klient] SET [ID] = @ID, [Услуга] = @Услуга, [Начало_оказания_услуги] = @Начало_оказания_услуги, [Клиент] = @Клиент, [ID_Client] = @ID_Client, [ID_Uslugi] = @ID_Uslugi WHERE (([ID] = @Original_ID) AND ((@IsNull_Начало_оказания_услуги = 1 AND [Начало_оказания_услуги] IS NULL) OR ([Начало_оказания_услуги] = @Original_Начало_оказания_услуги)) AND ((@IsNull_Клиент = 1 AND [Клиент] IS NULL) OR ([Клиент] = @Original_Клиент)) AND ((@IsNull_ID_Client = 1 AND [ID_Client] IS NULL) OR ([ID_Client] = @Original_ID_Client)) AND ((@IsNull_ID_Uslugi = 1 AND [ID_Uslugi] IS NULL) OR ([ID_Uslugi] = @Original_ID_Uslugi))); SELECT ID, Услуга, Начало_оказания_услуги, Клиент, ID_Client, ID_Uslugi FROM Uslugi_i_Klient WHERE (ID = @ID)