DynamicDataGrid.cs 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963
  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(DynamicGridFilter 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. var result = new Columns<TEntity>().Default(
  220. ColumnType.IncludeOptional,
  221. ColumnType.IncludeForeignKeys,
  222. ColumnType.IncludeUserProperties,
  223. ColumnType.IncludeEditable);
  224. var cols = DataColumns();
  225. foreach (var col in cols.Items)
  226. if (!result.Items.Any(x => string.Equals(x.Property, col.Property)))
  227. result.Add(col.Property);
  228. var props = DatabaseSchema.Properties(typeof(TEntity))
  229. .Where(x => x.Setter() != null)
  230. .OrderBy(x => CoreUtils.GetPropertySequence(typeof(TEntity), x.Name));
  231. foreach (var col in result.Items)
  232. {
  233. var prop = DatabaseSchema.Property(typeof(TEntity), col.Property);
  234. if (prop?.Editor is DataLookupEditor dataLookup)
  235. {
  236. foreach (var lookupColumn in LookupFactory.DefineFilterColumns<TEntity>(dataLookup.Type).ColumnNames())
  237. {
  238. result.Add(lookupColumn);
  239. }
  240. }
  241. }
  242. return result;
  243. }
  244. private Filter<TEntity>? GetRowFilter(CoreRow row)
  245. {
  246. var newFilters = new Filters<TEntity>();
  247. foreach (var column in FilterColumns)
  248. {
  249. newFilters.Add(new Filter<TEntity>(column.Property).IsEqualTo(row[column.Property]));
  250. }
  251. return newFilters.Combine();
  252. }
  253. protected override TEntity[] LoadItems(CoreRow[] rows)
  254. {
  255. Filter<TEntity>? filter = null;
  256. var results = new List<TEntity>();
  257. for (var i = 0; i < rows.Length; i = i + ChunkSize)
  258. {
  259. var chunk = rows.Skip(i).Take(ChunkSize);
  260. foreach (var row in chunk)
  261. {
  262. var newFilter = GetRowFilter(row);
  263. if (newFilter is not null)
  264. {
  265. //var id = row.Get<TEntity, Guid>(x => x.ID);
  266. if (filter is null)
  267. filter = newFilter;//new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  268. else
  269. filter = filter.Or(newFilter);//.Or(x => x.ID).IsEqualTo(id);
  270. }
  271. }
  272. var columns = LoadEditorColumns(); // new Columns<TEntity>().Default(ColumnType.IncludeOptional, ColumnType.IncludeForeignKeys, ColumnType.IncludeUserProperties);
  273. var data = new Client<TEntity>().Query(filter, columns);
  274. results.AddRange(data.Rows.Select(x => x.ToObject<TEntity>()));
  275. }
  276. return results.ToArray();
  277. }
  278. protected override TEntity LoadItem(CoreRow row)
  279. {
  280. var id = row.Get<TEntity, Guid>(x => x.ID);
  281. var filter = GetRowFilter(row);//new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  282. return new Client<TEntity>().Load(filter).FirstOrDefault()
  283. ?? throw new Exception($"No {typeof(TEntity).Name} with ID {id}");
  284. }
  285. public override void SaveItem(TEntity item)
  286. {
  287. new Client<TEntity>().Save(item, "Edited by User");
  288. }
  289. public override void SaveItems(TEntity[] items)
  290. {
  291. new Client<TEntity>().Save(items, "Edited by User");
  292. }
  293. protected override void DeleteItems(params CoreRow[] rows)
  294. {
  295. var deletes = new List<TEntity>();
  296. foreach (var row in rows)
  297. {
  298. var delete = new TEntity();
  299. foreach (var column in FilterColumns)
  300. {
  301. CoreUtils.SetPropertyValue(delete, column.Property, row[column.Property]);
  302. }
  303. //var delete = /* row.ToObject<TEntity>(); */ new TEntity { ID = row.Get<TEntity, Guid>(x => x.ID) };
  304. deletes.Add(delete);
  305. }
  306. new Client<TEntity>().Delete(deletes, "Deleted on User Request");
  307. }
  308. private object GetPropertyValue(Expression member, object obj)
  309. {
  310. var objectMember = Expression.Convert(member, typeof(object));
  311. var getterLambda = Expression.Lambda<Func<object>>(objectMember);
  312. var getter = getterLambda.Compile();
  313. return getter();
  314. }
  315. protected override void ObjectToRow(TEntity obj, CoreRow row)
  316. {
  317. foreach (var column in Data.Columns)
  318. {
  319. var prop = DatabaseSchema.Property(obj.GetType(), column.ColumnName);
  320. if (prop is StandardProperty)
  321. row.Set(column.ColumnName, CoreUtils.GetPropertyValue(obj, prop.Name));
  322. else if (prop is CustomProperty)
  323. row.Set(column.ColumnName, obj.UserProperties[column.ColumnName]);
  324. }
  325. //base.ObjectToRow(obj, row);
  326. }
  327. //private void Auditgrid_OnReload(object sender, Dictionary<string, object> criteria, ref String sort)
  328. //{
  329. // criteria["DocumentType"] = typeof(TEntity).EntityName();
  330. // criteria["DocumentID"] = (sender as FrameworkElement).Tag;
  331. // sort = "TimeStamp";
  332. //}
  333. public override void LoadEditorButtons(TEntity item, DynamicEditorButtons buttons)
  334. {
  335. base.LoadEditorButtons(item, buttons);
  336. if (ClientFactory.IsSupported<AuditTrail>())
  337. buttons.Add("Audit Trail", Wpf.Resources.view.AsBitmapImage(), item, AuditTrailClick);
  338. }
  339. private void AuditTrailClick(object sender, object item)
  340. {
  341. var entity = (TEntity)item;
  342. var window = new AuditWindow(entity.ID);
  343. window.ShowDialog();
  344. }
  345. protected override void LoadColumnsMenu(ContextMenu menu)
  346. {
  347. base.LoadColumnsMenu(menu);
  348. //menu.Items.Add(new Separator());
  349. var ResetColumns = new MenuItem { Header = "Reset Columns to Default" };
  350. ResetColumns.Click += ResetColumnsClick;
  351. menu.Items.Add(ResetColumns);
  352. if (Security.IsAllowed<CanSetDefaultColumns>())
  353. {
  354. menu.Items.Add(new Separator());
  355. var UpdateDefaultColumns = new MenuItem { Header = "Mark Columns as Default" };
  356. UpdateDefaultColumns.Click += UpdateDefaultColumnsClick;
  357. menu.Items.Add(UpdateDefaultColumns);
  358. }
  359. }
  360. private void ResetColumnsClick(object sender, RoutedEventArgs e)
  361. {
  362. VisibleColumns.Clear();
  363. SaveColumns(VisibleColumns);
  364. Refresh(true, true);
  365. }
  366. private void UpdateDefaultColumnsClick(object sender, RoutedEventArgs e)
  367. {
  368. var tag = GetTag();
  369. new GlobalConfiguration<DynamicGridColumns>(tag).Save(VisibleColumns);
  370. new UserConfiguration<DynamicGridColumns>(tag).Delete();
  371. Refresh(true, true);
  372. }
  373. private string GetTag()
  374. {
  375. var tag = typeof(TEntity).Name;
  376. if (!string.IsNullOrWhiteSpace(ColumnsTag))
  377. tag = string.Format("{0}.{1}", tag, ColumnsTag);
  378. return tag;
  379. }
  380. private BaseEditor GetColumnEditor(DynamicGridColumn column)
  381. {
  382. try
  383. {
  384. var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
  385. if (prop != null) return prop.Editor;
  386. var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
  387. return type.GetEditor() ?? new NullEditor();
  388. }
  389. catch (Exception e)
  390. {
  391. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  392. }
  393. return new NullEditor();
  394. }
  395. protected override DynamicGridColumns LoadColumns()
  396. {
  397. var tag = GetTag();
  398. var user = Task.Run(() => new UserConfiguration<DynamicGridColumns>(tag).Load());
  399. user.Wait();
  400. var global = Task.Run(() => new GlobalConfiguration<DynamicGridColumns>(tag).Load());
  401. global.Wait();
  402. //Task.WaitAll(user, global);
  403. var columns = user.Result.Any() ? user.Result : global.Result;
  404. if (!columns.Any())
  405. GenerateColumns(columns); //override this to provide specific columns on startup
  406. var removes = columns.Where(x => x is null || string.IsNullOrWhiteSpace(x.ColumnName) || DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor)
  407. .ToArray();
  408. foreach (var remove in removes)
  409. columns.Remove(remove);
  410. if (columns.Count == 0)
  411. columns.AddRange(base.LoadColumns());
  412. foreach (var column in columns)
  413. try
  414. {
  415. var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
  416. if (prop != null)
  417. {
  418. column.Editor = prop.Editor;
  419. }
  420. else
  421. {
  422. var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
  423. column.Editor = type.GetEditor() ?? new NullEditor();
  424. }
  425. }
  426. catch (Exception e)
  427. {
  428. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  429. }
  430. columns.RemoveAll(x => DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor);
  431. return columns;
  432. }
  433. protected virtual void GenerateColumns(DynamicGridColumns columns)
  434. {
  435. var cols = new Columns<TEntity>().Default(Options.Contains(DynamicGridOption.DirectEdit)
  436. ? new[] { ColumnType.IncludeForeignKeys, ColumnType.ExcludeID }
  437. : new ColumnType[] {
  438. ColumnType.IncludeLinked, ColumnType.IncludeNestedLinks, ColumnType.IncludeFormulae,
  439. ColumnType.IncludeAggregates, ColumnType.ExcludeID });
  440. if (cols != null)
  441. {
  442. foreach (var col in cols.Items)
  443. {
  444. var mc = MasterColumns.FirstOrDefault(x => x.ColumnName.Equals(col.Property));
  445. if (mc != null && !(mc.Editor is NullEditor) && mc.Editor.Visible != Visible.Hidden)
  446. columns.Add(mc);
  447. }
  448. }
  449. }
  450. protected override void SaveColumns(DynamicGridColumns columns)
  451. {
  452. var tag = GetTag();
  453. new UserConfiguration<DynamicGridColumns>(tag).Save(columns);
  454. }
  455. protected override BaseEditor? GetEditor(object item, DynamicGridColumn column)
  456. {
  457. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == column.ColumnName);
  458. if (prop != null)
  459. return prop.Editor;
  460. return base.GetEditor(item, column);
  461. }
  462. protected override object? GetEditorValue(object item, string name)
  463. {
  464. if (item is TEntity entity)
  465. {
  466. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
  467. if (prop is CustomProperty)
  468. {
  469. if (entity.UserProperties.ContainsKey(name))
  470. return entity.UserProperties[name];
  471. return null;
  472. }
  473. }
  474. return base.GetEditorValue(item, name);
  475. }
  476. protected override void SetEditorValue(object item, string name, object value)
  477. {
  478. var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
  479. if (prop is CustomProperty && item is TEntity entity)
  480. {
  481. entity.UserProperties[name] = value;
  482. }
  483. else
  484. {
  485. base.SetEditorValue(item, name, value);
  486. }
  487. }
  488. protected override Document? LoadDocument(Guid id)
  489. {
  490. return new Client<Document>().Load(new Filter<Document>(x => x.ID).IsEqualTo(id)).FirstOrDefault();
  491. }
  492. protected override Document? FindDocument(string filename)
  493. {
  494. return new Client<Document>().Load(new Filter<Document>(x => x.FileName).IsEqualTo(filename)).FirstOrDefault();
  495. }
  496. protected override void SaveDocument(Document document)
  497. {
  498. new Client<Document>().Save(document, "Updated by Editor");
  499. }
  500. protected bool Duplicate(
  501. CoreRow row,
  502. Expression<Func<TEntity, object?>> codefield,
  503. Type[] childtypes)
  504. {
  505. var id = row.Get<TEntity, Guid>(x => x.ID);
  506. var code = row.Get(codefield) as string;
  507. var tasks = new List<Task>();
  508. var itemtask = Task.Run(() =>
  509. {
  510. var filter = new Filter<TEntity>(x => x.ID).IsEqualTo(id);
  511. var result = new Client<TEntity>().Load(filter).FirstOrDefault()
  512. ?? throw new Exception("Entity does not exist!");
  513. return result;
  514. });
  515. tasks.Add(itemtask);
  516. //itemtask.Wait();
  517. Task<List<string?>>? codetask = null;
  518. if (!string.IsNullOrWhiteSpace(code))
  519. {
  520. codetask = Task.Run(() =>
  521. {
  522. var columns = new Columns<TEntity>(codefield);
  523. //columns.Add<String>(codefield);
  524. var filter = new Filter<TEntity>(codefield).BeginsWith(code);
  525. var table = new Client<TEntity>().Query(filter, columns);
  526. var result = table.Rows.Select(x => x.Get(codefield) as string).ToList();
  527. return result;
  528. });
  529. tasks.Add(codetask);
  530. }
  531. //codetask.Wait();
  532. var children = new Dictionary<Type, CoreTable>();
  533. foreach (var childtype in childtypes)
  534. {
  535. var childtask = Task.Run(() =>
  536. {
  537. var prop = childtype.GetProperties().FirstOrDefault(x =>
  538. x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink)) &&
  539. x.PropertyType.GetInheritedGenericTypeArguments().FirstOrDefault() == typeof(TEntity));
  540. if (prop is not null)
  541. {
  542. var filter = Core.Filter.Create(childtype);
  543. filter.Expression = CoreUtils.GetMemberExpression(childtype, prop.Name + ".ID");
  544. filter.Operator = Operator.IsEqualTo;
  545. filter.Value = id;
  546. var sort = LookupFactory.DefineSort(childtype);
  547. var client = ClientFactory.CreateClient(childtype);
  548. var table = client.Query(filter, null, sort);
  549. foreach (var r in table.Rows)
  550. {
  551. r["ID"] = Guid.Empty;
  552. r[prop.Name + ".ID"] = Guid.Empty;
  553. }
  554. children[childtype] = table;
  555. }
  556. else
  557. {
  558. Logger.Send(LogType.Error, "", $"DynamicDataGrid<{typeof(TEntity)}>.Duplicate(): No parent property found for child type {childtype}");
  559. }
  560. });
  561. tasks.Add(childtask);
  562. //childtask.Wait();
  563. }
  564. //var manytomanys = CoreUtils.TypeList(
  565. // AppDomain.CurrentDomain.GetAssemblies(),
  566. // x => x.GetInterfaces().Any(intf => intf.IsGenericType && intf.GetGenericTypeDefinition() == typeof(IManyToMany<,>) && intf.GenericTypeArguments.Contains(typeof(T)))
  567. //);
  568. //Task<CoreTable> childtask = Task.Run(() =>
  569. //{
  570. // var result = new CoreTable();
  571. // result.LoadColumns(typeof(TChild));
  572. // var children = new Client<TChild>().Load(new Filter<TChild>(x => linkfield).IsEqualTo(id));
  573. // foreach (var child in children)
  574. // {
  575. // child.ID = Guid.Empty;
  576. // String linkprop = CoreUtils.GetFullPropertyName<TChild, Guid>(linkfield, ".");
  577. // CoreUtils.SetPropertyValue(child, linkprop, Guid.Empty);
  578. // var newrow = result.NewRow();
  579. // result.LoadRow(newrow, child);
  580. // result.Rows.Add(newrow);
  581. // }
  582. // return result;
  583. //});
  584. //tasks.Add(childtask);
  585. Task.WaitAll(tasks.ToArray());
  586. var item = itemtask.Result;
  587. item.ID = Guid.Empty;
  588. if (codetask != null)
  589. {
  590. var codes = codetask.Result;
  591. var i = 1;
  592. while (codes.Contains(string.Format("{0} ({1})", code, i)))
  593. i++;
  594. var codeprop = CoreUtils.GetFullPropertyName(codefield, ".");
  595. CoreUtils.SetPropertyValue(item, codeprop, string.Format("{0} ({1})", code, i));
  596. }
  597. var grid = new DynamicDataGrid<TEntity>();
  598. return grid.EditItems(new[] { item }, t => children.ContainsKey(t) ? children[t] : null, true);
  599. }
  600. private bool DoFilter(Button button, CoreRow[] rows)
  601. {
  602. var menu = new ContextMenu();
  603. var none = new MenuItem { Header = "Clear Filters", Tag = null };
  604. none.Click += Filter_Click;
  605. menu.Items.Add(none);
  606. var tag = GetTag();
  607. var filters = new GlobalConfiguration<DynamicGridFilters>(tag).Load();
  608. foreach (var filter in filters)
  609. {
  610. var item = new MenuItem { Header = filter.Name, Tag = filter };
  611. if (SelectedFilter?.Item1 == filter.Name)
  612. {
  613. item.IsChecked = true;
  614. }
  615. item.Click += Filter_Click;
  616. menu.Items.Add(item);
  617. }
  618. if (Security.IsAllowed<CanCustomiseFilters>())
  619. {
  620. menu.Items.Add(new Separator());
  621. var manage = new MenuItem { Header = "Manage Filters" };
  622. manage.Click += (s, e) =>
  623. {
  624. var window = new DynamicGridFilterEditor(filters, typeof(TEntity));
  625. if (window.ShowDialog() == true)
  626. {
  627. new GlobalConfiguration<DynamicGridFilters>(tag).Save(filters);
  628. }
  629. };
  630. menu.Items.Add(manage);
  631. }
  632. menu.IsOpen = true;
  633. return false;
  634. }
  635. private void Filter_Click(object sender, RoutedEventArgs e)
  636. {
  637. var tag = (sender as MenuItem)?.Tag;
  638. string text = "";
  639. Bitmap image;
  640. if (tag is DynamicGridFilter filter)
  641. {
  642. SelectedFilter = new(filter.Name, Serialization.Deserialize<Filter<TEntity>>(filter.Filter));
  643. image = Wpf.Resources.filter_set;
  644. if ((bool)(OnFilterSelected?.Invoke(filter)))
  645. text = filter.Name;
  646. }
  647. else
  648. {
  649. SelectedFilter = null;
  650. image = Wpf.Resources.filter;
  651. OnFilterSelected?.Invoke(new DynamicGridFilter());
  652. }
  653. UpdateButton(FilterBtn, image.AsBitmapImage(), text);
  654. Refresh(false, true);
  655. }
  656. private bool DoMerge(Button arg1, CoreRow[] arg2)
  657. {
  658. if (arg2 == null || arg2.Length <= 1)
  659. return false;
  660. var targetid = arg2.Last().Get<TEntity, Guid>(x => x.ID);
  661. var target = arg2.Last().ToObject<TEntity>().ToString();
  662. var otherids = arg2.Select(r => r.Get<TEntity, Guid>(x => x.ID)).Where(x => x != targetid).ToArray();
  663. string[] others = arg2.Where(r => otherids.Contains(r.Get<Guid>("ID"))).Select(x => x.ToObject<TEntity>().ToString()!).ToArray();
  664. var rows = arg2.Length;
  665. if (MessageBox.Show(
  666. string.Format(
  667. "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?",
  668. string.Join("\n- ", others),
  669. target
  670. ),
  671. "Merge Items Warning",
  672. MessageBoxButton.YesNo,
  673. MessageBoxImage.Stop) != MessageBoxResult.Yes
  674. )
  675. return false;
  676. using (new WaitCursor())
  677. {
  678. var types = CoreUtils.TypeList(
  679. AppDomain.CurrentDomain.GetAssemblies(),
  680. x =>
  681. x.IsClass
  682. && !x.IsGenericType
  683. && x.IsSubclassOf(typeof(Entity))
  684. && !x.Equals(typeof(AuditTrail))
  685. && !x.Equals(typeof(TEntity))
  686. && x.GetCustomAttribute<AutoEntity>() == null
  687. ).ToArray();
  688. foreach (var type in types)
  689. {
  690. var props = CoreUtils.PropertyList(
  691. type,
  692. x =>
  693. x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink))
  694. && x.PropertyType.GetInheritedGenericTypeArguments().Contains(typeof(TEntity))
  695. );
  696. foreach (var prop in props)
  697. {
  698. var propname = string.Format(prop.Name + ".ID");
  699. var filter = Core.Filter.Create(type);
  700. filter.Expression = CoreUtils.CreateMemberExpression(type, propname);
  701. filter.Operator = Operator.InList;
  702. filter.Value = otherids;
  703. var columns = Columns.Create(type)
  704. .Add("ID")
  705. .Add(propname);
  706. var updates = ClientFactory.CreateClient(type).Query(filter, columns).Rows.Select(r => r.ToObject(type)).ToArray();
  707. if (updates.Any())
  708. {
  709. foreach (var update in updates)
  710. CoreUtils.SetPropertyValue(update, propname, targetid);
  711. ClientFactory.CreateClient(type).Save(updates,
  712. string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
  713. }
  714. }
  715. }
  716. var histories = new Client<AuditTrail>()
  717. .Query(new Filter<AuditTrail>(x => x.EntityID).InList(otherids), new Columns<AuditTrail>(x => x.EntityID)).Rows
  718. .Select(x => x.ToObject<AuditTrail>()).ToArray();
  719. foreach (var history in histories)
  720. history.EntityID = targetid;
  721. if (histories.Any())
  722. new Client<AuditTrail>().Save(histories, "");
  723. var deletes = new List<object>();
  724. foreach (var otherid in otherids)
  725. {
  726. var delete = new TEntity();
  727. CoreUtils.SetPropertyValue(delete, "ID", otherid);
  728. deletes.Add(delete);
  729. }
  730. ClientFactory.CreateClient(typeof(TEntity))
  731. .Delete(deletes, string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
  732. return true;
  733. }
  734. }
  735. protected override IEnumerable<TEntity> LoadDuplicatorItems(CoreRow[] rows)
  736. {
  737. return rows.Select(x => x.ToObject<TEntity>());
  738. }
  739. protected override bool BeforePaste(IEnumerable<TEntity> items, ClipAction action)
  740. {
  741. if (action == ClipAction.Copy)
  742. {
  743. foreach (var item in items)
  744. item.ID = Guid.Empty;
  745. return true;
  746. }
  747. return base.BeforePaste(items, action);
  748. }
  749. protected override void CustomiseExportFilters(Filters<TEntity> filters, CoreRow[] visiblerows)
  750. {
  751. base.CustomiseExportFilters(filters, visiblerows);
  752. /*if (IsEntity)
  753. {
  754. var ids = visiblerows.Select(r => r.Get<TEntity, Guid>(c => c.ID)).ToArray();
  755. filters.Add(new Filter<TEntity>(x => x.ID).InList(ids));
  756. }
  757. else
  758. {
  759. Filter<TEntity>? filter = null;
  760. foreach (var row in visiblerows)
  761. {
  762. var rowFilter = GetRowFilter(row);
  763. if(rowFilter is not null)
  764. {
  765. if (filter is null)
  766. {
  767. filter = rowFilter;
  768. }
  769. else
  770. {
  771. filter.Or(rowFilter);
  772. }
  773. }
  774. }
  775. filters.Add(filter);
  776. }*/
  777. }
  778. protected override IEnumerable<Tuple<Type?, CoreTable>> LoadExportTables(Filters<TEntity> filter, IEnumerable<Tuple<Type, IColumns>> tableColumns)
  779. {
  780. var queries = new Dictionary<string, IQueryDef>();
  781. var columns = tableColumns.ToList();
  782. foreach (var table in columns)
  783. {
  784. var tableType = table.Item1;
  785. PropertyInfo? property = null;
  786. var m2m = CoreUtils.GetManyToMany(tableType, typeof(TEntity));
  787. IFilter? queryFilter = null;
  788. if (m2m != null)
  789. {
  790. property = CoreUtils.GetManyToManyThisProperty(tableType, typeof(TEntity));
  791. }
  792. else
  793. {
  794. var o2m = CoreUtils.GetOneToMany(tableType, typeof(TEntity));
  795. if (o2m != null)
  796. {
  797. property = CoreUtils.GetOneToManyProperty(tableType, typeof(TEntity));
  798. }
  799. }
  800. if (property != null)
  801. {
  802. var subQuery = new SubQuery<TEntity>();
  803. subQuery.Filter = filter.Combine();
  804. subQuery.Column = new Column<TEntity>(x => x.ID);
  805. queryFilter = (Activator.CreateInstance(typeof(Filter<>).MakeGenericType(tableType)) as IFilter)!;
  806. queryFilter.Expression = CoreUtils.GetMemberExpression(tableType, property.Name + ".ID");
  807. queryFilter.InQuery(subQuery);
  808. queries[tableType.Name] = new QueryDef(tableType)
  809. {
  810. Filter = queryFilter,
  811. Columns = table.Item2
  812. };
  813. }
  814. }
  815. var results = Client.QueryMultiple(queries);
  816. return columns.Select(x => new Tuple<Type?, CoreTable>(x.Item1, results[x.Item1.Name]));
  817. }
  818. protected override CoreTable LoadImportKeys(String[] fields)
  819. {
  820. return new Client<TEntity>().Query(null, new Columns<TEntity>(fields));
  821. }
  822. public void UpdateFilterButton(Bitmap image, string text = "")
  823. {
  824. UpdateButton(FilterBtn, image.AsBitmapImage(), text);
  825. }
  826. }
  827. }