RequisitionPanel.xaml.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Linq;
  6. using System.Windows;
  7. using System.Windows.Controls;
  8. using Comal.Classes;
  9. using InABox.Clients;
  10. using InABox.Configuration;
  11. using InABox.Core;
  12. using InABox.DynamicGrid;
  13. using InABox.WPF;
  14. using InABox.Wpf;
  15. using Motorola.Snapi;
  16. using Motorola.Snapi.Constants.Enums;
  17. using Motorola.Snapi.EventArguments;
  18. using EventType = Motorola.Snapi.Constants.Enums.EventType;
  19. //using RestSharp;
  20. namespace PRSDesktop;
  21. public class RequisitionPanelSettings : IUserConfigurationSettings
  22. {
  23. public ScreenViewType ViewType { get; set; } = ScreenViewType.Combined;
  24. public double RequisitionsWidth { get; set; } = 450;
  25. public double DetailsWidth { get; set; } = 450;
  26. }
  27. /// <summary>
  28. /// Interaction logic for RequisitionPanel.xaml
  29. /// </summary>
  30. public partial class RequisitionPanel : UserControl, IPanel<Requisition>
  31. {
  32. private Requisition? _requisition;
  33. private RequisitionPanelSettings Settings;
  34. public List<IMotorolaBarcodeScanner> Scanners = new();
  35. public RequisitionPanel()
  36. {
  37. InitializeComponent();
  38. PickImage.Source = PRSDesktop.Resources.tick.AsBitmapImage(Color.White);
  39. StockImage.Source = PRSDesktop.Resources.forklift.AsBitmapImage(Color.White);
  40. TruckImage.Source = PRSDesktop.Resources.truck.AsBitmapImage();
  41. }
  42. //DateTime lastselection = DateTime.MaxValue;
  43. //DispatcherTimer timer = new DispatcherTimer();
  44. public event DataModelUpdateEvent? OnUpdateDataModel;
  45. public bool IsReady { get; set; }
  46. public Dictionary<string, object[]> Selected()
  47. {
  48. return new Dictionary<string, object[]>
  49. {
  50. { typeof(Requisition).EntityName(), Requisitions.SelectedRows },
  51. { typeof(RequisitionItem).EntityName(), Items.SelectedRows }
  52. };
  53. }
  54. public void Setup()
  55. {
  56. //Requisitions.OnSelectItem += Requisitions_OnSelectItem;
  57. //Requisitions.OnRequisitionFillStateChanged += Requisitions_OnRequisitionFillStateChanged;
  58. //Requisitions.OnRequisitionBoxesChanged += Requisitions_OnRequisitionBoxesChanged;
  59. LoadSettings();
  60. SetupScanner();
  61. Items.Reconfigure(options =>
  62. {
  63. if (_requisition != null)
  64. {
  65. if (_requisition.Filled.IsEmpty())
  66. {
  67. options.AddRows = true;
  68. options.DeleteRows = true;
  69. }
  70. else
  71. {
  72. options.AddRows = false;
  73. options.DeleteRows = false;
  74. }
  75. }
  76. });
  77. Requisitions.Refresh(true, false);
  78. Items.Refresh(true, false);
  79. UpdateLayout();
  80. }
  81. private void LoadSettings()
  82. {
  83. Settings = new UserConfiguration<RequisitionPanelSettings>().Load();
  84. MainPanel.View = Settings.ViewType == ScreenViewType.Register ? DynamicSplitPanelView.Master :
  85. Settings.ViewType == ScreenViewType.Details ? DynamicSplitPanelView.Detail : DynamicSplitPanelView.Combined;
  86. MainPanel.AnchorWidth = Settings.RequisitionsWidth;
  87. DetailsPanel.AnchorWidth = Settings.DetailsWidth;
  88. }
  89. private void SaveSettings()
  90. {
  91. Settings.ViewType = MainPanel.View switch
  92. {
  93. DynamicSplitPanelView.Master => ScreenViewType.Register,
  94. DynamicSplitPanelView.Detail => ScreenViewType.Details,
  95. DynamicSplitPanelView.Combined or _ => ScreenViewType.Combined
  96. };
  97. Settings.RequisitionsWidth = MainPanel.AnchorWidth;
  98. Settings.DetailsWidth = DetailsPanel.AnchorWidth;
  99. new UserConfiguration<RequisitionPanelSettings>().Save(Settings);
  100. }
  101. private void MainPanel_OnChanged(object sender, DynamicSplitPanelSettings e)
  102. {
  103. SaveSettings();
  104. }
  105. public void Shutdown(CancelEventArgs? cancel)
  106. {
  107. ShutdownScanner();
  108. }
  109. public void CreateToolbarButtons(IPanelHost host)
  110. {
  111. if (Security.CanView<RequisitionDestination>())
  112. {
  113. host.CreateSetupAction(new PanelAction
  114. {
  115. Caption = "Requisition Destinations",
  116. Image = PRSDesktop.Resources.truck,
  117. OnExecute = (action) =>
  118. {
  119. var list = new MasterList(typeof(RequisitionDestination));
  120. list.ShowDialog();
  121. }
  122. });
  123. }
  124. //host.CreatePanelAction(new PanelAction() { Caption = "Archive Requisition", Image = InABox.Wpf.Resources.delete, OnExecute = ArchiveRequisition });
  125. }
  126. public string SectionName => "Requisitions";
  127. public DataModel DataModel(Selection selection)
  128. {
  129. var ids = Requisitions.ExtractValues(x => x.ID, selection).ToArray();
  130. return new BaseDataModel<Requisition>(new Filter<Requisition>(x => x.ID).InList(ids));
  131. }
  132. public void Refresh()
  133. {
  134. Requisitions.Refresh(false, true);
  135. //lastselection = DateTime.MinValue;
  136. //Items.Refresh(true, false);
  137. }
  138. public void Heartbeat(TimeSpan time)
  139. {
  140. // Nothing to do here
  141. }
  142. private void ShutdownScanner()
  143. {
  144. try
  145. {
  146. foreach (var scanner in Scanners) scanner.Actions.ToggleLed(LedMode.GreenOff);
  147. BarcodeScannerManager.Instance.DataReceived -= Instance_DataReceived;
  148. BarcodeScannerManager.Instance.Close();
  149. }
  150. catch (Exception e)
  151. {
  152. MessageBox.Show("Error Shutting down Scanner!\n\n" + e.Message);
  153. }
  154. }
  155. private void SetupScanner()
  156. {
  157. Scanners.Clear();
  158. BarcodeScannerManager.Instance.Open();
  159. BarcodeScannerManager.Instance.RegisterForEvents(EventType.Barcode, EventType.Pnp, EventType.Image, EventType.Other, EventType.Rmd);
  160. BarcodeScannerManager.Instance.GetDevices();
  161. foreach (var scanner in BarcodeScannerManager.Instance.GetDevices())
  162. {
  163. Scanners.Add(scanner);
  164. scanner.Actions.ToggleLed(LedMode.RedOn);
  165. scanner.Actions.SoundBeeper(BeepPattern.FastWarble);
  166. }
  167. BarcodeScannerManager.Instance.DataReceived += Instance_DataReceived;
  168. }
  169. private void Instance_DataReceived(object? sender, BarcodeScanEventArgs e)
  170. {
  171. Dispatcher.Invoke(() => { ProcessCode(Scanners[(int)e.ScannerId], e.Data); });
  172. }
  173. private void ProcessCode(IMotorolaBarcodeScanner scanner, string code)
  174. {
  175. try
  176. {
  177. var iRow = Requisitions.SelectedRows.First().Index;
  178. if (iRow == -1)
  179. throw new Exception("Please select a Requsition First");
  180. var row = Requisitions.Data.Rows[iRow];
  181. var filled = row.Get<Requisition, DateTime>(x => x.Filled);
  182. if (!filled.IsEmpty())
  183. throw new Exception("Cannot Add Items to a completed Requisition");
  184. var reqid = row.Get<Requisition, Guid>(x => x.ID);
  185. var boxes = row.Get<Requisition, int>(x => x.Boxes);
  186. var sCode = code;
  187. var iQty = 1;
  188. if (sCode.Contains('*'))
  189. {
  190. var comps = sCode.Split('*');
  191. sCode = comps[0];
  192. iQty = int.Parse(comps[1].Trim());
  193. }
  194. RequisitionItem? item = null;
  195. CoreRow? itemrow = null;
  196. try
  197. {
  198. itemrow = Items.Data.Rows.FirstOrDefault(r => /* r.Get<RequisitionItem, int>(x => x.BoxNumber).Equals(boxes) && */
  199. r.Get<RequisitionItem, string>(x => x.BarCode).Equals(sCode));
  200. //itemrow = Items.Data.Rows.FirstOrDefault(r => r.Get<RequisitionItem, String>(x => x.BarCode).Equals(sCode));
  201. }
  202. catch (Exception e)
  203. {
  204. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  205. }
  206. if (itemrow != null)
  207. item = new Client<RequisitionItem>()
  208. .Load(new Filter<RequisitionItem>(x => x.ID).IsEqualTo(itemrow.Get<RequisitionItem, Guid>(x => x.ID))).FirstOrDefault();
  209. if (item != null)
  210. {
  211. item.Quantity += iQty;
  212. new Client<RequisitionItem>().Save(item, "Quantity Updated by Barcode Scanner");
  213. scanner?.Actions.SoundBeeper(BeepPattern.LowHigh);
  214. Refresh();
  215. }
  216. else
  217. {
  218. var product = new Client<Product>().Load(new Filter<Product>(x => x.Code).IsEqualTo(sCode)).FirstOrDefault();
  219. if (product != null)
  220. {
  221. item = new RequisitionItem
  222. {
  223. RequisitionLink = new RequisitionLink { ID = reqid },
  224. //BoxNumber = boxes,
  225. Code = product.Code,
  226. Description = product.Name,
  227. BarCode = sCode,
  228. Quantity = iQty
  229. };
  230. new Client<RequisitionItem>().Save(item, "Scanned by Barcode Reader");
  231. scanner?.Actions.SoundBeeper(BeepPattern.LowHigh);
  232. Refresh();
  233. }
  234. else
  235. {
  236. scanner?.Actions.SoundBeeper(BeepPattern.FourLowLong);
  237. }
  238. }
  239. }
  240. catch (Exception)
  241. {
  242. scanner?.Actions.SoundBeeper(BeepPattern.FourLowShort);
  243. }
  244. }
  245. /*private void ArchiveRequisition(PanelAction obj)
  246. {
  247. var bClosed = false;
  248. var iRow = Requisitions.SelectedRows.First().Index;
  249. if (iRow > -1)
  250. {
  251. var row = Requisitions.Data.Rows[iRow];
  252. var id = row.Get<Requisition, Guid>(x => x.ID);
  253. var filled = row.Get<Requisition, DateTime>(x => x.Filled);
  254. if (filled.IsEmpty())
  255. {
  256. MessageBox.Show("Please complete this requisition before Archiving it!");
  257. }
  258. else
  259. {
  260. var req = new Client<Requisition>().Load(new Filter<Requisition>(x => x.ID).IsEqualTo(id)).FirstOrDefault();
  261. if (req != null)
  262. {
  263. req.Archived = DateTime.Now;
  264. new Client<Requisition>().Save(req, "Requisition Archived");
  265. bClosed = true;
  266. }
  267. }
  268. }
  269. else
  270. {
  271. MessageBox.Show("Please select a requisition first!");
  272. }
  273. if (bClosed)
  274. Refresh();
  275. }*/
  276. private void LoadRequisition()
  277. {
  278. foreach (var scanner in Scanners)
  279. scanner.Actions.ToggleLed(_requisition != null ? LedMode.GreenOn : LedMode.RedOn);
  280. Title.Text = _requisition != null ? _requisition.Title : "";
  281. RequestedBy.Content = _requisition != null ? _requisition.RequestedBy.Name : "";
  282. DueDate.Content = _requisition != null ? string.Format("{0:dddd, dd MMM yyyy}", _requisition.Due) : "";
  283. Destination.Content = _requisition != null ? _requisition.Destination.Description : "";
  284. var notes = _requisition != null ? _requisition.Notes : Array.Empty<string>();
  285. var request = _requisition != null ? CoreUtils.StripHTML(_requisition.Request) : "";
  286. Request.Text = string.Join("\n===============================\n", Utility.ProcessNotes(notes, request));
  287. MarkAsFilled.IsEnabled = _requisition != null && _requisition.Archived.IsEmpty() && _requisition.StockUpdated.IsEmpty();
  288. MarkAsFilledDescription.Content = _requisition == null || _requisition.Filled.IsEmpty() ? "Mark As Filled" : "Clear Filled Flag";
  289. UpdateStock.IsEnabled = Security.IsAllowed<CanUpdateRequisitionStockMovements>() && _requisition != null &&
  290. !_requisition.Filled.IsEmpty();
  291. UpdateStockDescription.Content =
  292. _requisition == null || _requisition.StockUpdated.IsEmpty() ? "Update Stock Holdings" : "Clear Stock Movements";
  293. TakenBy.IsEnabled = _requisition != null && !_requisition.Filled.IsEmpty() && _requisition.Archived.IsEmpty() &&
  294. !_requisition.Delivery.IsValid();
  295. TakenByDescription.Content = _requisition == null
  296. ? "Select Employee"
  297. : _requisition.Delivery.IsValid()
  298. ? _requisition.Delivery.Completed.IsEmpty()
  299. ? string.Format("Booked On Delivery #{0}", _requisition.Delivery.Number)
  300. : string.Format("Delivered on {0:dd MMM yy} (#{1})", _requisition.Delivery.Completed, _requisition.Delivery.Number)
  301. : _requisition.TakenBy.IsValid()
  302. ? string.Format("{0} ({1:dd MMM yy})", _requisition.TakenBy.Name, _requisition.Archived)
  303. : "Select Employee";
  304. }
  305. private void Requisitions_OnSelectItem(object sender, DynamicGridSelectionEventArgs e)
  306. {
  307. _requisition = e.Rows?.FirstOrDefault()?.ToObject<Requisition>();
  308. LoadRequisition();
  309. Items.Master = _requisition;
  310. Items.Refresh(false, true);
  311. //lastselection = DateTime.Now;
  312. //Dispatcher.Invoke(() => { LoadRequisition(); });
  313. }
  314. private void TakenBy_Click(object sender, RoutedEventArgs e)
  315. {
  316. if (_requisition == null || _requisition.ID == Guid.Empty)
  317. return;
  318. var dlg = new MultiSelectDialog<Employee>(
  319. LookupFactory.DefineFilter<Employee>(),
  320. LookupFactory.DefineColumns<Employee>(),
  321. false);
  322. if (!dlg.ShowDialog())
  323. return;
  324. if (!_requisition.Filled.IsEmpty() && !_requisition.StockUpdated.IsEmpty())
  325. if (!MessageWindow.ShowYesNo(
  326. "This will remove this requisition from this list.\nAre you sure you wish to continue?",
  327. "Close Requisition?",
  328. image: MessageWindow.QuestionImage))
  329. return;
  330. if (_requisition.Archived.IsEmpty())
  331. _requisition.Archived = DateTime.Now;
  332. var emp = dlg.Data()?.Rows.FirstOrDefault();
  333. _requisition.TakenBy.ID = emp != null ? emp.Get<Employee, Guid>(x => x.ID) : Guid.Empty;
  334. _requisition.TakenBy.Name = emp != null ? emp.Get<Employee, string>(x => x.Name) : "";
  335. Progress.Show("Updating Requisition Delivery Status");
  336. new Client<Requisition>().Save(_requisition, "Updated [TakenBy] Flag");
  337. if (!_requisition.Filled.IsEmpty() && !_requisition.StockUpdated.IsEmpty() && !_requisition.Archived.IsEmpty())
  338. {
  339. Refresh();
  340. }
  341. else
  342. {
  343. Requisitions.UpdateRow<Requisition, Guid>(Requisitions.SelectedRows.First(), x => x.TakenBy.ID, _requisition.TakenBy.ID, false);
  344. Requisitions.UpdateRow<Requisition, string>(Requisitions.SelectedRows.First(), x => x.TakenBy.Name, _requisition.TakenBy.Name, false);
  345. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.Archived, _requisition.Archived);
  346. LoadRequisition();
  347. }
  348. Progress.Close();
  349. }
  350. private void MarkAsFilled_Click(object sender, RoutedEventArgs e)
  351. {
  352. var _row = Requisitions.SelectedRows.FirstOrDefault();
  353. if (_row == null)
  354. {
  355. MessageWindow.ShowMessage("Please select a Picking List first!", "Select Picking List");
  356. return;
  357. }
  358. var _currentrequi = _row.ToObject<Requisition>();
  359. if (!_currentrequi.Filled.IsEmpty())
  360. {
  361. Progress.ShowModal("Updating Picking List Items", (p) =>
  362. {
  363. _currentrequi.Filled = DateTime.MinValue;
  364. Client.Save(_currentrequi, "Filled flag cleared");
  365. });
  366. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.Filled,
  367. DateTime.MinValue);
  368. _requisition.Filled = DateTime.MinValue;
  369. LoadRequisition();
  370. Items.Refresh(false, true);
  371. return;
  372. }
  373. DateTime _filltime = DateTime.Now;
  374. var _confirm = MessageWindowResult.Yes;
  375. var _unpickeditems = Items.Data.Rows.Where(r =>
  376. (r.Get<RequisitionItem, Guid>(x => x.Product.ID) != Guid.Empty)
  377. && (r.Get<RequisitionItem, bool>(x => x.Product.NonStock) != true)
  378. && (!r.Get<RequisitionItem, bool>(x => x.Done))
  379. ).ToArray();
  380. if (_unpickeditems.Any())
  381. {
  382. _confirm = new MessageWindow()
  383. .Message(
  384. "There are items on this Picking List which are not done!\n\nDo you want to mark them as done, or move them to a New Picking List ?")
  385. .Title("Unpicked Items found")
  386. .AddYesButton("Mark as Done")
  387. .AddNoButton("New Picking List")
  388. .AddCancelButton()
  389. .Display()
  390. .Result;
  391. if (_confirm == MessageWindowResult.Cancel)
  392. return;
  393. }
  394. Progress.ShowModal("Updating Picking List Items", (p) =>
  395. {
  396. if (_confirm == MessageWindowResult.No)
  397. {
  398. Requisitions.SplitPickingList(_row, true, (_) => true, p);
  399. _currentrequi.Filled = _filltime;
  400. p.Report("Creating Delivery Items");
  401. Client.Save(_currentrequi,"Marked as Filled");
  402. }
  403. else if (_confirm == MessageWindowResult.Yes)
  404. {
  405. var updates = new List<RequisitionItem>();
  406. foreach (var row in _unpickeditems)
  407. {
  408. var item = row.ToObject<RequisitionItem>();
  409. item.Done = true;
  410. updates.Add(item);
  411. }
  412. Client.Save(updates, "Marked as Done because Requisition was marked as filled");
  413. _currentrequi.Filled = _filltime;
  414. p.Report("Creating Delivery Items");
  415. Client.Save(_currentrequi,"Marked as Filled");
  416. }
  417. });
  418. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.Filled, _filltime);
  419. _requisition.Filled = _filltime;
  420. LoadRequisition();
  421. Items.Refresh(false, true);
  422. }
  423. private void UpdateStock_Click(object sender, RoutedEventArgs e)
  424. {
  425. if (_requisition == null)
  426. {
  427. MessageWindow.ShowMessage("Please select a Requisition first!", "Select Requisition");
  428. return;
  429. }
  430. if (_requisition.StockUpdated.IsEmpty())
  431. {
  432. var emptyrows = Items.Data.Rows.Where(r =>
  433. !r.Get<RequisitionItem,double>(x=>x.ActualQuantity).IsEffectivelyEqual(0.0)
  434. && !Entity.IsEntityLinkValid<RequisitionItem, StockLocationLink>(x => x.Location, r)
  435. && r.Get<RequisitionItem, bool>(c => c.Product.NonStock).Equals(false));
  436. if (emptyrows.Any())
  437. {
  438. MessageWindow.ShowMessage(
  439. "You must select a Holding for each non-stock Item on this Requisition!",
  440. "Missing Holdings",
  441. image: MessageWindow.WarningImage);
  442. return;
  443. }
  444. if (!MessageWindow.ShowYesNo("Update Stock Movements?", "Confirm"))
  445. return;
  446. _requisition.StockUpdated = DateTime.Now;
  447. }
  448. else
  449. {
  450. if (!MessageWindow.ShowYesNo("Clear Stock Movements?", "Confirm"))
  451. return;
  452. _requisition.StockUpdated = DateTime.MinValue;
  453. }
  454. Progress.Show("Updating Stock Holdings");
  455. Client.Save(_requisition, "Updated Stock Flag");
  456. if (!_requisition.Filled.IsEmpty() && !_requisition.StockUpdated.IsEmpty() && !_requisition.Archived.IsEmpty())
  457. {
  458. Refresh();
  459. }
  460. else
  461. {
  462. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.StockUpdated, _requisition.StockUpdated);
  463. LoadRequisition();
  464. }
  465. Progress.Close();
  466. }
  467. }