DELETE FROM [dbo].[City] WHERE (([IDCity] = @Original_IDCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City))) INSERT INTO [dbo].[City] ([City]) VALUES (@City); SELECT IDCity, City FROM City WHERE (IDCity = SCOPE_IDENTITY()) SELECT IDCity, City FROM dbo.City UPDATE [dbo].[City] SET [City] = @City WHERE (([IDCity] = @Original_IDCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City))); SELECT IDCity, City FROM City WHERE (IDCity = @IDCity) DELETE FROM [dbo].[Manager] WHERE (([IDManager] = @Original_IDManager) 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_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) 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_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))) INSERT INTO [dbo].[Manager] ([Surname], [Name], [Patronomyc], [Login], [Password], [Photo]) VALUES (@Surname, @Name, @Patronomyc, @Login, @Password, @Photo); SELECT IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM Manager WHERE (IDManager = SCOPE_IDENTITY()) SELECT IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM dbo.Manager UPDATE [dbo].[Manager] SET [Surname] = @Surname, [Name] = @Name, [Patronomyc] = @Patronomyc, [Login] = @Login, [Password] = @Password, [Photo] = @Photo WHERE (([IDManager] = @Original_IDManager) 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_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) 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_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))); SELECT IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM Manager WHERE (IDManager = @IDManager) DELETE FROM [dbo].[Partner] WHERE (([IDPartner] = @Original_IDPartner) AND ([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_Namepartner = 1 AND [Namepartner] IS NULL) OR ([Namepartner] = @Original_Namepartner)) 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_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_IDPostCode = 1 AND [IDPostCode] IS NULL) OR ([IDPostCode] = @Original_IDPostCode)) AND ((@IsNull_IDRegion = 1 AND [IDRegion] IS NULL) OR ([IDRegion] = @Original_IDRegion)) AND ((@IsNull_IDCity = 1 AND [IDCity] IS NULL) OR ([IDCity] = @Original_IDCity)) AND ((@IsNull_IDStreet = 1 AND [IDStreet] IS NULL) OR ([IDStreet] = @Original_IDStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating))) INSERT INTO [dbo].[Partner] ([IDTypePartner], [Namepartner], [Surname], [Name], [Patronomyc], [Email], [Phone], [IDPostCode], [IDRegion], [IDCity], [IDStreet], [House], [INN], [Rating]) VALUES (@IDTypePartner, @Namepartner, @Surname, @Name, @Patronomyc, @Email, @Phone, @IDPostCode, @IDRegion, @IDCity, @IDStreet, @House, @INN, @Rating); SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM Partner WHERE (IDPartner = SCOPE_IDENTITY()) SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM dbo.Partner UPDATE [dbo].[Partner] SET [IDTypePartner] = @IDTypePartner, [Namepartner] = @Namepartner, [Surname] = @Surname, [Name] = @Name, [Patronomyc] = @Patronomyc, [Email] = @Email, [Phone] = @Phone, [IDPostCode] = @IDPostCode, [IDRegion] = @IDRegion, [IDCity] = @IDCity, [IDStreet] = @IDStreet, [House] = @House, [INN] = @INN, [Rating] = @Rating WHERE (([IDPartner] = @Original_IDPartner) AND ([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_Namepartner = 1 AND [Namepartner] IS NULL) OR ([Namepartner] = @Original_Namepartner)) 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_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_IDPostCode = 1 AND [IDPostCode] IS NULL) OR ([IDPostCode] = @Original_IDPostCode)) AND ((@IsNull_IDRegion = 1 AND [IDRegion] IS NULL) OR ([IDRegion] = @Original_IDRegion)) AND ((@IsNull_IDCity = 1 AND [IDCity] IS NULL) OR ([IDCity] = @Original_IDCity)) AND ((@IsNull_IDStreet = 1 AND [IDStreet] IS NULL) OR ([IDStreet] = @Original_IDStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating))); SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM Partner WHERE (IDPartner = @IDPartner) DELETE FROM [dbo].[PartnerProducts] WHERE (([IDPartnerProduct] = @Original_IDPartnerProduct) AND ((@IsNull_IDProduct = 1 AND [IDProduct] IS NULL) OR ([IDProduct] = @Original_IDProduct)) AND ((@IsNull_IDPartner = 1 AND [IDPartner] IS NULL) OR ([IDPartner] = @Original_IDPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale))) INSERT INTO [dbo].[PartnerProducts] ([IDProduct], [IDPartner], [CountProduct], [DateSale]) VALUES (@IDProduct, @IDPartner, @CountProduct, @DateSale); SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM PartnerProducts WHERE (IDPartnerProduct = SCOPE_IDENTITY()) SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM dbo.PartnerProducts UPDATE [dbo].[PartnerProducts] SET [IDProduct] = @IDProduct, [IDPartner] = @IDPartner, [CountProduct] = @CountProduct, [DateSale] = @DateSale WHERE (([IDPartnerProduct] = @Original_IDPartnerProduct) AND ((@IsNull_IDProduct = 1 AND [IDProduct] IS NULL) OR ([IDProduct] = @Original_IDProduct)) AND ((@IsNull_IDPartner = 1 AND [IDPartner] IS NULL) OR ([IDPartner] = @Original_IDPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale))); SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM PartnerProducts WHERE (IDPartnerProduct = @IDPartnerProduct) DELETE FROM [dbo].[PostCode] WHERE (([IDPostCode] = @Original_IDPostCode) AND ((@IsNull_PostCode = 1 AND [PostCode] IS NULL) OR ([PostCode] = @Original_PostCode))) INSERT INTO [dbo].[PostCode] ([PostCode]) VALUES (@PostCode); SELECT IDPostCode, PostCode FROM PostCode WHERE (IDPostCode = SCOPE_IDENTITY()) SELECT IDPostCode, PostCode FROM dbo.PostCode UPDATE [dbo].[PostCode] SET [PostCode] = @PostCode WHERE (([IDPostCode] = @Original_IDPostCode) AND ((@IsNull_PostCode = 1 AND [PostCode] IS NULL) OR ([PostCode] = @Original_PostCode))); SELECT IDPostCode, PostCode FROM PostCode WHERE (IDPostCode = @IDPostCode) DELETE FROM [dbo].[Product] WHERE (([IDProduct] = @Original_IDProduct) AND ((@IsNull_IDProductType = 1 AND [IDProductType] IS NULL) OR ([IDProductType] = @Original_IDProductType)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost))) INSERT INTO [dbo].[Product] ([IDProductType], [ProductName], [Article], [Cost]) VALUES (@IDProductType, @ProductName, @Article, @Cost); SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM Product WHERE (IDProduct = SCOPE_IDENTITY()) SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM dbo.Product UPDATE [dbo].[Product] SET [IDProductType] = @IDProductType, [ProductName] = @ProductName, [Article] = @Article, [Cost] = @Cost WHERE (([IDProduct] = @Original_IDProduct) AND ((@IsNull_IDProductType = 1 AND [IDProductType] IS NULL) OR ([IDProductType] = @Original_IDProductType)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost))); SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM Product WHERE (IDProduct = @IDProduct) DELETE FROM [dbo].[ProductType] WHERE (([IDProductType] = @Original_IDProductType) AND ((@IsNull_ProductType = 1 AND [ProductType] IS NULL) OR ([ProductType] = @Original_ProductType)) AND ((@IsNull_Сoefficient = 1 AND [Сoefficient] IS NULL) OR ([Сoefficient] = @Original_Сoefficient))) INSERT INTO [dbo].[ProductType] ([ProductType], [Сoefficient]) VALUES (@ProductType, @Сoefficient); SELECT IDProductType, ProductType, Сoefficient FROM ProductType WHERE (IDProductType = SCOPE_IDENTITY()) SELECT IDProductType, ProductType, Сoefficient FROM dbo.ProductType UPDATE [dbo].[ProductType] SET [ProductType] = @ProductType, [Сoefficient] = @Сoefficient WHERE (([IDProductType] = @Original_IDProductType) AND ((@IsNull_ProductType = 1 AND [ProductType] IS NULL) OR ([ProductType] = @Original_ProductType)) AND ((@IsNull_Сoefficient = 1 AND [Сoefficient] IS NULL) OR ([Сoefficient] = @Original_Сoefficient))); SELECT IDProductType, ProductType, Сoefficient FROM ProductType WHERE (IDProductType = @IDProductType) DELETE FROM [dbo].[Region] WHERE (([IDRegion] = @Original_IDRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region))) INSERT INTO [dbo].[Region] ([Region]) VALUES (@Region); SELECT IDRegion, Region FROM Region WHERE (IDRegion = SCOPE_IDENTITY()) SELECT IDRegion, Region FROM dbo.Region UPDATE [dbo].[Region] SET [Region] = @Region WHERE (([IDRegion] = @Original_IDRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region))); SELECT IDRegion, Region FROM Region WHERE (IDRegion = @IDRegion) DELETE FROM [dbo].[Street] WHERE (([IDStreet] = @Original_IDStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street))) INSERT INTO [dbo].[Street] ([Street]) VALUES (@Street); SELECT IDStreet, Street FROM Street WHERE (IDStreet = SCOPE_IDENTITY()) SELECT IDStreet, Street FROM dbo.Street UPDATE [dbo].[Street] SET [Street] = @Street WHERE (([IDStreet] = @Original_IDStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street))); SELECT IDStreet, Street FROM Street WHERE (IDStreet = @IDStreet) DELETE FROM [dbo].[TypeMaterial] WHERE (([IDTypeMaterial] = @Original_IDTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_DefectPercent = 1 AND [DefectPercent] IS NULL) OR ([DefectPercent] = @Original_DefectPercent))) INSERT INTO [dbo].[TypeMaterial] ([TypeMaterial], [DefectPercent]) VALUES (@TypeMaterial, @DefectPercent); SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM TypeMaterial WHERE (IDTypeMaterial = SCOPE_IDENTITY()) SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM dbo.TypeMaterial UPDATE [dbo].[TypeMaterial] SET [TypeMaterial] = @TypeMaterial, [DefectPercent] = @DefectPercent WHERE (([IDTypeMaterial] = @Original_IDTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_DefectPercent = 1 AND [DefectPercent] IS NULL) OR ([DefectPercent] = @Original_DefectPercent))); SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM TypeMaterial WHERE (IDTypeMaterial = @IDTypeMaterial) DELETE FROM [dbo].[TypePartner] WHERE (([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_TypePartner = 1 AND [TypePartner] IS NULL) OR ([TypePartner] = @Original_TypePartner))) INSERT INTO [dbo].[TypePartner] ([TypePartner]) VALUES (@TypePartner); SELECT IDTypePartner, TypePartner FROM TypePartner WHERE (IDTypePartner = SCOPE_IDENTITY()) SELECT IDTypePartner, TypePartner FROM dbo.TypePartner UPDATE [dbo].[TypePartner] SET [TypePartner] = @TypePartner WHERE (([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_TypePartner = 1 AND [TypePartner] IS NULL) OR ([TypePartner] = @Original_TypePartner))); SELECT IDTypePartner, TypePartner FROM TypePartner WHERE (IDTypePartner = @IDTypePartner) select 'Все типы' union all SELECT TypePartner FROM TypePartner SELECT PartnerProducts.IDPartner,Product.ProductName, PartnerProducts.CountProduct, PartnerProducts.DateSale FROM PartnerProducts INNER JOIN Product ON PartnerProducts.IDProduct = Product.IDProduct