ConsignmentItemGrid.cs 5.6 KB

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