DELETE FROM [dbo].[Cloth] WHERE (([IDCloth] = @Original_IDCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) 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_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))) INSERT INTO [dbo].[Cloth] ([Title], [Color], [Width], [Length], [Comment], [Photo]) VALUES (@Title, @Color, @Width, @Length, @Comment, @Photo); SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM Cloth WHERE (IDCloth = SCOPE_IDENTITY()) SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM dbo.Cloth UPDATE [dbo].[Cloth] SET [Title] = @Title, [Color] = @Color, [Width] = @Width, [Length] = @Length, [Comment] = @Comment, [Photo] = @Photo WHERE (([IDCloth] = @Original_IDCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) 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_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))); SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM Cloth WHERE (IDCloth = @IDCloth) DELETE FROM [dbo].[Furnitura] WHERE (([idfur] = @Original_idfur) 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 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_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) 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].[Izdelia] WHERE (([IDIzd] = @Original_IDIzd) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width))) INSERT INTO [dbo].[Izdelia] ([Title], [Lenght], [Width]) VALUES (@Title, @Lenght, @Width); SELECT IDIzd, Title, Lenght, Width FROM Izdelia WHERE (IDIzd = SCOPE_IDENTITY()) SELECT IDIzd, Title, Lenght, Width FROM dbo.Izdelia UPDATE [dbo].[Izdelia] SET [Title] = @Title, [Lenght] = @Lenght, [Width] = @Width WHERE (([IDIzd] = @Original_IDIzd) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width))); SELECT IDIzd, Title, Lenght, Width FROM Izdelia WHERE (IDIzd = @IDIzd) DELETE FROM [dbo].[Orders] WHERE (([IDOrder] = @Original_IDOrder) AND ((@IsNull_IDIzd = 1 AND [IDIzd] IS NULL) OR ([IDIzd] = @Original_IDIzd)) AND ((@IsNull_IDZak = 1 AND [IDZak] IS NULL) OR ([IDZak] = @Original_IDZak)) AND ((@IsNull_IDMen = 1 AND [IDMen] IS NULL) OR ([IDMen] = @Original_IDMen)) AND ((@IsNull_IDCloth = 1 AND [IDCloth] IS NULL) OR ([IDCloth] = @Original_IDCloth)) 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].[Orders] ([IDIzd], [IDZak], [IDMen], [IDCloth], [IDFur], [CountFur], [CountIzd]) VALUES (@IDIzd, @IDZak, @IDMen, @IDCloth, @IDFur, @CountFur, @CountIzd); SELECT IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM Orders WHERE (IDOrder = SCOPE_IDENTITY()) SELECT IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM dbo.Orders UPDATE [dbo].[Orders] SET [IDIzd] = @IDIzd, [IDZak] = @IDZak, [IDMen] = @IDMen, [IDCloth] = @IDCloth, [IDFur] = @IDFur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([IDOrder] = @Original_IDOrder) AND ((@IsNull_IDIzd = 1 AND [IDIzd] IS NULL) OR ([IDIzd] = @Original_IDIzd)) AND ((@IsNull_IDZak = 1 AND [IDZak] IS NULL) OR ([IDZak] = @Original_IDZak)) AND ((@IsNull_IDMen = 1 AND [IDMen] IS NULL) OR ([IDMen] = @Original_IDMen)) AND ((@IsNull_IDCloth = 1 AND [IDCloth] IS NULL) OR ([IDCloth] = @Original_IDCloth)) 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 IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM Orders WHERE (IDOrder = @IDOrder) DELETE FROM [dbo].[Roles] WHERE (([IDRole] = @Original_IDRole) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role))) INSERT INTO [dbo].[Roles] ([Role]) VALUES (@Role); SELECT IDRole, Role FROM Roles WHERE (IDRole = SCOPE_IDENTITY()) SELECT IDRole, Role FROM dbo.Roles UPDATE [dbo].[Roles] SET [Role] = @Role WHERE (([IDRole] = @Original_IDRole) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role))); SELECT IDRole, Role FROM Roles WHERE (IDRole = @IDRole) 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)