RequisitionPanel.xaml.cs 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523
  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 Motorola.Snapi;
  15. using Motorola.Snapi.Constants.Enums;
  16. using Motorola.Snapi.EventArguments;
  17. //using RestSharp;
  18. namespace PRSDesktop;
  19. public class RequisitionPanelSettings : IUserConfigurationSettings
  20. {
  21. public ScreenViewType ViewType { get; set; } = ScreenViewType.Combined;
  22. public double RequisitionsWidth { get; set; } = 450;
  23. public double DetailsWidth { get; set; } = 450;
  24. }
  25. /// <summary>
  26. /// Interaction logic for RequisitionPanel.xaml
  27. /// </summary>
  28. public partial class RequisitionPanel : UserControl, IPanel<Requisition>
  29. {
  30. private Requisition? _requisition;
  31. private RequisitionPanelSettings Settings;
  32. public List<IMotorolaBarcodeScanner> Scanners = new();
  33. public RequisitionPanel()
  34. {
  35. InitializeComponent();
  36. PickImage.Source = PRSDesktop.Resources.tick.AsBitmapImage(Color.White);
  37. StockImage.Source = PRSDesktop.Resources.forklift.AsBitmapImage(Color.White);
  38. TruckImage.Source = PRSDesktop.Resources.truck.AsBitmapImage();
  39. }
  40. //DateTime lastselection = DateTime.MaxValue;
  41. //DispatcherTimer timer = new DispatcherTimer();
  42. public event DataModelUpdateEvent? OnUpdateDataModel;
  43. public bool IsReady { get; set; }
  44. public Dictionary<string, object[]> Selected()
  45. {
  46. return new Dictionary<string, object[]>
  47. {
  48. { typeof(Requisition).EntityName(), Requisitions.SelectedRows },
  49. { typeof(RequisitionItem).EntityName(), Items.SelectedRows }
  50. };
  51. }
  52. public void Setup()
  53. {
  54. //Requisitions.OnSelectItem += Requisitions_OnSelectItem;
  55. //Requisitions.OnRequisitionFillStateChanged += Requisitions_OnRequisitionFillStateChanged;
  56. //Requisitions.OnRequisitionBoxesChanged += Requisitions_OnRequisitionBoxesChanged;
  57. LoadSettings();
  58. SetupScanner();
  59. Items.Reconfigure(options =>
  60. {
  61. options.BeginUpdate();
  62. if (_requisition != null)
  63. {
  64. if (_requisition.Filled.IsEmpty())
  65. {
  66. options.Add(DynamicGridOption.AddRows);
  67. options.Add(DynamicGridOption.DeleteRows);
  68. }
  69. else
  70. {
  71. options.Remove(DynamicGridOption.AddRows);
  72. options.Remove(DynamicGridOption.DeleteRows);
  73. }
  74. }
  75. options.EndUpdate();
  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. //host.CreatePanelAction(new PanelAction() { Caption = "Archive Requisition", Image = PRSDesktop.Resources.delete, OnExecute = ArchiveRequisition });
  112. }
  113. public string SectionName => "Requisitions";
  114. public DataModel DataModel(Selection selection)
  115. {
  116. var ids = Requisitions.ExtractValues(x => x.ID, selection).ToArray();
  117. return new BaseDataModel<Requisition>(new Filter<Requisition>(x => x.ID).InList(ids));
  118. }
  119. public void Refresh()
  120. {
  121. Requisitions.Refresh(false, true);
  122. //lastselection = DateTime.MinValue;
  123. //Items.Refresh(true, false);
  124. }
  125. public void Heartbeat(TimeSpan time)
  126. {
  127. // Nothing to do here
  128. }
  129. private void ShutdownScanner()
  130. {
  131. try
  132. {
  133. foreach (var scanner in Scanners) scanner.Actions.ToggleLed(LedMode.GreenOff);
  134. BarcodeScannerManager.Instance.DataReceived -= Instance_DataReceived;
  135. BarcodeScannerManager.Instance.Close();
  136. }
  137. catch (Exception e)
  138. {
  139. MessageBox.Show("Error Shutting down Scanner!\n\n" + e.Message);
  140. }
  141. }
  142. private void SetupScanner()
  143. {
  144. Scanners.Clear();
  145. BarcodeScannerManager.Instance.Open();
  146. BarcodeScannerManager.Instance.RegisterForEvents(EventType.Barcode, EventType.Pnp, EventType.Image, EventType.Other, EventType.Rmd);
  147. BarcodeScannerManager.Instance.GetDevices();
  148. foreach (var scanner in BarcodeScannerManager.Instance.GetDevices())
  149. {
  150. Scanners.Add(scanner);
  151. scanner.Actions.ToggleLed(LedMode.RedOn);
  152. scanner.Actions.SoundBeeper(BeepPattern.FastWarble);
  153. }
  154. BarcodeScannerManager.Instance.DataReceived += Instance_DataReceived;
  155. }
  156. private void Instance_DataReceived(object? sender, BarcodeScanEventArgs e)
  157. {
  158. Dispatcher.Invoke(() => { ProcessCode(Scanners[(int)e.ScannerId], e.Data); });
  159. }
  160. private void ProcessCode(IMotorolaBarcodeScanner scanner, string code)
  161. {
  162. try
  163. {
  164. var iRow = Requisitions.SelectedRows.First().Index;
  165. if (iRow == -1)
  166. throw new Exception("Please select a Requsition First");
  167. var row = Requisitions.Data.Rows[iRow];
  168. var filled = row.Get<Requisition, DateTime>(x => x.Filled);
  169. if (!filled.IsEmpty())
  170. throw new Exception("Cannot Add Items to a completed Requisition");
  171. var reqid = row.Get<Requisition, Guid>(x => x.ID);
  172. var boxes = row.Get<Requisition, int>(x => x.Boxes);
  173. var sCode = code;
  174. var iQty = 1;
  175. if (sCode.Contains('*'))
  176. {
  177. var comps = sCode.Split('*');
  178. sCode = comps[0];
  179. iQty = int.Parse(comps[1].Trim());
  180. }
  181. RequisitionItem? item = null;
  182. CoreRow? itemrow = null;
  183. try
  184. {
  185. itemrow = Items.Data.Rows.FirstOrDefault(r => /* r.Get<RequisitionItem, int>(x => x.BoxNumber).Equals(boxes) && */
  186. r.Get<RequisitionItem, string>(x => x.BarCode).Equals(sCode));
  187. //itemrow = Items.Data.Rows.FirstOrDefault(r => r.Get<RequisitionItem, String>(x => x.BarCode).Equals(sCode));
  188. }
  189. catch (Exception e)
  190. {
  191. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  192. }
  193. if (itemrow != null)
  194. item = new Client<RequisitionItem>()
  195. .Load(new Filter<RequisitionItem>(x => x.ID).IsEqualTo(itemrow.Get<RequisitionItem, Guid>(x => x.ID))).FirstOrDefault();
  196. if (item != null)
  197. {
  198. item.Quantity += iQty;
  199. new Client<RequisitionItem>().Save(item, "Quantity Updated by Barcode Scanner");
  200. scanner?.Actions.SoundBeeper(BeepPattern.LowHigh);
  201. Refresh();
  202. }
  203. else
  204. {
  205. var product = new Client<Product>().Load(new Filter<Product>(x => x.Code).IsEqualTo(sCode)).FirstOrDefault();
  206. if (product != null)
  207. {
  208. item = new RequisitionItem
  209. {
  210. RequisitionLink = new RequisitionLink { ID = reqid },
  211. //BoxNumber = boxes,
  212. Code = product.Code,
  213. Description = product.Name,
  214. BarCode = sCode,
  215. Quantity = iQty
  216. };
  217. new Client<RequisitionItem>().Save(item, "Scanned by Barcode Reader");
  218. scanner?.Actions.SoundBeeper(BeepPattern.LowHigh);
  219. Refresh();
  220. }
  221. else
  222. {
  223. scanner?.Actions.SoundBeeper(BeepPattern.FourLowLong);
  224. }
  225. }
  226. }
  227. catch (Exception)
  228. {
  229. scanner?.Actions.SoundBeeper(BeepPattern.FourLowShort);
  230. }
  231. }
  232. /*private void ArchiveRequisition(PanelAction obj)
  233. {
  234. var bClosed = false;
  235. var iRow = Requisitions.SelectedRows.First().Index;
  236. if (iRow > -1)
  237. {
  238. var row = Requisitions.Data.Rows[iRow];
  239. var id = row.Get<Requisition, Guid>(x => x.ID);
  240. var filled = row.Get<Requisition, DateTime>(x => x.Filled);
  241. if (filled.IsEmpty())
  242. {
  243. MessageBox.Show("Please complete this requisition before Archiving it!");
  244. }
  245. else
  246. {
  247. var req = new Client<Requisition>().Load(new Filter<Requisition>(x => x.ID).IsEqualTo(id)).FirstOrDefault();
  248. if (req != null)
  249. {
  250. req.Archived = DateTime.Now;
  251. new Client<Requisition>().Save(req, "Requisition Archived");
  252. bClosed = true;
  253. }
  254. }
  255. }
  256. else
  257. {
  258. MessageBox.Show("Please select a requisition first!");
  259. }
  260. if (bClosed)
  261. Refresh();
  262. }*/
  263. public Dictionary<Type, CoreTable> DataEnvironment()
  264. {
  265. return new Dictionary<Type, CoreTable>
  266. {
  267. [typeof(Requisition)] = Requisitions.Data,
  268. [typeof(RequisitionItem)] = Items.Data
  269. };
  270. }
  271. //private void Timer_Tick(object sender, EventArgs e)
  272. //{
  273. // if (lastselection < DateTime.Now.AddMilliseconds(-500))
  274. // {
  275. // lastselection = DateTime.MaxValue;
  276. // LoadRequisition();
  277. // }
  278. //}
  279. private void LoadRequisition()
  280. {
  281. foreach (var scanner in Scanners)
  282. scanner.Actions.ToggleLed(_requisition != null ? LedMode.GreenOn : LedMode.RedOn);
  283. Title.Text = _requisition != null ? _requisition.Title : "";
  284. RequestedBy.Content = _requisition != null ? _requisition.RequestedBy.Name : "";
  285. DueDate.Content = _requisition != null ? string.Format("{0:dddd, dd MMM yyyy}", _requisition.Due) : "";
  286. var notes = _requisition != null ? _requisition.Notes : Array.Empty<string>();
  287. var request = _requisition != null ? CoreUtils.StripHTML(_requisition.Request) : "";
  288. Request.Text = string.Join("\n===============================\n", Utility.ProcessNotes(notes, request));
  289. MarkAsFilled.IsEnabled = _requisition != null && _requisition.Archived.IsEmpty() && _requisition.StockUpdated.IsEmpty();
  290. MarkAsFilledDescription.Content = _requisition == null || _requisition.Filled.IsEmpty() ? "Mark As Filled" : "Clear Filled Flag";
  291. UpdateStock.IsEnabled = Security.IsAllowed<CanUpdateRequisitionStockMovements>() && _requisition != null &&
  292. !_requisition.Filled.IsEmpty();
  293. UpdateStockDescription.Content =
  294. _requisition == null || _requisition.StockUpdated.IsEmpty() ? "Update Stock Holdings" : "Clear Stock Movements";
  295. TakenBy.IsEnabled = _requisition != null && !_requisition.Filled.IsEmpty() && _requisition.Archived.IsEmpty() &&
  296. !_requisition.Delivery.IsValid();
  297. TakenByDescription.Content = _requisition == null
  298. ? "Select Employee"
  299. : _requisition.Delivery.IsValid()
  300. ? _requisition.Delivery.Completed.IsEmpty()
  301. ? string.Format("Booked On Delivery #{0}", _requisition.Delivery.Number)
  302. : string.Format("Delivered on {0:dd MMM yy} (#{1})", _requisition.Delivery.Completed, _requisition.Delivery.Number)
  303. : _requisition.TakenBy.IsValid()
  304. ? string.Format("{0} ({1:dd MMM yy})", _requisition.TakenBy.Name, _requisition.Archived)
  305. : "Select Employee";
  306. }
  307. private void Requisitions_OnSelectItem(object sender, DynamicGridSelectionEventArgs e)
  308. {
  309. _requisition = e.Rows?.FirstOrDefault()?.ToObject<Requisition>();
  310. LoadRequisition();
  311. Items.Requisition = _requisition;
  312. Items.Refresh(false, true);
  313. //lastselection = DateTime.Now;
  314. //Dispatcher.Invoke(() => { LoadRequisition(); });
  315. }
  316. private void TakenBy_Click(object sender, RoutedEventArgs e)
  317. {
  318. if (_requisition == null || _requisition.ID == Guid.Empty)
  319. return;
  320. var dlg = new MultiSelectDialog<Employee>(
  321. LookupFactory.DefineFilter<Employee>(),
  322. LookupFactory.DefineColumns<Employee>(),
  323. false);
  324. if (!dlg.ShowDialog())
  325. return;
  326. if (!_requisition.Filled.IsEmpty() && !_requisition.StockUpdated.IsEmpty())
  327. if (MessageBox.Show("This will remove this requisition from this list.\nAre you sure you wish to continue?", "Close Requisition?",
  328. MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes)
  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. if (_requisition == null)
  353. {
  354. MessageBox.Show("Please select a Requisition first!");
  355. return;
  356. }
  357. DateTime filltime = DateTime.Now;
  358. var unpickeditems = Items.Data.Rows.Where(r =>
  359. _requisition.Filled.IsEmpty()
  360. && (r.Get<RequisitionItem, Guid>(x => x.Product.ID) != Guid.Empty)
  361. && (r.Get<RequisitionItem, bool>(x => x.Product.NonStock) != true)
  362. && (r.Get<RequisitionItem, DateTime>(x => x.Picked).IsEmpty())
  363. );
  364. if (unpickeditems.Any())
  365. {
  366. var confirm = MessageBox.Show("Unpicked items exist on this requisition!\n\nDo you want to mark them as picked now?",
  367. "Unpicked Items", MessageBoxButton.YesNoCancel, MessageBoxImage.Question);
  368. if (confirm == MessageBoxResult.Cancel)
  369. return;
  370. filltime = DateTime.Now;
  371. if (confirm == MessageBoxResult.Yes)
  372. {
  373. var updates = new List<RequisitionItem>();
  374. foreach (var row in unpickeditems)
  375. {
  376. var item = row.ToObject<RequisitionItem>();
  377. item.Picked = filltime;
  378. updates.Add(item);
  379. }
  380. new Client<RequisitionItem>().Save(updates, "Marked as Picked because Requisition was marked as filled");
  381. }
  382. }
  383. _requisition.Filled = _requisition.Filled.IsEmpty() ? filltime : DateTime.MinValue;
  384. Progress.Show(_requisition.Filled.IsEmpty() ? "Clearing Delivery Items" : "Creating Delivery Items");
  385. new Client<Requisition>().Save(_requisition, "Updated Filled Flag");
  386. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.Filled, _requisition.Filled);
  387. LoadRequisition();
  388. Items.Refresh(false, true);
  389. Progress.Close();
  390. }
  391. private void UpdateStock_Click(object sender, RoutedEventArgs e)
  392. {
  393. if (_requisition == null)
  394. {
  395. MessageBox.Show("Please select a Requisition first!");
  396. return;
  397. }
  398. if (_requisition.StockUpdated.IsEmpty())
  399. {
  400. var emptyrows = Items.Data.Rows.Where(r =>
  401. !Entity.IsEntityLinkValid<RequisitionItem, StockLocationLink>(x => x.Location, r) &&
  402. r.Get<RequisitionItem, bool>(c => c.Product.NonStock).Equals(false));
  403. if (emptyrows.Any())
  404. {
  405. MessageBox.Show("You must select a Holding for each non-stock Item on this Requisition!", "Missing Holdings", MessageBoxButton.OK,
  406. MessageBoxImage.Error);
  407. return;
  408. }
  409. if (!_requisition.Filled.IsEmpty() && !_requisition.Archived.IsEmpty())
  410. {
  411. if (MessageBox.Show("This will remove this requisition from this list.\nAre you sure you wish to continue?", "Close Requisition?",
  412. MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes)
  413. return;
  414. }
  415. else
  416. {
  417. if (MessageBox.Show("Update Stock Movements?", "Confirm", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
  418. return;
  419. }
  420. _requisition.StockUpdated = DateTime.Now;
  421. }
  422. else
  423. {
  424. if (MessageBox.Show("Clear Stock Movements?", "Confirm", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
  425. return;
  426. _requisition.StockUpdated = DateTime.MinValue;
  427. }
  428. Progress.Show("Updating Stock Holdings");
  429. new Client<Requisition>().Save(_requisition, "Updated Stock Flag");
  430. if (!_requisition.Filled.IsEmpty() && !_requisition.StockUpdated.IsEmpty() && !_requisition.Archived.IsEmpty())
  431. {
  432. Refresh();
  433. }
  434. else
  435. {
  436. Requisitions.UpdateRow<Requisition, DateTime>(Requisitions.SelectedRows.First(), x => x.StockUpdated, _requisition.StockUpdated);
  437. LoadRequisition();
  438. }
  439. Progress.Close();
  440. }
  441. }