ConsignmentItemGrid.cs 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. using System;
  2. using System.Linq;
  3. using System.Threading;
  4. using System.Windows;
  5. using System.Windows.Controls;
  6. using Comal.Classes;
  7. using InABox.Clients;
  8. using InABox.Core;
  9. using InABox.DynamicGrid;
  10. using InABox.Wpf;
  11. using InABox.WPF;
  12. namespace PRSDesktop;
  13. public class ConsignmentItemGrid : DynamicDataGrid<PurchaseOrderItem>
  14. {
  15. private Button receiveall;
  16. private Button receiveselected;
  17. protected override void Init()
  18. {
  19. base.Init();
  20. receiveall = AddButton("Receive All", null, ReceiveAll);
  21. receiveall.IsEnabled = false;
  22. receiveselected = AddButton("Receive Selected", null, ReceiveSelected);
  23. receiveselected.IsEnabled = false;
  24. AddButton("Assign Location", null, SupplierPurchaseOrderItemOneToMany.AssignLocation);
  25. }
  26. protected override void DoReconfigure(DynamicGridOptions options)
  27. {
  28. base.DoReconfigure(options);
  29. options.RecordCount = true;
  30. options.SelectColumns = true;
  31. options.AddRows = true;
  32. options.DeleteRows = true;
  33. options.MultiSelect = true;
  34. }
  35. public Guid ConsignmentID { get; set; }
  36. public bool Completed { get; set; }
  37. protected override void SelectItems(CoreRow[]? rows)
  38. {
  39. receiveselected.IsEnabled = rows != null && rows.Any(r => r.Get<PurchaseOrderItem, DateTime>(c => c.ReceivedDate).IsEmpty());
  40. receiveall.IsEnabled = Data.Rows.Any(r => r.Get<PurchaseOrderItem, DateTime>(c => c.ReceivedDate).IsEmpty());
  41. base.SelectItems(rows);
  42. }
  43. private bool ReceiveAll(Button sender, CoreRow[] rows)
  44. {
  45. var unreceived = Data.Rows.Where(r => r.Get<PurchaseOrderItem, DateTime>(c => c.ReceivedDate).IsEmpty());
  46. if (!unreceived.Any())
  47. {
  48. MessageBox.Show("No Items to Receive");
  49. return false;
  50. }
  51. var now = DateTime.Now;
  52. using (new WaitCursor())
  53. {
  54. var items = unreceived.Select(x => x.ToObject<PurchaseOrderItem>());
  55. foreach (var item in items)
  56. item.ReceivedDate = now;
  57. new Client<PurchaseOrderItem>().Save(items, "Consignment Items Received");
  58. }
  59. return true;
  60. }
  61. private bool ReceiveSelected(Button sender, CoreRow[] rows)
  62. {
  63. if (!rows.Any())
  64. {
  65. MessageBox.Show("Please select a row first");
  66. return false;
  67. }
  68. var now = DateTime.Now;
  69. using (new WaitCursor())
  70. {
  71. var items = LoadItems(rows);
  72. foreach (var item in items)
  73. item.ReceivedDate = now;
  74. new Client<PurchaseOrderItem>().Save(items, "Consignment Items Received");
  75. }
  76. return true;
  77. }
  78. protected override void Reload(
  79. Filters<PurchaseOrderItem> criteria, Columns<PurchaseOrderItem> columns, ref SortOrder<PurchaseOrderItem>? sort,
  80. CancellationToken token, Action<CoreTable?, Exception?> action)
  81. {
  82. criteria.Add(new Filter<PurchaseOrderItem>(x => x.Consignment.ID).IsEqualTo(
  83. ConsignmentID == Guid.Empty ? CoreUtils.FullGuid : ConsignmentID));
  84. base.Reload(criteria, columns, ref sort, token, action);
  85. }
  86. protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
  87. {
  88. if (ConsignmentID.Equals(Guid.Empty))
  89. {
  90. MessageBox.Show("Please select a Requisition first!");
  91. return;
  92. }
  93. if (Completed)
  94. {
  95. MessageBox.Show("Cannot Modify a Completed Requisition");
  96. return;
  97. }
  98. var dialog = new MultiSelectDialog<PurchaseOrderItem>(
  99. new Filter<PurchaseOrderItem>(x => x.Consignment.ID).IsEqualTo(Guid.Empty).And(x => x.ReceivedDate).IsEqualTo(DateTime.MinValue),
  100. Columns.None<PurchaseOrderItem>().Add(x => x.PurchaseOrderLink.PONumber, x => x.Product.Code, x => x.Product.Name, x => x.Description,
  101. x => x.Qty)
  102. //new System.Linq.Expressions.Expression<Func<PurchaseOrderItem, object>>[] { x => x.PurchaseOrderLink.PONumber, x => x.ProductLink.Code, x=>x.ProductLink.Name, x=>x.Description, x=>x.Qty}
  103. );
  104. if (dialog.ShowDialog())
  105. {
  106. Progress.Show("Adding Order Items");
  107. var items = dialog.Items(Columns.Required<PurchaseOrderItem>().Add(x => x.ID).Add(x => x.Consignment.ID));
  108. foreach (var item in items)
  109. item.Consignment.ID = ConsignmentID;
  110. Progress.SetMessage("Updating Items");
  111. new Client<PurchaseOrderItem>().Save(items, "Added to Consignment");
  112. Refresh(false, true);
  113. Progress.Close();
  114. MessageBox.Show(string.Format("{0} order items added", items.Length));
  115. }
  116. }
  117. public override bool EditItems(PurchaseOrderItem[] items, Func<Type, CoreTable?>? PageDataHandler, bool PreloadPages = false)
  118. {
  119. if (ConsignmentID.Equals(Guid.Empty))
  120. {
  121. MessageWindow.ShowMessage("Please select a Requisition first!", "Invalid Action");
  122. return false;
  123. }
  124. if (Completed)
  125. {
  126. MessageWindow.ShowMessage("Cannot Modify a Completed Requisition", "Invalid Action");
  127. return false;
  128. }
  129. return base.EditItems(items, PageDataHandler, PreloadPages);
  130. }
  131. protected override bool CanDeleteItems(CoreRow[] rows)
  132. {
  133. if (ConsignmentID.Equals(Guid.Empty))
  134. {
  135. MessageBox.Show("Please select a Requisition first!");
  136. return false;
  137. }
  138. if (Completed)
  139. {
  140. MessageBox.Show("Cannot Modify a Closed Requisition");
  141. return false;
  142. }
  143. return base.CanDeleteItems(rows);
  144. }
  145. public override void DeleteItems(params CoreRow[] rows)
  146. {
  147. using (new WaitCursor())
  148. {
  149. var items = LoadItems(rows);
  150. foreach (var item in items)
  151. item.Consignment.ID = Guid.Empty;
  152. new Client<PurchaseOrderItem>().Save(items, "Removed from Consignment");
  153. }
  154. }
  155. }