DeliveryBuilderGrid.cs 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  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. var newrow = DeliveryItems.NewRow();
  85. DeliveryItems.LoadRow(newrow, item);
  86. DeliveryItems.Rows.Add(newrow);
  87. }
  88. else
  89. {
  90. var item = del.ToObject<DeliveryItem>();
  91. new Client<DeliveryItem>().Delete(item, "Removed By DeliveryBuilder");
  92. DeliveryItems.Rows.RemoveAt(del.Index);
  93. }
  94. }
  95. DoChanged();
  96. return true;
  97. }
  98. if (DeliveryItems != null)
  99. {
  100. var oid = row.Get<PurchaseOrderItem, Guid>(c => c.ID);
  101. try
  102. {
  103. CheckCode(oid);
  104. DoChanged();
  105. return true;
  106. }
  107. catch (Exception e)
  108. {
  109. MessageBox.Show(e.Message);
  110. return false;
  111. }
  112. }
  113. return false;
  114. }
  115. public bool CheckCode(Guid oid)
  116. {
  117. var ordrow = Data.Rows.Where(r => r.Get<PurchaseOrderItem, Guid>(c => c.ID).Equals(oid)).FirstOrDefault();
  118. if (ordrow == null)
  119. throw new Exception("Cannot find Order Item: " + oid);
  120. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  121. if (del == null)
  122. {
  123. var item = new DeliveryItem();
  124. item.OrderItem.ID = oid;
  125. item.Delivery.ID = DeliveryID;
  126. item.Description = string.Format("{0} x {1} ",
  127. ordrow.Get<PurchaseOrderItem, double>(c => c.Qty),
  128. ordrow.Get<PurchaseOrderItem, string>(c => c.Description)
  129. );
  130. item.ManufacturingPacketLink.ID = ordrow.Get<PurchaseOrderItem, Guid>(c => c.Packet.ID);
  131. item.JobLink.ID = ordrow.Get<PurchaseOrderItem, Guid>(c => c.Packet.SetoutLink.JobLink.ID);
  132. item.Type = DeliveryItemType.TreatmentItem;
  133. new Client<DeliveryItem>().Save(item, "Scanned By DeliveryBuilder");
  134. var newrow = DeliveryItems.NewRow();
  135. DeliveryItems.LoadRow(newrow, item);
  136. DeliveryItems.Rows.Add(newrow);
  137. return true;
  138. }
  139. else
  140. {
  141. var item = del.ToObject<DeliveryItem>();
  142. new Client<DeliveryItem>().Delete(item, "Removed By DeliveryBuilder");
  143. DeliveryItems.Rows.RemoveAt(del.Index);
  144. return false;
  145. }
  146. }
  147. private BitmapImage? ConfirmedImage(CoreRow? row)
  148. {
  149. if (row == null)
  150. return tick;
  151. if (DeliveryItems != null)
  152. {
  153. var oid = row.Get<PurchaseOrderItem, Guid>(c => c.ID);
  154. var del = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.OrderItem.ID).Equals(oid));
  155. return del != null ? tick : null;
  156. }
  157. return null;
  158. }
  159. protected override void Reload(Filters<PurchaseOrderItem> criteria, Columns<PurchaseOrderItem> columns, ref SortOrder<PurchaseOrderItem>? sort,
  160. Action<CoreTable?, Exception?> action)
  161. {
  162. criteria.Add(new Filter<PurchaseOrderItem>(x => x.PurchaseOrderLink.ID).IsEqualTo(_orderid));
  163. base.Reload(criteria, columns, ref sort, action);
  164. }
  165. }
  166. }