DynamicManyToManyGrid.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Globalization;
  5. using System.Linq;
  6. using System.Reflection;
  7. using System.Threading.Tasks;
  8. using System.Windows;
  9. using System.Windows.Controls;
  10. using InABox.Clients;
  11. using InABox.Configuration;
  12. using InABox.Core;
  13. using InABox.WPF;
  14. namespace InABox.DynamicGrid
  15. {
  16. public interface IDynamicManyToManyGrid<TManyToMany, TThis> : IDynamicEditorPage
  17. {
  18. }
  19. public class DynamicManyToManyGrid<TManyToMany, TThis> : DynamicGrid<TManyToMany>, IDynamicEditorPage, IDynamicManyToManyGrid<TManyToMany, TThis>
  20. where TThis : Entity, new()
  21. where TManyToMany : Entity, IPersistent, IRemotable, new()
  22. {
  23. //private Guid ID = Guid.Empty;
  24. protected TThis Item;
  25. private TManyToMany[] MasterList = { };
  26. protected PropertyInfo otherproperty;
  27. protected IEntityLink GetOtherLink(TManyToMany item) => (otherproperty.GetValue(item) as IEntityLink)!;
  28. protected PropertyInfo thisproperty;
  29. protected IEntityLink GetThisLink(TManyToMany item) => (thisproperty.GetValue(item) as IEntityLink)!;
  30. protected List<TManyToMany> WorkingList = new();
  31. public PageType PageType => PageType.Other;
  32. private bool _readOnly;
  33. public bool ReadOnly
  34. {
  35. get => _readOnly;
  36. set
  37. {
  38. if(_readOnly != value)
  39. {
  40. _readOnly = value;
  41. Reconfigure();
  42. }
  43. }
  44. }
  45. private static bool IsAutoEntity => typeof(TManyToMany).HasAttribute<AutoEntity>();
  46. public DynamicManyToManyGrid()
  47. {
  48. MultiSelect = true;
  49. thisproperty = CoreUtils.GetManyToManyThisProperty(typeof(TManyToMany), typeof(TThis));
  50. otherproperty = CoreUtils.GetManyToManyOtherProperty(typeof(TManyToMany), typeof(TThis));
  51. HiddenColumns.Add(x => x.ID);
  52. HiddenColumns.Add(CoreUtils.CreateLambdaExpression<TManyToMany>(otherproperty.Name + ".ID"));
  53. }
  54. protected override void Init()
  55. {
  56. }
  57. protected override void DoReconfigure(FluentList<DynamicGridOption> options)
  58. {
  59. options.BeginUpdate();
  60. options.Add(DynamicGridOption.RecordCount)
  61. .Add(DynamicGridOption.SelectColumns)
  62. .Add(DynamicGridOption.MultiSelect);
  63. if (Security.CanEdit<TManyToMany>() && !ReadOnly)
  64. options.Add(DynamicGridOption.AddRows).Add(DynamicGridOption.EditRows);
  65. if (Security.CanDelete<TManyToMany>() && !ReadOnly)
  66. options.Add(DynamicGridOption.DeleteRows);
  67. if (Security.CanImport<TManyToMany>() && !ReadOnly)
  68. options.Add(DynamicGridOption.ImportData);
  69. if (Security.CanExport<TManyToMany>())
  70. options.Add(DynamicGridOption.ExportData);
  71. if (Security.CanMerge<TManyToMany>())
  72. options.Add(DynamicGridOption.MultiSelect);
  73. options.EndUpdate();
  74. }
  75. public bool MultiSelect { get; set; }
  76. public DynamicEditorGrid EditorGrid { get; set; }
  77. public string Caption()
  78. {
  79. //var m2m = typeof(TManyToMany).GetInterfaces().FirstOrDefault(i => i.IsGenericType && i.GetGenericTypeDefinition() == typeof(IManyToMany<,>) && i.GenericTypeArguments.Contains(typeof(TThis)));
  80. //Type other = m2m.GenericTypeArguments.FirstOrDefault(x => x != typeof(TThis));
  81. //var serv = System.Data.Entity PluralizationService.CreateService(new System.Globalization.CultureInfo("en-us"));
  82. //var plural = serv.Pluralize(source);
  83. //return MvcHtmlString.Create(plural);
  84. var result = new Inflector.Inflector(new CultureInfo("en")).Pluralize(OtherType().Name);
  85. return result;
  86. }
  87. public virtual int Order()
  88. {
  89. return int.MinValue;
  90. }
  91. public bool Ready { get; set; }
  92. public void Load(object item, Func<Type, CoreTable?>? PageDataHandler)
  93. {
  94. Item = (TThis)item;
  95. var data = PageDataHandler?.Invoke(typeof(TManyToMany));
  96. if (data != null)
  97. {
  98. RefreshData(data);
  99. }
  100. else
  101. {
  102. if (Item.ID == Guid.Empty)
  103. {
  104. data = new CoreTable();
  105. data.LoadColumns(typeof(TManyToMany));
  106. RefreshData(data);
  107. }
  108. else
  109. {
  110. var exp = CoreUtils.GetPropertyExpression<TManyToMany>(thisproperty.Name + ".ID");
  111. var filter = new Filter<TManyToMany>(exp).IsEqualTo(Item.ID).And(exp).IsNotEqualTo(Guid.Empty);
  112. var sort = LookupFactory.DefineSort<TManyToMany>();
  113. new Client<TManyToMany>().Query(filter, null, sort, (o, e) => {
  114. if(o != null)
  115. {
  116. Dispatcher.Invoke(() => RefreshData(o));
  117. }
  118. else if(e != null)
  119. {
  120. Logger.Send(LogType.Information, ClientFactory.UserID, $"Unknown Error: {CoreUtils.FormatException(e)}");
  121. MessageBox.Show("An error occurred while loading data.");
  122. }
  123. });
  124. }
  125. }
  126. }
  127. public void BeforeSave(object item)
  128. {
  129. // Don't need to do anything here
  130. }
  131. public void AfterSave(object item)
  132. {
  133. if (IsAutoEntity)
  134. {
  135. return;
  136. }
  137. // First remove any deleted files
  138. foreach (var map in MasterList)
  139. if (!WorkingList.Contains(map))
  140. new Client<TManyToMany>().Delete(map, typeof(TManyToMany).Name + " Deleted by User");
  141. foreach (var map in WorkingList)
  142. {
  143. var prop = GetThisLink(map);
  144. if (prop.ID != Item.ID)
  145. prop.ID = Item.ID;
  146. }
  147. if (WorkingList.Any(x => x.IsChanged()))
  148. new Client<TManyToMany>().Save(WorkingList.Where(x => x.IsChanged()), "Updated by User");
  149. }
  150. public Size MinimumSize()
  151. {
  152. return new Size(400, 400);
  153. }
  154. private static Type OtherType() =>
  155. CoreUtils.GetManyToManyOtherType(typeof(TManyToMany), typeof(TThis));
  156. private static string GetTag()
  157. {
  158. return typeof(TManyToMany).Name + "." + typeof(TThis).Name;
  159. }
  160. protected override DynamicGridColumns LoadColumns()
  161. {
  162. var tag = GetTag();
  163. var global = Task.Run(() => new GlobalConfiguration<DynamicGridColumns>(tag).Load());
  164. var user = Task.Run(() => new UserConfiguration<DynamicGridColumns>(tag).Load());
  165. Task.WaitAll(global, user);
  166. var columns = user.Result.Any() ? user.Result : global.Result;
  167. if (columns.Count == 0)
  168. columns.AddRange(base.LoadColumns().Where(x => !x.ColumnName.StartsWith(thisproperty.Name)));
  169. return columns;
  170. }
  171. protected override void SaveColumns(DynamicGridColumns columns)
  172. {
  173. var tag = GetTag();
  174. new UserConfiguration<DynamicGridColumns>(tag).Save(columns);
  175. }
  176. protected override void LoadColumnsMenu(ContextMenu menu)
  177. {
  178. base.LoadColumnsMenu(menu);
  179. //menu.Items.Add(new Separator());
  180. var ResetColumns = new MenuItem { Header = "Reset Columns to Default" };
  181. ResetColumns.Click += ResetColumnsClick;
  182. menu.Items.Add(ResetColumns);
  183. if (Security.IsAllowed<CanSetDefaultColumns>())
  184. {
  185. menu.Items.Add(new Separator());
  186. var UpdateDefaultColumns = new MenuItem { Header = "Mark Columns as Default" };
  187. UpdateDefaultColumns.Click += UpdateDefaultColumnsClick;
  188. menu.Items.Add(UpdateDefaultColumns);
  189. }
  190. }
  191. private void ResetColumnsClick(object sender, RoutedEventArgs e)
  192. {
  193. VisibleColumns.Clear();
  194. SaveColumns(VisibleColumns);
  195. Refresh(true, true);
  196. }
  197. private void UpdateDefaultColumnsClick(object sender, RoutedEventArgs e)
  198. {
  199. var tag = GetTag();
  200. new GlobalConfiguration<DynamicGridColumns>(tag).Save(VisibleColumns);
  201. new UserConfiguration<DynamicGridColumns>(tag).Delete();
  202. Refresh(true, true);
  203. }
  204. protected override DynamicGridSettings LoadSettings()
  205. {
  206. var tag = GetTag();
  207. var user = Task.Run(() => new UserConfiguration<DynamicGridSettings>(tag).Load());
  208. user.Wait();
  209. //var global = Task.Run(() => new GlobalConfiguration<DynamicGridSettings>(tag).Load());
  210. //global.Wait();
  211. //Task.WaitAll(user, global);
  212. //var columns = user.Result.Any() ? user.Result : global.Result;
  213. return user.Result;
  214. }
  215. protected override void SaveSettings(DynamicGridSettings settings)
  216. {
  217. var tag = GetTag();
  218. new UserConfiguration<DynamicGridSettings>(tag).Save(settings);
  219. }
  220. protected virtual Guid[] CurrentGuids()
  221. {
  222. var result = new List<Guid>();
  223. foreach (var item in WorkingList)
  224. {
  225. //var prop = GetOtherLink(item);
  226. var prop = GetThisLink(item);
  227. result.Add(prop.ID);
  228. }
  229. return result.ToArray();
  230. }
  231. protected virtual object GetFilter()
  232. {
  233. var result = LookupFactory.DefineFilter(OtherType(), typeof(TThis), new[] { (TThis)Item });
  234. var filtertype = typeof(Filter<>).MakeGenericType(OtherType());
  235. var filtermethod = filtertype.GetMethods(BindingFlags.Public | BindingFlags.Static).Where(x =>
  236. x.Name.Equals("List") && x.GetParameters().Last().ParameterType.IsAssignableFrom(typeof(IEnumerable<Guid>))).First();
  237. var filterexpression = CoreUtils.GetPropertyExpression(OtherType(), "ID");
  238. var filtervalues = CurrentGuids();
  239. var filter = filtermethod.Invoke(null, new object[] { filterexpression, ListOperator.Excludes, filtervalues }) as IFilter;
  240. if (filter != null)
  241. {
  242. if (result != null)
  243. {
  244. filter.And(result);
  245. }
  246. return filter;
  247. }
  248. if (result != null) return result;
  249. return null;
  250. }
  251. protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
  252. {
  253. if (MultiSelect)
  254. {
  255. var filter = GetFilter();
  256. var dlgtype = typeof(MultiSelectDialog<>).MakeGenericType(OtherType());
  257. var dlg = (Activator.CreateInstance(dlgtype, filter, null, true) as IMultiSelectDialog)!;
  258. if (dlg.ShowDialog())
  259. {
  260. var guids = CurrentGuids();
  261. var items = dlgtype.GetMethod("Items").Invoke(dlg, new object[] { null }) as IEnumerable;
  262. foreach (var item in items)
  263. {
  264. var entity = item as Entity;
  265. if (!guids.Contains(entity.ID))
  266. {
  267. var newitem = CreateItem();
  268. var prop = GetOtherLink(newitem);
  269. prop.ID = entity.ID;
  270. prop.Synchronise(entity);
  271. SaveItem(newitem);
  272. }
  273. }
  274. Refresh(false, true);
  275. }
  276. }
  277. else
  278. {
  279. base.DoAdd();
  280. }
  281. }
  282. protected override TManyToMany CreateItem()
  283. {
  284. var result = new TManyToMany();
  285. if (Item != null)
  286. {
  287. var prop = GetOtherLink(result);
  288. prop.ID = Item.ID;
  289. prop.Synchronise(Item);
  290. }
  291. return result;
  292. }
  293. protected override TManyToMany LoadItem(CoreRow row)
  294. {
  295. return WorkingList[_recordmap[row].Index];
  296. }
  297. public override void SaveItem(TManyToMany item)
  298. {
  299. if (!WorkingList.Contains(item))
  300. WorkingList.Add(item);
  301. }
  302. protected override void DeleteItems(params CoreRow[] rows)
  303. {
  304. foreach (var row in rows)
  305. {
  306. var id = row.Get<TManyToMany, Guid>(c => c.ID);
  307. var item = WorkingList.FirstOrDefault(x => x.ID.Equals(id));
  308. if (item != null)
  309. WorkingList.Remove(item);
  310. }
  311. }
  312. private void RefreshData(CoreTable data)
  313. {
  314. MasterList = data.Rows.Select(x => x.ToObject<TManyToMany>()).ToArray();
  315. WorkingList = MasterList.ToList();
  316. Refresh(true, true);
  317. Ready = true;
  318. }
  319. protected override void Reload(Filters<TManyToMany> criteria, Columns<TManyToMany> columns, ref SortOrder<TManyToMany>? sort,
  320. Action<CoreTable?, Exception?> action)
  321. {
  322. var results = new CoreTable();
  323. results.LoadColumns(typeof(TManyToMany));
  324. if (sort != null)
  325. {
  326. var exp = IQueryableExtensions.ToLambda<TManyToMany>(sort.Expression);
  327. var sorted = sort.Direction == SortDirection.Ascending
  328. ? WorkingList.AsQueryable().OrderBy(exp)
  329. : WorkingList.AsQueryable().OrderByDescending(exp);
  330. foreach (var then in sort.Thens)
  331. {
  332. var thexp = IQueryableExtensions.ToLambda<TManyToMany>(then.Expression);
  333. sorted = sort.Direction == SortDirection.Ascending ? sorted.ThenBy(exp) : sorted.ThenByDescending(exp);
  334. }
  335. WorkingList = sorted.ToList();
  336. }
  337. results.LoadRows(WorkingList);
  338. //results.LoadRows(WorkingList);
  339. action.Invoke(results, null);
  340. }
  341. protected override BaseEditor? GetEditor(object item, DynamicGridColumn column)
  342. {
  343. var type = CoreUtils.GetProperty(typeof(TManyToMany), column.ColumnName).DeclaringType;
  344. if (type.GetInterfaces().Contains(typeof(IEntityLink)) && type.ContainsInheritedGenericType(typeof(TThis)))
  345. return new NullEditor();
  346. return base.GetEditor(item, column);
  347. }
  348. public override void LoadEditorButtons(TManyToMany item, DynamicEditorButtons buttons)
  349. {
  350. base.LoadEditorButtons(item, buttons);
  351. if (ClientFactory.IsSupported<AuditTrail>())
  352. buttons.Add("Audit Trail",Wpf.Resources.view.AsBitmapImage(), item, AuditTrailClick);
  353. }
  354. private void AuditTrailClick(object sender, object item)
  355. {
  356. var entity = (TManyToMany)item;
  357. var window = new AuditWindow(entity.ID);
  358. window.ShowDialog();
  359. }
  360. public override DynamicEditorPages LoadEditorPages(TManyToMany item)
  361. {
  362. return item.ID != Guid.Empty ? base.LoadEditorPages(item) : new DynamicEditorPages();
  363. }
  364. protected override bool BeforePaste(IEnumerable<TManyToMany> items, ClipAction action)
  365. {
  366. if (action == ClipAction.Copy)
  367. {
  368. foreach (var item in items)
  369. {
  370. item.ID = Guid.Empty;
  371. }
  372. }
  373. return base.BeforePaste(items, action);
  374. }
  375. }
  376. }