SystemSetupActions.cs 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using Comal.Classes;
  5. using InABox.Clients;
  6. using InABox.Core;
  7. using InABox.DynamicGrid;
  8. using InABox.Wpf;
  9. namespace PRSDesktop;
  10. public static class SystemSetupActions
  11. {
  12. private class V6SettingsGrid : DynamicItemsListGrid<V6Settings>
  13. {
  14. private void Validate<T>(string sql, List<string> errors) where T : V6Object, new()
  15. {
  16. var t = new T();
  17. List<string> _e = new();
  18. t.ValidateQuery(sql,_e);
  19. if (_e.Any())
  20. {
  21. errors.Add($"The query for {typeof(T).Name} has some errors:");
  22. errors.AddRange(_e);
  23. }
  24. }
  25. private static void ValidateUom(V6Settings settings, string uomcode, List<string> errors, IEnumerable<ProductDimensionUnit> uoms, params string[] checks)
  26. {
  27. var _uomvalue = CoreUtils.GetPropertyValue(settings, uomcode) as string;
  28. if (string.IsNullOrWhiteSpace(_uomvalue))
  29. {
  30. errors.Add($"{uomcode.SplitCamelCase()} may not be blank!");
  31. return;
  32. }
  33. var _uom = uoms.FirstOrDefault(x => string.Equals(x.Code, _uomvalue));
  34. if (_uom == null)
  35. {
  36. errors.Add($"{uomcode.SplitCamelCase()}: {_uomvalue} is not a value Unit of Measure!");
  37. return;
  38. }
  39. List<string> _missing = new();
  40. foreach (var _check in checks)
  41. {
  42. var _enabled = (bool)(CoreUtils.GetPropertyValue(_uom, _check) ?? false);
  43. if (!_enabled)
  44. _missing.Add(_check);
  45. }
  46. if (_missing.Any())
  47. errors.Add($"{_uomvalue} is missing the following checks: {string.Join(", ",_missing)}");
  48. }
  49. protected override void DoValidate(V6Settings[] items, List<string> errors)
  50. {
  51. base.DoValidate(items, errors);
  52. var _item = items.FirstOrDefault();
  53. if (_item == null)
  54. return;
  55. var _uoms = Client.Query(new Filter<ProductDimensionUnit>().All(), Columns.All<ProductDimensionUnit>()).ToObjects<ProductDimensionUnit>().ToArray();
  56. if (_item.ImportCosts != V6ImportCosts.None)
  57. {
  58. ValidateUom(_item, nameof(V6Settings.ProfileUom), errors, _uoms, nameof(ProductDimensionUnit.HasLength));
  59. ValidateUom(_item, nameof(V6Settings.ComponentUom), errors, _uoms, nameof(ProductDimensionUnit.HasQuantity));
  60. ValidateUom(_item, nameof(V6Settings.GlassUom), errors, _uoms, nameof(ProductDimensionUnit.HasHeight), nameof(ProductDimensionUnit.HasWidth));
  61. }
  62. if (_item.ImportDesigns == V6ImportDesigns.ToManufacturing)
  63. {
  64. if (String.IsNullOrWhiteSpace(_item.PacketTemplate))
  65. errors.Add("Packet Template my not be blank!");
  66. else
  67. {
  68. var _found = Client
  69. .Query(new Filter<ManufacturingTemplate>(x => x.Code).IsEqualTo(_item.PacketTemplate),
  70. Columns.None<ManufacturingTemplate>()).Rows.Any();
  71. if (!_found)
  72. errors.Add($"Packet Template [{_item.PacketTemplate}] does not exist!");
  73. }
  74. }
  75. _item.CheckSQL();
  76. Validate<V6Quote>(_item.QuoteSQL, errors);
  77. Validate<V6Elevation>(_item.ElevationSQL, errors);
  78. Validate<V6Drawings>(_item.DrawingsSQL, errors);
  79. Validate<V6Profile>(_item.ProfileSQL, errors);
  80. Validate<V6Component>(_item.ComponentSQL, errors);
  81. Validate<V6Labour>(_item.LabourSQL, errors);
  82. Validate<V6Glass>(_item.GlassSQL, errors);
  83. }
  84. }
  85. public static void ERPStatuses(IPanelHost host)
  86. {
  87. host.CreateSetupActionIfCanView<LogikalSettings>("Logikal Settings", PRSDesktop.Resources.logikal, (action) =>
  88. {
  89. var logikal = Client.Query(
  90. new Filter<LogikalSettings>().All(),
  91. Columns.All<LogikalSettings>()
  92. ).Rows
  93. .FirstOrDefault()?
  94. .ToObject<LogikalSettings>() ?? new LogikalSettings();
  95. var grid = new DynamicItemsListGrid<LogikalSettings>();
  96. if (grid.EditItems(new LogikalSettings[] { logikal }))
  97. {
  98. Client.Save(logikal, "Updated Settings");
  99. }
  100. });
  101. host.CreateSetupActionIfCanView<V6Settings>("V6 Settings", PRSDesktop.Resources.v6, (action) =>
  102. {
  103. var v6 = Client.Query(
  104. new Filter<V6Settings>().All(),
  105. Columns.All<V6Settings>()
  106. ).Rows
  107. .FirstOrDefault()?
  108. .ToObject<V6Settings>() ?? new V6Settings();
  109. v6.CheckSQL();
  110. var grid = new V6SettingsGrid();
  111. if (grid.EditItems(new V6Settings[] { v6 }))
  112. {
  113. Client.Save(v6, "Updated Settings");
  114. }
  115. });
  116. }
  117. }