DELETE FROM [dbo].[Order] WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate)) INSERT INTO [dbo].[Order] ([OrderStatus], [OrderDeliveryDate], [OrderPickupPoint]) VALUES (@OrderStatus, @OrderDeliveryDate, @OrderPickupPoint); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = SCOPE_IDENTITY()) SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM dbo.[Order] UPDATE [dbo].[Order] SET [OrderStatus] = @OrderStatus, [OrderDeliveryDate] = @OrderDeliveryDate, [OrderPickupPoint] = @OrderPickupPoint WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate)); SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = @OrderID) DELETE FROM [dbo].[OrdersProdukts] WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)) INSERT INTO [dbo].[OrdersProdukts] ([ProductArticleNumber]) VALUES (@ProductArticleNumber); SELECT OrderID, ProductArticleNumber FROM OrdersProdukts WHERE (OrderID = SCOPE_IDENTITY()) SELECT OrderID, ProductArticleNumber FROM dbo.OrdersProdukts UPDATE [dbo].[OrdersProdukts] SET [ProductArticleNumber] = @ProductArticleNumber WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)); SELECT OrderID, ProductArticleNumber FROM OrdersProdukts WHERE (OrderID = @OrderID) DELETE FROM [dbo].[Prodykt] WHERE (([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Prais = 1 AND [Prais] IS NULL) OR ([Prais] = @Original_Prais)) AND ((@IsNull_Единица_измерения = 1 AND [Единица_измерения] IS NULL) OR ([Единица_измерения] = @Original_Единица_измерения)) AND ((@IsNull_Размер_макс_скидки = 1 AND [Размер_макс_скидки] IS NULL) OR ([Размер_макс_скидки] = @Original_Размер_макс_скидки)) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_Действующая_Скидка = 1 AND [Действующая_Скидка] IS NULL) OR ([Действующая_Скидка] = @Original_Действующая_Скидка)) AND ((@IsNull_Количество_на_складе = 1 AND [Количество_на_складе] IS NULL) OR ([Количество_на_складе] = @Original_Количество_на_складе)) AND ((@IsNull_OrderID = 1 AND [OrderID] IS NULL) OR ([OrderID] = @Original_OrderID))) INSERT INTO [dbo].[Prodykt] ([ArticleNumber], [Name], [Description], [Category], [Photo], [Manufacturer], [Prais], [Единица_измерения], [Размер_макс_скидки], [Поставщик], [Действующая_Скидка], [Количество_на_складе], [Ctatys], [OrderID]) VALUES (@ArticleNumber, @Name, @Description, @Category, @Photo, @Manufacturer, @Prais, @Единица_измерения, @Размер_макс_скидки, @Поставщик, @Действующая_Скидка, @Количество_на_складе, @Ctatys, @OrderID); SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM Prodykt WHERE (ArticleNumber = @ArticleNumber) SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM dbo.Prodykt UPDATE [dbo].[Prodykt] SET [ArticleNumber] = @ArticleNumber, [Name] = @Name, [Description] = @Description, [Category] = @Category, [Photo] = @Photo, [Manufacturer] = @Manufacturer, [Prais] = @Prais, [Единица_измерения] = @Единица_измерения, [Размер_макс_скидки] = @Размер_макс_скидки, [Поставщик] = @Поставщик, [Действующая_Скидка] = @Действующая_Скидка, [Количество_на_складе] = @Количество_на_складе, [Ctatys] = @Ctatys, [OrderID] = @OrderID WHERE (([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Prais = 1 AND [Prais] IS NULL) OR ([Prais] = @Original_Prais)) AND ((@IsNull_Единица_измерения = 1 AND [Единица_измерения] IS NULL) OR ([Единица_измерения] = @Original_Единица_измерения)) AND ((@IsNull_Размер_макс_скидки = 1 AND [Размер_макс_скидки] IS NULL) OR ([Размер_макс_скидки] = @Original_Размер_макс_скидки)) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_Действующая_Скидка = 1 AND [Действующая_Скидка] IS NULL) OR ([Действующая_Скидка] = @Original_Действующая_Скидка)) AND ((@IsNull_Количество_на_складе = 1 AND [Количество_на_складе] IS NULL) OR ([Количество_на_складе] = @Original_Количество_на_складе)) AND ((@IsNull_OrderID = 1 AND [OrderID] IS NULL) OR ([OrderID] = @Original_OrderID))); SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM Prodykt WHERE (ArticleNumber = @ArticleNumber) DELETE FROM [dbo].[Role] WHERE (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName)) INSERT INTO [dbo].[Role] ([RoleName]) VALUES (@RoleName); SELECT RoleID, RoleName FROM Role WHERE (RoleID = SCOPE_IDENTITY()) SELECT RoleID, RoleName FROM dbo.Role UPDATE [dbo].[Role] SET [RoleName] = @RoleName WHERE (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName)); SELECT RoleID, RoleName FROM Role WHERE (RoleID = @RoleID) DELETE FROM [dbo].[Users1] WHERE (([id] = @Original_id) AND ((@IsNull_familia = 1 AND [familia] IS NULL) OR ([familia] = @Original_familia)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_othestvo = 1 AND [othestvo] IS NULL) OR ([othestvo] = @Original_othestvo)) AND ((@IsNull_pole = 1 AND [pole] IS NULL) OR ([pole] = @Original_pole))) INSERT INTO [dbo].[Users1] ([familia], [name], [othestvo], [login], [pasword], [pole]) VALUES (@familia, @name, @othestvo, @login, @pasword, @pole); SELECT id, familia, name, othestvo, login, pasword, pole FROM Users1 WHERE (id = SCOPE_IDENTITY()) SELECT id, familia, name, othestvo, login, pasword, pole FROM dbo.Users1 UPDATE [dbo].[Users1] SET [familia] = @familia, [name] = @name, [othestvo] = @othestvo, [login] = @login, [pasword] = @pasword, [pole] = @pole WHERE (([id] = @Original_id) AND ((@IsNull_familia = 1 AND [familia] IS NULL) OR ([familia] = @Original_familia)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_othestvo = 1 AND [othestvo] IS NULL) OR ([othestvo] = @Original_othestvo)) AND ((@IsNull_pole = 1 AND [pole] IS NULL) OR ([pole] = @Original_pole))); SELECT id, familia, name, othestvo, login, pasword, pole FROM Users1 WHERE (id = @id) DELETE FROM [dbo].[Zakaz] WHERE (([id] = @Original_id) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_dadaDostavki = 1 AND [dadaDostavki] IS NULL) OR ([dadaDostavki] = @Original_dadaDostavki)) AND ((@IsNull_Punkt = 1 AND [Punkt] IS NULL) OR ([Punkt] = @Original_Punkt)) AND ((@IsNull_Klient = 1 AND [Klient] IS NULL) OR ([Klient] = @Original_Klient)) AND ((@IsNull_KodPoluhatil = 1 AND [KodPoluhatil] IS NULL) OR ([KodPoluhatil] = @Original_KodPoluhatil)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status))) INSERT INTO [dbo].[Zakaz] ([data], [dadaDostavki], [Punkt], [Klient], [KodPoluhatil], [Status]) VALUES (@data, @dadaDostavki, @Punkt, @Klient, @KodPoluhatil, @Status); SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM Zakaz WHERE (id = SCOPE_IDENTITY()) SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM dbo.Zakaz UPDATE [dbo].[Zakaz] SET [data] = @data, [dadaDostavki] = @dadaDostavki, [Punkt] = @Punkt, [Klient] = @Klient, [KodPoluhatil] = @KodPoluhatil, [Status] = @Status WHERE (([id] = @Original_id) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_dadaDostavki = 1 AND [dadaDostavki] IS NULL) OR ([dadaDostavki] = @Original_dadaDostavki)) AND ((@IsNull_Punkt = 1 AND [Punkt] IS NULL) OR ([Punkt] = @Original_Punkt)) AND ((@IsNull_Klient = 1 AND [Klient] IS NULL) OR ([Klient] = @Original_Klient)) AND ((@IsNull_KodPoluhatil = 1 AND [KodPoluhatil] IS NULL) OR ([KodPoluhatil] = @Original_KodPoluhatil)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status))); SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM Zakaz WHERE (id = @id) DELETE FROM [dbo].[ZakazTovara] WHERE (([id] = @Original_id) AND ((@IsNull_nomerZakaz = 1 AND [nomerZakaz] IS NULL) OR ([nomerZakaz] = @Original_nomerZakaz)) AND ((@IsNull_nameTovar = 1 AND [nameTovar] IS NULL) OR ([nameTovar] = @Original_nameTovar)) AND ((@IsNull_kolichestvo = 1 AND [kolichestvo] IS NULL) OR ([kolichestvo] = @Original_kolichestvo)) AND ((@IsNull_id_punkt = 1 AND [id_punkt] IS NULL) OR ([id_punkt] = @Original_id_punkt))) INSERT INTO [dbo].[ZakazTovara] ([nomerZakaz], [nameTovar], [kolichestvo], [id_punkt]) VALUES (@nomerZakaz, @nameTovar, @kolichestvo, @id_punkt); SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM ZakazTovara WHERE (id = SCOPE_IDENTITY()) SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM dbo.ZakazTovara UPDATE [dbo].[ZakazTovara] SET [nomerZakaz] = @nomerZakaz, [nameTovar] = @nameTovar, [kolichestvo] = @kolichestvo, [id_punkt] = @id_punkt WHERE (([id] = @Original_id) AND ((@IsNull_nomerZakaz = 1 AND [nomerZakaz] IS NULL) OR ([nomerZakaz] = @Original_nomerZakaz)) AND ((@IsNull_nameTovar = 1 AND [nameTovar] IS NULL) OR ([nameTovar] = @Original_nameTovar)) AND ((@IsNull_kolichestvo = 1 AND [kolichestvo] IS NULL) OR ([kolichestvo] = @Original_kolichestvo)) AND ((@IsNull_id_punkt = 1 AND [id_punkt] IS NULL) OR ([id_punkt] = @Original_id_punkt))); SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM ZakazTovara WHERE (id = @id) DELETE FROM [dbo].[ПунктВыдачи] WHERE (([id] = @Original_id) AND ([Идентификатор] = @Original_Идентификатор) AND ([Город] = @Original_Город) AND ([Улица] = @Original_Улица) AND ((@IsNull_Дом = 1 AND [Дом] IS NULL) OR ([Дом] = @Original_Дом))) INSERT INTO [dbo].[ПунктВыдачи] ([Идентификатор], [Город], [Улица], [Дом]) VALUES (@Идентификатор, @Город, @Улица, @Дом); SELECT id, Идентификатор, Город, Улица, Дом FROM ПунктВыдачи WHERE (id = SCOPE_IDENTITY()) SELECT id, Идентификатор, Город, Улица, Дом FROM dbo.ПунктВыдачи UPDATE [dbo].[ПунктВыдачи] SET [Идентификатор] = @Идентификатор, [Город] = @Город, [Улица] = @Улица, [Дом] = @Дом WHERE (([id] = @Original_id) AND ([Идентификатор] = @Original_Идентификатор) AND ([Город] = @Original_Город) AND ([Улица] = @Original_Улица) AND ((@IsNull_Дом = 1 AND [Дом] IS NULL) OR ([Дом] = @Original_Дом))); SELECT id, Идентификатор, Город, Улица, Дом FROM ПунктВыдачи WHERE (id = @id)