DynamicGrid.cs 77 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Diagnostics;
  6. using System.Globalization;
  7. using System.Linq;
  8. using System.Linq.Expressions;
  9. using System.Threading.Tasks;
  10. using System.Windows;
  11. using System.Windows.Controls;
  12. using System.Windows.Data;
  13. using System.Windows.Input;
  14. using System.Windows.Media;
  15. using System.Windows.Media.Animation;
  16. using System.Windows.Media.Imaging;
  17. using InABox.Clients;
  18. using InABox.Core;
  19. using InABox.Wpf;
  20. using InABox.WPF;
  21. using Syncfusion.Data;
  22. using Syncfusion.UI.Xaml.Grid;
  23. using Syncfusion.UI.Xaml.Grid.Helpers;
  24. using static InABox.DynamicGrid.IDynamicGrid;
  25. using Color = System.Drawing.Color;
  26. using Image = System.Windows.Controls.Image;
  27. using RowColumnIndex = Syncfusion.UI.Xaml.ScrollAxis.RowColumnIndex;
  28. using SolidColorBrush = System.Windows.Media.SolidColorBrush;
  29. using String = System.String;
  30. using VerticalAlignment = System.Windows.VerticalAlignment;
  31. using VirtualizingCellsControl = Syncfusion.UI.Xaml.Grid.VirtualizingCellsControl;
  32. namespace InABox.DynamicGrid;
  33. public abstract class DynamicGrid : ContentControl
  34. {
  35. public static readonly DependencyProperty UseWaitCursorProperty =
  36. DependencyProperty.Register(nameof(UseWaitCursor), typeof(bool), typeof(DynamicGrid<>));
  37. public bool UseWaitCursor
  38. {
  39. get => (bool)GetValue(UseWaitCursorProperty);
  40. set => SetValue(UseWaitCursorProperty, value);
  41. }
  42. }
  43. public abstract class DynamicGrid<T> : DynamicGrid, IDynamicGridUIComponentParent<T>, IDynamicGrid<T>
  44. where T : BaseObject, new()
  45. {
  46. protected enum ClipAction
  47. {
  48. Cut,
  49. Copy
  50. }
  51. private IDynamicGridUIComponent<T> UIComponent { get; set; }
  52. private UIElement? _header;
  53. private readonly Button Add;
  54. public bool bRefreshing;
  55. bool IDynamicGridUIComponentParent<T>.IsRefreshing => bRefreshing;
  56. private readonly Label ClipboardSpacer;
  57. private readonly Button Copy;
  58. private readonly Label Count;
  59. private readonly Button Cut;
  60. private readonly Border Disabler;
  61. private readonly Button Delete;
  62. private readonly DockPanel Docker;
  63. private readonly DynamicRowMovementColumn? down;
  64. private readonly Button Edit;
  65. private readonly Label EditSpacer;
  66. private readonly Button Export;
  67. private readonly Label ExportSpacer;
  68. private readonly Button DuplicateBtn;
  69. private readonly Button SwitchViewBtn;
  70. private readonly Button Help;
  71. private readonly Button Import;
  72. private readonly Grid Layout;
  73. private readonly Label Loading;
  74. private DoubleAnimation LoadingFader = new DoubleAnimation(1d, 0.2d, new Duration(TimeSpan.FromSeconds(2))) { AutoReverse = true };
  75. //private readonly Button MultiEdit;
  76. private readonly Button Paste;
  77. private readonly Button Print;
  78. private readonly Label PrintSpacer;
  79. private readonly StackPanel LeftButtonStack;
  80. private readonly StackPanel RightButtonStack;
  81. private readonly DynamicRowMovementColumn? up;
  82. protected DynamicGridRowStyleSelector<T> RowStyleSelector;
  83. #region Events
  84. public event IDynamicGrid.ReconfigureEvent? OnReconfigure;
  85. public OnGetDynamicGridRowStyle? OnGetRowStyle { get; set; }
  86. public ValidateEvent<T>? OnValidate { get; set; }
  87. public event OnPrintData? OnPrintData;
  88. public event BeforeRefreshEventHandler? BeforeRefresh;
  89. public event AfterRefreshEventHandler? AfterRefresh;
  90. public event OnDefineFilter? OnDefineFilter;
  91. public event OnCreateItem? OnCreateItem;
  92. public event OnAfterCreateItem? OnAfterCreateItem;
  93. /// <summary>
  94. /// Called when an item is selected in the grid. It is not called if <see cref="IsReady"/> is not <see langword="true"/>.
  95. /// </summary>
  96. /// <remarks>
  97. /// It is unnecessary to use this if within a grid. Instead, override <see cref="SelectItems(CoreRow[]?)"/>.
  98. /// </remarks>
  99. public event SelectItemHandler? OnSelectItem;
  100. public event OnCellDoubleClick? OnCellDoubleClick;
  101. public event EventHandler? OnChanged;
  102. public delegate void BeforeSelectionEvent(CancelEventArgs cancel);
  103. public event BeforeSelectionEvent? OnBeforeSelection;
  104. protected virtual void Changed()
  105. {
  106. }
  107. public virtual void DoChanged()
  108. {
  109. Changed();
  110. OnChanged?.Invoke(this, EventArgs.Empty);
  111. }
  112. public event EditorValueChangedHandler? OnEditorValueChanged;
  113. public event OnCustomiseEditor<T>? OnCustomiseEditor;
  114. public event OnFilterRecord? OnFilterRecord;
  115. public event OnDoubleClick? OnDoubleClick;
  116. public event EntitySaveEvent? OnBeforeSave;
  117. public event EntitySaveEvent? OnAfterSave;
  118. public delegate void EditorLoaded(IDynamicEditorForm editor, T[] items);
  119. public event EditorLoaded OnEditorLoaded;
  120. public event OnLoadEditorButtons<T> OnLoadEditorButtons;
  121. public virtual event OnCustomiseColumns? OnCustomiseColumns;
  122. protected void DoCustomiseColumnsEvent(object sender, DynamicGridColumns columns) =>
  123. OnCustomiseColumns?.Invoke(sender, columns);
  124. #endregion
  125. protected DynamicGridSettings Settings { get; set; }
  126. public DynamicGrid() : base()
  127. {
  128. UseWaitCursor = true;
  129. Options = new FluentList<DynamicGridOption>();
  130. Options.OnChanged += (sender, args) =>
  131. {
  132. _hasLoadedOptions = true;
  133. OptionsChanged();
  134. };
  135. ActionColumns = new DynamicActionColumns();
  136. ColumnGroupings = new DynamicGridColumnGroupings();
  137. RowStyleSelector = GetRowStyleSelector();
  138. RowStyleSelector.GetStyle += (row, style) => GetRowStyle(row, style);
  139. IsReady = false;
  140. Data = new CoreTable();
  141. MasterColumns = new DynamicGridColumns();
  142. MasterColumns.ExtractColumns(typeof(T));
  143. HiddenColumns = new HiddenColumnsList();
  144. foreach (var column in LookupFactory.RequiredColumns<T>().ColumnNames())
  145. {
  146. AddHiddenColumn(column);
  147. }
  148. if (IsSequenced)
  149. {
  150. up = new DynamicRowMovementColumn(DynamicRowMovement.Up, SwapRows);
  151. ActionColumns.Add(up);
  152. down = new DynamicRowMovementColumn(DynamicRowMovement.Down, SwapRows);
  153. ActionColumns.Add(down);
  154. HiddenColumns.Add(x => (x as ISequenceable)!.Sequence);
  155. }
  156. VisibleColumns = new DynamicGridColumns();
  157. UIComponent = CreateUIComponent();
  158. Loading = new Label();
  159. Loading.Content = "Loading...";
  160. Loading.Foreground = new SolidColorBrush(Colors.White);
  161. Loading.VerticalContentAlignment = VerticalAlignment.Center;
  162. Loading.HorizontalContentAlignment = HorizontalAlignment.Center;
  163. Loading.Visibility = Visibility.Collapsed;
  164. Loading.SetValue(Panel.ZIndexProperty, 999);
  165. Loading.SetValue(Grid.RowProperty, 1);
  166. Loading.FontSize = 14.0F;
  167. LoadingFader.Completed += (sender, args) =>
  168. {
  169. if (Loading.Visibility == Visibility.Visible)
  170. {
  171. //Logger.Send(LogType.Information, this.GetType().EntityName().Split(".").Last(), "Loading Fader Restarting");
  172. Loading.BeginAnimation(Label.OpacityProperty, LoadingFader);
  173. }
  174. };
  175. Help = CreateButton(Wpf.Resources.help.AsBitmapImage(Color.White));
  176. Help.Margin = new Thickness(0, 2, 2, 0);
  177. Help.SetValue(DockPanel.DockProperty, Dock.Right);
  178. Help.Click += (o, e) => ShowHelp(typeof(T).Name.Split('.').Last().SplitCamelCase().Replace(" ", "_"));
  179. Add = CreateButton(Wpf.Resources.add.AsBitmapImage(Color.White));
  180. Add.Margin = new Thickness(0, 2, 2, 0);
  181. Add.Click += Add_Click;
  182. Edit = CreateButton(Wpf.Resources.pencil.AsBitmapImage(Color.White));
  183. Edit.Margin = new Thickness(0, 2, 2, 0);
  184. Edit.Click += Edit_Click;
  185. SwitchViewBtn = CreateButton(Wpf.Resources.alter.AsBitmapImage());
  186. SwitchViewBtn.Margin = new Thickness(0, 2, 2, 0);
  187. SwitchViewBtn.Click += SwitchView_Click;
  188. EditSpacer = new Label { Width = 5 };
  189. Print = CreateButton(Wpf.Resources.print.AsBitmapImage(Color.White));
  190. Print.Margin = new Thickness(0, 2, 2, 0);
  191. Print.Click += (o, e) => DoPrint(o);
  192. PrintSpacer = new Label { Width = 5 };
  193. Cut = CreateButton(Wpf.Resources.cut.AsBitmapImage(Color.White));
  194. Cut.Margin = new Thickness(0, 2, 2, 0);
  195. Cut.Click += Cut_Click;
  196. Copy = CreateButton(Wpf.Resources.copy.AsBitmapImage(Color.White));
  197. Copy.Margin = new Thickness(0, 2, 2, 0);
  198. Copy.Click += Copy_Click;
  199. Paste = CreateButton(Wpf.Resources.paste.AsBitmapImage(Color.White));
  200. Paste.Margin = new Thickness(0, 2, 2, 0);
  201. Paste.Click += Paste_Click;
  202. ClipboardSpacer = new Label { Width = 5 };
  203. Export = CreateButton(Wpf.Resources.doc_xls.AsBitmapImage(Color.White), "Export");
  204. Export.Margin = new Thickness(0, 2, 2, 0);
  205. Export.Click += Export_Click;
  206. Import = CreateButton(Wpf.Resources.doc_xls.AsBitmapImage(Color.White), "Import");
  207. Import.Margin = new Thickness(0, 2, 2, 0);
  208. Import.Click += Import_Click;
  209. ExportSpacer = new Label { Width = 5 };
  210. LeftButtonStack = new StackPanel();
  211. LeftButtonStack.Orientation = Orientation.Horizontal;
  212. LeftButtonStack.SetValue(DockPanel.DockProperty, Dock.Left);
  213. LeftButtonStack.Children.Add(Help);
  214. LeftButtonStack.Children.Add(Add);
  215. LeftButtonStack.Children.Add(Edit);
  216. LeftButtonStack.Children.Add(SwitchViewBtn);
  217. //Stack.Children.Add(MultiEdit);
  218. LeftButtonStack.Children.Add(EditSpacer);
  219. LeftButtonStack.Children.Add(Print);
  220. LeftButtonStack.Children.Add(PrintSpacer);
  221. LeftButtonStack.Children.Add(Cut);
  222. LeftButtonStack.Children.Add(Copy);
  223. LeftButtonStack.Children.Add(Paste);
  224. LeftButtonStack.Children.Add(ClipboardSpacer);
  225. LeftButtonStack.Children.Add(Export);
  226. LeftButtonStack.Children.Add(Import);
  227. LeftButtonStack.Children.Add(ExportSpacer);
  228. RightButtonStack = new StackPanel();
  229. RightButtonStack.Orientation = Orientation.Horizontal;
  230. RightButtonStack.SetValue(DockPanel.DockProperty, Dock.Right);
  231. Delete = CreateButton(Wpf.Resources.delete.AsBitmapImage(Color.White));
  232. Delete.Margin = new Thickness(2, 2, 0, 0);
  233. Delete.SetValue(DockPanel.DockProperty, Dock.Right);
  234. Delete.Click += Delete_Click;
  235. DuplicateBtn = AddButton("Duplicate", Wpf.Resources.paste.AsBitmapImage(Color.White), DoDuplicate);
  236. Count = new Label();
  237. Count.Height = 30;
  238. Count.Margin = new Thickness(0, 2, 0, 0);
  239. Count.VerticalContentAlignment = VerticalAlignment.Center;
  240. Count.HorizontalContentAlignment = HorizontalAlignment.Center;
  241. Count.SetValue(DockPanel.DockProperty, Dock.Left);
  242. Docker = new DockPanel();
  243. Docker.SetValue(Grid.RowProperty, 2);
  244. Docker.SetValue(Grid.ColumnProperty, 0);
  245. Docker.Children.Add(LeftButtonStack);
  246. Docker.Children.Add(Delete);
  247. Docker.Children.Add(RightButtonStack);
  248. Docker.Children.Add(Count);
  249. Layout = new Grid();
  250. Layout.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
  251. Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Auto) });
  252. Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Star) });
  253. Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Auto) });
  254. var control = UIComponent.Control;
  255. control.SetValue(Grid.RowProperty, 1);
  256. Layout.Children.Add(control);
  257. Layout.Children.Add(Loading);
  258. Layout.Children.Add(Docker);
  259. Disabler = new Border()
  260. {
  261. BorderBrush = new SolidColorBrush(Colors.Transparent),
  262. Background = new SolidColorBrush(Colors.DimGray) { Opacity = 0.2 },
  263. Visibility = Visibility.Collapsed,
  264. };
  265. Disabler.SetValue(Canvas.ZIndexProperty, 99);
  266. Disabler.SetValue(Grid.RowSpanProperty, 3);
  267. Layout.Children.Add(Disabler);
  268. //Scroll.ApplyTemplate();
  269. Content = Layout;
  270. IsEnabledChanged += (sender, args) =>
  271. {
  272. Disabler.Visibility = Equals(args.NewValue, true)
  273. ? Visibility.Collapsed
  274. : Visibility.Visible;
  275. };
  276. Settings = LoadSettings();
  277. Init();
  278. Reconfigure();
  279. }
  280. #region IDynamicGridUIComponentParent
  281. protected virtual IDynamicGridUIComponent<T> CreateUIComponent()
  282. {
  283. return new DynamicGridGridUIComponent<T>()
  284. {
  285. Parent = this
  286. };
  287. }
  288. bool IDynamicGridUIComponentParent<T>.CanSort()
  289. {
  290. return !IsSequenced;
  291. }
  292. T IDynamicGrid<T>.LoadItem(CoreRow row) => LoadItem(row);
  293. DynamicGridRowStyleSelector<T> IDynamicGridUIComponentParent<T>.RowStyleSelector => RowStyleSelector;
  294. void IDynamicGridUIComponentParent<T>.BeforeSelection(CancelEventArgs cancel)
  295. {
  296. BeforeSelection(cancel);
  297. }
  298. void IDynamicGridUIComponentParent<T>.SelectItems(CoreRow[] rows)
  299. {
  300. SelectItems(rows);
  301. }
  302. void IDynamicGridUIComponentParent<T>.EntityChanged(T obj, CoreRow row, string changedColumn, Dictionary<string, object?> changes)
  303. => EntityChanged(obj, row, changedColumn, changes);
  304. void IDynamicGridUIComponentParent<T>.UpdateData(T obj, CoreRow row, string changedColumn, Dictionary<CoreColumn, object?> updates)
  305. {
  306. var result = new Dictionary<string, object?>();
  307. foreach (var (col, value) in updates)
  308. {
  309. UpdateRow(row, col.ColumnName, value, refresh: false);
  310. DynamicGridUtils.UpdateEditorValue(new BaseObject[] { obj }, col.ColumnName, value, result);
  311. }
  312. EntityChanged(obj, row, changedColumn, result);
  313. }
  314. void IDynamicGridUIComponentParent<T>.HandleKey(KeyEventArgs e)
  315. {
  316. if (IsSequenced)
  317. {
  318. if (e.Key == Key.X && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
  319. {
  320. CutToClipBuffer();
  321. }
  322. else if (e.Key == Key.C && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
  323. {
  324. CopyToClipBuffer();
  325. }
  326. else if (e.Key == Key.V && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
  327. {
  328. PasteFromClipBuffer();
  329. }
  330. else if (e.Key == Key.Escape)
  331. {
  332. ResetClipBuffer();
  333. InvalidateGrid();
  334. }
  335. }
  336. }
  337. void IDynamicGridUIComponentParent<T>.DoubleClickCell(CoreRow? row, DynamicColumnBase? column)
  338. {
  339. var args = new DynamicGridCellClickEventArgs(row, column);
  340. if (OnCellDoubleClick is not null && column is DynamicGridColumn col)
  341. {
  342. OnCellDoubleClick?.Invoke(this, args);
  343. if (args.Handled)
  344. return;
  345. }
  346. if (row is not null)
  347. DoDoubleClick(this, args);
  348. }
  349. void IDynamicGridUIComponentParent<T>.ExecuteActionColumn(DynamicActionColumn column, CoreRow[]? rows)
  350. {
  351. var bRefresh = false;
  352. if(rows is null)
  353. {
  354. bRefresh = column.Action?.Invoke(null) ?? false;
  355. }
  356. else
  357. {
  358. foreach (var row in rows)
  359. if (column.Action?.Invoke(row) == true)
  360. bRefresh = true;
  361. }
  362. if (bRefresh)
  363. Dispatcher.BeginInvoke(() => { Refresh(true, true); });
  364. }
  365. void IDynamicGridUIComponentParent<T>.OpenColumnMenu(DynamicColumnBase column)
  366. {
  367. if(column is DynamicMenuColumn menuColumn)
  368. {
  369. menuColumn.Action?.Invoke(SelectedRows.FirstOrDefault());
  370. }
  371. else if(column is DynamicActionColumn actionColumn)
  372. {
  373. var menu = actionColumn?.ContextMenu?.Invoke(SelectedRows);
  374. if (menu != null && menu.Items.Count > 0)
  375. {
  376. menu.IsOpen = true;
  377. }
  378. }
  379. }
  380. void IDynamicGridUIComponentParent<T>.UpdateRecordCount(int count)
  381. {
  382. Count.Content = string.Format("{0} Records", count);
  383. }
  384. void IDynamicGridUIComponentParent<T>.LoadColumnsMenu(ContextMenu menu)
  385. {
  386. menu.AddItem("Select Columns", null, SelectColumnsClick);
  387. LoadColumnsMenu(menu);
  388. }
  389. void IDynamicGridUIComponentParent<T>.DragOver(object sender, DragEventArgs e)
  390. {
  391. HandleDragOver(sender, e);
  392. }
  393. void IDynamicGridUIComponentParent<T>.Drop(object sender, DragEventArgs e)
  394. {
  395. if (!HasOption(DynamicGridOption.DragTarget))
  396. return;
  397. if(DynamicGridUtils.TryGetDropData(e, out var entityType, out var table))
  398. {
  399. OnDragEnd(entityType, table, e);
  400. }
  401. else
  402. {
  403. HandleDragDrop(sender, e);
  404. }
  405. }
  406. void IDynamicGridUIComponentParent<T>.DragStart(object? sender, CoreRow[] rows)
  407. {
  408. Logger.Send(LogType.Information, "", "RowDragDropController_DragStart");
  409. if (!HasOption(DynamicGridOption.DragSource))
  410. return;
  411. OnRowsDragStart(rows);
  412. }
  413. void IDynamicGridUIComponentParent<T>.UIFilterChanged(object sender) => DoFilterChanged();
  414. protected virtual void DoFilterChanged()
  415. {
  416. }
  417. IEnumerable<string>? IDynamicGridUIComponentParent<T>.GetColumnFilterItems(DynamicColumnBase column) => GetColumnFilterItems(column);
  418. protected virtual IEnumerable<string>? GetColumnFilterItems(DynamicColumnBase column)
  419. {
  420. return null;
  421. }
  422. #endregion
  423. protected virtual DynamicGridRowStyleSelector<T> GetRowStyleSelector()
  424. {
  425. return new DynamicGridRowStyleSelector<T, DynamicGridRowStyle>();
  426. }
  427. protected virtual DynamicGridStyle GetRowStyle(CoreRow row, DynamicGridStyle style)
  428. {
  429. DynamicGridStyle? result = null;
  430. if (ClipBuffer != null)
  431. if (ClipBuffer.Item2.Contains(row))
  432. {
  433. var bgbrush = style.Background as SolidColorBrush;
  434. var bgcolor = bgbrush != null ? bgbrush.Color : Colors.Transparent;
  435. result = new DynamicGridRowStyle(style);
  436. result.Background = ClipBuffer.Item1 == ClipAction.Cut
  437. ? new SolidColorBrush(bgcolor.MixColors(0.5, Colors.Orchid))
  438. : new SolidColorBrush(bgcolor.MixColors(0.5, Colors.LightGreen));
  439. result.Foreground = new SolidColorBrush(Colors.Gray);
  440. result.FontStyle = FontStyles.Italic;
  441. }
  442. result ??= OnGetRowStyle != null ? OnGetRowStyle(row, style) : style;
  443. return result;
  444. }
  445. protected virtual void BeforeSelection(CancelEventArgs cancel)
  446. {
  447. OnBeforeSelection?.Invoke(cancel);
  448. }
  449. public bool IsReady { get; protected set; }
  450. public UIElement? Header
  451. {
  452. get => _header;
  453. set
  454. {
  455. if (_header is not null && Layout.Children.Contains(_header))
  456. Layout.Children.Remove(_header);
  457. _header = value;
  458. if (_header is not null)
  459. {
  460. _header.SetValue(Grid.RowProperty, 0);
  461. _header.SetValue(Grid.ColumnProperty, 0);
  462. _header.SetValue(Grid.ColumnSpanProperty, 2);
  463. Layout.Children.Add(_header);
  464. }
  465. }
  466. }
  467. /// <summary>
  468. /// Represents the data in the grid. This is <see langword="null"/> until <see cref="Refresh(bool, bool)"/> is called.
  469. /// </summary>
  470. public CoreTable? MasterData { get; set; }
  471. public DynamicGridColumns MasterColumns { get; protected set; }
  472. public DynamicGridColumns VisibleColumns { get; protected set; }
  473. public DynamicActionColumns ActionColumns { get; protected set; }
  474. public CoreTable Data { get; set; }
  475. public class HiddenColumnsList
  476. {
  477. private List<string> Columns { get; set; } = new();
  478. public IEnumerable<string> ColumnNames => Columns;
  479. public void Add(Expression<Func<T, object?>> column) => Add(CoreUtils.GetFullPropertyName(column, "."));
  480. public void Add(IColumn column) => Add(column.Property);
  481. public void Add(string column)
  482. {
  483. if (!Contains(column))
  484. Columns.Add(column);
  485. }
  486. public bool Contains(string column) => Columns.Contains(column);
  487. }
  488. public void AddHiddenColumn(string column) => HiddenColumns.Add(column);
  489. public HiddenColumnsList HiddenColumns { get; }
  490. private static bool IsSequenced => typeof(T).GetInterfaces().Any(x => x.Equals(typeof(ISequenceable)));
  491. public double RowHeight
  492. {
  493. get => UIComponent.RowHeight;
  494. set => UIComponent.RowHeight = value;
  495. }
  496. public double HeaderHeight
  497. {
  498. get => UIComponent.HeaderRowHeight;
  499. set => UIComponent.HeaderRowHeight = value;
  500. }
  501. #region Options
  502. /// <summary>
  503. /// Initialise things like custom buttons; called once during construction.
  504. /// </summary>
  505. protected abstract void Init();
  506. protected abstract void DoReconfigure(FluentList<DynamicGridOption> options);
  507. private bool _hasLoadedOptions = false;
  508. protected virtual void OptionsChanged()
  509. {
  510. var reloadColumns = false;
  511. Help.Visibility = HasOption(DynamicGridOption.ShowHelp) ? Visibility.Visible : Visibility.Collapsed;
  512. Add.Visibility = HasOption(DynamicGridOption.AddRows) ? Visibility.Visible : Visibility.Collapsed;
  513. Edit.Visibility = HasOption(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
  514. EditSpacer.Visibility = HasOption(DynamicGridOption.AddRows) || HasOption(DynamicGridOption.EditRows)
  515. ? Visibility.Visible
  516. : Visibility.Collapsed;
  517. Print.Visibility = HasOption(DynamicGridOption.Print) ? Visibility.Visible : Visibility.Collapsed;
  518. PrintSpacer.Visibility = HasOption(DynamicGridOption.Print) ? Visibility.Visible : Visibility.Collapsed;
  519. Cut.Visibility = IsSequenced && HasOption(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
  520. Copy.Visibility = IsSequenced && HasOption(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
  521. Paste.Visibility = IsSequenced && HasOption(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
  522. ClipboardSpacer.Visibility = IsSequenced && HasOption(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
  523. Export.Visibility = HasOption(DynamicGridOption.ExportData) ? Visibility.Visible : Visibility.Collapsed;
  524. Import.Visibility = HasOption(DynamicGridOption.ImportData) ? Visibility.Visible : Visibility.Collapsed;
  525. ExportSpacer.Visibility = HasOption(DynamicGridOption.ExportData) || HasOption(DynamicGridOption.ImportData)
  526. ? Visibility.Visible
  527. : Visibility.Collapsed;
  528. SwitchViewBtn.Visibility = HasOption(DynamicGridOption.DirectEdit)
  529. ? HasOption(DynamicGridOption.HideDirectEditButton)
  530. ? Visibility.Collapsed
  531. : Visibility.Visible
  532. : Visibility.Collapsed;
  533. Count.Visibility = HasOption(DynamicGridOption.RecordCount) ? Visibility.Visible : Visibility.Collapsed;
  534. Delete.Visibility = HasOption(DynamicGridOption.DeleteRows) ? Visibility.Visible : Visibility.Collapsed;
  535. if (up != null)
  536. up.Position = HasOption(DynamicGridOption.EditRows) ? DynamicActionColumnPosition.Start : DynamicActionColumnPosition.Hidden;
  537. if (down != null)
  538. down.Position = HasOption(DynamicGridOption.EditRows) ? DynamicActionColumnPosition.Start : DynamicActionColumnPosition.Hidden;
  539. if (DuplicateBtn != null)
  540. DuplicateBtn.Visibility = Visibility.Collapsed;
  541. reloadColumns = reloadColumns || UIComponent.OptionsChanged();
  542. if(reloadColumns)
  543. {
  544. Refresh(true, false);
  545. }
  546. }
  547. public bool IsDirectEditMode(IEnumerable<DynamicGridOption>? options = null)
  548. {
  549. return HasOption(DynamicGridOption.DirectEdit, options)
  550. && (Settings.ViewMode == DynamicGridSettings.DynamicGridViewMode.DirectEdit
  551. || Settings.ViewMode == DynamicGridSettings.DynamicGridViewMode.Default);
  552. }
  553. private void SwitchView_Click(object sender, RoutedEventArgs e)
  554. {
  555. Settings.ViewMode = Settings.ViewMode switch
  556. {
  557. DynamicGridSettings.DynamicGridViewMode.Default => DynamicGridSettings.DynamicGridViewMode.Normal,
  558. DynamicGridSettings.DynamicGridViewMode.Normal => DynamicGridSettings.DynamicGridViewMode.DirectEdit,
  559. DynamicGridSettings.DynamicGridViewMode.DirectEdit or _ => DynamicGridSettings.DynamicGridViewMode.Normal
  560. };
  561. SaveSettings(Settings);
  562. Reconfigure();
  563. }
  564. public FluentList<DynamicGridOption> Options { get; }
  565. protected void OnReconfigureEvent(FluentList<DynamicGridOption> options)
  566. {
  567. OnReconfigure?.Invoke(options);
  568. }
  569. /// <summary>
  570. /// Configure custom buttons and options.
  571. /// </summary>
  572. public void Reconfigure(FluentList<DynamicGridOption> options)
  573. {
  574. options.BeginUpdate().Clear();
  575. DoReconfigure(options);
  576. OnReconfigureEvent(options);
  577. options.EndUpdate();
  578. if (!_hasLoadedOptions)
  579. {
  580. _hasLoadedOptions = true;
  581. OptionsChanged();
  582. }
  583. }
  584. public void Reconfigure()
  585. {
  586. Reconfigure(Options);
  587. }
  588. public void Reconfigure(ReconfigureEvent onReconfigure)
  589. {
  590. OnReconfigure += onReconfigure;
  591. Reconfigure();
  592. }
  593. public bool HasOption(DynamicGridOption option, IEnumerable<DynamicGridOption>? options = null) => (options ?? Options).Contains(option);
  594. bool IDynamicGrid.HasOption(InABox.DynamicGrid.DynamicGridOption option) => HasOption(option, null);
  595. #endregion
  596. protected virtual DynamicGridSettings LoadSettings()
  597. {
  598. return new DynamicGridSettings();
  599. }
  600. protected virtual void SaveSettings(DynamicGridSettings settings)
  601. {
  602. }
  603. protected virtual void LoadColumnsMenu(ContextMenu menu)
  604. {
  605. }
  606. protected void UpdateCell(int row, string colname, object? value)
  607. {
  608. var coreRow = Data.Rows[row];
  609. coreRow[colname] = value;
  610. UIComponent.UpdateCell(coreRow, colname, value);
  611. }
  612. private void EntityChanged(T obj, CoreRow row, string changedColumn, Dictionary<string, object?> changes)
  613. {
  614. OnAfterEditorValueChanged(null, [obj], new AfterEditorValueChangedArgs(changedColumn, changes), changes);
  615. SaveItem(obj);
  616. foreach (var (key, value) in changes)
  617. {
  618. row[key] = value;
  619. }
  620. UIComponent.UpdateRow(row);
  621. }
  622. #region Row Selections
  623. protected CoreRow[] GetVisibleRows()
  624. {
  625. return UIComponent.GetVisibleRows();
  626. }
  627. public CoreRow[] SelectedRows
  628. {
  629. get => UIComponent.SelectedRows;
  630. set => UIComponent.SelectedRows = value;
  631. }
  632. /// <summary>
  633. /// Call the <see cref="OnSelectItem"/> event, and do any updating which needs to occur when items are selected.
  634. /// </summary>
  635. /// <param name="rows"></param>
  636. protected virtual void SelectItems(CoreRow[]? rows)
  637. {
  638. if (IsReady)
  639. OnSelectItem?.Invoke(this, new DynamicGridSelectionEventArgs(rows));
  640. DuplicateBtn.Visibility =
  641. typeof(T).IsAssignableTo(typeof(IDuplicatable)) && rows != null && rows.Length >= 1 ? Visibility.Visible : Visibility.Collapsed;
  642. }
  643. protected virtual void DoDoubleClick(object sender, DynamicGridCellClickEventArgs args)
  644. {
  645. if (IsDirectEditMode())
  646. return;
  647. //SelectItems(SelectedRows);
  648. var e = new HandledEventArgs(false);
  649. OnDoubleClick?.Invoke(sender, e);
  650. if (e.Handled)
  651. return;
  652. if (HasOption(DynamicGridOption.EditRows))
  653. DoEdit();
  654. }
  655. #endregion
  656. #region Column Handling
  657. #region Column Grouping
  658. public DynamicGridColumnGroupings ColumnGroupings { get; set; }
  659. /// <summary>
  660. /// Create a new column header group, and return it for editing.
  661. /// </summary>
  662. /// <returns></returns>
  663. public DynamicGridColumnGrouping AddColumnGrouping()
  664. {
  665. var group = new DynamicGridColumnGrouping();
  666. ColumnGroupings.Add(group);
  667. return group;
  668. }
  669. /// <summary>
  670. /// Gets the current column header group, and if there is none, create a new one.
  671. /// </summary>
  672. /// <returns></returns>
  673. public DynamicGridColumnGrouping GetColumnGrouping()
  674. {
  675. if(ColumnGroupings.Count == 0)
  676. {
  677. return AddColumnGrouping();
  678. }
  679. return ColumnGroupings[^1];
  680. }
  681. #endregion
  682. protected virtual DynamicGridColumns LoadColumns()
  683. {
  684. var result = new DynamicGridColumns();
  685. var cols = IsDirectEditMode()
  686. ? new Columns<T>().Default(ColumnType.IncludeForeignKeys, ColumnType.ExcludeID)
  687. : new Columns<T>().Default(ColumnType.IncludeLinked, ColumnType.ExcludeID);
  688. result.AddRange(MasterColumns.Where(x => cols.Items.Any(c => c.Property.Equals(x.ColumnName)))
  689. .OrderBy(x => CoreUtils.GetPropertySequence(typeof(T), x.ColumnName)));
  690. return result;
  691. }
  692. /// <summary>
  693. /// Provide a set of columns which is the default for this grid.
  694. /// </summary>
  695. public virtual DynamicGridColumns GenerateColumns()
  696. {
  697. var columns = new DynamicGridColumns();
  698. var cols = IsDirectEditMode()
  699. ? new Columns<T>().Default(ColumnType.IncludeForeignKeys, ColumnType.ExcludeID)
  700. : new Columns<T>().Default(ColumnType.IncludeLinked, ColumnType.ExcludeID);
  701. if (cols != null)
  702. {
  703. foreach (var col in cols.Items)
  704. {
  705. var mc = MasterColumns.FirstOrDefault(x => x.ColumnName.Equals(col.Property));
  706. if (mc != null && mc.Editor is not NullEditor && mc.Editor.Visible != Visible.Hidden)
  707. columns.Add(mc);
  708. }
  709. }
  710. return columns;
  711. }
  712. private bool SwapRows(int row1, int row2)
  713. {
  714. CoreRow[] rows = Data.Rows.Where(x => x.Index.Equals(row1) || x.Index.Equals(row2)).ToArray();
  715. var items = LoadItems(rows);
  716. var first = (items.First() as ISequenceable)!;
  717. var last = (items.Last() as ISequenceable)!;
  718. var iBuf1 = first.Sequence;
  719. var iBuf2 = last.Sequence;
  720. first.Sequence = iBuf2;
  721. last.Sequence = iBuf1;
  722. SaveItems(items);
  723. return true;
  724. }
  725. protected virtual void SaveColumns(DynamicGridColumns columns)
  726. {
  727. }
  728. public int DesiredWidth()
  729. {
  730. return UIComponent.DesiredWidth();
  731. }
  732. public virtual void ConfigureColumns(DynamicGridColumns columns)
  733. {
  734. DoCustomiseColumnsEvent(this,columns);
  735. }
  736. /// <summary>
  737. /// Handle to configure column groups.
  738. /// </summary>
  739. /// <remarks>
  740. /// This is called after <see cref="LoadColumns"/>, so by the time this is called, both <see cref="VisibleColumns"/>
  741. /// and <see cref="ActionColumns"/> will be loaded, which means one can reference these in the column groups.
  742. /// <br/>
  743. /// <b>Note:</b> <see cref="ColumnGroupings"/> is cleared before this function is called.
  744. /// </remarks>
  745. protected virtual void ConfigureColumnGroups()
  746. {
  747. }
  748. private void ReloadColumns()
  749. {
  750. ConfigureColumns(MasterColumns /*, false */);
  751. VisibleColumns = LoadColumns();
  752. ConfigureColumns(VisibleColumns /*, true */);
  753. ColumnGroupings.Clear();
  754. ConfigureColumnGroups();
  755. UIComponent.RefreshColumns(VisibleColumns, ActionColumns, ColumnGroupings);
  756. }
  757. #endregion
  758. #region Refresh / Reload
  759. protected abstract void Reload(Filters<T> criteria, Columns<T> columns, ref SortOrder<T>? sort, Action<CoreTable?, Exception?> action);
  760. public Filter<T>? DefineFilter()
  761. {
  762. if (OnDefineFilter is null)
  763. return null;
  764. var result = OnDefineFilter.Invoke(typeof(T)) as Filter<T>;
  765. return result;
  766. }
  767. protected virtual bool FilterRecord(CoreRow row)
  768. {
  769. var bOK = ActionColumns.All(x =>
  770. {
  771. return x.FilterRecord is null || x.SelectedFilters is null || x.SelectedFilters.Length == 0
  772. || x.FilterRecord.Invoke(row, x.SelectedFilters);
  773. });
  774. if (bOK && OnFilterRecord is not null)
  775. bOK = OnFilterRecord(row);
  776. return bOK;
  777. }
  778. public IEnumerable<TType> ExtractValues<TType>(Expression<Func<T, TType>> column, Selection selection)
  779. {
  780. var result = selection == Selection.None
  781. ? Enumerable.Empty<TType>()
  782. : selection == Selection.Selected
  783. ? SelectedRows.Select(r => r.Get(column))
  784. : Data.ExtractValues(column);
  785. return result;
  786. }
  787. public virtual void Refresh(bool reloadcolumns, bool reloaddata)
  788. {
  789. if (bRefreshing)
  790. return;
  791. if (!DoBeforeRefresh())
  792. return;
  793. UIComponent.BeforeRefresh();
  794. var cursor = UseWaitCursor ? new WaitCursor() : null;
  795. Loading.Visibility = Visibility.Visible;
  796. Loading.BeginAnimation(Label.OpacityProperty, LoadingFader);
  797. bRefreshing = true;
  798. if (reloadcolumns)
  799. ReloadColumns();
  800. if (reloaddata)
  801. {
  802. _lookupcache.Clear();
  803. var criteria = new Filters<T>();
  804. var filter = DefineFilter();
  805. if (filter != null)
  806. criteria.Add(filter);
  807. var columns = DataColumns();
  808. var sort = LookupFactory.DefineSort<T>();
  809. if (sort == null && IsSequenced)
  810. sort = new SortOrder<T>("Sequence");
  811. Reload(
  812. criteria
  813. , columns
  814. , ref sort
  815. , (table, exception) =>
  816. {
  817. if (exception != null)
  818. {
  819. Dispatcher.Invoke(() =>
  820. {
  821. MessageWindow.ShowError("Sorry! We couldn't load the data.", exception);
  822. });
  823. }
  824. else if (table is not null)
  825. {
  826. MasterData = table;
  827. Dispatcher.Invoke(() =>
  828. {
  829. ProcessData();
  830. DoAfterRefresh();
  831. bRefreshing = false;
  832. IsReady = true;
  833. });
  834. }
  835. }
  836. );
  837. }
  838. else
  839. {
  840. ProcessData();
  841. DoAfterRefresh();
  842. bRefreshing = false;
  843. IsReady = true;
  844. Loading.BeginAnimation(Label.OpacityProperty, null);
  845. Loading.Visibility = Visibility.Collapsed;
  846. }
  847. if (cursor != null)
  848. {
  849. cursor.Dispose();
  850. cursor = null;
  851. }
  852. }
  853. protected void NotifyBeforeRefresh(BeforeRefreshEventArgs args) => BeforeRefresh?.Invoke(this, args);
  854. protected void NotifyAfterRefresh(AfterRefreshEventArgs args) => AfterRefresh?.Invoke(this, args);
  855. protected bool OnBeforeRefresh()
  856. {
  857. return true;
  858. }
  859. private bool DoBeforeRefresh()
  860. {
  861. var result = OnBeforeRefresh();
  862. if (result)
  863. {
  864. var args = new BeforeRefreshEventArgs() { Cancel = false };
  865. NotifyBeforeRefresh(args);
  866. result = args.Cancel == false;
  867. }
  868. return result;
  869. }
  870. protected virtual void OnAfterRefresh()
  871. {
  872. }
  873. protected void DoAfterRefresh()
  874. {
  875. OnAfterRefresh();
  876. NotifyAfterRefresh(new AfterRefreshEventArgs());
  877. }
  878. public Columns<T> DataColumns()
  879. {
  880. var columns = new Columns<T>();
  881. foreach (var column in VisibleColumns)
  882. columns.Add(column.ColumnName);
  883. foreach (var column in HiddenColumns.ColumnNames)
  884. columns.Add(new Column<T>(column));
  885. return columns;
  886. }
  887. private void ProcessData()
  888. {
  889. Data.Columns.Clear();
  890. Data.Setters.Clear();
  891. if (MasterData != null)
  892. foreach (var column in MasterData.Columns)
  893. Data.Columns.Add(column);
  894. LoadData();
  895. }
  896. protected readonly Dictionary<CoreRow, CoreRow> _recordmap = new();
  897. public void UpdateRow<TRow, TType>(CoreRow row, Expression<Func<TRow, TType>> column, TType value, bool refresh = true)
  898. {
  899. row.Set(column, value);
  900. _recordmap[row].Set(column, value);
  901. if (refresh)
  902. InvalidateRow(row);
  903. }
  904. public void UpdateRow<TType>(CoreRow row, string column, TType value, bool refresh = true)
  905. {
  906. row.Set(column, value);
  907. _recordmap[row].Set(column, value);
  908. if (refresh)
  909. InvalidateRow(row);
  910. }
  911. public void UpdateRow(CoreRow row, T obj)
  912. {
  913. ObjectToRow(obj, row);
  914. ObjectToRow(obj, _recordmap[row]);
  915. }
  916. public void AddRow(CoreRow row)
  917. {
  918. if (MasterData is null) return;
  919. var masterrow = MasterData.NewRow();
  920. MasterData.FillRow(masterrow, row);
  921. Refresh(false, false);
  922. }
  923. public void AddRow(T data)
  924. {
  925. if (MasterData is null) return;
  926. MasterData.LoadRow(data);
  927. Refresh(false, false);
  928. }
  929. public void DeleteRow(CoreRow row)
  930. {
  931. if (MasterData is null) return;
  932. var masterrow = _recordmap[row];
  933. MasterData.Rows.Remove(masterrow);
  934. Refresh(false, false);
  935. }
  936. private void FilterRows(CoreTable from, CoreTable into, Dictionary<CoreRow, CoreRow>? recordMap = null, Func<CoreRow, bool>? filter = null)
  937. {
  938. into.Rows.Clear();
  939. recordMap?.Clear();
  940. foreach (var row in from.Rows.ToArray())
  941. if (FilterRecord(row) && filter?.Invoke(row) != false)
  942. {
  943. var newrow = into.NewRow();
  944. for (var i = 0; i < into.Columns.Count; i++)
  945. {
  946. var value = i < row.Values.Count ? row.Values[i] : null;
  947. if (into.Columns[i].DataType.IsNumeric())
  948. value = into.Columns[i].DataType.IsDefault(value) ? null : value;
  949. //else if (Data.Columns[i].DataType == typeof(String[]))
  950. // value = String.Join("\n", value as String[]);
  951. newrow.Values.Add(value);
  952. }
  953. //newrow.Values.AddRange(row.Values);
  954. //if ((OnFilterRecord == null) || (OnFilterRecord(row)))
  955. into.Rows.Add(newrow);
  956. recordMap?.TryAdd(newrow, row);
  957. }
  958. }
  959. private void LoadData()
  960. {
  961. ResetClipBuffer();
  962. if (MasterData is null)
  963. return;
  964. FilterRows(MasterData, Data, _recordmap);
  965. InvalidateGrid();
  966. //ScrollBar.Value = _CurrentRow <= 0 ? 0 : _CurrentRow;
  967. SelectedRows = Array.Empty<CoreRow>();
  968. }
  969. //IncrementalList<T> _data = null;
  970. public void InvalidateRow(CoreRow row)
  971. {
  972. UIComponent.InvalidateRow(row);
  973. }
  974. protected void InvalidateGrid()
  975. {
  976. if (RowStyleSelector != null)
  977. RowStyleSelector.Data = Data;
  978. UIComponent.RefreshData(Data);
  979. Loading.BeginAnimation(Label.OpacityProperty, null);
  980. Loading.Visibility = Visibility.Collapsed;
  981. }
  982. public void AddVisualFilter(string column, string value, FilterType filtertype = FilterType.Contains)
  983. {
  984. UIComponent.AddVisualFilter(column, value, filtertype);
  985. }
  986. protected List<Tuple<string, Func<CoreRow, bool>>> GetFilterPredicates()
  987. {
  988. return UIComponent.GetFilterPredicates();
  989. }
  990. #endregion
  991. #region Item Manipulation
  992. #region Load/Save/Delete
  993. public virtual T[] LoadItems(CoreRow[] rows)
  994. {
  995. var result = new List<T>();
  996. foreach (var row in rows)
  997. {
  998. var index = Data.Rows.IndexOf(row);
  999. result.Add(LoadItem(row));
  1000. }
  1001. return result.ToArray();
  1002. }
  1003. public abstract T LoadItem(CoreRow row);
  1004. public abstract void SaveItem(T item);
  1005. public virtual void SaveItems(T[] items)
  1006. {
  1007. foreach (var item in items)
  1008. SaveItem(item);
  1009. }
  1010. protected virtual bool CanDeleteItems(params CoreRow[] rows)
  1011. {
  1012. return true;
  1013. }
  1014. public abstract void DeleteItems(params CoreRow[] rows);
  1015. protected virtual void DoDelete()
  1016. {
  1017. var rows = SelectedRows.ToArray();
  1018. if (rows.Any())
  1019. if (CanDeleteItems(rows))
  1020. if (MessageBox.Show("Are you sure you wish to delete the selected records?", "Confirm Delete", MessageBoxButton.YesNo) ==
  1021. MessageBoxResult.Yes)
  1022. {
  1023. DeleteItems(rows);
  1024. SelectedRows = Array.Empty<CoreRow>();
  1025. OnChanged?.Invoke(this, EventArgs.Empty);
  1026. Refresh(false, true);
  1027. SelectItems(null);
  1028. }
  1029. }
  1030. private void Delete_Click(object sender, RoutedEventArgs e)
  1031. {
  1032. DoDelete();
  1033. }
  1034. #endregion
  1035. #region Edit
  1036. protected virtual void DoEdit()
  1037. {
  1038. if (SelectedRows.Length == 0)
  1039. return;
  1040. if (AddEditClick(SelectedRows))
  1041. {
  1042. SelectItems(SelectedRows);
  1043. }
  1044. }
  1045. private void Edit_Click(object sender, RoutedEventArgs e)
  1046. {
  1047. DoEdit();
  1048. }
  1049. protected virtual void DoAdd(bool OpenEditorOnDirectEdit = false)
  1050. {
  1051. //CoreRow row = (SelectedRow > -1) && (SelectedRow < Data.Rows.Count) ? Data.Rows[this.SelectedRow] : null;
  1052. if (IsDirectEditMode() && !OpenEditorOnDirectEdit)
  1053. {
  1054. CreateItems(null);
  1055. }
  1056. else if (AddEditClick(null))
  1057. {
  1058. Refresh(false, true);
  1059. }
  1060. }
  1061. protected void CreateItems(Func<IEnumerable<T>>? create)
  1062. {
  1063. var newRows = new List<CoreRow>();
  1064. var items = create?.Invoke() ?? CoreUtils.One(CreateItem());
  1065. foreach (var item in items)
  1066. {
  1067. if (!AfterCreate(item))
  1068. return;
  1069. SaveItem(item);
  1070. var datarow = Data.NewRow();
  1071. ObjectToRow(item, datarow);
  1072. Data.Rows.Add(datarow);
  1073. newRows.Add(datarow);
  1074. var masterrow = MasterData.NewRow();
  1075. ObjectToRow(item, masterrow);
  1076. MasterData.Rows.Add(masterrow);
  1077. _recordmap[datarow] = masterrow;
  1078. }
  1079. InvalidateGrid();
  1080. SelectedRows = newRows.ToArray();
  1081. OnChanged?.Invoke(this, EventArgs.Empty);
  1082. }
  1083. private void Add_Click(object sender, RoutedEventArgs e)
  1084. {
  1085. if (CanCreateItems())
  1086. DoAdd();
  1087. }
  1088. public virtual DynamicEditorPages LoadEditorPages(T item)
  1089. {
  1090. DynamicEditorPages pages = new DynamicEditorPages();
  1091. DynamicGridUtils.LoadOneToManyPages(typeof(T), pages);
  1092. DynamicGridUtils.LoadEnclosedListPages(typeof(T), pages);
  1093. DynamicGridUtils.LoadManyToManyPages(typeof(T), pages);
  1094. DynamicGridUtils.LoadCustomEditorPages(typeof(T), pages);
  1095. foreach (var page in pages)
  1096. page.Ready = false;
  1097. return pages;
  1098. }
  1099. public virtual void LoadEditorButtons(T item, DynamicEditorButtons buttons)
  1100. {
  1101. buttons.Clear();
  1102. buttons.Add(
  1103. "",
  1104. Wpf.Resources.help.AsBitmapImage(),
  1105. item,
  1106. (f, i) =>
  1107. {
  1108. Process.Start(new ProcessStartInfo("https://prsdigital.com.au/wiki/index.php/" + typeof(T).Name.SplitCamelCase().Replace(" ", "_"))
  1109. { UseShellExecute = true });
  1110. }
  1111. );
  1112. OnLoadEditorButtons?.Invoke(item, buttons);
  1113. }
  1114. protected virtual void BeforeLoad(IDynamicEditorForm form, T[] items)
  1115. {
  1116. form.BeforeLoad();
  1117. }
  1118. void IDynamicGrid.InitialiseEditorForm(IDynamicEditorForm editor, object[] items, Func<Type, CoreTable>? pageDataHandler, bool preloadPages)
  1119. {
  1120. InitialiseEditorForm(editor, items.Cast<T>().ToArray(), pageDataHandler, preloadPages);
  1121. }
  1122. public virtual bool EditItems(object[] items, Func<Type, CoreTable?>? PageDataHandler = null, bool PreloadPages = false)
  1123. {
  1124. var values = items.Cast<T>().ToArray();
  1125. return EditItems(values, PageDataHandler, PreloadPages);
  1126. }
  1127. public virtual void InitialiseEditorForm(IDynamicEditorForm editor, T[] items, Func<Type, CoreTable?>? pageDataHandler = null, bool preloadPages = false)
  1128. {
  1129. var pages = items.Length == 1 ? LoadEditorPages(items.First()) : new DynamicEditorPages();
  1130. var buttons = new DynamicEditorButtons();
  1131. if (items.Length == 1)
  1132. LoadEditorButtons(items.First(), buttons);
  1133. editor.Setup(items.Any() ? items.First().GetType() : typeof(T), pages, buttons, pageDataHandler, preloadPages);
  1134. editor.OnCustomiseColumns = (sender, columns) =>
  1135. {
  1136. columns.Clear();
  1137. columns.AddRange(MasterColumns);
  1138. ConfigureColumns(columns);
  1139. };
  1140. editor.OnDefineEditor = (o, c) =>
  1141. {
  1142. var result = GetEditor(o, c);
  1143. if (result != null)
  1144. result = result.CloneEditor();
  1145. return result;
  1146. };
  1147. editor.OnFormCustomiseEditor += DoCustomiseEditor;
  1148. editor.OnDefineFilter = (type, column) => { return DefineLookupFilter(type, column, items); };
  1149. //editor.OnDefineFilter += (o, e) => { return DefineFilter(items, e); };
  1150. editor.OnDefineLookups = editor => DefineLookups(editor, items);
  1151. editor.OnEditorValueChanged += (s, n, v) => EditorValueChanged(editor, items, n, v);
  1152. editor.OnAfterEditorValueChanged += (g, args) => AfterEditorValueChanged(g, items, args);
  1153. editor.OnReconfigureEditors = g => DoReconfigureEditors(g, items);
  1154. editor.OnValidateData += (o, i) => ValidateData(items);
  1155. editor.OnSelectPage += SelectPage;
  1156. editor.OnSaveItem = (o, e) =>
  1157. {
  1158. try
  1159. {
  1160. using var Wait = new WaitCursor();
  1161. DoBeforeSave(editor, items);
  1162. if (items.Length == 1)
  1163. editor.UnloadEditorPages(false);
  1164. foreach (var item in items)
  1165. SaveItem(item);
  1166. if (items.Length == 1)
  1167. editor.UnloadEditorPages(true);
  1168. DoAfterSave(editor, items);
  1169. }
  1170. catch (Exception err)
  1171. {
  1172. MessageBox.Show(err.Message);
  1173. e.Cancel = true;
  1174. }
  1175. };
  1176. BeforeLoad(editor, items);
  1177. editor.Items = items;
  1178. AfterLoad(editor, items);
  1179. }
  1180. private void DoCustomiseEditor(IDynamicEditorForm sender, object[] items, DynamicGridColumn column, BaseEditor editor)
  1181. {
  1182. CustomiseEditor((T[])items, column, editor);
  1183. OnCustomiseEditor?.Invoke(sender, (T[])items, column, editor);
  1184. }
  1185. protected virtual void CustomiseEditor(T[] items, DynamicGridColumn column, BaseEditor editor)
  1186. {
  1187. }
  1188. protected virtual void DoAfterSave(IDynamicEditorForm editor, T[] items)
  1189. {
  1190. OnAfterSave?.Invoke(editor, items);
  1191. }
  1192. protected virtual void DoBeforeSave(IDynamicEditorForm editor, T[] items)
  1193. {
  1194. OnBeforeSave?.Invoke(editor, items);
  1195. }
  1196. public virtual bool EditItems(T[] items, Func<Type, CoreTable?>? PageDataHandler = null, bool PreloadPages = false)
  1197. {
  1198. DynamicEditorForm editor;
  1199. using (var cursor = new WaitCursor())
  1200. {
  1201. editor = new DynamicEditorForm();
  1202. editor.SetValue(Panel.ZIndexProperty, 999);
  1203. InitialiseEditorForm(editor, items, PageDataHandler, PreloadPages);
  1204. OnEditorLoaded?.Invoke(editor, items);
  1205. }
  1206. return editor.ShowDialog() == true;
  1207. }
  1208. private Dictionary<String, object?> AfterEditorValueChanged(DynamicEditorGrid grid, T[] items, AfterEditorValueChangedArgs args)
  1209. {
  1210. var changes = new Dictionary<string, object?>();
  1211. OnAfterEditorValueChanged(grid, items, args, changes);
  1212. return changes;
  1213. }
  1214. protected virtual void OnAfterEditorValueChanged(DynamicEditorGrid? grid, T[] items, AfterEditorValueChangedArgs args, Dictionary<String, object?> changes)
  1215. {
  1216. }
  1217. protected virtual void DoReconfigureEditors(DynamicEditorGrid grid, T[] items)
  1218. {
  1219. /*if (items.First() is IDimensioned dimensioned)
  1220. {
  1221. UpdateEditor(grid, x => x.Dimensions.Quantity, dimensioned.Dimensions.GetUnit().HasQuantity);
  1222. UpdateEditor(grid, x => x.Dimensions.Length, dimensioned.Dimensions.GetUnit().HasLength);
  1223. UpdateEditor(grid, x => x.Dimensions.Width, dimensioned.Dimensions.GetUnit().HasWidth);
  1224. UpdateEditor(grid, x => x.Dimensions.Height, dimensioned.Dimensions.GetUnit().HasHeight);
  1225. UpdateEditor(grid, x => x.Dimensions.Weight, dimensioned.Dimensions.GetUnit().HasWeight);
  1226. }*/
  1227. }
  1228. private string[]? ValidateData(T[] items)
  1229. {
  1230. var errors = new List<string>();
  1231. DoValidate(items, errors);
  1232. OnValidate?.Invoke(this, items, errors);
  1233. return errors.Any() ? errors.ToArray() : null;
  1234. }
  1235. protected virtual void DoValidate(T[] items, List<string> errors)
  1236. {
  1237. }
  1238. protected virtual void AfterLoad(IDynamicEditorForm editor, T[] items)
  1239. {
  1240. editor.AfterLoad();
  1241. }
  1242. protected virtual void SelectPage(object sender, BaseObject[]? items)
  1243. {
  1244. }
  1245. protected virtual Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, T[] items, string name, object value)
  1246. {
  1247. var result = DynamicGridUtils.UpdateEditorValue(items, name, value);
  1248. if (OnEditorValueChanged != null)
  1249. {
  1250. var newchanges = OnEditorValueChanged(editor, name, value);
  1251. foreach (var key in newchanges.Keys)
  1252. result[key] = newchanges[key];
  1253. }
  1254. return result;
  1255. }
  1256. private readonly Dictionary<Tuple<Type, Type>, Dictionary<object, object>> _lookupcache = new();
  1257. protected virtual void DefineLookups(ILookupEditorControl sender, T[] items, bool async = true)
  1258. {
  1259. if (sender.EditorDefinition is not ILookupEditor editor)
  1260. return;
  1261. var colname = sender.ColumnName;
  1262. if (async)
  1263. {
  1264. Task.Run(() =>
  1265. {
  1266. try
  1267. {
  1268. var values = editor.Values(typeof(T), colname, items);
  1269. Dispatcher.Invoke(
  1270. () =>
  1271. {
  1272. try
  1273. {
  1274. //Logger.Send(LogType.Information, typeof(T).Name, "Dispatching Results" + colname);
  1275. sender.LoadLookups(values);
  1276. }
  1277. catch (Exception e2)
  1278. {
  1279. Logger.Send(LogType.Information, typeof(T).Name,
  1280. "Exception (2) in LoadLookups: " + e2.Message + "\n" + e2.StackTrace);
  1281. }
  1282. }
  1283. );
  1284. }
  1285. catch (Exception e)
  1286. {
  1287. Logger.Send(LogType.Information, typeof(T).Name,
  1288. "Exception (1) in LoadLookups: " + e.Message + "\n" + e.StackTrace);
  1289. }
  1290. });
  1291. }
  1292. else
  1293. {
  1294. var values = editor.Values(typeof(T), colname, items);
  1295. sender.LoadLookups(values);
  1296. }
  1297. }
  1298. /// <summary>
  1299. /// Retrieves an editor to display for the given column of <paramref name="item"/>.
  1300. /// </summary>
  1301. /// <param name="item">The object being edited.</param>
  1302. /// <param name="column">The column of the editor.</param>
  1303. /// <returns>A new editor, or <see langword="null"/> if no editor defined and no sensible default exists.</returns>
  1304. protected virtual BaseEditor? GetEditor(object item, DynamicGridColumn column)
  1305. {
  1306. return column.Editor ?? CoreUtils.GetProperty(item.GetType(), column.ColumnName).GetEditor();
  1307. }
  1308. protected IFilter? DefineLookupFilter(Type type, string column, T[] items)
  1309. {
  1310. return LookupFactory.DefineLookupFilter(typeof(T), type, column, items);
  1311. }
  1312. protected virtual void SetEditorValue(object item, string name, object value)
  1313. {
  1314. try
  1315. {
  1316. CoreUtils.SetPropertyValue(item, name, value);
  1317. }
  1318. catch (Exception e)
  1319. {
  1320. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  1321. }
  1322. }
  1323. protected virtual object? GetEditorValue(object item, string name)
  1324. {
  1325. return CoreUtils.GetPropertyValue(item, name);
  1326. }
  1327. protected virtual bool CanCreateItems()
  1328. {
  1329. return true;
  1330. }
  1331. private bool AddEditClick(CoreRow[]? rows)
  1332. {
  1333. if (!IsEnabled || bRefreshing)
  1334. return false;
  1335. if (rows == null || !rows.Any())
  1336. {
  1337. if (!CanCreateItems())
  1338. return false;
  1339. var item = CreateItem();
  1340. if (!AfterCreate(item))
  1341. return false;
  1342. // Yea, and this won't work, because we're actually usually showing the description of a linked item,
  1343. // not the id of the link, and we need to set the ID to have it work properly :-(
  1344. //foreach (String key in VisualFilters.Keys)
  1345. // CoreUtils.SetPropertyValue(item, key, VisualFilters[key]);
  1346. if (EditItems([item]))
  1347. {
  1348. //_CurrentRow = Data.Rows.Count;
  1349. var row = Data.NewRow();
  1350. ObjectToRow(item, row);
  1351. Data.Rows.Add(row);
  1352. InvalidateGrid();
  1353. SelectedRows = [row];
  1354. DoChanged();
  1355. return true;
  1356. }
  1357. return false;
  1358. }
  1359. var items = Array.Empty<T>();
  1360. using (new WaitCursor())
  1361. {
  1362. Stopwatch sw = new Stopwatch();
  1363. sw.Start();
  1364. items = LoadItems(rows);
  1365. //Logger.Send(LogType.Information, "DG:LoadItems", String.Format("Loaded Items: {0}ms", sw.ElapsedMilliseconds));
  1366. sw.Stop();
  1367. }
  1368. if (items.Length != 0)
  1369. {
  1370. var sel = SelectedRows;
  1371. if (EditItems(items))
  1372. {
  1373. for (var i = 0; i < items.Length; i++)
  1374. {
  1375. UpdateRow(rows[i], items[i]);
  1376. }
  1377. InvalidateGrid();
  1378. SelectedRows = sel;
  1379. DoChanged();
  1380. return true;
  1381. }
  1382. return false;
  1383. }
  1384. return false;
  1385. }
  1386. #endregion
  1387. #region Duplicate
  1388. protected virtual IEnumerable<T> LoadDuplicatorItems(CoreRow[] rows)
  1389. {
  1390. return LoadItems(rows);
  1391. }
  1392. private bool DoDuplicate(Button button, CoreRow[] rows)
  1393. {
  1394. if (!rows.Any())
  1395. {
  1396. MessageBox.Show("Please select at least one record to duplicate!");
  1397. return false;
  1398. }
  1399. /*var ids = ExtractValues(x => x.ID, Selection.Selected).ToArray();
  1400. if (!ids.Any())
  1401. {
  1402. MessageBox.Show("Please select at least one record to duplicate!");
  1403. return false;
  1404. }*/
  1405. var duplicator = (new T() as IDuplicatable)?.GetDuplicator();
  1406. if (duplicator is null)
  1407. {
  1408. MessageBox.Show($"Cannot duplicate {typeof(T)}");
  1409. return false;
  1410. }
  1411. duplicator.Duplicate(LoadDuplicatorItems(rows));// new Filter<T>(x => x.ID).InList(ids));
  1412. return true;
  1413. }
  1414. #endregion
  1415. public virtual T CreateItem()
  1416. {
  1417. var result = new T();
  1418. OnCreateItem?.Invoke(this, result);
  1419. return result;
  1420. }
  1421. public virtual bool AfterCreate(T item)
  1422. {
  1423. return OnAfterCreateItem?.Invoke(this, item) ?? true;
  1424. }
  1425. protected virtual void DoPrint(object sender)
  1426. {
  1427. OnPrintData?.Invoke(sender);
  1428. }
  1429. protected virtual void ShowHelp(string slug)
  1430. {
  1431. Process.Start(new ProcessStartInfo("https://prsdigital.com.au/wiki/index.php/" + slug) { UseShellExecute = true });
  1432. }
  1433. protected void ReloadForms<TTargetType, TTargetForm, TSourceForm>(IDynamicEditorForm editor, TTargetType item,
  1434. Expression<Func<TSourceForm, object?>> sourcekey, Guid sourceid)
  1435. where TTargetType : Entity, new()
  1436. where TTargetForm : Entity, IRemotable, IPersistent, IDigitalFormInstance, new()
  1437. where TSourceForm : Entity, IRemotable, IPersistent, IDigitalForm<TTargetType>, new()
  1438. {
  1439. var type = typeof(IDynamicOneToManyGrid<,>).MakeGenericType(typeof(TTargetType), typeof(TTargetForm));
  1440. var page =
  1441. editor.Pages?.FirstOrDefault(x => x.GetType().GetInterfaces().Contains(type)) as IDynamicOneToManyGrid<TTargetType, TTargetForm>;
  1442. if (page != null && item != null)
  1443. {
  1444. if (!page.Ready)
  1445. page.Load(item, null);
  1446. CoreTable table;
  1447. if (sourceid == Guid.Empty)
  1448. {
  1449. table = new CoreTable();
  1450. table.LoadColumns(typeof(TSourceForm));
  1451. }
  1452. else
  1453. {
  1454. table = new Client<TSourceForm>().Query(
  1455. new Filter<TSourceForm>(sourcekey).IsEqualTo(sourceid).And(x => x.Form.AppliesTo)
  1456. .IsEqualTo(typeof(TTargetType).EntityName().Split('.').Last())
  1457. );
  1458. }
  1459. var newforms = new List<TTargetForm>();
  1460. foreach (var row in table.Rows)
  1461. {
  1462. var sourceform = row.ToObject<TSourceForm>();
  1463. var targetform = new TTargetForm();
  1464. targetform.Form.ID = sourceform.Form.ID;
  1465. targetform.Form.Synchronise(sourceform.Form);
  1466. newforms.Add(targetform);
  1467. }
  1468. page.Items.Clear();
  1469. page.LoadItems(newforms.ToArray());
  1470. }
  1471. }
  1472. #region ClipBuffer
  1473. private Tuple<ClipAction, CoreRow[]>? ClipBuffer;
  1474. protected void ResetClipBuffer()
  1475. {
  1476. ClipBuffer = null;
  1477. }
  1478. protected void SetClipBuffer(ClipAction action, CoreRow[] rows)
  1479. {
  1480. ClipBuffer = new Tuple<ClipAction, CoreRow[]>(action, rows);
  1481. }
  1482. private void CutToClipBuffer()
  1483. {
  1484. SetClipBuffer(ClipAction.Cut, SelectedRows);
  1485. InvalidateGrid();
  1486. }
  1487. private void CopyToClipBuffer()
  1488. {
  1489. SetClipBuffer(ClipAction.Copy, SelectedRows);
  1490. InvalidateGrid();
  1491. }
  1492. private void PasteFromClipBuffer()
  1493. {
  1494. if (ClipBuffer == null)
  1495. return;
  1496. if (!IsSequenced)
  1497. return;
  1498. using (new WaitCursor())
  1499. {
  1500. var updates = ClipBuffer.Item2.Select(x => x.ToObject<T>()).ToList();
  1501. if (BeforePaste(updates, ClipBuffer.Item1))
  1502. {
  1503. var currow = SelectedRows.FirstOrDefault()
  1504. ?? Data.Rows.LastOrDefault();
  1505. var sequence = currow != null ? currow.Get<T, long>(c => ((ISequenceable)c).Sequence) : 0;
  1506. var postrows = Data.Rows.Where(r => !ClipBuffer.Item2.Contains(r) && r.Get<ISequenceable, long>(x => x.Sequence) >= sequence);
  1507. updates.AddRange(LoadItems(postrows.ToArray()));
  1508. foreach (var update in updates)
  1509. {
  1510. sequence++;
  1511. ((ISequenceable)update).Sequence = sequence;
  1512. }
  1513. }
  1514. if (updates.Any())
  1515. {
  1516. SaveItems(updates.ToArray());
  1517. Refresh(false, true);
  1518. }
  1519. }
  1520. }
  1521. protected virtual bool BeforePaste(IEnumerable<T> items, ClipAction action)
  1522. {
  1523. return true;
  1524. }
  1525. private void Cut_Click(object sender, RoutedEventArgs e)
  1526. {
  1527. CutToClipBuffer();
  1528. }
  1529. private void Copy_Click(object sender, RoutedEventArgs e)
  1530. {
  1531. CopyToClipBuffer();
  1532. }
  1533. private void Paste_Click(object sender, RoutedEventArgs e)
  1534. {
  1535. PasteFromClipBuffer();
  1536. }
  1537. #endregion
  1538. protected virtual void ObjectToRow(T obj, CoreRow row)
  1539. {
  1540. row.Table.FillRow(row, obj);
  1541. }
  1542. #region Import / Export
  1543. protected virtual CoreTable LoadImportKeys(String[] fields)
  1544. {
  1545. var result = new CoreTable();
  1546. result.LoadColumns(new Columns<T>(fields));
  1547. return result;
  1548. }
  1549. protected virtual Guid GetImportID()
  1550. {
  1551. return Guid.Empty;
  1552. }
  1553. protected virtual bool CustomiseImportItem(T item)
  1554. {
  1555. if (IsSequenced)
  1556. ((ISequenceable)item).Sequence = CoreUtils.GenerateSequence();
  1557. return true;
  1558. }
  1559. protected virtual string CustomiseImportFileName(string filename)
  1560. {
  1561. return filename;
  1562. }
  1563. protected virtual void DoImport()
  1564. {
  1565. var list = new DynamicImportList(
  1566. typeof(T),
  1567. GetImportID()
  1568. );
  1569. list.OnImportItem += o => { return CustomiseImportItem((T)o); };
  1570. list.OnCustomiseImport += (o, args) => { args.FileName = CustomiseImportFileName(args.FileName); };
  1571. list.OnSave += (sender, entity) => SaveItem(entity as T);
  1572. list.OnLoad += (sender, type, fields, id) => LoadImportKeys(fields);
  1573. list.ShowDialog();
  1574. Refresh(false, true);
  1575. }
  1576. private void Import_Click(object sender, RoutedEventArgs e)
  1577. {
  1578. DoImport();
  1579. }
  1580. protected virtual void CustomiseExportColumns(List<string> columnnames)
  1581. {
  1582. }
  1583. protected virtual string CustomiseExportFileName(string filename)
  1584. {
  1585. return filename;
  1586. }
  1587. protected virtual void CustomiseExportFilters(Filters<T> filters, CoreRow[] visiblerows)
  1588. {
  1589. }
  1590. protected virtual void ApplyExportFilter(CoreTable table, object data)
  1591. {
  1592. }
  1593. protected virtual void DoExport()
  1594. {
  1595. var columnnames = VisibleColumns.Select(x => x.ColumnName).ToList();
  1596. CustomiseExportColumns(columnnames);
  1597. var form = new DynamicExportForm(typeof(T), columnnames);
  1598. if (form.ShowDialog() != true)
  1599. return;
  1600. var filters = new Filters<T>();
  1601. filters.Add(DefineFilter());
  1602. var predicates = UIComponent.GetFilterPredicates();
  1603. var visiblerows = GetVisibleRows();
  1604. CustomiseExportFilters(filters, visiblerows);
  1605. var columns = new Columns<T>(form.Fields);
  1606. var otherColumns = form.GetChildFields()
  1607. .Select(x => new Tuple<Type, IColumns>(
  1608. x.Key,
  1609. (Activator.CreateInstance(typeof(Columns<>).MakeGenericType(x.Key), new object[] { x.Value }) as IColumns)!))
  1610. .Where(x => x.Item2.ColumnNames().Any()).ToList();
  1611. var reloadColumns = new Columns<T>();
  1612. foreach (var column in columns.ColumnNames())
  1613. {
  1614. reloadColumns.Add(column);
  1615. }
  1616. foreach (var column in HiddenColumns.ColumnNames)
  1617. {
  1618. reloadColumns.Add(column);
  1619. }
  1620. foreach (var (column, _) in predicates)
  1621. {
  1622. reloadColumns.Add(column);
  1623. }
  1624. var sort = LookupFactory.DefineSort<T>();
  1625. Reload(filters, reloadColumns, ref sort, (data, err) => Dispatcher.Invoke(() =>
  1626. {
  1627. if (data is not null)
  1628. {
  1629. var newData = new CoreTable();
  1630. foreach (var column in columns.Items)
  1631. newData.Columns.Add(new CoreColumn { ColumnName = column.Property, DataType = column.Type });
  1632. FilterRows(data, newData, filter: row =>
  1633. {
  1634. foreach(var (_, predicate) in predicates)
  1635. {
  1636. if (!predicate(row))
  1637. {
  1638. return false;
  1639. }
  1640. }
  1641. return true;
  1642. });
  1643. var list = new List<Tuple<Type?, CoreTable>>() { new(typeof(T), newData) };
  1644. list.AddRange(LoadExportTables(filters, otherColumns));
  1645. DoExportTables(list);
  1646. }
  1647. else if (err is not null)
  1648. {
  1649. Logger.Send(LogType.Error, "", $"Error in export: {CoreUtils.FormatException(err)}");
  1650. MessageBox.Show(err.Message);
  1651. }
  1652. }));
  1653. }
  1654. private void Export_Click(object sender, RoutedEventArgs e)
  1655. {
  1656. DoExport();
  1657. }
  1658. /// <summary>
  1659. /// Loads the child tables for an export, based on the filter of the parent table.
  1660. /// </summary>
  1661. /// <remarks>
  1662. /// If not overriden, defaults to creating empty tables with no records.
  1663. /// </remarks>
  1664. /// <param name="filter">Filter for the parent table.</param>
  1665. /// <param name="tableColumns">A list of the child table types, with columns to load for each</param>
  1666. /// <returns>A list of tables, in the same order as they came in <paramref name="tableColumns"/></returns>
  1667. protected virtual IEnumerable<Tuple<Type?, CoreTable>> LoadExportTables(Filters<T> filter, IEnumerable<Tuple<Type, IColumns>> tableColumns)
  1668. {
  1669. return tableColumns.Select(x =>
  1670. {
  1671. var table = new CoreTable();
  1672. table.LoadColumns(x.Item2);
  1673. return new Tuple<Type?, CoreTable>(x.Item1, table);
  1674. });
  1675. }
  1676. private void DoExportTables(List<Tuple<Type?, CoreTable>> data)
  1677. {
  1678. var filename = CustomiseExportFileName(typeof(T).EntityName().Split('.').Last());
  1679. ExcelExporter.DoExport(data, filename);
  1680. }
  1681. #endregion
  1682. public void ScrollIntoView(CoreRow row)
  1683. {
  1684. UIComponent.ScrollIntoView(row);
  1685. }
  1686. #endregion
  1687. #region Custom Buttons
  1688. private Button CreateButton(BitmapImage? image = null, string? text = null, string? tooltip = null)
  1689. {
  1690. var button = new Button();
  1691. button.SetValue(BorderBrushProperty, new SolidColorBrush(Colors.Gray));
  1692. button.SetValue(BorderThicknessProperty, new Thickness(0.75));
  1693. button.Height = 30;
  1694. UpdateButton(button, image, text, tooltip);
  1695. return button;
  1696. }
  1697. public void UpdateButton(Button button, BitmapImage? image, string? text, string? tooltip = null)
  1698. {
  1699. var stackPnl = new StackPanel();
  1700. stackPnl.Orientation = Orientation.Horizontal;
  1701. //stackPnl.Margin = new Thickness(2);
  1702. if (image != null)
  1703. {
  1704. var img = new Image();
  1705. img.Source = image;
  1706. img.Margin = new Thickness(2);
  1707. img.ToolTip = tooltip;
  1708. stackPnl.Children.Add(img);
  1709. }
  1710. if (!string.IsNullOrEmpty(text))
  1711. {
  1712. button.MaxWidth = double.MaxValue;
  1713. var lbl = new Label();
  1714. lbl.Content = text;
  1715. lbl.VerticalAlignment = VerticalAlignment.Stretch;
  1716. lbl.VerticalContentAlignment = VerticalAlignment.Center;
  1717. lbl.Margin = new Thickness(2, 0, 5, 0);
  1718. lbl.ToolTip = ToolTip;
  1719. stackPnl.Children.Add(lbl);
  1720. }
  1721. else
  1722. button.MaxWidth = 30;
  1723. button.Content = stackPnl;
  1724. button.ToolTip = tooltip;
  1725. }
  1726. private bool bFirstButtonAdded = true;
  1727. private bool AnyButtonsVisible()
  1728. {
  1729. if (Add.Visibility != Visibility.Collapsed)
  1730. return true;
  1731. if (Edit.Visibility != Visibility.Collapsed)
  1732. return true;
  1733. /*if (MultiEdit.Visibility != Visibility.Collapsed)
  1734. return true;*/
  1735. if (Export.Visibility != Visibility.Collapsed)
  1736. return true;
  1737. return false;
  1738. }
  1739. public Button AddButton(string? caption, BitmapImage? image, string? tooltip, DynamicGridButtonClickEvent action, DynamicGridButtonPosition position = DynamicGridButtonPosition.Left)
  1740. {
  1741. var button = CreateButton(image, caption, tooltip);
  1742. button.Margin = position == DynamicGridButtonPosition.Right
  1743. ? new Thickness(2, 2, 0, 0)
  1744. : bFirstButtonAdded && AnyButtonsVisible()
  1745. ? new Thickness(0, 2, 0, 0)
  1746. : new Thickness(0, 2, 2, 0);
  1747. button.Padding = !String.IsNullOrWhiteSpace(caption) ? new Thickness(5, 1, 5, 1) : new Thickness(1);
  1748. button.Tag = action;
  1749. button.Click += Button_Click;
  1750. if (position == DynamicGridButtonPosition.Right)
  1751. RightButtonStack.Children.Add(button);
  1752. else
  1753. LeftButtonStack.Children.Add(button);
  1754. bFirstButtonAdded = false;
  1755. return button;
  1756. }
  1757. public Button AddButton(string? caption, BitmapImage? image, DynamicGridButtonClickEvent action, DynamicGridButtonPosition position = DynamicGridButtonPosition.Left)
  1758. {
  1759. var result = AddButton(caption, image, null, action, position);
  1760. return result;
  1761. }
  1762. private void Button_Click(object sender, RoutedEventArgs e)
  1763. {
  1764. var button = (Button)sender;
  1765. var action = (DynamicGridButtonClickEvent)button.Tag;
  1766. //CoreRow row = (CurrentRow > -1) && (CurrentRow < Data.Rows.Count) ? Data.Rows[this.CurrentRow] : null;
  1767. if (action.Invoke(button, SelectedRows))
  1768. Refresh(false, true);
  1769. }
  1770. #endregion
  1771. #region Header Actions
  1772. private void SelectColumnsClick()
  1773. {
  1774. var editor = new DynamicGridColumnsEditor(typeof(T));
  1775. editor.DirectEdit = IsDirectEditMode();
  1776. editor.Columns.AddRange(VisibleColumns);
  1777. if (editor.ShowDialog().Equals(true))
  1778. {
  1779. VisibleColumns.Clear();
  1780. VisibleColumns.AddRange(editor.Columns);
  1781. SaveColumns(VisibleColumns);
  1782. //OnSaveColumns?.Invoke(this, editor.Columns);
  1783. Refresh(true, true);
  1784. }
  1785. }
  1786. #endregion
  1787. #region Drag + Drop
  1788. /// <summary>
  1789. /// Handle a number of rows from a different <see cref="DynamicGrid{T}"/> being dragged into this one.
  1790. /// </summary>
  1791. /// <param name="entity">The type of entity that that the rows of <paramref name="table"/> represent.</param>
  1792. /// <param name="table">The data being dragged.</param>
  1793. /// <param name="e"></param>
  1794. protected virtual void OnDragEnd(Type entity, CoreTable table, DragEventArgs e)
  1795. {
  1796. Logger.Send(LogType.Information,"","OnDragEnd");
  1797. }
  1798. /// <summary>
  1799. /// Handle all types of items being dragged onto this grid that aren't handled by <see cref="OnDragEnd(Type, CoreTable, DragEventArgs)"/>,
  1800. /// i.e., data which is not a <see cref="CoreTable"/> from another <see cref="DynamicGrid{T}"/>
  1801. /// </summary>
  1802. /// <remarks>
  1803. /// Can be used to handle files, for example.
  1804. /// </remarks>
  1805. /// <param name="sender"></param>
  1806. /// <param name="e"></param>
  1807. protected virtual void HandleDragDrop(object sender, DragEventArgs e)
  1808. {
  1809. }
  1810. protected virtual void HandleDragOver(object sender, DragEventArgs e)
  1811. {
  1812. }
  1813. protected DragDropEffects DragTable(Type entity, CoreTable table)
  1814. {
  1815. Logger.Send(LogType.Information, "", "DragTable");
  1816. var data = new DataObject();
  1817. data.SetData(DynamicGridUtils.DragFormat, new DynamicGridDragFormat(table.ToDataTable(), entity));
  1818. var effect = DragDrop.DoDragDrop(this, data, DragDropEffects.All);
  1819. return effect;
  1820. }
  1821. protected virtual DragDropEffects OnRowsDragStart(CoreRow[] rows)
  1822. {
  1823. Logger.Send(LogType.Information, "", "OnRowsDragStart");
  1824. var table = new CoreTable();
  1825. table.LoadColumns(Data.Columns);
  1826. table.LoadRows(rows);
  1827. return DragTable(typeof(T), table);
  1828. }
  1829. #endregion
  1830. }
  1831. #region Styling
  1832. public class DynamicGridRowStyle : DynamicGridStyle<VirtualizingCellsControl>
  1833. {
  1834. public DynamicGridRowStyle() : base(null)
  1835. {
  1836. }
  1837. public DynamicGridRowStyle(IDynamicGridStyle source) : base(source)
  1838. {
  1839. }
  1840. public override DependencyProperty FontSizeProperty => Control.FontSizeProperty;
  1841. public override DependencyProperty FontStyleProperty => Control.FontStyleProperty;
  1842. public override DependencyProperty FontWeightProperty => Control.FontWeightProperty;
  1843. public override DependencyProperty BackgroundProperty => Control.BackgroundProperty;
  1844. public override DependencyProperty ForegroundProperty => Control.ForegroundProperty;
  1845. }
  1846. public class DynamicGridCellStyle : DynamicGridStyle<Control>
  1847. {
  1848. public DynamicGridCellStyle() : base(null)
  1849. {
  1850. }
  1851. public DynamicGridCellStyle(IDynamicGridStyle source) : base(source)
  1852. {
  1853. }
  1854. public override DependencyProperty FontSizeProperty => Control.FontSizeProperty;
  1855. public override DependencyProperty FontStyleProperty => Control.FontStyleProperty;
  1856. public override DependencyProperty FontWeightProperty => Control.FontWeightProperty;
  1857. public override DependencyProperty BackgroundProperty => Control.BackgroundProperty;
  1858. public override DependencyProperty ForegroundProperty => Control.ForegroundProperty;
  1859. }
  1860. public class GridSelectionControllerExt : GridSelectionController
  1861. {
  1862. public GridSelectionControllerExt(SfDataGrid datagrid)
  1863. : base(datagrid)
  1864. {
  1865. }
  1866. protected override void ProcessSelectedItemChanged(SelectionPropertyChangedHandlerArgs handle)
  1867. {
  1868. base.ProcessSelectedItemChanged(handle);
  1869. if (handle.NewValue != null)
  1870. {
  1871. //this.DataGrid.ScrollInView(this.CurrentCellManager.CurrentRowColumnIndex);
  1872. //int rowIndex = this.CurrentCellManager.CurrentRowColumnIndex.RowIndex;
  1873. var columnIndex = CurrentCellManager.CurrentRowColumnIndex.ColumnIndex;
  1874. var scrollRowIndex = DataGrid.GetVisualContainer().ScrollRows.LastBodyVisibleLineIndex;
  1875. DataGrid.ScrollInView(new RowColumnIndex(scrollRowIndex, columnIndex));
  1876. }
  1877. }
  1878. }
  1879. public class DynamicGridSummaryStyleSelector : StyleSelector
  1880. {
  1881. private readonly IDynamicGrid _grid;
  1882. public DynamicGridSummaryStyleSelector(IDynamicGrid grid)
  1883. {
  1884. _grid = grid;
  1885. }
  1886. public override Style SelectStyle(object item, DependencyObject container)
  1887. {
  1888. var vcol = ((GridTableSummaryCell)container).ColumnBase.ColumnIndex;
  1889. var col = vcol > -1 && vcol < _grid.VisibleColumns.Count ? _grid.VisibleColumns[vcol] : null;
  1890. var style = new Style(typeof(GridTableSummaryCell));
  1891. style.Setters.Add(new Setter(Control.BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
  1892. style.Setters.Add(new Setter(Control.ForegroundProperty, new SolidColorBrush(Colors.Black)));
  1893. style.Setters.Add(new Setter(Control.HorizontalContentAlignmentProperty,
  1894. col != null ? col.HorizontalAlignment(typeof(double)) : HorizontalAlignment.Right));
  1895. style.Setters.Add(new Setter(Control.BorderBrushProperty, new SolidColorBrush(Colors.Gray)));
  1896. style.Setters.Add(new Setter(Control.BorderThicknessProperty, new Thickness(0, 0, 0.75, 0)));
  1897. style.Setters.Add(new Setter(Control.FontSizeProperty, 12D));
  1898. style.Setters.Add(new Setter(Control.FontWeightProperty, FontWeights.DemiBold));
  1899. return style;
  1900. }
  1901. }
  1902. // Used to render boolean columns (the default "false" value shows what appears to be an intermediate state, which is ugly
  1903. // This should show nothing for false, and a tick in a box for true
  1904. public class BoolToImageConverter : AbstractConverter<bool,ImageSource>
  1905. {
  1906. public ImageSource TrueValue { get; set; }
  1907. public ImageSource FalseValue { get; set; }
  1908. public BoolToImageConverter()
  1909. {
  1910. TrueValue = Wpf.Resources.Bullet_Tick.AsBitmapImage();
  1911. }
  1912. public override ImageSource Convert(bool value)
  1913. {
  1914. return value ? TrueValue : FalseValue;
  1915. }
  1916. public override bool Deconvert(ImageSource value)
  1917. {
  1918. return ImageUtils.IsEqual(value as BitmapImage,TrueValue as BitmapImage);
  1919. }
  1920. }
  1921. public class StringToColorImageConverter : IValueConverter
  1922. {
  1923. private readonly int _height = 50;
  1924. private readonly int _width = 25;
  1925. private readonly Dictionary<string, BitmapImage> cache = new();
  1926. public StringToColorImageConverter(int width, int height)
  1927. {
  1928. _width = width;
  1929. _height = height;
  1930. }
  1931. public object? Convert(object value, Type targetType, object parameter, CultureInfo culture)
  1932. {
  1933. var str = value?.ToString();
  1934. if (str is null)
  1935. return null;
  1936. var colorcode = str.TrimStart('#');
  1937. if (!cache.ContainsKey(colorcode))
  1938. {
  1939. var col = ImageUtils.StringToColor(colorcode);
  1940. var bmp = ImageUtils.BitmapFromColor(col, _width, _height, Color.Black);
  1941. cache[colorcode] = bmp.AsBitmapImage();
  1942. }
  1943. var result = cache[colorcode];
  1944. return result;
  1945. }
  1946. public object? ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
  1947. {
  1948. return null;
  1949. }
  1950. }
  1951. public class StringArrayConverter : IValueConverter
  1952. {
  1953. object? IValueConverter.Convert(object value, Type targetType, object parameter, CultureInfo culture)
  1954. {
  1955. if (value is string[] strArray)
  1956. {
  1957. return string.Join("\n", strArray);
  1958. }
  1959. Logger.Send(LogType.Error, "", $"Attempt to convert an object which is not a string array: {value}.");
  1960. return null;
  1961. }
  1962. object IValueConverter.ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
  1963. {
  1964. return value;
  1965. }
  1966. }
  1967. #endregion
  1968. [Serializable]
  1969. class DynamicGridDragFormat
  1970. {
  1971. private string entity;
  1972. public DataTable Table { get; set; }
  1973. public Type Entity { get => CoreUtils.GetEntity(entity); set => entity = value.EntityName(); }
  1974. public DynamicGridDragFormat(DataTable table, Type entity)
  1975. {
  1976. Table = table;
  1977. Entity = entity;
  1978. }
  1979. }