DELETE FROM [dbo].[Akademiki] WHERE (([id] = @Original_id) AND ([DateOfbirth] = @Original_DateOfbirth) AND ([Spec] = @Original_Spec) AND ([yearOrden] = @Original_yearOrden)) INSERT INTO [dbo].[Akademiki] ([id], [FIO], [DateOfbirth], [Spec], [yearOrden]) VALUES (@id, @FIO, @DateOfbirth, @Spec, @yearOrden); SELECT id, FIO, DateOfbirth, Spec, yearOrden FROM Akademiki WHERE (id = @id) SELECT id, FIO, DateOfbirth, Spec, yearOrden FROM dbo.Akademiki UPDATE [dbo].[Akademiki] SET [id] = @id, [FIO] = @FIO, [DateOfbirth] = @DateOfbirth, [Spec] = @Spec, [yearOrden] = @yearOrden WHERE (([id] = @Original_id) AND ([DateOfbirth] = @Original_DateOfbirth) AND ([Spec] = @Original_Spec) AND ([yearOrden] = @Original_yearOrden)); SELECT id, FIO, DateOfbirth, Spec, yearOrden FROM Akademiki WHERE (id = @id) INSERT INTO [dbo].[applic] ([number], [kodsubj]) VALUES (@number, @kodsubj) SELECT number, kodsubj FROM dbo.applic INSERT INTO [dbo].[billin] ([emailpayer], [emailrecipient], [SUM], [CURRENCY], [BILLINGDATE], [COMMENT]) VALUES (@emailpayer, @emailrecipient, @SUM, @CURRENCY, @BILLINGDATE, @COMMENT) SELECT emailpayer, emailrecipient, SUM, CURRENCY, BILLINGDATE, COMMENT FROM dbo.billin INSERT INTO [dbo].[billing] ([emailpayer], [emailrecipient], [SUM], [CURRENCY], [BILLINGDATE], [COMMENT]) VALUES (@emailpayer, @emailrecipient, @SUM, @CURRENCY, @BILLINGDATE, @COMMENT) SELECT emailpayer, emailrecipient, SUM, CURRENCY, BILLINGDATE, COMMENT FROM dbo.billing DELETE FROM [dbo].[Countries] WHERE (([Name] = @Original_Name) AND ([capital] = @Original_capital) AND ([square] = @Original_square) AND ([population] = @Original_population) AND ([contin] = @Original_contin)) INSERT INTO [dbo].[Countries] ([Name], [capital], [square], [population], [contin]) VALUES (@Name, @capital, @square, @population, @contin); SELECT Name, capital, square, population, contin FROM Countries WHERE (Name = @Name) SELECT Name, capital, square, population, contin FROM dbo.Countries UPDATE [dbo].[Countries] SET [Name] = @Name, [capital] = @capital, [square] = @square, [population] = @population, [contin] = @contin WHERE (([Name] = @Original_Name) AND ([capital] = @Original_capital) AND ([square] = @Original_square) AND ([population] = @Original_population) AND ([contin] = @Original_contin)); SELECT Name, capital, square, population, contin FROM Countries WHERE (Name = @Name) DELETE FROM [dbo].[Countries2] WHERE (([country] = @Original_country) AND ([capital] = @Original_capital) AND ([cont] = @Original_cont) AND ([popul] = @Original_popul) AND ([sqr] = @Original_sqr) AND ([typeOfgov] = @Original_typeOfgov)) INSERT INTO [dbo].[Countries2] ([country], [capital], [cont], [popul], [sqr], [typeOfgov]) VALUES (@country, @capital, @cont, @popul, @sqr, @typeOfgov); SELECT country, capital, cont, popul, sqr, typeOfgov FROM Countries2 WHERE (country = @country) SELECT country, capital, cont, popul, sqr, typeOfgov FROM dbo.Countries2 UPDATE [dbo].[Countries2] SET [country] = @country, [capital] = @capital, [cont] = @cont, [popul] = @popul, [sqr] = @sqr, [typeOfgov] = @typeOfgov WHERE (([country] = @Original_country) AND ([capital] = @Original_capital) AND ([cont] = @Original_cont) AND ([popul] = @Original_popul) AND ([sqr] = @Original_sqr) AND ([typeOfgov] = @Original_typeOfgov)); SELECT country, capital, cont, popul, sqr, typeOfgov FROM Countries2 WHERE (country = @country) INSERT INTO [dbo].[departOwner] ([Tabnumber], [exp]) VALUES (@Tabnumber, @exp) SELECT Tabnumber, exp FROM dbo.departOwner DELETE FROM [dbo].[Departs] WHERE (([abbrDep] = @Original_abbrDep) AND ([FacultyAbbr] = @Original_FacultyAbbr)) INSERT INTO [dbo].[Departs] ([abbrDep], [Name], [FacultyAbbr]) VALUES (@abbrDep, @Name, @FacultyAbbr); SELECT abbrDep, Name, FacultyAbbr FROM Departs WHERE (abbrDep = @abbrDep) SELECT abbrDep, Name, FacultyAbbr FROM dbo.Departs UPDATE [dbo].[Departs] SET [abbrDep] = @abbrDep, [Name] = @Name, [FacultyAbbr] = @FacultyAbbr WHERE (([abbrDep] = @Original_abbrDep) AND ([FacultyAbbr] = @Original_FacultyAbbr)); SELECT abbrDep, Name, FacultyAbbr FROM Departs WHERE (abbrDep = @abbrDep) DELETE FROM [dbo].[engineer] WHERE (([tabnumber] = @Original_tabnumber) AND ([spec] = @Original_spec)) INSERT INTO [dbo].[engineer] ([tabnumber], [spec]) VALUES (@tabnumber, @spec); SELECT tabnumber, spec FROM engineer WHERE (tabnumber = @tabnumber) SELECT tabnumber, spec FROM dbo.engineer UPDATE [dbo].[engineer] SET [tabnumber] = @tabnumber, [spec] = @spec WHERE (([tabnumber] = @Original_tabnumber) AND ([spec] = @Original_spec)); SELECT tabnumber, spec FROM engineer WHERE (tabnumber = @tabnumber) DELETE FROM [dbo].[Exams] WHERE (([idExam] = @Original_idExam) AND ([date] = @Original_date) AND ([kodSubj] = @Original_kodSubj) AND ([regNumber] = @Original_regNumber) AND ([tabNumber] = @Original_tabNumber) AND ([Classroom] = @Original_Classroom) AND ([mark] = @Original_mark)) INSERT INTO [dbo].[Exams] ([idExam], [date], [kodSubj], [regNumber], [tabNumber], [Classroom], [mark]) VALUES (@idExam, @date, @kodSubj, @regNumber, @tabNumber, @Classroom, @mark); SELECT idExam, date, kodSubj, regNumber, tabNumber, Classroom, mark FROM Exams WHERE (idExam = @idExam) SELECT idExam, date, kodSubj, regNumber, tabNumber, Classroom, mark FROM dbo.Exams UPDATE [dbo].[Exams] SET [idExam] = @idExam, [date] = @date, [kodSubj] = @kodSubj, [regNumber] = @regNumber, [tabNumber] = @tabNumber, [Classroom] = @Classroom, [mark] = @mark WHERE (([idExam] = @Original_idExam) AND ([date] = @Original_date) AND ([kodSubj] = @Original_kodSubj) AND ([regNumber] = @Original_regNumber) AND ([tabNumber] = @Original_tabNumber) AND ([Classroom] = @Original_Classroom) AND ([mark] = @Original_mark)); SELECT idExam, date, kodSubj, regNumber, tabNumber, Classroom, mark FROM Exams WHERE (idExam = @idExam) DELETE FROM [dbo].[Fuculty] WHERE (([abbrF] = @Original_abbrF) AND ([Name] = @Original_Name)) INSERT INTO [dbo].[Fuculty] ([abbrF], [Name]) VALUES (@abbrF, @Name); SELECT abbrF, Name FROM Fuculty WHERE (abbrF = @abbrF) SELECT abbrF, Name FROM dbo.Fuculty UPDATE [dbo].[Fuculty] SET [abbrF] = @abbrF, [Name] = @Name WHERE (([abbrF] = @Original_abbrF) AND ([Name] = @Original_Name)); SELECT abbrF, Name FROM Fuculty WHERE (abbrF = @abbrF) DELETE FROM [dbo].[KindOfgov] WHERE (([kod] = @Original_kod) AND ([kind] = @Original_kind)) INSERT INTO [dbo].[KindOfgov] ([kod], [kind]) VALUES (@kod, @kind); SELECT kod, kind FROM KindOfgov WHERE (kod = @kod) SELECT kod, kind FROM dbo.KindOfgov UPDATE [dbo].[KindOfgov] SET [kod] = @kod, [kind] = @kind WHERE (([kod] = @Original_kod) AND ([kind] = @Original_kind)); SELECT kod, kind FROM KindOfgov WHERE (kod = @kod) 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].[OrderProduct] WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)) INSERT INTO [dbo].[OrderProduct] ([OrderID], [ProductArticleNumber]) VALUES (@OrderID, @ProductArticleNumber); SELECT OrderID, ProductArticleNumber FROM OrderProduct WHERE (OrderID = @OrderID) AND (ProductArticleNumber = @ProductArticleNumber) SELECT OrderID, ProductArticleNumber FROM dbo.OrderProduct UPDATE [dbo].[OrderProduct] SET [OrderID] = @OrderID, [ProductArticleNumber] = @ProductArticleNumber WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber)); SELECT OrderID, ProductArticleNumber FROM OrderProduct WHERE (OrderID = @OrderID) AND (ProductArticleNumber = @ProductArticleNumber) DELETE FROM [dbo].[Product] WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock)) INSERT INTO [dbo].[Product] ([ProductArticleNumber], [ProductName], [ProductDescription], [ProductCategory], [ProductPhoto], [ProductManufacturer], [ProductCost], [ProductDiscountAmount], [ProductQuantityInStock], [ProductStatus]) VALUES (@ProductArticleNumber, @ProductName, @ProductDescription, @ProductCategory, @ProductPhoto, @ProductManufacturer, @ProductCost, @ProductDiscountAmount, @ProductQuantityInStock, @ProductStatus); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber) SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus FROM dbo.Product UPDATE [dbo].[Product] SET [ProductArticleNumber] = @ProductArticleNumber, [ProductName] = @ProductName, [ProductDescription] = @ProductDescription, [ProductCategory] = @ProductCategory, [ProductPhoto] = @ProductPhoto, [ProductManufacturer] = @ProductManufacturer, [ProductCost] = @ProductCost, [ProductDiscountAmount] = @ProductDiscountAmount, [ProductQuantityInStock] = @ProductQuantityInStock, [ProductStatus] = @ProductStatus WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock)); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock, ProductStatus FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber) 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].[Specs] WHERE (([NumberOfSpec] = @Original_NumberOfSpec) AND ([abbr] = @Original_abbr)) INSERT INTO [dbo].[Specs] ([NumberOfSpec], [Direction], [abbr]) VALUES (@NumberOfSpec, @Direction, @abbr); SELECT NumberOfSpec, Direction, abbr FROM Specs WHERE (NumberOfSpec = @NumberOfSpec) SELECT NumberOfSpec, Direction, abbr FROM dbo.Specs UPDATE [dbo].[Specs] SET [NumberOfSpec] = @NumberOfSpec, [Direction] = @Direction, [abbr] = @abbr WHERE (([NumberOfSpec] = @Original_NumberOfSpec) AND ([abbr] = @Original_abbr)); SELECT NumberOfSpec, Direction, abbr FROM Specs WHERE (NumberOfSpec = @NumberOfSpec) DELETE FROM [dbo].[Students] WHERE (([idStud] = @Original_idStud) AND ([number] = @Original_number)) INSERT INTO [dbo].[Students] ([idStud], [number], [FIO]) VALUES (@idStud, @number, @FIO); SELECT idStud, number, FIO FROM Students WHERE (idStud = @idStud) SELECT idStud, number, FIO FROM dbo.Students UPDATE [dbo].[Students] SET [idStud] = @idStud, [number] = @number, [FIO] = @FIO WHERE (([idStud] = @Original_idStud) AND ([number] = @Original_number)); SELECT idStud, number, FIO FROM Students WHERE (idStud = @idStud) DELETE FROM [dbo].[students2] WHERE (([ID] = @Original_ID) AND ([FIO] = @Original_FIO) AND ([subj] = @Original_subj) AND ([School] = @Original_School) AND ([Points] = @Original_Points)) INSERT INTO [dbo].[students2] ([ID], [FIO], [subj], [School], [Points]) VALUES (@ID, @FIO, @subj, @School, @Points); SELECT ID, FIO, subj, School, Points FROM students2 WHERE (ID = @ID) SELECT ID, FIO, subj, School, Points FROM dbo.students2 UPDATE [dbo].[students2] SET [ID] = @ID, [FIO] = @FIO, [subj] = @subj, [School] = @School, [Points] = @Points WHERE (([ID] = @Original_ID) AND ([FIO] = @Original_FIO) AND ([subj] = @Original_subj) AND ([School] = @Original_School) AND ([Points] = @Original_Points)); SELECT ID, FIO, subj, School, Points FROM students2 WHERE (ID = @ID) DELETE FROM [dbo].[Subjs] WHERE (([idsubj] = @Original_idsubj) AND ([hours] = @Original_hours) AND ([Name] = @Original_Name) AND ([abbr] = @Original_abbr)) INSERT INTO [dbo].[Subjs] ([idsubj], [hours], [Name], [abbr]) VALUES (@idsubj, @hours, @Name, @abbr); SELECT idsubj, hours, Name, abbr FROM Subjs WHERE (idsubj = @idsubj) SELECT idsubj, hours, Name, abbr FROM dbo.Subjs UPDATE [dbo].[Subjs] SET [idsubj] = @idsubj, [hours] = @hours, [Name] = @Name, [abbr] = @abbr WHERE (([idsubj] = @Original_idsubj) AND ([hours] = @Original_hours) AND ([Name] = @Original_Name) AND ([abbr] = @Original_abbr)); SELECT idsubj, hours, Name, abbr FROM Subjs WHERE (idsubj = @idsubj) DELETE FROM [dbo].[tbl_categories] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_categories] ([title], [description], [added_date], [added_by]) VALUES (@title, @description, @added_date, @added_by); SELECT id, title, description, added_date, added_by FROM tbl_categories WHERE (id = SCOPE_IDENTITY()) SELECT id, title, description, added_date, added_by FROM dbo.tbl_categories UPDATE [dbo].[tbl_categories] SET [title] = @title, [description] = @description, [added_date] = @added_date, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, title, description, added_date, added_by FROM tbl_categories WHERE (id = @id) DELETE FROM [dbo].[tbl_dea_cust] WHERE (([id] = @Original_id) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_dea_cust] ([type], [name], [email], [contact], [address], [added_date], [added_by]) VALUES (@type, @name, @email, @contact, @address, @added_date, @added_by); SELECT id, type, name, email, contact, address, added_date, added_by FROM tbl_dea_cust WHERE (id = SCOPE_IDENTITY()) SELECT id, type, name, email, contact, address, added_date, added_by FROM dbo.tbl_dea_cust UPDATE [dbo].[tbl_dea_cust] SET [type] = @type, [name] = @name, [email] = @email, [contact] = @contact, [address] = @address, [added_date] = @added_date, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, type, name, email, contact, address, added_date, added_by FROM tbl_dea_cust WHERE (id = @id) DELETE FROM [dbo].[tbl_products] WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_category = 1 AND [category] IS NULL) OR ([category] = @Original_category)) AND ((@IsNull_rate = 1 AND [rate] IS NULL) OR ([rate] = @Original_rate)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_products] ([name], [category], [description], [rate], [qty], [added_date], [added_by]) VALUES (@name, @category, @description, @rate, @qty, @added_date, @added_by); SELECT id, name, category, description, rate, qty, added_date, added_by FROM tbl_products WHERE (id = SCOPE_IDENTITY()) SELECT id, name, category, description, rate, qty, added_date, added_by FROM dbo.tbl_products UPDATE [dbo].[tbl_products] SET [name] = @name, [category] = @category, [description] = @description, [rate] = @rate, [qty] = @qty, [added_date] = @added_date, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_category = 1 AND [category] IS NULL) OR ([category] = @Original_category)) AND ((@IsNull_rate = 1 AND [rate] IS NULL) OR ([rate] = @Original_rate)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, name, category, description, rate, qty, added_date, added_by FROM tbl_products WHERE (id = @id) DELETE FROM [dbo].[tbl_transaction_detail] WHERE (([id] = @Original_id) AND ((@IsNull_product_id = 1 AND [product_id] IS NULL) OR ([product_id] = @Original_product_id)) AND ((@IsNull_rate = 1 AND [rate] IS NULL) OR ([rate] = @Original_rate)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)) AND ((@IsNull_dea_cust_id = 1 AND [dea_cust_id] IS NULL) OR ([dea_cust_id] = @Original_dea_cust_id)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_transaction_detail] ([product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by]) VALUES (@product_id, @rate, @qty, @total, @dea_cust_id, @added_date, @added_by); SELECT id, product_id, rate, qty, total, dea_cust_id, added_date, added_by FROM tbl_transaction_detail WHERE (id = SCOPE_IDENTITY()) SELECT id, product_id, rate, qty, total, dea_cust_id, added_date, added_by FROM dbo.tbl_transaction_detail UPDATE [dbo].[tbl_transaction_detail] SET [product_id] = @product_id, [rate] = @rate, [qty] = @qty, [total] = @total, [dea_cust_id] = @dea_cust_id, [added_date] = @added_date, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_product_id = 1 AND [product_id] IS NULL) OR ([product_id] = @Original_product_id)) AND ((@IsNull_rate = 1 AND [rate] IS NULL) OR ([rate] = @Original_rate)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)) AND ((@IsNull_dea_cust_id = 1 AND [dea_cust_id] IS NULL) OR ([dea_cust_id] = @Original_dea_cust_id)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, product_id, rate, qty, total, dea_cust_id, added_date, added_by FROM tbl_transaction_detail WHERE (id = @id) DELETE FROM [dbo].[tbl_transactions] WHERE (([id] = @Original_id) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_dea_cust_id = 1 AND [dea_cust_id] IS NULL) OR ([dea_cust_id] = @Original_dea_cust_id)) AND ((@IsNull_grandTotal = 1 AND [grandTotal] IS NULL) OR ([grandTotal] = @Original_grandTotal)) AND ((@IsNull_transaction_date = 1 AND [transaction_date] IS NULL) OR ([transaction_date] = @Original_transaction_date)) AND ((@IsNull_tax = 1 AND [tax] IS NULL) OR ([tax] = @Original_tax)) AND ((@IsNull_discount = 1 AND [discount] IS NULL) OR ([discount] = @Original_discount)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_transactions] ([type], [dea_cust_id], [grandTotal], [transaction_date], [tax], [discount], [added_by]) VALUES (@type, @dea_cust_id, @grandTotal, @transaction_date, @tax, @discount, @added_by); SELECT id, type, dea_cust_id, grandTotal, transaction_date, tax, discount, added_by FROM tbl_transactions WHERE (id = SCOPE_IDENTITY()) SELECT id, type, dea_cust_id, grandTotal, transaction_date, tax, discount, added_by FROM dbo.tbl_transactions UPDATE [dbo].[tbl_transactions] SET [type] = @type, [dea_cust_id] = @dea_cust_id, [grandTotal] = @grandTotal, [transaction_date] = @transaction_date, [tax] = @tax, [discount] = @discount, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_dea_cust_id = 1 AND [dea_cust_id] IS NULL) OR ([dea_cust_id] = @Original_dea_cust_id)) AND ((@IsNull_grandTotal = 1 AND [grandTotal] IS NULL) OR ([grandTotal] = @Original_grandTotal)) AND ((@IsNull_transaction_date = 1 AND [transaction_date] IS NULL) OR ([transaction_date] = @Original_transaction_date)) AND ((@IsNull_tax = 1 AND [tax] IS NULL) OR ([tax] = @Original_tax)) AND ((@IsNull_discount = 1 AND [discount] IS NULL) OR ([discount] = @Original_discount)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, type, dea_cust_id, grandTotal, transaction_date, tax, discount, added_by FROM tbl_transactions WHERE (id = @id) DELETE FROM [dbo].[tbl_users] WHERE (([id] = @Original_id) AND ((@IsNull_first_name = 1 AND [first_name] IS NULL) OR ([first_name] = @Original_first_name)) AND ((@IsNull_last_name = 1 AND [last_name] IS NULL) OR ([last_name] = @Original_last_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_gender = 1 AND [gender] IS NULL) OR ([gender] = @Original_gender)) AND ((@IsNull_user_type = 1 AND [user_type] IS NULL) OR ([user_type] = @Original_user_type)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))) INSERT INTO [dbo].[tbl_users] ([first_name], [last_name], [email], [username], [password], [contact], [address], [gender], [user_type], [added_date], [added_by]) VALUES (@first_name, @last_name, @email, @username, @password, @contact, @address, @gender, @user_type, @added_date, @added_by); SELECT id, first_name, last_name, email, username, password, contact, address, gender, user_type, added_date, added_by FROM tbl_users WHERE (id = SCOPE_IDENTITY()) SELECT id, first_name, last_name, email, username, password, contact, address, gender, user_type, added_date, added_by FROM dbo.tbl_users UPDATE [dbo].[tbl_users] SET [first_name] = @first_name, [last_name] = @last_name, [email] = @email, [username] = @username, [password] = @password, [contact] = @contact, [address] = @address, [gender] = @gender, [user_type] = @user_type, [added_date] = @added_date, [added_by] = @added_by WHERE (([id] = @Original_id) AND ((@IsNull_first_name = 1 AND [first_name] IS NULL) OR ([first_name] = @Original_first_name)) AND ((@IsNull_last_name = 1 AND [last_name] IS NULL) OR ([last_name] = @Original_last_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_gender = 1 AND [gender] IS NULL) OR ([gender] = @Original_gender)) AND ((@IsNull_user_type = 1 AND [user_type] IS NULL) OR ([user_type] = @Original_user_type)) AND ((@IsNull_added_date = 1 AND [added_date] IS NULL) OR ([added_date] = @Original_added_date)) AND ((@IsNull_added_by = 1 AND [added_by] IS NULL) OR ([added_by] = @Original_added_by))); SELECT id, first_name, last_name, email, username, password, contact, address, gender, user_type, added_date, added_by FROM tbl_users WHERE (id = @id) DELETE FROM [dbo].[Teachers] WHERE (([tabNumber] = @Original_tabNumber) AND ([rank] = @Original_rank) AND ([step] = @Original_step)) INSERT INTO [dbo].[Teachers] ([tabNumber], [rank], [step]) VALUES (@tabNumber, @rank, @step); SELECT tabNumber, rank, step FROM Teachers WHERE (tabNumber = @tabNumber) SELECT tabNumber, rank, step FROM dbo.Teachers UPDATE [dbo].[Teachers] SET [tabNumber] = @tabNumber, [rank] = @rank, [step] = @step WHERE (([tabNumber] = @Original_tabNumber) AND ([rank] = @Original_rank) AND ([step] = @Original_step)); SELECT tabNumber, rank, step FROM Teachers WHERE (tabNumber = @tabNumber) INSERT INTO [dbo].[Tovari] ([Товар]) VALUES (@Товар) SELECT Товар FROM dbo.Tovari DELETE FROM [dbo].[User] WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([UserRole] = @Original_UserRole)) INSERT INTO [dbo].[User] ([UserSurname], [UserName], [UserPatronymic], [UserLogin], [UserPassword], [UserRole]) VALUES (@UserSurname, @UserName, @UserPatronymic, @UserLogin, @UserPassword, @UserRole); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM [User] WHERE (UserID = SCOPE_IDENTITY()) SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM dbo.[User] UPDATE [dbo].[User] SET [UserSurname] = @UserSurname, [UserName] = @UserName, [UserPatronymic] = @UserPatronymic, [UserLogin] = @UserLogin, [UserPassword] = @UserPassword, [UserRole] = @UserRole WHERE (([UserID] = @Original_UserID) AND ([UserSurname] = @Original_UserSurname) AND ([UserName] = @Original_UserName) AND ([UserPatronymic] = @Original_UserPatronymic) AND ([UserRole] = @Original_UserRole)); SELECT UserID, UserSurname, UserName, UserPatronymic, UserLogin, UserPassword, UserRole FROM [User] WHERE (UserID = @UserID) DELETE FROM [dbo].[woorkers] WHERE (([ID] = @Original_ID) AND ((@IsNull_NAME = 1 AND [NAME] IS NULL) OR ([NAME] = @Original_NAME)) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Date = 1 AND [Date] IS NULL) OR ([Date] = @Original_Date)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description))) INSERT INTO [dbo].[woorkers] ([NAME], [login], [Salary], [Age], [Date], [Description]) VALUES (@NAME, @login, @Salary, @Age, @Date, @Description); SELECT ID, NAME, login, Salary, Age, Date, Description FROM woorkers WHERE (ID = SCOPE_IDENTITY()) SELECT ID, NAME, login, Salary, Age, Date, Description FROM dbo.woorkers UPDATE [dbo].[woorkers] SET [NAME] = @NAME, [login] = @login, [Salary] = @Salary, [Age] = @Age, [Date] = @Date, [Description] = @Description WHERE (([ID] = @Original_ID) AND ((@IsNull_NAME = 1 AND [NAME] IS NULL) OR ([NAME] = @Original_NAME)) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Date = 1 AND [Date] IS NULL) OR ([Date] = @Original_Date)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description))); SELECT ID, NAME, login, Salary, Age, Date, Description FROM woorkers WHERE (ID = @ID) INSERT INTO [dbo].[Worker] ([id], [name], [logn], [salary], [age], [date], [discription]) VALUES (@id, @name, @logn, @salary, @age, @date, @discription) SELECT id, name, logn, salary, age, date, discription FROM dbo.Worker DELETE FROM [dbo].[Workers] WHERE (([ID] = @Original_ID) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Date = 1 AND [Date] IS NULL) OR ([Date] = @Original_Date))) INSERT INTO [dbo].[Workers] ([Login], [Salary], [Age], [Date], [Description]) VALUES (@Login, @Salary, @Age, @Date, @Description); SELECT ID, Login, Salary, Age, Date, Description FROM Workers WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Login, Salary, Age, Date, Description FROM dbo.Workers UPDATE [dbo].[Workers] SET [Login] = @Login, [Salary] = @Salary, [Age] = @Age, [Date] = @Date, [Description] = @Description WHERE (([ID] = @Original_ID) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Salary = 1 AND [Salary] IS NULL) OR ([Salary] = @Original_Salary)) AND ((@IsNull_Age = 1 AND [Age] IS NULL) OR ([Age] = @Original_Age)) AND ((@IsNull_Date = 1 AND [Date] IS NULL) OR ([Date] = @Original_Date))); SELECT ID, Login, Salary, Age, Date, Description FROM Workers WHERE (ID = @ID) DELETE FROM [dbo].[Продажи] WHERE (([код_товара] = @Original_код_товара) AND ((@IsNull_дата = 1 AND [дата] IS NULL) OR ([дата] = @Original_дата)) AND ((@IsNull_количество = 1 AND [количество] IS NULL) OR ([количество] = @Original_количество))) INSERT INTO [dbo].[Продажи] ([код_товара], [дата], [количество]) VALUES (@код_товара, @дата, @количество); SELECT код_товара, дата, количество FROM Продажи WHERE (код_товара = @код_товара) SELECT код_товара, дата, количество FROM dbo.Продажи UPDATE [dbo].[Продажи] SET [код_товара] = @код_товара, [дата] = @дата, [количество] = @количество WHERE (([код_товара] = @Original_код_товара) AND ((@IsNull_дата = 1 AND [дата] IS NULL) OR ([дата] = @Original_дата)) AND ((@IsNull_количество = 1 AND [количество] IS NULL) OR ([количество] = @Original_количество))); SELECT код_товара, дата, количество FROM Продажи WHERE (код_товара = @код_товара) INSERT INTO [dbo].[Товары] ([код], [название]) VALUES (@код, @название) SELECT код, название FROM dbo.Товары