SupplierProductGrid.cs 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  1. using System;
  2. using System.Diagnostics;
  3. using System.Linq;
  4. using System.Windows;
  5. using System.Windows.Controls;
  6. using System.Windows.Media.Imaging;
  7. using Comal.Classes;
  8. using InABox.Clients;
  9. using InABox.Core;
  10. using InABox.DynamicGrid;
  11. using InABox.WPF;
  12. namespace PRSDesktop
  13. {
  14. internal class SupplierProductGrid : DynamicDataGrid<SupplierProduct>, ISupplierGrid
  15. {
  16. private static ProductsGrid pg;
  17. private readonly Button ActiveButton;
  18. private bool? bActive;
  19. private bool? bLinked;
  20. private readonly Button CreateProductButton;
  21. private readonly Button EditProductButton;
  22. private Button LinkedButton;
  23. private readonly Button LinkProductButton;
  24. private readonly BitmapImage url = PRSDesktop.Resources.view.AsBitmapImage();
  25. public SupplierProductGrid()
  26. {
  27. ColumnsTag = "SupplierProduct";
  28. Options.AddRange(
  29. DynamicGridOption.SelectColumns,
  30. DynamicGridOption.MultiSelect,
  31. DynamicGridOption.FilterRows,
  32. DynamicGridOption.RecordCount
  33. );
  34. HiddenColumns.Add(x => x.URL);
  35. ActionColumns.Add(new DynamicImageColumn(URLImage, URLAction) { Position = DynamicActionColumnPosition.Start });
  36. LinkedButton = AddButton("Linked + Unlinked", null, ToggleLinked);
  37. ActiveButton = AddButton("Active + Expired", null, ToggleActive);
  38. ActiveButton.Margin = new Thickness(ActiveButton.Margin.Left, ActiveButton.Margin.Top, 10, ActiveButton.Margin.Bottom);
  39. CreateProductButton = AddButton("Create Product", PRSDesktop.Resources.small_add.AsBitmapImage(), CreateProduct);
  40. CreateProductButton.Visibility = Visibility.Collapsed;
  41. LinkProductButton = AddButton("Link Product", PRSDesktop.Resources.link.AsBitmapImage(), LinkProduct);
  42. LinkProductButton.Visibility = Visibility.Collapsed;
  43. EditProductButton = AddButton("Edit Product", PRSDesktop.Resources.product.AsBitmapImage(), EditProduct);
  44. EditProductButton.Visibility = Visibility.Collapsed;
  45. HiddenColumns.Add(x => x.Product.ID);
  46. HiddenColumns.Add(x => x.SupplierCode);
  47. HiddenColumns.Add(x => x.SupplierDescription);
  48. HiddenColumns.Add(x => x.TaxCode.ID);
  49. HiddenColumns.Add(x => x.CostPrice);
  50. }
  51. public Guid ParentID { get; set; }
  52. private void ToggleBoolean(ref bool? value)
  53. {
  54. if (value.HasValue)
  55. {
  56. if (value.Value)
  57. value = false;
  58. else
  59. value = null;
  60. }
  61. else
  62. {
  63. value = true;
  64. }
  65. }
  66. private bool ToggleLinked(Button sender, CoreRow[] row)
  67. {
  68. ToggleBoolean(ref bLinked);
  69. UpdateButton(sender, null, bLinked.HasValue ? bLinked.Value ? "Linked Only" : "Unlinked Only" : "Linked + Unlinked");
  70. return true;
  71. }
  72. private bool ToggleActive(Button sender, CoreRow[] row)
  73. {
  74. ToggleBoolean(ref bActive);
  75. UpdateButton(sender, null, bActive.HasValue ? bActive.Value ? "Active Only" : "Expired Only" : "Active + Expired");
  76. return true;
  77. }
  78. private bool CreateProduct(Button sender, CoreRow[] arg2)
  79. {
  80. if (arg2 == null || arg2.Length != 1)
  81. return false;
  82. var sp = arg2.First().ToObject<SupplierProduct>();
  83. if (pg == null)
  84. pg = new ProductsGrid();
  85. var product = new Product();
  86. product.Code = sp.SupplierCode;
  87. product.Name = sp.SupplierDescription;
  88. product.Supplier.ID = sp.ID;
  89. product.UseDefaultSupplierPricing = true;
  90. product.PricingStrategy = ProductPricingStrategy.Standard;
  91. product.BaseCost = sp.CostPrice;
  92. product.NettCost = sp.CostPrice;
  93. product.TaxCode.ID = sp.TaxCode.ID;
  94. if (pg.EditItems(new[] { product }))
  95. {
  96. sp.Product.ID = product.ID;
  97. new Client<SupplierProduct>().Save(sp, "");
  98. return true;
  99. }
  100. return false;
  101. }
  102. private bool LinkProduct(Button arg1, CoreRow[] arg2)
  103. {
  104. if (arg2 == null || arg2.Length != 1)
  105. return false;
  106. var list = new PopupList(typeof(Product), Guid.Empty, new string[] { });
  107. if (list.ShowDialog() == true)
  108. {
  109. var sp = arg2.First().ToObject<SupplierProduct>();
  110. sp.Product.ID = list.ID;
  111. new Client<SupplierProduct>().Save(sp, "");
  112. return true;
  113. }
  114. return false;
  115. }
  116. private bool EditProduct(Button sender, CoreRow[] arg2)
  117. {
  118. if (arg2 == null || arg2.Length != 1)
  119. return false;
  120. var product = new Client<Product>()
  121. .Load(new Filter<Product>(x => x.ID).IsEqualTo(arg2.First().Get<SupplierProduct, Guid>(x => x.Product.ID))).FirstOrDefault();
  122. if (product != null)
  123. {
  124. if (pg == null)
  125. pg = new ProductsGrid();
  126. return pg.EditItems(new[] { product });
  127. }
  128. return false;
  129. }
  130. private bool URLAction(CoreRow arg)
  131. {
  132. var url = arg.Get<Product, String>(x => x.URL);
  133. if (!String.IsNullOrWhiteSpace(url))
  134. Process.Start(new ProcessStartInfo(url) { UseShellExecute = true });
  135. return false;
  136. }
  137. private BitmapImage URLImage(CoreRow arg)
  138. {
  139. return arg == null ? null : string.IsNullOrWhiteSpace(arg.Get<Product, string>(x => x.URL)) ? null : url;
  140. }
  141. protected override void Reload(Filters<SupplierProduct> criteria, Columns<SupplierProduct> columns, ref SortOrder<SupplierProduct> sort,
  142. Action<CoreTable, Exception> action)
  143. {
  144. if (bLinked.HasValue)
  145. {
  146. if (bLinked.Value)
  147. criteria.Add(new Filter<SupplierProduct>(x => x.Product).LinkValid());
  148. else
  149. criteria.Add(new Filter<SupplierProduct>(x => x.Product).NotLinkValid());
  150. }
  151. if (bActive.HasValue)
  152. {
  153. if (bActive.Value)
  154. criteria.Add(new Filter<SupplierProduct>(x => x.Expired).IsEqualTo(DateTime.MinValue));
  155. else
  156. criteria.Add(new Filter<SupplierProduct>(x => x.Expired).IsNotEqualTo(DateTime.MinValue));
  157. }
  158. criteria.Add(new Filter<SupplierProduct>(x => x.SupplierLink.ID).IsEqualTo(ParentID));
  159. base.Reload(criteria, columns, ref sort, action);
  160. }
  161. protected override SupplierProduct CreateItem()
  162. {
  163. var result = base.CreateItem();
  164. result.SupplierLink.ID = ParentID;
  165. return result;
  166. }
  167. protected override BaseEditor? GetEditor(object item, DynamicGridColumn column)
  168. {
  169. if (column.ColumnName.Equals("SupplierLink.ID"))
  170. return new NullEditor();
  171. return base.GetEditor(item, column);
  172. }
  173. protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
  174. {
  175. if (ParentID == Guid.Empty)
  176. MessageBox.Show("Please select a Supplier first!");
  177. else
  178. base.DoAdd();
  179. }
  180. protected override void SelectItems(CoreRow[] rows)
  181. {
  182. base.SelectItems(rows);
  183. var bSingle = rows != null && rows.Length == 1;
  184. var bExisting = bSingle && rows.First().IsEntityLinkValid<SupplierProduct, ProductLink>(x => x.Product);
  185. CreateProductButton.Visibility = bSingle && !bExisting ? Visibility.Visible : Visibility.Collapsed;
  186. LinkProductButton.Visibility = bSingle && !bExisting ? Visibility.Visible : Visibility.Collapsed;
  187. EditProductButton.Visibility = bSingle && bExisting ? Visibility.Visible : Visibility.Collapsed;
  188. }
  189. protected override Guid GetImportID()
  190. {
  191. return ParentID;
  192. }
  193. }
  194. }