RequisitionPanel.xaml.cs 20 KB

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