ConsignmentItemGrid.cs 5.8 KB

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