DELETE FROM [dbo].[Color] WHERE (([id_colors] = @Original_id_colors) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))) INSERT INTO [dbo].[Color] ([Title]) VALUES (@Title); SELECT id_colors, Title FROM Color WHERE (id_colors = SCOPE_IDENTITY()) SELECT id_colors, Title FROM dbo.Color UPDATE [dbo].[Color] SET [Title] = @Title WHERE (([id_colors] = @Original_id_colors) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))); SELECT id_colors, Title FROM Color WHERE (id_colors = @id_colors) DELETE FROM [dbo].[Furnitura] WHERE (([id_fur] = @Original_id_fur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur))) INSERT INTO [dbo].[Furnitura] ([namefur], [photo], [countfur]) VALUES (@namefur, @photo, @countfur); SELECT id_fur, namefur, photo, countfur FROM Furnitura WHERE (id_fur = SCOPE_IDENTITY()) SELECT id_fur, namefur, photo, countfur FROM dbo.Furnitura UPDATE [dbo].[Furnitura] SET [namefur] = @namefur, [photo] = @photo, [countfur] = @countfur WHERE (([id_fur] = @Original_id_fur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur))); SELECT id_fur, namefur, photo, countfur FROM Furnitura WHERE (id_fur = @id_fur) DELETE FROM [dbo].[Izdelie] WHERE (([id_izd] = @Original_id_izd) AND ((@IsNull_name_izd = 1 AND [name_izd] IS NULL) OR ([name_izd] = @Original_name_izd)) 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] ([name_izd], [length], [width]) VALUES (@name_izd, @length, @width); SELECT id_izd, name_izd, length, width FROM Izdelie WHERE (id_izd = SCOPE_IDENTITY()) SELECT id_izd, name_izd, length, width FROM dbo.Izdelie UPDATE [dbo].[Izdelie] SET [name_izd] = @name_izd, [length] = @length, [width] = @width WHERE (([id_izd] = @Original_id_izd) AND ((@IsNull_name_izd = 1 AND [name_izd] IS NULL) OR ([name_izd] = @Original_name_izd)) 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_izd, name_izd, length, width FROM Izdelie WHERE (id_izd = @id_izd) DELETE FROM [dbo].[Orders] WHERE (([id_order] = @Original_id_order) AND ((@IsNull_id_izd = 1 AND [id_izd] IS NULL) OR ([id_izd] = @Original_id_izd)) AND ((@IsNull_id_zak = 1 AND [id_zak] IS NULL) OR ([id_zak] = @Original_id_zak)) AND ((@IsNull_id_men = 1 AND [id_men] IS NULL) OR ([id_men] = @Original_id_men)) AND ((@IsNull_id_tkan = 1 AND [id_tkan] IS NULL) OR ([id_tkan] = @Original_id_tkan)) AND ((@IsNull_id_fur = 1 AND [id_fur] IS NULL) OR ([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_izd], [id_zak], [id_men], [id_tkan], [id_fur], [CountFur], [CountIzd]) VALUES (@id_izd, @id_zak, @id_men, @id_tkan, @id_fur, @CountFur, @CountIzd); SELECT id_order, id_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM Orders WHERE (id_order = SCOPE_IDENTITY()) SELECT id_order, id_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM dbo.Orders UPDATE [dbo].[Orders] SET [id_izd] = @id_izd, [id_zak] = @id_zak, [id_men] = @id_men, [id_tkan] = @id_tkan, [id_fur] = @id_fur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([id_order] = @Original_id_order) AND ((@IsNull_id_izd = 1 AND [id_izd] IS NULL) OR ([id_izd] = @Original_id_izd)) AND ((@IsNull_id_zak = 1 AND [id_zak] IS NULL) OR ([id_zak] = @Original_id_zak)) AND ((@IsNull_id_men = 1 AND [id_men] IS NULL) OR ([id_men] = @Original_id_men)) AND ((@IsNull_id_tkan = 1 AND [id_tkan] IS NULL) OR ([id_tkan] = @Original_id_tkan)) AND ((@IsNull_id_fur = 1 AND [id_fur] IS NULL) OR ([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_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM Orders WHERE (id_order = @id_order) DELETE FROM [dbo].[Roles] WHERE (([id_Roles] = @Original_id_Roles) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))) INSERT INTO [dbo].[Roles] ([Title]) VALUES (@Title); SELECT id_Roles, Title FROM Roles WHERE (id_Roles = SCOPE_IDENTITY()) SELECT id_Roles, Title FROM dbo.Roles UPDATE [dbo].[Roles] SET [Title] = @Title WHERE (([id_Roles] = @Original_id_Roles) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))); SELECT id_Roles, Title FROM Roles WHERE (id_Roles = @id_Roles) DELETE FROM [dbo].[Tkan] WHERE (([id_Tkan] = @Original_id_Tkan) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) 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)) AND ((@IsNull_NamePhoto = 1 AND [NamePhoto] IS NULL) OR ([NamePhoto] = @Original_NamePhoto))) INSERT INTO [dbo].[Tkan] ([Title], [id_color], [Length], [Width], [Comment], [NamePhoto]) VALUES (@Title, @id_color, @Length, @Width, @Comment, @NamePhoto); SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM Tkan WHERE (id_Tkan = SCOPE_IDENTITY()) SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM dbo.Tkan UPDATE [dbo].[Tkan] SET [Title] = @Title, [id_color] = @id_color, [Length] = @Length, [Width] = @Width, [Comment] = @Comment, [NamePhoto] = @NamePhoto WHERE (([id_Tkan] = @Original_id_Tkan) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) 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)) AND ((@IsNull_NamePhoto = 1 AND [NamePhoto] IS NULL) OR ([NamePhoto] = @Original_NamePhoto))); SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM Tkan WHERE (id_Tkan = @id_Tkan) DELETE FROM [dbo].[Users] WHERE (([id_User] = @Original_id_User) 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_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) 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], [Surname], [Name], [Otch], [Phone]) VALUES (@login, @pass, @Role, @Surname, @Name, @Otch, @Phone); SELECT id_User, login, pass, Role, Surname, Name, Otch, Phone FROM Users WHERE (id_User = SCOPE_IDENTITY()) SELECT id_User, login, pass, Role, Surname, Name, Otch, Phone FROM dbo.Users UPDATE [dbo].[Users] SET [login] = @login, [pass] = @pass, [Role] = @Role, [Surname] = @Surname, [Name] = @Name, [Otch] = @Otch, [Phone] = @Phone WHERE (([id_User] = @Original_id_User) 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_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) 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 id_User, login, pass, Role, Surname, Name, Otch, Phone FROM Users WHERE (id_User = @id_User)