OrderDetail_Triggers.sql

-- OrderDetail tablosu için trigger

CREATE TRIGGER IncreaseOrderTotalPrice
On OrderDetails
After Insert
As
Declare @OrderId int
Declare @OrderPrice decimal
Select @OrderId = OrderId From inserted
Select @orderPrice = TotalPrice From inserted
Update Orders Set TotalPrice = TotalPrice + @OrderPrice Where OrderId=@OrderId


CREATE TRIGGER DecreaseOrderTotalPrice
On OrderDetails
After Delete
As
Declare @OrderId int
Declare @OrderPrice decimal
Select @OrderId = OrderId From deleted
Select @orderPrice = TotalPrice From deleted
Update Orders Set TotalPrice = TotalPrice - @OrderPrice Where OrderId=@OrderId