MeetingItemTaskGrid.cs 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Threading;
  5. using System.Windows;
  6. using System.Windows.Controls;
  7. using System.Windows.Media.Imaging;
  8. using Comal.Classes;
  9. using InABox.Clients;
  10. using InABox.Core;
  11. using InABox.DynamicGrid;
  12. using InABox.WPF;
  13. using NPOI.OpenXmlFormats.Dml;
  14. namespace PRSDesktop
  15. {
  16. public class MeetingItemTaskGrid : DynamicDataGrid<MeetingItemKanban>
  17. {
  18. public Guid MeetingID { get; set; }
  19. public Guid MeetingItemID { get; set; }
  20. protected override void Init()
  21. {
  22. base.Init();
  23. HiddenColumns.Add(x => x.Kanban.Completed);
  24. ActionColumns.Add(new DynamicImageColumn(StatusImage));
  25. AddButton("", InABox.Wpf.Resources.add.AsBitmapImage(), AddTask);
  26. AddButton("", PRSDesktop.Resources.link.AsBitmapImage(), LinkTask);
  27. AddButton("", InABox.Wpf.Resources.pencil.AsBitmapImage(), EditTask);
  28. AddButton("Copy From", null, CopyTasks);
  29. AddButton("", InABox.Wpf.Resources.delete.AsBitmapImage(), DeleteTask, DynamicGridButtonPosition.Right);
  30. }
  31. protected override void DoReconfigure(DynamicGridOptions options)
  32. {
  33. base.DoReconfigure(options);
  34. options.Clear();
  35. options.RecordCount = true;
  36. }
  37. private bool CopyTasks(Button arg1, CoreRow[] arg2)
  38. {
  39. var dlg = new MultiSelectDialog<Meeting>(
  40. new Filter<Meeting>(x=>x.ID).IsNotEqualTo(MeetingID),
  41. Columns.None<Meeting>().Add(x=>x.ID, x=>x.Number, x=>x.Date, x=>x.Time.Finish),
  42. false
  43. );
  44. if (dlg.ShowDialog() == true)
  45. {
  46. var meeting = dlg.Items().FirstOrDefault();
  47. if (meeting != null)
  48. {
  49. using (new WaitCursor())
  50. {
  51. var compfilter = new Filter<MeetingItemKanban>(x => x.Entity.Meeting.ID).IsEqualTo(meeting.ID);
  52. compfilter = compfilter.And(new Filter<MeetingItemKanban>(x => x.Kanban.Completed).IsEqualTo(DateTime.MinValue)
  53. .Or(x => x.Kanban.Completed).IsGreaterThanOrEqualTo(meeting.Date.Add(meeting.Time.Finish))
  54. );
  55. var tasks = new Client<MeetingItemKanban>().Query(
  56. compfilter,
  57. Columns.None<MeetingItemKanban>().Add(x => x.Kanban.ID)
  58. .Add(x => x.Entity.ID)
  59. ).Rows.Select(r => r.ToObject<MeetingItemKanban>());
  60. List<MeetingItemKanban> miks = new List<MeetingItemKanban>();
  61. foreach (MeetingItemKanban task in tasks)
  62. {
  63. MeetingItemKanban mik = new MeetingItemKanban();
  64. mik.Kanban.ID = task.Kanban.ID;
  65. mik.Entity.ID = MeetingItemID;
  66. miks.Add(mik);
  67. }
  68. if (miks.Any())
  69. {
  70. new Client<MeetingItemKanban>().Save(miks, $"Copied from Meeting #{meeting.Number}");
  71. DoChanged();
  72. return true;
  73. }
  74. }
  75. }
  76. }
  77. return false;
  78. }
  79. protected override DynamicGridColumns LoadColumns()
  80. {
  81. return new DynamicGridColumns()
  82. {
  83. new DynamicGridColumn()
  84. {
  85. ColumnName = CoreUtils.GetFullPropertyName<MeetingItemKanban, int>(x => x.Kanban.Number, "."),
  86. Width = 50
  87. },
  88. new DynamicGridColumn()
  89. {
  90. ColumnName = CoreUtils.GetFullPropertyName<MeetingItemKanban, String>(x => x.Kanban.Title, "."),
  91. Width = 0
  92. },
  93. new DynamicGridColumn()
  94. {
  95. ColumnName = CoreUtils.GetFullPropertyName<MeetingItemKanban, String>(x => x.Kanban.EmployeeLink.Code, "."),
  96. Width = 100
  97. }
  98. };
  99. }
  100. private readonly BitmapImage _status = PRSDesktop.Resources.tick.AsBitmapImage();
  101. private BitmapImage? StatusImage(CoreRow? arg)
  102. {
  103. return arg == null
  104. ? _status
  105. : arg.Get<MeetingItemKanban, DateTime>(c => c.Kanban.Completed).IsEmpty()
  106. ? null
  107. : _status;
  108. }
  109. private bool AddTask(Button arg1, CoreRow[] arg2)
  110. {
  111. if (MeetingItemID == Guid.Empty)
  112. return false;
  113. var kg = DynamicGridUtils.CreateDynamicGrid(typeof(DynamicDataGrid<>), typeof(Kanban));
  114. kg.OnAfterSave += (editor, items) =>
  115. {
  116. List<MeetingItemKanban> miks = new List<MeetingItemKanban>();
  117. foreach (Kanban item in items.Cast<Kanban>())
  118. {
  119. MeetingItemKanban mik = new MeetingItemKanban();
  120. mik.Kanban.ID = item.ID;
  121. mik.Entity.ID = MeetingItemID;
  122. miks.Add(mik);
  123. }
  124. new Client<MeetingItemKanban>().Save(miks, "");
  125. };
  126. var kanban = new Kanban();
  127. if (kg.EditItems(new Kanban[] { kanban }) == true)
  128. {
  129. DoChanged();
  130. return true;
  131. }
  132. return false;
  133. }
  134. private bool LinkTask(Button arg1, CoreRow[] arg2)
  135. {
  136. if (MeetingItemID == Guid.Empty)
  137. return false;
  138. var dlg = new MultiSelectDialog<Kanban>(
  139. new Filter<Kanban>(x => x.Completed).IsEqualTo(DateTime.MinValue),
  140. Columns.None<Kanban>().Add(x=>x.ID),
  141. true
  142. );
  143. if (dlg.ShowDialog() != true)
  144. return false;
  145. if (!dlg.IDs().Any())
  146. return false;
  147. var miks = new List<MeetingItemKanban>();
  148. foreach (var id in dlg.IDs())
  149. {
  150. var mik = new MeetingItemKanban();
  151. mik.Entity.ID = MeetingItemID;
  152. mik.Kanban.ID = id;
  153. miks.Add(mik);
  154. }
  155. new Client<MeetingItemKanban>().Save(miks, "Added To Meeting");
  156. DoChanged();
  157. return true;
  158. }
  159. private bool EditTask(Button arg1, CoreRow[] arg2)
  160. {
  161. if (MeetingItemID == Guid.Empty)
  162. return false;
  163. if (!SelectedRows.Any())
  164. return false;
  165. var ids = SelectedRows.ToArray().Select(r=>r.Get<MeetingItemKanban,Guid>(x=>x.Kanban.ID)).ToArray();
  166. var kanbans = new Client<Kanban>().Load(new Filter<Kanban>(x => x.ID).InList(ids));
  167. var kg = DynamicGridUtils.CreateDynamicGrid(typeof(DynamicDataGrid<>), typeof(Kanban));
  168. if (kg.EditItems(kanbans) == true)
  169. {
  170. DoChanged();
  171. return true;
  172. }
  173. return false;
  174. }
  175. private bool DeleteTask(Button arg1, CoreRow[] arg2)
  176. {
  177. if (MeetingItemID == Guid.Empty)
  178. return false;
  179. if (!SelectedRows.Any())
  180. return false;
  181. if (MessageBox.Show("This will unlink the selected task from this meeting, but leave the task active.\n\nDo You wish to continue?",
  182. "Unlink Task", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
  183. return false;
  184. var ids = SelectedRows.ToArray().Select(r=>r.Get<MeetingItemKanban,Guid>(x=>x.ID)).ToArray();
  185. var miks = ids.Select(x => new MeetingItemKanban() { ID = x }).ToArray();
  186. new Client<MeetingItemKanban>().Delete(miks, "Removed from Meeting");
  187. DoChanged();
  188. return true;
  189. }
  190. protected override void Reload(
  191. Filters<MeetingItemKanban> criteria, Columns<MeetingItemKanban> columns, ref SortOrder<MeetingItemKanban>? sort,
  192. CancellationToken token, Action<CoreTable?, Exception?> action)
  193. {
  194. criteria.Add(MeetingItemID == Guid.Empty
  195. ? new Filter<MeetingItemKanban>(x=>x.Entity.ID).None()
  196. : new Filter<MeetingItemKanban>(x => x.Entity.ID).IsEqualTo(MeetingItemID));
  197. base.Reload(criteria, columns, ref sort, token, action);
  198. }
  199. }
  200. }