DynamicDataGrid.cs 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Diagnostics.CodeAnalysis;
  4. using System.Drawing;
  5. using System.Linq;
  6. using System.Linq.Expressions;
  7. using System.Reflection;
  8. using System.Threading.Tasks;
  9. using System.Windows;
  10. using System.Windows.Controls;
  11. using InABox.Clients;
  12. using InABox.Configuration;
  13. using InABox.Core;
  14. using InABox.WPF;
  15. using Expression = System.Linq.Expressions.Expression;
  16. namespace InABox.DynamicGrid
  17. {
  18. public interface IDynamicDataGrid : IDynamicGrid
  19. {
  20. /// <summary>
  21. /// The tag the the DynamicGridColumns are stored against. If set to <see langword="null"/>,
  22. /// the name of <typeparamref name="TEntity"/> is used as a default.
  23. /// </summary>
  24. string? ColumnsTag { get; set; }
  25. IColumns LoadEditorColumns();
  26. }
  27. public class DynamicDataGrid<TEntity> : DynamicGrid<TEntity>, IDynamicDataGrid where TEntity : Entity, IRemotable, IPersistent, new()
  28. {
  29. public delegate bool FilterSelected(CoreFilterDefinition filter);
  30. public event FilterSelected OnFilterSelected;
  31. public delegate void OnReloadEventHandler(object sender, Filters<TEntity> criteria, Columns<TEntity> columns, ref SortOrder<TEntity>? sortby);
  32. private readonly int ChunkSize = 500;
  33. private readonly Button MergeBtn;
  34. private readonly Button FilterBtn;
  35. private bool _showFilterList;
  36. public bool ShowFilterList
  37. {
  38. get => _showFilterList;
  39. set
  40. {
  41. _showFilterList = value;
  42. if (FilterBtn != null) // FilterBtn can be null when ShowFilterList is set in DynamicGrid constructor
  43. FilterBtn.Visibility = value ? Visibility.Visible : Visibility.Collapsed;
  44. }
  45. }
  46. protected Tuple<string, Filter<TEntity>>? SelectedFilter;
  47. private Column<TEntity>[] FilterColumns;
  48. public DynamicDataGrid() : base()
  49. {
  50. FilterBtn = AddButton("", Wpf.Resources.filter.AsBitmapImage(), DoFilter);
  51. FilterBtn.Margin = new Thickness(0, 2, 7, 0);
  52. FilterBtn.Padding = new Thickness(0);
  53. FilterBtn.Visibility = ShowFilterList ? Visibility.Visible : Visibility.Collapsed;
  54. Options.BeginUpdate();
  55. if (Security.CanEdit<TEntity>())
  56. Options.Add(DynamicGridOption.AddRows).Add(DynamicGridOption.EditRows);
  57. if (Security.CanDelete<TEntity>())
  58. Options.Add(DynamicGridOption.DeleteRows);
  59. if (Security.CanImport<TEntity>())
  60. Options.Add(DynamicGridOption.ImportData);
  61. if (Security.CanExport<TEntity>())
  62. Options.Add(DynamicGridOption.ExportData);
  63. if (Security.CanMerge<TEntity>())
  64. Options.Add(DynamicGridOption.MultiSelect);
  65. Options.EndUpdate();
  66. MergeBtn = AddButton("Merge", Wpf.Resources.merge.AsBitmapImage(Color.White), DoMerge);
  67. var fields = DatabaseSchema.Properties(typeof(TEntity));
  68. foreach (var field in fields)
  69. if (!MasterColumns.Any(x => x.ColumnName == field.Name))
  70. MasterColumns.Add(new DynamicGridColumn { ColumnName = field.Name });
  71. var cols = LookupFactory.DefineColumns<TEntity>();
  72. // Minimum Columns for Lookup values
  73. foreach (var col in cols.Items)
  74. HiddenColumns.Add(CoreUtils.CreateLambdaExpression<TEntity>(col.Property));
  75. // Minimum Columns for Successful Saving
  76. // This should be cross-checked with the relevant Store<>
  77. // so that clients will (usually) provide sufficient columns for saving
  78. var required = LookupFactory.RequiredColumns<TEntity>();
  79. foreach (var col in required.Items)
  80. HiddenColumns.Add(CoreUtils.CreateLambdaExpression<TEntity>(col.Property));
  81. //HiddenColumns.Add(x => x.ID);
  82. if (typeof(TEntity).GetInterfaces().Contains(typeof(IIssues)))
  83. {
  84. HiddenColumns.Add(x => (x as IIssues)!.Issues);
  85. var coltype = typeof(DynamicIssuesColumn<>).MakeGenericType(typeof(TEntity));
  86. ActionColumns.Add((Activator.CreateInstance(coltype, this) as DynamicActionColumn)!);
  87. }
  88. SetupFilterColumns();
  89. }
  90. [MemberNotNull(nameof(FilterColumns))]
  91. private void SetupFilterColumns()
  92. {
  93. if (typeof(TEntity).GetCustomAttribute<AutoEntity>() is AutoEntity auto)
  94. {
  95. if (auto.Generator is not null)
  96. {
  97. var columns = auto.Generator.IDColumns;
  98. FilterColumns = columns.Select(x => new Column<TEntity>(x.Property)).ToArray();
  99. }
  100. else
  101. {
  102. FilterColumns = Array.Empty<Column<TEntity>>();
  103. }
  104. }
  105. else
  106. {
  107. FilterColumns = new[] { new Column<TEntity>(x => x.ID) };
  108. }
  109. foreach (var column in FilterColumns)
  110. {
  111. AddHiddenColumn(column.Property);
  112. }
  113. }
  114. protected override void BeforeLoad(IDynamicEditorForm form)
  115. {
  116. form.ReadOnly = !Security.CanEdit<TEntity>();
  117. base.BeforeLoad(form);
  118. }
  119. public string? ColumnsTag { get; set; }
  120. protected override void OptionsChanged(object sender, EventArgs args)
  121. {
  122. base.OptionsChanged(sender, args);
  123. if (MergeBtn != null)
  124. MergeBtn.Visibility = Visibility.Collapsed;
  125. ShowFilterList = Options.Contains(DynamicGridOption.FilterRows);
  126. }
  127. protected override void SelectItems(CoreRow[]? rows)
  128. {
  129. base.SelectItems(rows);
  130. MergeBtn.Visibility = Options.Contains(DynamicGridOption.MultiSelect) && typeof(TEntity).IsAssignableTo(typeof(IMergeable)) && Security.CanMerge<TEntity>() && rows != null && rows.Length > 1
  131. ? Visibility.Visible
  132. : Visibility.Collapsed;
  133. }
  134. /*private Filter<T>? CreateFilter<T>(Dictionary<string, object> criteria) where T : Entity
  135. {
  136. Filter<T>? filter = null;
  137. foreach (var key in criteria.Keys)
  138. {
  139. var exp = CoreUtils.GetPropertyExpression<T>(key);
  140. var flt = new Filter<T>(exp).IsEqualTo(criteria[key]);
  141. if (filter != null)
  142. filter.Ands.Add(flt);
  143. else
  144. filter = flt;
  145. }
  146. return filter;
  147. }
  148. private Columns<T> CreateColumns<T>(List<string> columnnames) where T : Entity
  149. {
  150. var expressions = new List<Expression<Func<T, object?>>>();
  151. foreach (var columnname in columnnames)
  152. try
  153. {
  154. var expression = CoreUtils.GetPropertyExpression<T>(columnname);
  155. expressions.Add(expression);
  156. }
  157. catch (Exception e)
  158. {
  159. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  160. }
  161. if (!columnnames.Contains("ID"))
  162. expressions.Add(CoreUtils.GetPropertyExpression<T>("ID"));
  163. //if (!columnnames.Contains("Attributes"))
  164. // expressions.Add(CoreUtils.GetPropertyExpression<T>("Attributes"));
  165. return new Columns<T>(expressions.ToArray());
  166. }
  167. private SortOrder<T>? CreateSortOrder<T>(string columnname) where T : Entity
  168. {
  169. if (string.IsNullOrWhiteSpace(columnname))
  170. return null;
  171. var expression = CoreUtils.GetPropertyExpression<T>(columnname);
  172. return new SortOrder<T>(expression);
  173. }*/
  174. public event OnReloadEventHandler? OnReload;
  175. protected override void Reload(Filters<TEntity> criteria, Columns<TEntity> columns, ref SortOrder<TEntity>? sort,
  176. Action<CoreTable?, Exception?> action)
  177. {
  178. //if (sort == null)
  179. // sort = new SortOrder<TEntity>(x => x.Sort);
  180. if (SelectedFilter != null)
  181. criteria.Add(SelectedFilter.Item2);
  182. OnReload?.Invoke(this, criteria, columns, ref sort);
  183. new Client<TEntity>().Query(criteria.Combine(), columns, sort, action);
  184. }
  185. private CoreRow[]? SelectedBeforeRefresh;
  186. protected override void OnAfterRefresh()
  187. {
  188. base.OnAfterRefresh();
  189. if (SelectedBeforeRefresh is not null)
  190. {
  191. var selectedValues = SelectedBeforeRefresh
  192. .Select(x => FilterColumns.Select(c => x[c.Property]).ToList())
  193. .ToList();
  194. SelectedBeforeRefresh = null;
  195. var selectedRows = Data.Rows.Where(r =>
  196. {
  197. return selectedValues.Any(v =>
  198. {
  199. for (int i = 0; i < v.Count; ++i)
  200. {
  201. if (v[i]?.Equals(r[FilterColumns[i].Property]) != true)
  202. return false;
  203. }
  204. return true;
  205. });
  206. }).ToArray();
  207. SelectedRows = selectedRows;
  208. SelectItems(selectedRows);
  209. }
  210. }
  211. public override void Refresh(bool reloadcolumns, bool reloaddata)
  212. {
  213. SelectedBeforeRefresh = SelectedRows;
  214. base.Refresh(reloadcolumns, reloaddata);
  215. }
  216. IColumns IDynamicDataGrid.LoadEditorColumns() => LoadEditorColumns();
  217. public Columns<TEntity> LoadEditorColumns()
  218. {
  219. return DynamicGridUtils.LoadEditorColumns(DataColumns());
  220. }
  221. private Filter<TEntity>? GetRowFilter(CoreRow row)
  222. {
  223. var newFilters = new Filters<TEntity>();
  224. foreach (var column in FilterColumns)
  225. {
  226. newFilters.Add(new Filter<TEntity>(column.Property).IsEqualTo(row[column.Property]));
  227. }
  228. return newFilters.Combine();
  229. }
  230. protected override TEntity[] LoadItems(CoreRow[] rows)
  231. {
  232. Filter<TEntity>? filter = null;
  233. var results = new List<TEntity>();
  234. for (var i = 0; i < rows.Length; i = i + ChunkSize)
  235. {
  236. var chunk = rows.Skip(i).Take(ChunkSize);
  237. foreach (var row in chunk)
  238. {
  239. var newFilter = GetRowFilter(row);
  240. if (newFilter is not null)
  241. {
  242. //var id = row.Get<TEntity, Guid>(x => x.ID);
  243. if (filter is null)
  244. filter = newFilter;//new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  245. else
  246. filter = filter.Or(newFilter);//.Or(x => x.ID).IsEqualTo(id);
  247. }
  248. }
  249. var columns = LoadEditorColumns(); // new Columns<TEntity>().Default(ColumnType.IncludeOptional, ColumnType.IncludeForeignKeys, ColumnType.IncludeUserProperties);
  250. var data = new Client<TEntity>().Query(filter, columns);
  251. results.AddRange(data.Rows.Select(x => x.ToObject<TEntity>()));
  252. }
  253. return results.ToArray();
  254. }
  255. protected override TEntity LoadItem(CoreRow row)
  256. {
  257. var id = row.Get<TEntity, Guid>(x => x.ID);
  258. var filter = GetRowFilter(row);//new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  259. return new Client<TEntity>().Load(filter).FirstOrDefault()
  260. ?? throw new Exception($"No {typeof(TEntity).Name} with ID {id}");
  261. }
  262. public override void SaveItem(TEntity item)
  263. {
  264. new Client<TEntity>().Save(item, "Edited by User");
  265. }
  266. public override void SaveItems(TEntity[] items)
  267. {
  268. new Client<TEntity>().Save(items, "Edited by User");
  269. }
  270. protected override void DeleteItems(params CoreRow[] rows)
  271. {
  272. var deletes = new List<TEntity>();
  273. foreach (var row in rows)
  274. {
  275. var delete = new TEntity();
  276. foreach (var column in FilterColumns)
  277. {
  278. CoreUtils.SetPropertyValue(delete, column.Property, row[column.Property]);
  279. }
  280. //var delete = /* row.ToObject<TEntity>(); */ new TEntity { ID = row.Get<TEntity, Guid>(x => x.ID) };
  281. deletes.Add(delete);
  282. }
  283. new Client<TEntity>().Delete(deletes, "Deleted on User Request");
  284. }
  285. private object GetPropertyValue(Expression member, object obj)
  286. {
  287. var objectMember = Expression.Convert(member, typeof(object));
  288. var getterLambda = Expression.Lambda<Func<object>>(objectMember);
  289. var getter = getterLambda.Compile();
  290. return getter();
  291. }
  292. protected override void ObjectToRow(TEntity obj, CoreRow row)
  293. {
  294. foreach (var column in Data.Columns)
  295. {
  296. var prop = DatabaseSchema.Property(obj.GetType(), column.ColumnName);
  297. if (prop is StandardProperty)
  298. row.Set(column.ColumnName, CoreUtils.GetPropertyValue(obj, prop.Name));
  299. else if (prop is CustomProperty)
  300. row.Set(column.ColumnName, obj.UserProperties[column.ColumnName]);
  301. }
  302. //base.ObjectToRow(obj, row);
  303. }
  304. //private void Auditgrid_OnReload(object sender, Dictionary<string, object> criteria, ref String sort)
  305. //{
  306. // criteria["DocumentType"] = typeof(TEntity).EntityName();
  307. // criteria["DocumentID"] = (sender as FrameworkElement).Tag;
  308. // sort = "TimeStamp";
  309. //}
  310. public override void LoadEditorButtons(TEntity item, DynamicEditorButtons buttons)
  311. {
  312. base.LoadEditorButtons(item, buttons);
  313. if (ClientFactory.IsSupported<AuditTrail>())
  314. buttons.Add("Audit Trail", Wpf.Resources.view.AsBitmapImage(), item, AuditTrailClick);
  315. }
  316. private void AuditTrailClick(object sender, object item)
  317. {
  318. var entity = (TEntity)item;
  319. var window = new AuditWindow(entity.ID);
  320. window.ShowDialog();
  321. }
  322. protected override void LoadColumnsMenu(ContextMenu menu)
  323. {
  324. base.LoadColumnsMenu(menu);
  325. //menu.Items.Add(new Separator());
  326. var ResetColumns = new MenuItem { Header = "Reset Columns to Default" };
  327. ResetColumns.Click += ResetColumnsClick;
  328. menu.Items.Add(ResetColumns);
  329. if (Security.IsAllowed<CanSetDefaultColumns>())
  330. {
  331. menu.Items.Add(new Separator());
  332. var UpdateDefaultColumns = new MenuItem { Header = "Mark Columns as Default" };
  333. UpdateDefaultColumns.Click += UpdateDefaultColumnsClick;
  334. menu.Items.Add(UpdateDefaultColumns);
  335. }
  336. }
  337. private void ResetColumnsClick(object sender, RoutedEventArgs e)
  338. {
  339. VisibleColumns.Clear();
  340. SaveColumns(VisibleColumns);
  341. Refresh(true, true);
  342. }
  343. private void UpdateDefaultColumnsClick(object sender, RoutedEventArgs e)
  344. {
  345. var tag = GetTag();
  346. new GlobalConfiguration<DynamicGridColumns>(tag).Save(VisibleColumns);
  347. new UserConfiguration<DynamicGridColumns>(tag).Delete();
  348. Refresh(true, true);
  349. }
  350. private string GetTag()
  351. {
  352. var tag = typeof(TEntity).Name;
  353. if (!string.IsNullOrWhiteSpace(ColumnsTag))
  354. tag = string.Format("{0}.{1}", tag, ColumnsTag);
  355. return tag;
  356. }
  357. private BaseEditor GetColumnEditor(DynamicGridColumn column)
  358. {
  359. try
  360. {
  361. var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
  362. if (prop != null) return prop.Editor;
  363. var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
  364. return type.GetEditor() ?? new NullEditor();
  365. }
  366. catch (Exception e)
  367. {
  368. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  369. }
  370. return new NullEditor();
  371. }
  372. protected override DynamicGridColumns LoadColumns()
  373. {
  374. var tag = GetTag();
  375. var user = Task.Run(() => new UserConfiguration<DynamicGridColumns>(tag).Load());
  376. user.Wait();
  377. var global = Task.Run(() => new GlobalConfiguration<DynamicGridColumns>(tag).Load());
  378. global.Wait();
  379. //Task.WaitAll(user, global);
  380. var columns = user.Result.Any() ? user.Result : global.Result;
  381. if (!columns.Any())
  382. GenerateColumns(columns); //override this to provide specific columns on startup
  383. var removes = columns.Where(x => x is null || string.IsNullOrWhiteSpace(x.ColumnName) || DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor)
  384. .ToArray();
  385. foreach (var remove in removes)
  386. columns.Remove(remove);
  387. if (columns.Count == 0)
  388. columns.AddRange(base.LoadColumns());
  389. foreach (var column in columns)
  390. try
  391. {
  392. var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
  393. if (prop != null)
  394. {
  395. column.Editor = prop.Editor;
  396. }
  397. else
  398. {
  399. var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
  400. column.Editor = type.GetEditor() ?? new NullEditor();
  401. }
  402. }
  403. catch (Exception e)
  404. {
  405. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  406. }
  407. columns.RemoveAll(x => DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor);
  408. return columns;
  409. }
  410. protected virtual void GenerateColumns(DynamicGridColumns columns)
  411. {
  412. var cols = new Columns<TEntity>().Default(Options.Contains(DynamicGridOption.DirectEdit)
  413. ? new[] { ColumnType.IncludeForeignKeys, ColumnType.ExcludeID }
  414. : new ColumnType[] {
  415. ColumnType.IncludeLinked, ColumnType.IncludeNestedLinks, ColumnType.IncludeFormulae,
  416. ColumnType.IncludeAggregates, ColumnType.ExcludeID });
  417. if (cols != null)
  418. {
  419. foreach (var col in cols.Items)
  420. {
  421. var mc = MasterColumns.FirstOrDefault(x => x.ColumnName.Equals(col.Property));
  422. if (mc != null && !(mc.Editor is NullEditor) && mc.Editor.Visible != Visible.Hidden)
  423. columns.Add(mc);
  424. }
  425. }
  426. }
  427. protected override void SaveColumns(DynamicGridColumns columns)
  428. {
  429. var tag = GetTag();
  430. new UserConfiguration<DynamicGridColumns>(tag).Save(columns);
  431. }
  432. protected override BaseEditor? GetEditor(object item, DynamicGridColumn column)
  433. {
  434. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == column.ColumnName);
  435. if (prop != null)
  436. return prop.Editor;
  437. return base.GetEditor(item, column);
  438. }
  439. protected override object? GetEditorValue(object item, string name)
  440. {
  441. if (item is TEntity entity)
  442. {
  443. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
  444. if (prop is CustomProperty)
  445. {
  446. if (entity.UserProperties.ContainsKey(name))
  447. return entity.UserProperties[name];
  448. return null;
  449. }
  450. }
  451. return base.GetEditorValue(item, name);
  452. }
  453. protected override void SetEditorValue(object item, string name, object value)
  454. {
  455. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
  456. if (prop is CustomProperty && item is TEntity entity)
  457. {
  458. entity.UserProperties[name] = value;
  459. }
  460. else
  461. {
  462. base.SetEditorValue(item, name, value);
  463. }
  464. }
  465. protected bool Duplicate(
  466. CoreRow row,
  467. Expression<Func<TEntity, object?>> codefield,
  468. Type[] childtypes)
  469. {
  470. var id = row.Get<TEntity, Guid>(x => x.ID);
  471. var code = row.Get(codefield) as string;
  472. var tasks = new List<Task>();
  473. var itemtask = Task.Run(() =>
  474. {
  475. var filter = new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  476. var result = new Client<TEntity>().Load(filter).FirstOrDefault()
  477. ?? throw new Exception("Entity does not exist!");
  478. return result;
  479. });
  480. tasks.Add(itemtask);
  481. //itemtask.Wait();
  482. Task<List<string?>>? codetask = null;
  483. if (!string.IsNullOrWhiteSpace(code))
  484. {
  485. codetask = Task.Run(() =>
  486. {
  487. var columns = new Columns<TEntity>(codefield);
  488. //columns.Add<String>(codefield);
  489. var filter = new Filter<TEntity>(codefield).BeginsWith(code);
  490. var table = new Client<TEntity>().Query(filter, columns);
  491. var result = table.Rows.Select(x => x.Get(codefield) as string).ToList();
  492. return result;
  493. });
  494. tasks.Add(codetask);
  495. }
  496. //codetask.Wait();
  497. var children = new Dictionary<Type, CoreTable>();
  498. foreach (var childtype in childtypes)
  499. {
  500. var childtask = Task.Run(() =>
  501. {
  502. var prop = childtype.GetProperties().FirstOrDefault(x =>
  503. x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink)) &&
  504. x.PropertyType.GetInheritedGenericTypeArguments().FirstOrDefault() == typeof(TEntity));
  505. if (prop is not null)
  506. {
  507. var filter = Core.Filter.Create(childtype);
  508. filter.Expression = CoreUtils.GetMemberExpression(childtype, prop.Name + ".ID");
  509. filter.Operator = Operator.IsEqualTo;
  510. filter.Value = id;
  511. var sort = LookupFactory.DefineSort(childtype);
  512. var client = ClientFactory.CreateClient(childtype);
  513. var table = client.Query(filter, null, sort);
  514. foreach (var r in table.Rows)
  515. {
  516. r["ID"] = Guid.Empty;
  517. r[prop.Name + ".ID"] = Guid.Empty;
  518. }
  519. children[childtype] = table;
  520. }
  521. else
  522. {
  523. Logger.Send(LogType.Error, "", $"DynamicDataGrid<{typeof(TEntity)}>.Duplicate(): No parent property found for child type {childtype}");
  524. }
  525. });
  526. tasks.Add(childtask);
  527. //childtask.Wait();
  528. }
  529. //var manytomanys = CoreUtils.TypeList(
  530. // AppDomain.CurrentDomain.GetAssemblies(),
  531. // x => x.GetInterfaces().Any(intf => intf.IsGenericType && intf.GetGenericTypeDefinition() == typeof(IManyToMany<,>) && intf.GenericTypeArguments.Contains(typeof(T)))
  532. //);
  533. //Task<CoreTable> childtask = Task.Run(() =>
  534. //{
  535. // var result = new CoreTable();
  536. // result.LoadColumns(typeof(TChild));
  537. // var children = new Client<TChild>().Load(new Filter<TChild>(x => linkfield).IsEqualTo(id));
  538. // foreach (var child in children)
  539. // {
  540. // child.ID = Guid.Empty;
  541. // String linkprop = CoreUtils.GetFullPropertyName<TChild, Guid>(linkfield, ".");
  542. // CoreUtils.SetPropertyValue(child, linkprop, Guid.Empty);
  543. // var newrow = result.NewRow();
  544. // result.LoadRow(newrow, child);
  545. // result.Rows.Add(newrow);
  546. // }
  547. // return result;
  548. //});
  549. //tasks.Add(childtask);
  550. Task.WaitAll(tasks.ToArray());
  551. var item = itemtask.Result;
  552. item.ID = Guid.Empty;
  553. if (codetask != null)
  554. {
  555. var codes = codetask.Result;
  556. var i = 1;
  557. while (codes.Contains(string.Format("{0} ({1})", code, i)))
  558. i++;
  559. var codeprop = CoreUtils.GetFullPropertyName(codefield, ".");
  560. CoreUtils.SetPropertyValue(item, codeprop, string.Format("{0} ({1})", code, i));
  561. }
  562. var grid = new DynamicDataGrid<TEntity>();
  563. return grid.EditItems(new[] { item }, t => children.ContainsKey(t) ? children[t] : null, true);
  564. }
  565. private bool DoFilter(Button button, CoreRow[] rows)
  566. {
  567. var menu = new ContextMenu();
  568. var none = new MenuItem { Header = "Clear Filters", Tag = null };
  569. none.Click += Filter_Click;
  570. menu.Items.Add(none);
  571. var tag = GetTag();
  572. var filters = new GlobalConfiguration<CoreFilterDefinitions>(tag).Load();
  573. foreach (var filter in filters)
  574. {
  575. var item = new MenuItem { Header = filter.Name, Tag = filter };
  576. if (SelectedFilter?.Item1 == filter.Name)
  577. {
  578. item.IsChecked = true;
  579. }
  580. item.Click += Filter_Click;
  581. menu.Items.Add(item);
  582. }
  583. if (Security.IsAllowed<CanCustomiseFilters>())
  584. {
  585. menu.Items.Add(new Separator());
  586. var manage = new MenuItem { Header = "Manage Filters" };
  587. manage.Click += (s, e) =>
  588. {
  589. var window = new DynamicGridFilterEditor(filters, typeof(TEntity));
  590. if (window.ShowDialog() == true)
  591. {
  592. new GlobalConfiguration<CoreFilterDefinitions>(tag).Save(filters);
  593. }
  594. };
  595. menu.Items.Add(manage);
  596. }
  597. menu.IsOpen = true;
  598. return false;
  599. }
  600. private void Filter_Click(object sender, RoutedEventArgs e)
  601. {
  602. var tag = (sender as MenuItem)?.Tag;
  603. string text = "";
  604. Bitmap image;
  605. if (tag is CoreFilterDefinition filter)
  606. {
  607. SelectedFilter = new(filter.Name, Serialization.Deserialize<Filter<TEntity>>(filter.Filter));
  608. image = Wpf.Resources.filter_set;
  609. text = filter.Name;
  610. OnFilterSelected?.Invoke(filter);
  611. }
  612. else
  613. {
  614. SelectedFilter = null;
  615. image = Wpf.Resources.filter;
  616. text = "";
  617. OnFilterSelected?.Invoke(new CoreFilterDefinition());
  618. }
  619. UpdateButton(FilterBtn, image.AsBitmapImage(), text);
  620. Refresh(false, true);
  621. }
  622. private bool DoMerge(Button arg1, CoreRow[] arg2)
  623. {
  624. if (arg2 == null || arg2.Length <= 1)
  625. return false;
  626. var targetid = arg2.Last().Get<TEntity, Guid>(x => x.ID);
  627. var target = arg2.Last().ToObject<TEntity>().ToString();
  628. var otherids = arg2.Select(r => r.Get<TEntity, Guid>(x => x.ID)).Where(x => x != targetid).ToArray();
  629. string[] others = arg2.Where(r => otherids.Contains(r.Get<Guid>("ID"))).Select(x => x.ToObject<TEntity>().ToString()!).ToArray();
  630. var rows = arg2.Length;
  631. if (MessageBox.Show(
  632. string.Format(
  633. "This will merge the following items:\n\n- {0}\n\n into:\n\n- {1}\n\nAfter this, the items will be permanently removed.\nAre you sure you wish to do this?",
  634. string.Join("\n- ", others),
  635. target
  636. ),
  637. "Merge Items Warning",
  638. MessageBoxButton.YesNo,
  639. MessageBoxImage.Stop) != MessageBoxResult.Yes
  640. )
  641. return false;
  642. using (new WaitCursor())
  643. {
  644. var types = CoreUtils.TypeList(
  645. AppDomain.CurrentDomain.GetAssemblies(),
  646. x =>
  647. x.IsClass
  648. && !x.IsGenericType
  649. && x.IsSubclassOf(typeof(Entity))
  650. && !x.Equals(typeof(AuditTrail))
  651. && !x.Equals(typeof(TEntity))
  652. && x.GetCustomAttribute<AutoEntity>() == null
  653. ).ToArray();
  654. foreach (var type in types)
  655. {
  656. var props = CoreUtils.PropertyList(
  657. type,
  658. x =>
  659. x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink))
  660. && x.PropertyType.GetInheritedGenericTypeArguments().Contains(typeof(TEntity))
  661. );
  662. foreach (var prop in props)
  663. {
  664. var propname = string.Format(prop.Name + ".ID");
  665. var filter = Core.Filter.Create(type);
  666. filter.Expression = CoreUtils.CreateMemberExpression(type, propname);
  667. filter.Operator = Operator.InList;
  668. filter.Value = otherids;
  669. var columns = Columns.Create(type)
  670. .Add("ID")
  671. .Add(propname);
  672. var updates = ClientFactory.CreateClient(type).Query(filter, columns).Rows.Select(r => r.ToObject(type)).ToArray();
  673. if (updates.Any())
  674. {
  675. foreach (var update in updates)
  676. CoreUtils.SetPropertyValue(update, propname, targetid);
  677. ClientFactory.CreateClient(type).Save(updates,
  678. string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
  679. }
  680. }
  681. }
  682. var histories = new Client<AuditTrail>()
  683. .Query(new Filter<AuditTrail>(x => x.EntityID).InList(otherids), new Columns<AuditTrail>(x => x.EntityID)).Rows
  684. .Select(x => x.ToObject<AuditTrail>()).ToArray();
  685. foreach (var history in histories)
  686. history.EntityID = targetid;
  687. if (histories.Any())
  688. new Client<AuditTrail>().Save(histories, "");
  689. var deletes = new List<object>();
  690. foreach (var otherid in otherids)
  691. {
  692. var delete = new TEntity();
  693. CoreUtils.SetPropertyValue(delete, "ID", otherid);
  694. deletes.Add(delete);
  695. }
  696. ClientFactory.CreateClient(typeof(TEntity))
  697. .Delete(deletes, string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
  698. return true;
  699. }
  700. }
  701. protected override IEnumerable<TEntity> LoadDuplicatorItems(CoreRow[] rows)
  702. {
  703. return rows.Select(x => x.ToObject<TEntity>());
  704. }
  705. protected override bool BeforePaste(IEnumerable<TEntity> items, ClipAction action)
  706. {
  707. if (action == ClipAction.Copy)
  708. {
  709. foreach (var item in items)
  710. item.ID = Guid.Empty;
  711. return true;
  712. }
  713. return base.BeforePaste(items, action);
  714. }
  715. protected override void CustomiseExportFilters(Filters<TEntity> filters, CoreRow[] visiblerows)
  716. {
  717. base.CustomiseExportFilters(filters, visiblerows);
  718. /*if (IsEntity)
  719. {
  720. var ids = visiblerows.Select(r => r.Get<TEntity, Guid>(c => c.ID)).ToArray();
  721. filters.Add(new Filter<TEntity>(x => x.ID).InList(ids));
  722. }
  723. else
  724. {
  725. Filter<TEntity>? filter = null;
  726. foreach (var row in visiblerows)
  727. {
  728. var rowFilter = GetRowFilter(row);
  729. if(rowFilter is not null)
  730. {
  731. if (filter is null)
  732. {
  733. filter = rowFilter;
  734. }
  735. else
  736. {
  737. filter.Or(rowFilter);
  738. }
  739. }
  740. }
  741. filters.Add(filter);
  742. }*/
  743. }
  744. protected override IEnumerable<Tuple<Type?, CoreTable>> LoadExportTables(Filters<TEntity> filter, IEnumerable<Tuple<Type, IColumns>> tableColumns)
  745. {
  746. var queries = new Dictionary<string, IQueryDef>();
  747. var columns = tableColumns.ToList();
  748. foreach (var table in columns)
  749. {
  750. var tableType = table.Item1;
  751. PropertyInfo? property = null;
  752. var m2m = CoreUtils.GetManyToMany(tableType, typeof(TEntity));
  753. IFilter? queryFilter = null;
  754. if (m2m != null)
  755. {
  756. property = CoreUtils.GetManyToManyThisProperty(tableType, typeof(TEntity));
  757. }
  758. else
  759. {
  760. var o2m = CoreUtils.GetOneToMany(tableType, typeof(TEntity));
  761. if (o2m != null)
  762. {
  763. property = CoreUtils.GetOneToManyProperty(tableType, typeof(TEntity));
  764. }
  765. }
  766. if (property != null)
  767. {
  768. var subQuery = new SubQuery<TEntity>();
  769. subQuery.Filter = filter.Combine();
  770. subQuery.Column = new Column<TEntity>(x => x.ID);
  771. queryFilter = (Activator.CreateInstance(typeof(Filter<>).MakeGenericType(tableType)) as IFilter)!;
  772. queryFilter.Expression = CoreUtils.GetMemberExpression(tableType, property.Name + ".ID");
  773. queryFilter.InQuery(subQuery);
  774. queries[tableType.Name] = new QueryDef(tableType)
  775. {
  776. Filter = queryFilter,
  777. Columns = table.Item2
  778. };
  779. }
  780. }
  781. var results = Client.QueryMultiple(queries);
  782. return columns.Select(x => new Tuple<Type?, CoreTable>(x.Item1, results[x.Item1.Name]));
  783. }
  784. protected override CoreTable LoadImportKeys(String[] fields)
  785. {
  786. return new Client<TEntity>().Query(null, new Columns<TEntity>(fields));
  787. }
  788. public void UpdateFilterButton(Bitmap image, string text = "")
  789. {
  790. UpdateButton(FilterBtn, image.AsBitmapImage(), text);
  791. }
  792. }
  793. }