DeliveryBuilderGrid.cs 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. using System;
  2. using System.Linq;
  3. using System.Threading;
  4. using System.Windows;
  5. using System.Windows.Media.Imaging;
  6. using Comal.Classes;
  7. using InABox.Clients;
  8. using InABox.Core;
  9. using InABox.DynamicGrid;
  10. using InABox.WPF;
  11. namespace PRSDesktop
  12. {
  13. public class DeliveryBuilderGrid : DynamicDataGrid<PurchaseOrderItem>
  14. {
  15. private Guid _orderid;
  16. private readonly BitmapImage tick = PRSDesktop.Resources.tick.AsBitmapImage();
  17. public DeliveryBuilderGrid()
  18. {
  19. DeliveryItems = null;
  20. HiddenColumns.Add(x => x.Packet.ID);
  21. HiddenColumns.Add(x => x.PurchaseOrderLink.PONumber);
  22. HiddenColumns.Add(x => x.Packet.SetoutLink.ID);
  23. HiddenColumns.Add(x => x.Packet.SetoutLink.JobLink.ID);
  24. ActionColumns.Add(new DynamicImageColumn(ConfirmedImage, ConfirmClick));
  25. RowHeight = 35;
  26. FontSize = 20;
  27. }
  28. protected override void DoReconfigure(DynamicGridOptions options)
  29. {
  30. base.DoReconfigure(options);
  31. options.RecordCount = true;
  32. }
  33. public CoreTable? DeliveryItems { get; private set; }
  34. public Guid OrderID
  35. {
  36. get => _orderid;
  37. set
  38. {
  39. _orderid = value;
  40. DeliveryItems = new Client<DeliveryItem>().Query(
  41. new Filter<DeliveryItem>(x => x.OrderItem.PurchaseOrderLink.ID).IsEqualTo(value),
  42. Columns.None<DeliveryItem>().Add(x => x.ID, x => x.Delivery.ID, x => x.OrderItem.ID, x => x.OrderItem.PurchaseOrderLink.ID,
  43. x => x.Description)
  44. );
  45. Refresh(true, true);
  46. }
  47. }
  48. public Guid DeliveryID { get; set; }
  49. public bool DeliveryDocketReady()
  50. {
  51. if (DeliveryItems == null || !DeliveryItems.Rows.Any())
  52. return false;
  53. if (Data == null || !Data.Rows.Any())
  54. return false;
  55. foreach (var row in Data.Rows)
  56. {
  57. var oid = row.Get<PurchaseOrderItem, Guid>(c => c.ID);
  58. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  59. if (del == null)
  60. return false;
  61. }
  62. return true;
  63. }
  64. private bool ConfirmClick(CoreRow? row)
  65. {
  66. if (row == null)
  67. {
  68. foreach (CoreRow dataRow in Data.Rows)
  69. {
  70. var oid = dataRow.Get<PurchaseOrderItem, Guid>(c => c.ID);
  71. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  72. if (del == null)
  73. {
  74. var item = new DeliveryItem();
  75. item.OrderItem.ID = oid;
  76. item.Delivery.ID = DeliveryID;
  77. item.Description = string.Format("{0} x {1} ",
  78. dataRow.Get<PurchaseOrderItem, double>(c => c.Qty),
  79. dataRow.Get<PurchaseOrderItem, string>(c => c.Description)
  80. );
  81. item.ManufacturingPacketLink.ID = dataRow.Get<PurchaseOrderItem, Guid>(c => c.Packet.ID);
  82. item.JobLink.ID = dataRow.Get<PurchaseOrderItem, Guid>(c => c.Packet.SetoutLink.JobLink.ID);
  83. item.Type = DeliveryItemType.TreatmentItem;
  84. new Client<DeliveryItem>().Save(item, "Scanned By DeliveryBuilder");
  85. DeliveryItems.LoadRow(item);
  86. }
  87. else
  88. {
  89. var item = del.ToObject<DeliveryItem>();
  90. new Client<DeliveryItem>().Delete(item, "Removed By DeliveryBuilder");
  91. DeliveryItems.Rows.RemoveAt(del.Index);
  92. }
  93. }
  94. DoChanged();
  95. return true;
  96. }
  97. if (DeliveryItems != null)
  98. {
  99. var oid = row.Get<PurchaseOrderItem, Guid>(c => c.ID);
  100. try
  101. {
  102. CheckCode(oid);
  103. DoChanged();
  104. return true;
  105. }
  106. catch (Exception e)
  107. {
  108. MessageBox.Show(e.Message);
  109. return false;
  110. }
  111. }
  112. return false;
  113. }
  114. public bool CheckCode(Guid oid)
  115. {
  116. var ordrow = Data.Rows.Where(r => r.Get<PurchaseOrderItem, Guid>(c => c.ID).Equals(oid)).FirstOrDefault();
  117. if (ordrow == null)
  118. throw new Exception("Cannot find Order Item: " + oid);
  119. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  120. if (del == null)
  121. {
  122. var item = new DeliveryItem();
  123. item.OrderItem.ID = oid;
  124. item.Delivery.ID = DeliveryID;
  125. item.Description = string.Format("{0} x {1} ",
  126. ordrow.Get<PurchaseOrderItem, double>(c => c.Qty),
  127. ordrow.Get<PurchaseOrderItem, string>(c => c.Description)
  128. );
  129. item.ManufacturingPacketLink.ID = ordrow.Get<PurchaseOrderItem, Guid>(c => c.Packet.ID);
  130. item.JobLink.ID = ordrow.Get<PurchaseOrderItem, Guid>(c => c.Packet.SetoutLink.JobLink.ID);
  131. item.Type = DeliveryItemType.TreatmentItem;
  132. new Client<DeliveryItem>().Save(item, "Scanned By DeliveryBuilder");
  133. DeliveryItems.LoadRow(item);
  134. return true;
  135. }
  136. else
  137. {
  138. var item = del.ToObject<DeliveryItem>();
  139. new Client<DeliveryItem>().Delete(item, "Removed By DeliveryBuilder");
  140. DeliveryItems.Rows.RemoveAt(del.Index);
  141. return false;
  142. }
  143. }
  144. private BitmapImage? ConfirmedImage(CoreRow? row)
  145. {
  146. if (row == null)
  147. return tick;
  148. if (DeliveryItems != null)
  149. {
  150. var oid = row.Get<PurchaseOrderItem, Guid>(c => c.ID);
  151. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  152. return del != null ? tick : null;
  153. }
  154. return null;
  155. }
  156. protected override void Reload(
  157. Filters<PurchaseOrderItem> criteria, Columns<PurchaseOrderItem> columns, ref SortOrder<PurchaseOrderItem>? sort,
  158. CancellationToken token, Action<CoreTable?, Exception?> action)
  159. {
  160. criteria.Add(new Filter<PurchaseOrderItem>(x => x.PurchaseOrderLink.ID).IsEqualTo(_orderid));
  161. base.Reload(criteria, columns, ref sort, token, action);
  162. }
  163. }
  164. }