DELETE FROM [dbo].[Furnitura] WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur))) INSERT INTO [dbo].[Furnitura] ([namefur], [photo], [countfur]) VALUES (@namefur, @photo, @countfur); SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = SCOPE_IDENTITY()) SELECT idfur, namefur, photo, countfur FROM dbo.Furnitura UPDATE [dbo].[Furnitura] SET [namefur] = @namefur, [photo] = @photo, [countfur] = @countfur WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur))); SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = @idfur) DELETE FROM [dbo].[Izdeliya] WHERE (([idizd] = @Original_idizd) AND ((@IsNull_nameizd = 1 AND [nameizd] IS NULL) OR ([nameizd] = @Original_nameizd)) 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].[Izdeliya] ([nameizd], [length], [width]) VALUES (@nameizd, @length, @width); SELECT idizd, nameizd, length, width FROM Izdeliya WHERE (idizd = SCOPE_IDENTITY()) SELECT idizd, nameizd, length, width FROM dbo.Izdeliya UPDATE [dbo].[Izdeliya] SET [nameizd] = @nameizd, [length] = @length, [width] = @width WHERE (([idizd] = @Original_idizd) AND ((@IsNull_nameizd = 1 AND [nameizd] IS NULL) OR ([nameizd] = @Original_nameizd)) 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 idizd, nameizd, length, width FROM Izdeliya WHERE (idizd = @idizd) DELETE FROM [dbo].[Tkani] WHERE (([idtkan] = @Original_idtkan) AND ((@IsNull_nametkan = 1 AND [nametkan] IS NULL) OR ([nametkan] = @Original_nametkan)) AND ((@IsNull_color = 1 AND [color] IS NULL) OR ([color] = @Original_color)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description))) INSERT INTO [dbo].[Tkani] ([nametkan], [color], [width], [length], [description], [phototkan]) VALUES (@nametkan, @color, @width, @length, @description, @phototkan); SELECT idtkan, nametkan, color, width, length, description, phototkan FROM Tkani WHERE (idtkan = SCOPE_IDENTITY()) SELECT idtkan, nametkan, color, width, length, description, phototkan FROM dbo.Tkani UPDATE [dbo].[Tkani] SET [nametkan] = @nametkan, [color] = @color, [width] = @width, [length] = @length, [description] = @description, [phototkan] = @phototkan WHERE (([idtkan] = @Original_idtkan) AND ((@IsNull_nametkan = 1 AND [nametkan] IS NULL) OR ([nametkan] = @Original_nametkan)) AND ((@IsNull_color = 1 AND [color] IS NULL) OR ([color] = @Original_color)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description))); SELECT idtkan, nametkan, color, width, length, description, phototkan FROM Tkani WHERE (idtkan = @idtkan) DELETE FROM [dbo].[Users] WHERE (([iduser] = @Original_iduser) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_pass = 1 AND [pass] IS NULL) OR ([pass] = @Original_pass)) AND ((@IsNull_role = 1 AND [role] IS NULL) OR ([role] = @Original_role)) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_otch = 1 AND [otch] IS NULL) OR ([otch] = @Original_otch)) AND ((@IsNull_phone = 1 AND [phone] IS NULL) OR ([phone] = @Original_phone))) INSERT INTO [dbo].[Users] ([login], [pass], [role], [fam], [name], [otch], [phone]) VALUES (@login, @pass, @role, @fam, @name, @otch, @phone); SELECT iduser, login, pass, role, fam, name, otch, phone FROM Users WHERE (iduser = SCOPE_IDENTITY()) SELECT iduser, login, pass, role, fam, name, otch, phone FROM dbo.Users UPDATE [dbo].[Users] SET [login] = @login, [pass] = @pass, [role] = @role, [fam] = @fam, [name] = @name, [otch] = @otch, [phone] = @phone WHERE (([iduser] = @Original_iduser) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_pass = 1 AND [pass] IS NULL) OR ([pass] = @Original_pass)) AND ((@IsNull_role = 1 AND [role] IS NULL) OR ([role] = @Original_role)) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_otch = 1 AND [otch] IS NULL) OR ([otch] = @Original_otch)) AND ((@IsNull_phone = 1 AND [phone] IS NULL) OR ([phone] = @Original_phone))); SELECT iduser, login, pass, role, fam, name, otch, phone FROM Users WHERE (iduser = @iduser) DELETE FROM [dbo].[Zakaz] WHERE (([idzak] = @Original_idzak) AND ((@IsNull_idizd = 1 AND [idizd] IS NULL) OR ([idizd] = @Original_idizd)) AND ((@IsNull_idzakazchik = 1 AND [idzakazchik] IS NULL) OR ([idzakazchik] = @Original_idzakazchik)) AND ((@IsNull_idman = 1 AND [idman] IS NULL) OR ([idman] = @Original_idman)) AND ((@IsNull_idtkan = 1 AND [idtkan] IS NULL) OR ([idtkan] = @Original_idtkan)) AND ((@IsNull_idfur = 1 AND [idfur] IS NULL) OR ([idfur] = @Original_idfur)) 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].[Zakaz] ([idizd], [idzakazchik], [idman], [idtkan], [idfur], [countfur], [countizd]) VALUES (@idizd, @idzakazchik, @idman, @idtkan, @idfur, @countfur, @countizd); SELECT idzak, idizd, idzakazchik, idman, idtkan, idfur, countfur, countizd FROM Zakaz WHERE (idzak = SCOPE_IDENTITY()) SELECT idzak, idizd, idzakazchik, idman, idtkan, idfur, countfur, countizd FROM dbo.Zakaz UPDATE [dbo].[Zakaz] SET [idizd] = @idizd, [idzakazchik] = @idzakazchik, [idman] = @idman, [idtkan] = @idtkan, [idfur] = @idfur, [countfur] = @countfur, [countizd] = @countizd WHERE (([idzak] = @Original_idzak) AND ((@IsNull_idizd = 1 AND [idizd] IS NULL) OR ([idizd] = @Original_idizd)) AND ((@IsNull_idzakazchik = 1 AND [idzakazchik] IS NULL) OR ([idzakazchik] = @Original_idzakazchik)) AND ((@IsNull_idman = 1 AND [idman] IS NULL) OR ([idman] = @Original_idman)) AND ((@IsNull_idtkan = 1 AND [idtkan] IS NULL) OR ([idtkan] = @Original_idtkan)) AND ((@IsNull_idfur = 1 AND [idfur] IS NULL) OR ([idfur] = @Original_idfur)) 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 idzak, idizd, idzakazchik, idman, idtkan, idfur, countfur, countizd FROM Zakaz WHERE (idzak = @idzak)