DeletionsGrid.cs 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. using InABox.Core;
  2. using InABox.Database;
  3. using InABox.DynamicGrid;
  4. using InABox.Wpf;
  5. using InABox.WPF;
  6. using System;
  7. using System.Collections.Generic;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Threading;
  11. using System.Threading.Tasks;
  12. using System.Windows;
  13. using System.Windows.Controls;
  14. namespace PRSServer.Forms;
  15. public class DeletionsGrid : DynamicGrid<Deletion>
  16. {
  17. private Button Refresh;
  18. private Button Recover;
  19. private Button View;
  20. public DeletionsGrid()
  21. {
  22. HiddenColumns.Add(x => x.ID);
  23. HiddenColumns.Add(x => x.Data);
  24. Refresh = AddButton("", Properties.Resources.refresh.AsBitmapImage(), RefreshItems);
  25. Recover = AddButton("Recover", null, RecoverItems);
  26. View = AddButton("", Properties.Resources.view.AsBitmapImage(), ViewItems);
  27. OnDoubleClick += DeletionsGrid_OnDoubleClick;
  28. }
  29. protected override void DoReconfigure(DynamicGridOptions options)
  30. {
  31. options.Clear();
  32. options.DeleteRows = true;
  33. options.FilterRows = true;
  34. options.MultiSelect = true;
  35. }
  36. private void DeletionsGrid_OnDoubleClick(object sender, System.ComponentModel.HandledEventArgs args)
  37. {
  38. DoViewItems(SelectedRows);
  39. }
  40. private bool RefreshItems(Button button, CoreRow[] selectedRows)
  41. {
  42. return true;
  43. }
  44. private bool RecoverItems(Button button, CoreRow[] selectedRows)
  45. {
  46. var rows = SelectedRows.ToList();
  47. if (!rows.Any())
  48. return false;
  49. var recover = MessageWindow.ShowYesNo(
  50. "Are you sure you wish to recover these records?",
  51. "Confirm Recover");
  52. if(recover)
  53. {
  54. foreach(var row in rows)
  55. {
  56. DbFactory.NewProvider(Logger.Main).Recover(row.ToObject<Deletion>());
  57. }
  58. MessageWindow.ShowMessage("Records recovered", "Records recovered");
  59. return true;
  60. }
  61. return false;
  62. }
  63. private void DoViewItems(CoreRow[] selectedRows)
  64. {
  65. var rows = SelectedRows.ToList();
  66. if (!rows.Any())
  67. return;
  68. else if (rows.Count > 1)
  69. {
  70. MessageWindow.ShowMessage("Please select only one row", "Error");
  71. return; ;
  72. }
  73. var deletion = rows[0].ToObject<Deletion>();
  74. var window = new ViewDeletionWindow(deletion);
  75. window.ShowDialog();
  76. }
  77. private bool ViewItems(Button button, CoreRow[] selectedRows)
  78. {
  79. DoViewItems(selectedRows);
  80. return false;
  81. }
  82. public override void DeleteItems(params CoreRow[] rows)
  83. {
  84. foreach(var row in rows)
  85. {
  86. DbFactory.NewProvider(Logger.Main).Purge(row.ToObject<Deletion>());
  87. }
  88. }
  89. protected override void DoDelete()
  90. {
  91. var rows = SelectedRows.ToArray();
  92. if (!rows.Any())
  93. return;
  94. var delete = MessageWindow.ShowYesNo(
  95. "Are you sure you wish to permanently delete these records?\n(This cannot be undone.)",
  96. "Confirm Permanent Delete");
  97. if(delete)
  98. {
  99. DeleteItems(rows);
  100. SelectedRows = Array.Empty<CoreRow>();
  101. DoChanged();
  102. Refresh(false, true);
  103. SelectItems(null);
  104. }
  105. }
  106. public override Deletion LoadItem(CoreRow row)
  107. {
  108. var id = row.Get<Deletion, Guid>(x => x.ID);
  109. return DbFactory.NewProvider(Logger.Main).Query(new Filter<Deletion>(x => x.ID).IsEqualTo(id))
  110. .Rows.FirstOrDefault()?.ToObject<Deletion>()!;
  111. }
  112. protected override void Reload(
  113. Filters<Deletion> criteria, Columns<Deletion> columns, ref SortOrder<Deletion>? sort,
  114. CancellationToken token, Action<CoreTable?, Exception?> action)
  115. {
  116. if(sort == null)
  117. {
  118. sort = new SortOrder<Deletion>(x => x.DeletionDate, SortDirection.Descending);
  119. }
  120. var table = DbFactory.NewProvider(Logger.Main).Query(criteria.Combine(), columns, sort);
  121. action(table, null);
  122. }
  123. public override void SaveItem(Deletion item)
  124. {
  125. // Cannot save deletions
  126. }
  127. }