ConsignmentItemGrid.cs 5.5 KB

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