Guest User

Untitled

a guest
Jul 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. public void DeleteFruit(Guid fruitId,Guid userId)
  2. {
  3. var fruit= db.Fruits.Where(r => (r.Id== fruitId).FirstorDefault();
  4. if (fruit != null)
  5. {
  6. var record = new MonitorDelete { ID = fruit.ID, UserID = userId};
  7. db.MonitorDeletes.Add(record);
  8. db.Fruits.Remove(fruit);
  9. db.SaveChanges();
  10. }
  11. }
  12.  
  13. ALTER TRIGGER [dbo].[TR_Fruits_Audit] ON [dbo].[Fruits]
  14. AFTER INSERT, UPDATE, DELETE
  15. AS
  16.  
  17. SET NOCOUNT ON
  18.  
  19. BEGIN
  20.  
  21. -- Determine if it is an update, insert or delete;
  22. DECLARE @Action as char(1);
  23.  
  24. SET @Action =
  25. (CASE
  26. WHEN EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED)
  27. THEN 'U'
  28. WHEN EXISTS(SELECT * FROM INSERTED)
  29. THEN 'I'
  30. WHEN EXISTS(SELECT * FROM DELETED)
  31. THEN 'D'
  32. ELSE NULL
  33. END)
  34. IF @Action is not null
  35. BEGIN
  36. DECLARE @Guid as uniqueidentifier;
  37. SET @Guid = NEWID();
  38. IF @Action = 'D'
  39. BEGIN
  40. SELECT @RecordChange = (SELECT count(*) FROM (SELECT a.UserID FROM MonitorDelete a JOIN deleted d on a.ID=d.ID)z);
  41. IF @RecordChange > 0
  42. BEGIN
  43. INSERT INTO AuditFruits (ID, ActivityUser, FruitID, FruitName)
  44. SELECT @Guid, ad.UserID, d.FruitID,d.FruitName FROM deleted d
  45. join MonitorDelete ad on d.ID=ad.ID
  46. END
  47. ELSE
  48. BEGIN
  49. INSERT INTO AuditFruits (ID, FruitID, FruitName)
  50. SELECT @Guid, d.FruitID,d.FruitName FROM deleted d
  51. END
  52. END
  53. END
Add Comment
Please, Sign In to add comment