DELETE FROM [dbo].[Clothess] WHERE (([ID_Cloth] = @Original_ID_Cloth) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Color = 1 AND [ID_Color] IS NULL) OR ([ID_Color] = @Original_ID_Color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment))) INSERT INTO [dbo].[Clothess] ([Name], [ID_Color], [Length], [Width], [Comment], [Photo]) VALUES (@Name, @ID_Color, @Length, @Width, @Comment, @Photo); SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM Clothess WHERE (ID_Cloth = SCOPE_IDENTITY()) SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM dbo.Clothess UPDATE [dbo].[Clothess] SET [Name] = @Name, [ID_Color] = @ID_Color, [Length] = @Length, [Width] = @Width, [Comment] = @Comment, [Photo] = @Photo WHERE (([ID_Cloth] = @Original_ID_Cloth) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Color = 1 AND [ID_Color] IS NULL) OR ([ID_Color] = @Original_ID_Color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment))); SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM Clothess WHERE (ID_Cloth = @ID_Cloth) DELETE FROM [dbo].[Colors] WHERE (([ID_Color] = @Original_ID_Color) AND ((@IsNull_Name_Color = 1 AND [Name_Color] IS NULL) OR ([Name_Color] = @Original_Name_Color))) INSERT INTO [dbo].[Colors] ([Name_Color]) VALUES (@Name_Color); SELECT ID_Color, Name_Color FROM Colors WHERE (ID_Color = SCOPE_IDENTITY()) SELECT ID_Color, Name_Color FROM dbo.Colors UPDATE [dbo].[Colors] SET [Name_Color] = @Name_Color WHERE (([ID_Color] = @Original_ID_Color) AND ((@IsNull_Name_Color = 1 AND [Name_Color] IS NULL) OR ([Name_Color] = @Original_Name_Color))); SELECT ID_Color, Name_Color FROM Colors WHERE (ID_Color = @ID_Color) DELETE FROM [dbo].[Furnitures] WHERE (([ID_Fur] = @Original_ID_Fur) AND ([Name_Fur] = @Original_Name_Fur) AND ((@IsNull_Count_Fur = 1 AND [Count_Fur] IS NULL) OR ([Count_Fur] = @Original_Count_Fur))) INSERT INTO [dbo].[Furnitures] ([ID_Fur], [Name_Fur], [Photo], [Count_Fur]) VALUES (@ID_Fur, @Name_Fur, @Photo, @Count_Fur); SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM Furnitures WHERE (ID_Fur = @ID_Fur) SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM dbo.Furnitures UPDATE [dbo].[Furnitures] SET [ID_Fur] = @ID_Fur, [Name_Fur] = @Name_Fur, [Photo] = @Photo, [Count_Fur] = @Count_Fur WHERE (([ID_Fur] = @Original_ID_Fur) AND ([Name_Fur] = @Original_Name_Fur) AND ((@IsNull_Count_Fur = 1 AND [Count_Fur] IS NULL) OR ([Count_Fur] = @Original_Count_Fur))); SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM Furnitures WHERE (ID_Fur = @ID_Fur) DELETE FROM [dbo].[Izdelie] WHERE (([ID_Izdelie] = @Original_ID_Izdelie) AND ((@IsNull_Name_Izdelie = 1 AND [Name_Izdelie] IS NULL) OR ([Name_Izdelie] = @Original_Name_Izdelie)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width))) INSERT INTO [dbo].[Izdelie] ([ID_Izdelie], [Name_Izdelie], [Length], [Width]) VALUES (@ID_Izdelie, @Name_Izdelie, @Length, @Width); SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM Izdelie WHERE (ID_Izdelie = @ID_Izdelie) SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM dbo.Izdelie UPDATE [dbo].[Izdelie] SET [ID_Izdelie] = @ID_Izdelie, [Name_Izdelie] = @Name_Izdelie, [Length] = @Length, [Width] = @Width WHERE (([ID_Izdelie] = @Original_ID_Izdelie) AND ((@IsNull_Name_Izdelie = 1 AND [Name_Izdelie] IS NULL) OR ([Name_Izdelie] = @Original_Name_Izdelie)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width))); SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM Izdelie WHERE (ID_Izdelie = @ID_Izdelie) DELETE FROM [dbo].[Orders] WHERE (([ID_Order] = @Original_ID_Order) AND ([ID_Izdelie] = @Original_ID_Izdelie) AND ([ID_Zakazchik] = @Original_ID_Zakazchik) AND ([ID_Manager] = @Original_ID_Manager) AND ([ID_Cloth] = @Original_ID_Cloth) AND ([ID_Fur] = @Original_ID_Fur) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd))) INSERT INTO [dbo].[Orders] ([ID_Izdelie], [ID_Zakazchik], [ID_Manager], [ID_Cloth], [ID_Fur], [CountFur], [CountIzd]) VALUES (@ID_Izdelie, @ID_Zakazchik, @ID_Manager, @ID_Cloth, @ID_Fur, @CountFur, @CountIzd); SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM Orders WHERE (ID_Order = SCOPE_IDENTITY()) SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM dbo.Orders UPDATE [dbo].[Orders] SET [ID_Izdelie] = @ID_Izdelie, [ID_Zakazchik] = @ID_Zakazchik, [ID_Manager] = @ID_Manager, [ID_Cloth] = @ID_Cloth, [ID_Fur] = @ID_Fur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([ID_Order] = @Original_ID_Order) AND ([ID_Izdelie] = @Original_ID_Izdelie) AND ([ID_Zakazchik] = @Original_ID_Zakazchik) AND ([ID_Manager] = @Original_ID_Manager) AND ([ID_Cloth] = @Original_ID_Cloth) AND ([ID_Fur] = @Original_ID_Fur) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd))); SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM Orders WHERE (ID_Order = @ID_Order) DELETE FROM [dbo].[Roles] WHERE (([ID_Role] = @Original_ID_Role) AND ([Name_Role] = @Original_Name_Role)) INSERT INTO [dbo].[Roles] ([Name_Role]) VALUES (@Name_Role); SELECT ID_Role, Name_Role FROM Roles WHERE (ID_Role = SCOPE_IDENTITY()) SELECT ID_Role, Name_Role FROM dbo.Roles UPDATE [dbo].[Roles] SET [Name_Role] = @Name_Role WHERE (([ID_Role] = @Original_ID_Role) AND ([Name_Role] = @Original_Name_Role)); SELECT ID_Role, Name_Role FROM Roles WHERE (ID_Role = @ID_Role) DELETE FROM [dbo].[Users] WHERE (([ID_User] = @Original_ID_User) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_ID_Role = 1 AND [ID_Role] IS NULL) OR ([ID_Role] = @Original_ID_Role)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymicv = 1 AND [Patronymicv] IS NULL) OR ([Patronymicv] = @Original_Patronymicv)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone))) INSERT INTO [dbo].[Users] ([Login], [Password], [ID_Role], [Surname], [Name], [Patronymicv], [Phone]) VALUES (@Login, @Password, @ID_Role, @Surname, @Name, @Patronymicv, @Phone); SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM Users WHERE (ID_User = SCOPE_IDENTITY()) SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM dbo.Users UPDATE [dbo].[Users] SET [Login] = @Login, [Password] = @Password, [ID_Role] = @ID_Role, [Surname] = @Surname, [Name] = @Name, [Patronymicv] = @Patronymicv, [Phone] = @Phone WHERE (([ID_User] = @Original_ID_User) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_ID_Role = 1 AND [ID_Role] IS NULL) OR ([ID_Role] = @Original_ID_Role)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymicv = 1 AND [Patronymicv] IS NULL) OR ([Patronymicv] = @Original_Patronymicv)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone))); SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM Users WHERE (ID_User = @ID_User)