DeliveryBuilderGrid.cs 6.8 KB

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