123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841 |
- using System;
- using System.Collections.Generic;
- using System.Drawing;
- using System.Linq;
- using System.Linq.Expressions;
- using System.Reflection;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using InABox.Clients;
- using InABox.Configuration;
- using InABox.Core;
- using InABox.WPF;
- using Expression = System.Linq.Expressions.Expression;
- namespace InABox.DynamicGrid
- {
- public class DynamicDataGrid<TEntity> : DynamicGrid<TEntity> where TEntity : Entity, IRemotable, IPersistent, new()
- {
- public delegate void OnReloadEventHandler(object sender, Filters<TEntity> criteria, Columns<TEntity> columns, ref SortOrder<TEntity>? sortby);
- private readonly int ChunkSize = 500;
- private readonly Button DuplicateBtn;
- private readonly Button MergeBtn;
- private readonly Button FilterBtn;
- private bool _showFilterList;
- public bool ShowFilterList {
- get => _showFilterList;
- set
- {
- _showFilterList = value;
- if(FilterBtn != null) // FilterBtn can be null when ShowFilterList is set in DynamicGrid constructor
- FilterBtn.Visibility = value ? Visibility.Visible : Visibility.Collapsed;
- }
- }
- private Tuple<string, Filter<TEntity>>? Filter;
- public DynamicDataGrid() : base()
- {
- FilterBtn = AddButton("", Properties.Resources.filter.AsBitmapImage(), DoFilter);
- FilterBtn.Margin = new Thickness(0, 2, 7, 0);
- FilterBtn.Padding = new Thickness(0);
- FilterBtn.Visibility = ShowFilterList ? Visibility.Visible : Visibility.Collapsed;
- Options.BeginUpdate();
- if (Security.CanEdit<TEntity>())
- Options.Add(DynamicGridOption.AddRows).Add(DynamicGridOption.EditRows);
- if (Security.CanDelete<TEntity>())
- Options.Add(DynamicGridOption.DeleteRows);
- if (Security.CanImport<TEntity>())
- Options.Add(DynamicGridOption.ImportData);
- if (Security.CanExport<TEntity>())
- Options.Add(DynamicGridOption.ExportData);
- if (Security.CanMerge<TEntity>())
- Options.Add(DynamicGridOption.MultiSelect);
- Options.EndUpdate();
- DuplicateBtn = AddButton("Duplicate", Properties.Resources.paste.AsBitmapImage(Color.White), DoDuplicate);
- MergeBtn = AddButton("Merge", Properties.Resources.merge.AsBitmapImage(Color.White), DoMerge);
- var fields = DatabaseSchema.Properties(typeof(TEntity));
-
- foreach (var field in fields)
- if (!MasterColumns.Any(x => x.ColumnName == field.Name))
- MasterColumns.Add(new DynamicGridColumn { ColumnName = field.Name });
-
- var cols = LookupFactory.DefineColumns<TEntity>();
-
- // Minimum Columns for Lookup values
- foreach (var col in cols.Items)
- HiddenColumns.Add(CoreUtils.CreateLambdaExpression<TEntity>(col.Property));
-
- // Minimum Columns for Successful Saving
- // This should be cross-checked with the relevant Store<>
- // so that clients will (usually) provide sufficient columns for saving
- var required = LookupFactory.RequiredColumns<TEntity>();
- foreach (var col in required.Items)
- HiddenColumns.Add(CoreUtils.CreateLambdaExpression<TEntity>(col.Property));
- //HiddenColumns.Add(x => x.ID);
- if (typeof(TEntity).GetInterfaces().Contains(typeof(IIssues)))
- {
- HiddenColumns.Add(x => (x as IIssues)!.Issues);
- var coltype = typeof(DynamicIssuesColumn<>).MakeGenericType(typeof(TEntity));
- ActionColumns.Add((Activator.CreateInstance(coltype, this) as DynamicActionColumn)!);
- }
- }
- protected override void CustomiseEditorForm(DynamicEditorForm form)
- {
- base.CustomiseEditorForm(form);
- form.ReadOnly = !Security.CanEdit<TEntity>();
- }
- /// <summary>
- /// The tag the the DynamicGridColumns are stored against. If set to <see langword="null"/>,
- /// the name of <typeparamref name="TEntity"/> is used as a default.
- /// </summary>
- public string? ColumnsTag { get; set; }
- protected override void OptionsChanged(object sender, EventArgs args)
- {
- base.OptionsChanged(sender, args);
- if (MergeBtn != null)
- MergeBtn.Visibility = Visibility.Collapsed;
- if (DuplicateBtn != null)
- DuplicateBtn.Visibility = Visibility.Collapsed;
- ShowFilterList = Options.Contains(DynamicGridOption.FilterRows);
- }
- protected override void SelectItems(CoreRow[]? rows)
- {
- base.SelectItems(rows);
- MergeBtn.Visibility = Options.Contains(DynamicGridOption.MultiSelect) && Security.CanMerge<TEntity>() && rows != null && rows.Length > 1
- ? Visibility.Visible
- : Visibility.Collapsed;
- DuplicateBtn.Visibility =
- typeof(TEntity) is IDuplicatable && rows != null && rows.Length >= 1 ? Visibility.Visible : Visibility.Collapsed;
- }
- private Filter<T>? CreateFilter<T>(Dictionary<string, object> criteria) where T : Entity
- {
- Filter<T>? filter = null;
- foreach (var key in criteria.Keys)
- {
- var exp = CoreUtils.GetPropertyExpression<T>(key);
- var flt = new Filter<T>(exp).IsEqualTo(criteria[key]);
- if (filter != null)
- filter.Ands.Add(flt);
- else
- filter = flt;
- }
- return filter;
- }
- private Columns<T> CreateColumns<T>(List<string> columnnames) where T : Entity
- {
- var expressions = new List<Expression<Func<T, object?>>>();
- foreach (var columnname in columnnames)
- try
- {
- var expression = CoreUtils.GetPropertyExpression<T>(columnname);
- expressions.Add(expression);
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- }
- if (!columnnames.Contains("ID"))
- expressions.Add(CoreUtils.GetPropertyExpression<T>("ID"));
- //if (!columnnames.Contains("Attributes"))
- // expressions.Add(CoreUtils.GetPropertyExpression<T>("Attributes"));
- return new Columns<T>(expressions.ToArray());
- }
- private SortOrder<T>? CreateSortOrder<T>(string columnname) where T : Entity
- {
- if (string.IsNullOrWhiteSpace(columnname))
- return null;
- var expression = CoreUtils.GetPropertyExpression<T>(columnname);
- return new SortOrder<T>(expression);
- }
- public event OnReloadEventHandler? OnReload;
- protected override void Reload(Filters<TEntity> criteria, Columns<TEntity> columns, ref SortOrder<TEntity>? sort,
- Action<CoreTable?, Exception?> action)
- {
- //if (sort == null)
- // sort = new SortOrder<TEntity>(x => x.Sort);
- if (Filter != null)
- criteria.Add(Filter.Item2);
- OnReload?.Invoke(this, criteria, columns, ref sort);
- new Client<TEntity>().Query(criteria.Combine(), columns, sort, action);
- }
- public override void Refresh(bool reloadcolumns, bool reloaddata)
- {
- var selectedids = SelectedRows.Select(x => x.Get<TEntity, Guid>(c => c.ID)).ToArray();
- base.Refresh(reloadcolumns, reloaddata);
- SelectedRows = Data.Rows.Where(r => selectedids.Contains(r.Get<TEntity, Guid>(c => c.ID))).ToArray();
- SelectItems(SelectedRows);
- }
- public Columns<TEntity> LoadEditorColumns()
- {
- var result = new Columns<TEntity>().Default(
- ColumnType.IncludeOptional,
- ColumnType.IncludeForeignKeys,
- ColumnType.IncludeUserProperties,
- ColumnType.IncludeEditable);
- var cols = DataColumns();
- foreach (var col in cols.Items)
- if (!result.Items.Any(x => string.Equals(x.Property, col.Property)))
- result.Add(col.Property);
- return result;
- }
- protected override TEntity[] LoadItems(CoreRow[] rows)
- {
- Filter<TEntity>? filter = null;
- var results = new List<TEntity>();
- for (var i = 0; i < rows.Length; i = i + ChunkSize)
- {
- var chunk = rows.Skip(i).Take(ChunkSize);
- foreach (var row in chunk)
- {
- var id = row.Get<TEntity, Guid>(x => x.ID);
- if (filter is null)
- filter = new Filter<TEntity>(x => x.ID).IsEqualTo(id);
- else
- filter = filter.Or(x => x.ID).IsEqualTo(id);
- }
- var columns = LoadEditorColumns(); // new Columns<TEntity>().Default(ColumnType.IncludeOptional, ColumnType.IncludeForeignKeys, ColumnType.IncludeUserProperties);
- var data = new Client<TEntity>().Query(filter, columns);
- results.AddRange(data.Rows.Select(x => x.ToObject<TEntity>()));
- }
- return results.ToArray();
- }
- protected override TEntity LoadItem(CoreRow row)
- {
- var id = row.Get<TEntity, Guid>(x => x.ID);
- var filter = new Filter<TEntity>(x => x.ID).IsEqualTo(id);
- return new Client<TEntity>().Load(filter).FirstOrDefault()
- ?? throw new Exception($"No {typeof(TEntity).Name} with ID {id}");
- }
- protected override void SaveItem(TEntity item)
- {
- new Client<TEntity>().Save(item, "Edited by User");
- }
- protected override void SaveItems(TEntity[] items)
- {
- new Client<TEntity>().Save(items, "Edited by User");
- }
- protected override void DeleteItems(params CoreRow[] rows)
- {
- var deletes = new List<TEntity>();
- foreach (var row in rows)
- {
- var delete = /* row.ToObject<TEntity>(); */ new TEntity { ID = row.Get<TEntity, Guid>(x => x.ID) };
- deletes.Add(delete);
- }
- new Client<TEntity>().Delete(deletes, "Deleted on User Request");
- }
- private object GetPropertyValue(Expression member, object obj)
- {
- var objectMember = Expression.Convert(member, typeof(object));
- var getterLambda = Expression.Lambda<Func<object>>(objectMember);
- var getter = getterLambda.Compile();
- return getter();
- }
- protected override void ObjectToRow(TEntity obj, CoreRow row)
- {
- foreach (var column in Data.Columns)
- {
- var prop = DatabaseSchema.Property(obj.GetType(), column.ColumnName);
- if (prop is StandardProperty)
- row.Set(column.ColumnName, CoreUtils.GetPropertyValue(obj, prop.Name));
- else if (prop is CustomProperty)
- row.Set(column.ColumnName, obj.UserProperties[column.ColumnName]);
- }
- //base.ObjectToRow(obj, row);
- }
- //private void Auditgrid_OnReload(object sender, Dictionary<string, object> criteria, ref String sort)
- //{
- // criteria["DocumentType"] = typeof(TEntity).EntityName();
- // criteria["DocumentID"] = (sender as FrameworkElement).Tag;
- // sort = "TimeStamp";
- //}
- public override void LoadEditorButtons(TEntity item, DynamicEditorButtons buttons)
- {
- base.LoadEditorButtons(item, buttons);
- if (ClientFactory.IsSupported<AuditTrail>())
- buttons.Add("Audit Trail", Properties.Resources.view.AsBitmapImage(), item, AuditTrailClick);
- }
- private void AuditTrailClick(object sender, object item)
- {
- var entity = (TEntity)item;
- var window = new AuditWindow(entity.ID);
- window.ShowDialog();
- }
- protected override void LoadColumnsMenu(ContextMenu menu)
- {
- base.LoadColumnsMenu(menu);
- //menu.Items.Add(new Separator());
- var ResetColumns = new MenuItem { Header = "Reset Columns to Default" };
- ResetColumns.Click += ResetColumnsClick;
- menu.Items.Add(ResetColumns);
- if (Security.IsAllowed<CanSetDefaultColumns>())
- {
- menu.Items.Add(new Separator());
- var UpdateDefaultColumns = new MenuItem { Header = "Mark Columns as Default" };
- UpdateDefaultColumns.Click += UpdateDefaultColumnsClick;
- menu.Items.Add(UpdateDefaultColumns);
- }
- }
- private void ResetColumnsClick(object sender, RoutedEventArgs e)
- {
- VisibleColumns.Clear();
- SaveColumns(VisibleColumns);
- Refresh(true, true);
- }
- private void UpdateDefaultColumnsClick(object sender, RoutedEventArgs e)
- {
- var tag = GetTag();
- new GlobalConfiguration<DynamicGridColumns>(tag).Save(VisibleColumns);
- new UserConfiguration<DynamicGridColumns>(tag).Delete();
- Refresh(true, true);
- }
- private string GetTag()
- {
- var tag = typeof(TEntity).Name;
- if (!string.IsNullOrWhiteSpace(ColumnsTag))
- tag = string.Format("{0}.{1}", tag, ColumnsTag);
- return tag;
- }
- private BaseEditor GetColumnEditor(DynamicGridColumn column)
- {
- try
- {
- var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
- if (prop != null) return prop.Editor;
- var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
- return type.GetEditor() ?? new NullEditor();
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- }
- return new NullEditor();
- }
- protected override DynamicGridColumns LoadColumns()
- {
- var tag = GetTag();
- var user = Task.Run(() => new UserConfiguration<DynamicGridColumns>(tag).Load());
- var global = Task.Run(() => new GlobalConfiguration<DynamicGridColumns>(tag).Load());
- Task.WaitAll(user, global);
- var columns = user.Result.Any() ? user.Result : global.Result;
- if (!columns.Any())
- GenerateColumns(columns); //override this to provide specific columns on startup
- var removes = columns.Where(x => DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor)
- .ToArray();
- foreach (var remove in removes)
- columns.Remove(remove);
- if (columns.Count == 0)
- columns.AddRange(base.LoadColumns());
- foreach (var column in columns)
- try
- {
- var prop = DatabaseSchema.Property(typeof(TEntity), column.ColumnName);
- if (prop != null)
- {
- column.Editor = prop.Editor;
- }
- else
- {
- var type = CoreUtils.GetProperty(typeof(TEntity), column.ColumnName);
- column.Editor = type.GetEditor() ?? new NullEditor();
- }
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- }
- columns.RemoveAll(x => DatabaseSchema.Property(typeof(TEntity), x.ColumnName) == null || GetColumnEditor(x) is NullEditor);
- return columns;
- }
- protected virtual void GenerateColumns(DynamicGridColumns columns)
- {
- var cols = new Columns<TEntity>().Default(Options.Contains(DynamicGridOption.DirectEdit)
- ? new[] { ColumnType.IncludeForeignKeys }
- : new ColumnType[] { ColumnType.IncludeLinked, ColumnType.IncludeNestedLinks, ColumnType.IncludeFormulae, ColumnType.IncludeAggregates });
- if (cols != null)
- {
- foreach (var col in cols.Items)
- {
- var mc = MasterColumns.FirstOrDefault(x => x.ColumnName.Equals(col.Property));
- if (mc != null && !(mc.Editor is NullEditor) && mc.Editor.Visible != Visible.Hidden)
- columns.Add(mc);
- }
- }
- }
- protected override void SaveColumns(DynamicGridColumns columns)
- {
- var tag = GetTag();
- new UserConfiguration<DynamicGridColumns>(tag).Save(columns);
- }
- public override void ConfigureColumns(DynamicGridColumns columns /*, bool dolookups */)
- {
- //var eProps = CoreUtils.PropertyList(typeof(Entity), x => true, true);
- //foreach (String eProp in eProps.Keys)
- //{
- // var column = columns.Where(x => x.ColumnName.Equals(eProp)).FirstOrDefault();
- // if (column != null)
- // columns.Remove(column);
- //}
- base.ConfigureColumns(columns /*, dolookups */);
- }
- protected override BaseEditor? GetEditor(object item, DynamicGridColumn column)
- {
- var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == column.ColumnName);
- if (prop != null)
- return prop.Editor;
- return base.GetEditor(item, column);
- }
- protected override object? GetEditorValue(object item, string name)
- {
- if(item is TEntity entity)
- {
- var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
- if (prop is CustomProperty)
- {
- if (entity.UserProperties.ContainsKey(name))
- return entity.UserProperties[name];
- return null;
- }
- }
- return base.GetEditorValue(item, name);
- }
- protected override void SetEditorValue(object item, string name, object value)
- {
- var prop = DatabaseSchema.Properties(typeof(TEntity)).FirstOrDefault(x => x.Name == name);
- if (prop is CustomProperty && item is TEntity entity)
- {
- entity.UserProperties[name] = value;
- }
- else
- {
- base.SetEditorValue(item, name, value);
- }
- }
- protected override Document? LoadDocument(Guid id)
- {
- return new Client<Document>().Load(new Filter<Document>(x => x.ID).IsEqualTo(id)).FirstOrDefault();
- }
- protected override Document? FindDocument(string filename)
- {
- return new Client<Document>().Load(new Filter<Document>(x => x.FileName).IsEqualTo(filename)).FirstOrDefault();
- }
- protected override void SaveDocument(Document document)
- {
- new Client<Document>().Save(document, "Updated by Editor");
- }
- protected bool Duplicate(
- CoreRow row,
- Expression<Func<TEntity, object?>> codefield,
- Type[] childtypes)
- {
- var id = row.Get<TEntity, Guid>(x => x.ID);
- var code = row.Get(codefield) as string;
- var tasks = new List<Task>();
- var itemtask = Task.Run(() =>
- {
- var filter = new Filter<TEntity>(x => x.ID).IsEqualTo(id);
- var result = new Client<TEntity>().Load(filter).FirstOrDefault()
- ?? throw new Exception("Entity does not exist!");
- return result;
- });
- tasks.Add(itemtask);
- //itemtask.Wait();
- Task<List<string?>>? codetask = null;
- if (!string.IsNullOrWhiteSpace(code))
- {
- codetask = Task.Run(() =>
- {
- var columns = new Columns<TEntity>(codefield);
- //columns.Add<String>(codefield);
- var filter = new Filter<TEntity>(codefield).BeginsWith(code);
- var table = new Client<TEntity>().Query(filter, columns);
- var result = table.Rows.Select(x => x.Get(codefield) as string).ToList();
- return result;
- });
- tasks.Add(codetask);
- }
- //codetask.Wait();
- var children = new Dictionary<Type, CoreTable>();
- foreach (var childtype in childtypes)
- {
- var childtask = Task.Run(() =>
- {
- var prop = childtype.GetProperties().FirstOrDefault(x =>
- x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink)) &&
- x.PropertyType.GetInheritedGenericTypeArguments().FirstOrDefault() == typeof(TEntity));
- if(prop is not null)
- {
- var filter = Core.Filter.Create(childtype);
- filter.Expression = CoreUtils.GetMemberExpression(childtype, prop.Name + ".ID");
- filter.Operator = Operator.IsEqualTo;
- filter.Value = id;
- var sort = LookupFactory.DefineSort(childtype);
- var client = ClientFactory.CreateClient(childtype);
- var table = client.Query(filter, null, sort);
- foreach (var r in table.Rows)
- {
- r["ID"] = Guid.Empty;
- r[prop.Name + ".ID"] = Guid.Empty;
- }
- children[childtype] = table;
- }
- else
- {
- Logger.Send(LogType.Error, "", $"DynamicDataGrid<{typeof(TEntity)}>.Duplicate(): No parent property found for child type {childtype}");
- }
- });
- tasks.Add(childtask);
- //childtask.Wait();
- }
- //var manytomanys = CoreUtils.TypeList(
- // AppDomain.CurrentDomain.GetAssemblies(),
- // x => x.GetInterfaces().Any(intf => intf.IsGenericType && intf.GetGenericTypeDefinition() == typeof(IManyToMany<,>) && intf.GenericTypeArguments.Contains(typeof(T)))
- //);
- //Task<CoreTable> childtask = Task.Run(() =>
- //{
- // var result = new CoreTable();
- // result.LoadColumns(typeof(TChild));
- // var children = new Client<TChild>().Load(new Filter<TChild>(x => linkfield).IsEqualTo(id));
- // foreach (var child in children)
- // {
- // child.ID = Guid.Empty;
- // String linkprop = CoreUtils.GetFullPropertyName<TChild, Guid>(linkfield, ".");
- // CoreUtils.SetPropertyValue(child, linkprop, Guid.Empty);
- // var newrow = result.NewRow();
- // result.LoadRow(newrow, child);
- // result.Rows.Add(newrow);
- // }
- // return result;
- //});
- //tasks.Add(childtask);
- Task.WaitAll(tasks.ToArray());
- var item = itemtask.Result;
- item.ID = Guid.Empty;
- if (codetask != null)
- {
- var codes = codetask.Result;
- var i = 1;
- while (codes.Contains(string.Format("{0} ({1})", code, i)))
- i++;
- var codeprop = CoreUtils.GetFullPropertyName(codefield, ".");
- CoreUtils.SetPropertyValue(item, codeprop, string.Format("{0} ({1})", code, i));
- }
- var grid = new DynamicDataGrid<TEntity>();
- return grid.EditItems(new[] { item }, t => children.ContainsKey(t) ? children[t] : null, true);
- }
- private bool DoFilter(Button button, CoreRow[] rows)
- {
- var menu = new ContextMenu();
- var none = new MenuItem { Header = "Clear Filters", Tag = null };
- none.Click += Filter_Click;
- menu.Items.Add(none);
- var tag = GetTag();
- var filters = new GlobalConfiguration<DynamicGridFilters>(tag).Load();
- foreach(var filter in filters)
- {
- var item = new MenuItem { Header = filter.Name, Tag = filter };
- if(Filter?.Item1 == filter.Name)
- {
- item.IsChecked = true;
- }
- item.Click += Filter_Click;
- menu.Items.Add(item);
- }
- if (Security.IsAllowed<CanCustomiseFilters>())
- {
- menu.Items.Add(new Separator());
- var manage = new MenuItem { Header = "Manage Filters" };
- manage.Click += (s, e) =>
- {
- var window = new DynamicGridFilterEditor(filters, typeof(TEntity));
- if(window.ShowDialog() == true)
- {
- new GlobalConfiguration<DynamicGridFilters>(tag).Save(filters);
- }
- };
- menu.Items.Add(manage);
- }
- menu.IsOpen = true;
- return false;
- }
- private void Filter_Click(object sender, RoutedEventArgs e)
- {
- var tag = (sender as MenuItem)?.Tag;
- Bitmap image;
- if(tag is DynamicGridFilter filter)
- {
- Filter = new(filter.Name, Serialization.Deserialize<Filter<TEntity>>(filter.Filter));
- image = Properties.Resources.filter_set;
- }
- else
- {
- Filter = null;
- image = Properties.Resources.filter;
- }
- UpdateButton(FilterBtn, image.AsBitmapImage(), "");
- Refresh(false, true);
- }
- private bool DoMerge(Button arg1, CoreRow[] arg2)
- {
- if (arg2 == null || arg2.Length <= 1)
- return false;
- var targetid = arg2.Last().Get<TEntity, Guid>(x => x.ID);
- var target = arg2.Last().ToObject<TEntity>().ToString();
- var otherids = arg2.Select(r => r.Get<TEntity, Guid>(x => x.ID)).Where(x => x != targetid).ToArray();
- string[] others = arg2.Where(r => otherids.Contains(r.Get<Guid>("ID"))).Select(x => x.ToObject<TEntity>().ToString()!).ToArray();
- var rows = arg2.Length;
- if (MessageBox.Show(
- string.Format(
- "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?",
- string.Join("\n- ", others),
- target
- ),
- "Merge Items Warning",
- MessageBoxButton.YesNo,
- MessageBoxImage.Stop) != MessageBoxResult.Yes
- )
- return false;
- using (new WaitCursor())
- {
- var types = CoreUtils.TypeList(
- AppDomain.CurrentDomain.GetAssemblies(),
- x =>
- x.IsClass
- && !x.IsGenericType
- && x.IsSubclassOf(typeof(Entity))
- && !x.Equals(typeof(AuditTrail))
- && !x.Equals(typeof(TEntity))
- ).ToArray();
- foreach (var type in types)
- {
- var props = CoreUtils.PropertyList(
- type,
- x =>
- x.PropertyType.GetInterfaces().Contains(typeof(IEntityLink))
- && x.PropertyType.GetInheritedGenericTypeArguments().Contains(typeof(TEntity))
- ).ToArray();
- foreach (var prop in props)
- {
- var propname = string.Format(prop.Name + ".ID");
- var filter = Core.Filter.Create(type);
- filter.Expression = CoreUtils.CreateMemberExpression(type, propname);
- filter.Operator = Operator.InList;
- filter.Value = otherids;
- var columns = Columns.Create(type)
- .Add("ID")
- .Add(propname);
- var updates = ClientFactory.CreateClient(type).Query(filter, columns).Rows.Select(r => r.ToObject(type)).ToArray();
- if (updates.Any())
- {
- foreach (var update in updates)
- CoreUtils.SetPropertyValue(update, propname, targetid);
- ClientFactory.CreateClient(type).Save(updates,
- string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
- }
- }
- }
- var histories = new Client<AuditTrail>()
- .Query(new Filter<AuditTrail>(x => x.EntityID).InList(otherids), new Columns<AuditTrail>(x => x.EntityID)).Rows
- .Select(x => x.ToObject<AuditTrail>()).ToArray();
- foreach (var history in histories)
- history.EntityID = targetid;
- if (histories.Any())
- new Client<AuditTrail>().Save(histories, "");
- var deletes = new List<TEntity>();
- foreach (var otherid in otherids)
- {
- var delete = new TEntity();
- CoreUtils.SetPropertyValue(delete, "ID", otherid);
- deletes.Add(delete);
- }
- ClientFactory.CreateClient(typeof(TEntity))
- .Delete(deletes, string.Format("Merged {0} Records", typeof(TEntity).EntityName().Split('.').Last()));
- return true;
- }
- }
- private bool DoDuplicate(Button arg1, CoreRow[] arg2)
- {
- var ids = ExtractValues(x => x.ID, Selection.Selected).ToArray();
- if (!ids.Any())
- {
- MessageBox.Show("Please select at least one record to duplicate!");
- return false;
- }
- var duplicator = (new TEntity() as IDuplicatable)?.GetDuplicator();
- if(duplicator is null)
- {
- MessageBox.Show($"Cannot duplicate {typeof(TEntity)}");
- return false;
- }
- duplicator.Duplicate(new Filter<TEntity>(x => x.ID).InList(ids));
- return true;
- }
- protected override bool BeforePaste(IEnumerable<TEntity> items, ClipAction action)
- {
- if (action == ClipAction.Copy)
- {
- foreach (var item in items)
- item.ID = Guid.Empty;
- return true;
- }
- return base.BeforePaste(items, action);
- }
- protected override void CustomiseExportFilters(Filters<TEntity> filters, CoreRow[] visiblerows)
- {
- base.CustomiseExportFilters(filters, visiblerows);
- var ids = visiblerows.Select(r => r.Get<TEntity, Guid>(c => c.ID)).ToArray();
- filters.Add(new Filter<TEntity>(x => x.ID).InList(ids));
- }
- protected override IEnumerable<Tuple<Type?, CoreTable>> LoadExportTables(Filters<TEntity> filter, IEnumerable<Tuple<Type, IColumns>> tableColumns)
- {
- var queries = new Dictionary<string, IQueryDef>();
- var columns = tableColumns.ToList();
- foreach (var table in columns)
- {
- var tableType = table.Item1;
- PropertyInfo? property = null;
- var m2m = CoreUtils.GetManyToMany(tableType, typeof(TEntity));
- IFilter? queryFilter = null;
- if (m2m != null)
- {
- property = CoreUtils.GetManyToManyThisProperty(tableType, typeof(TEntity));
- }
- else
- {
- var o2m = CoreUtils.GetOneToMany(tableType, typeof(TEntity));
- if (o2m != null)
- {
- property = CoreUtils.GetOneToManyProperty(tableType, typeof(TEntity));
- }
- }
- if (property != null)
- {
- var subQuery = new SubQuery<TEntity>();
- subQuery.Filter = filter.Combine();
- subQuery.Column = new Column<TEntity>(x => x.ID);
- queryFilter = (Activator.CreateInstance(typeof(Filter<>).MakeGenericType(tableType)) as IFilter)!;
- queryFilter.Expression = CoreUtils.GetMemberExpression(tableType, property.Name + ".ID");
- queryFilter.InQuery(subQuery);
- queries[tableType.Name] = new QueryDef(tableType)
- {
- Filter = queryFilter,
- Columns = table.Item2
- };
- }
- }
- var results = Client.QueryMultiple(queries);
- return columns.Select(x => new Tuple<Type?, CoreTable>(x.Item1, results[x.Item1.Name]));
- }
- }
- }
|