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 ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Пол = 1 AND [Пол] IS NULL) OR ([Пол] = @Original_Пол)) AND ([Телефон] = @Original_Телефон) AND ((@IsNull_ДатаРождения = 1 AND [ДатаРождения] IS NULL) OR ([ДатаРождения] = @Original_ДатаРождения)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([ДатаРегистрации] = @Original_ДатаРегистрации) AND ((@IsNull_PhotoPath = 1 AND [PhotoPath] IS NULL) OR ([PhotoPath] = @Original_PhotoPath))) INSERT INTO [dbo].[Client] ([Имя], [Фамилия], [Отчество], [Пол], [Телефон], [ДатаРождения], [Email], [ДатаРегистрации], [PhotoPath]) VALUES (@Имя, @Фамилия, @Отчество, @Пол, @Телефон, @ДатаРождения, @Email, @ДатаРегистрации, @PhotoPath); SELECT ID, Имя, Фамилия, Отчество, Пол, Телефон, ДатаРождения, Email, ДатаРегистрации, PhotoPath FROM Client WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Имя, Фамилия, Отчество, Пол, Телефон, ДатаРождения, Email, ДатаРегистрации, PhotoPath FROM dbo.Client UPDATE [dbo].[Client] SET [Имя] = @Имя, [Фамилия] = @Фамилия, [Отчество] = @Отчество, [Пол] = @Пол, [Телефон] = @Телефон, [ДатаРождения] = @ДатаРождения, [Email] = @Email, [ДатаРегистрации] = @ДатаРегистрации, [PhotoPath] = @PhotoPath WHERE (([ID] = @Original_ID) AND ([Имя] = @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 ([Телефон] = @Original_Телефон) AND ((@IsNull_ДатаРождения = 1 AND [ДатаРождения] IS NULL) OR ([ДатаРождения] = @Original_ДатаРождения)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([ДатаРегистрации] = @Original_ДатаРегистрации) AND ((@IsNull_PhotoPath = 1 AND [PhotoPath] IS NULL) OR ([PhotoPath] = @Original_PhotoPath))); SELECT ID, Имя, Фамилия, Отчество, Пол, Телефон, ДатаРождения, Email, ДатаРегистрации, PhotoPath FROM Client WHERE (ID = @ID) 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], [Client]) VALUES (@Name, @StartDate, @Client); SELECT ID, Name, StartDate, Client FROM Manufacturer WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Name, StartDate, Client FROM dbo.Manufacturer UPDATE [dbo].[Manufacturer] SET [Name] = @Name, [StartDate] = @StartDate, [Client] = @Client WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate))); SELECT ID, Name, StartDate, Client 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 ((@IsNull_ДействующаяСкидка = 1 AND [ДействующаяСкидка] IS NULL) OR ([ДействующаяСкидка] = @Original_ДействующаяСкидка)) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath))) INSERT INTO [dbo].[Service] ([НаименованиеУслугми], [Изображение], [Длительность], [Стоимость], [ДействующаяСкидка], [MainImagePath]) VALUES (@НаименованиеУслугми, @Изображение, @Длительность, @Стоимость, @ДействующаяСкидка, @MainImagePath); SELECT ID, НаименованиеУслугми, Изображение, Длительность, Стоимость, ДействующаяСкидка, MainImagePath FROM Service WHERE (ID = SCOPE_IDENTITY()) SELECT ID, НаименованиеУслугми, Изображение, Длительность, Стоимость, ДействующаяСкидка, MainImagePath FROM dbo.Service UPDATE [dbo].[Service] SET [НаименованиеУслугми] = @НаименованиеУслугми, [Изображение] = @Изображение, [Длительность] = @Длительность, [Стоимость] = @Стоимость, [ДействующаяСкидка] = @ДействующаяСкидка, [MainImagePath] = @MainImagePath WHERE (([ID] = @Original_ID) AND ([НаименованиеУслугми] = @Original_НаименованиеУслугми) AND ((@IsNull_ДействующаяСкидка = 1 AND [ДействующаяСкидка] IS NULL) OR ([ДействующаяСкидка] = @Original_ДействующаяСкидка)) AND ((@IsNull_MainImagePath = 1 AND [MainImagePath] IS NULL) OR ([MainImagePath] = @Original_MainImagePath))); SELECT ID, НаименованиеУслугми, Изображение, Длительность, Стоимость, ДействующаяСкидка, 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].[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) INSERT INTO [dbo].[Авторизация] ([Логин], [Пароль]) VALUES (@Логин, @Пароль) SELECT Логин, Пароль FROM dbo.Авторизация