public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
if (!SelectedColumns.Any())
{
yield return(new ValidationResult("Select the information that you wish to show in the report", new[] { "ReportColumns" }));
}
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
p.Add(string.Join(",", AndColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", AndColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", AndColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
return(p);
}
private void ThreadProc()
{
// Get DataTable from cache of contacts
DataTable table = ContactExtension.GetDataTableFromContacts();
Deduplication dedup = new Deduplication(new ProgressNotifyDelegate(OnProgress));
// Build columns list for deduplication
List <Column> columns = new List <Column>(table.Columns.Count);
Column column;
for (int i = 0; i < table.Columns.Count; i++)
{
column = new Column(table.Columns[i].ColumnName);
column.SearchIn = SelectedColumns.Contains(column.Name);
columns.Add(column);
}
// Search duplicates
DedupTable = dedup.SearchDuplicates(table, columns, null, SeacrhQuality.Normal,
_thresholdLevel, ReturnResults.DuplicatesOnly);
TotalDuplicates = "Total Duplicates: " + _dedupTable.Rows.Count;
ProgressBarVisibility = Visibility.Collapsed;
}
private void checkAll(object sender, EventArgs e)
{
for (int i = 0; i < SelectedColumns.Items.Count; i++)
{
SelectedColumns.SetItemChecked(i, true);
}
}
/// <summary>
/// Remove column from "selected" (and add to "available" list)
/// </summary>
/// <param name="column"></param>
private void RemoveColumn(GuiGridColumn column)
{
AvailableColumns.Add(column);
SelectedColumns.Remove(column);
SelectedAvailableColumn = column;
SelectedSelectedColumn = null;
}
/// <summary>
/// Selects the columns.
/// </summary>
/// <param name="columns">The columns.</param>
public void SelectColumns(params string[] columns)
{
foreach (var column in columns)
{
SelectedColumns.Add(column);
}
}
/// <summary>
/// Move all values from 'Columns' list box to 'Selected Columns' list box
/// </summary>
private void MoveAllFromColumnsToSelectedColumnsAction()
{
for (int i = 0; i < Columns.Count;)
{
SelectedColumns.Add(Columns.ElementAt(i));
Columns.RemoveAt(i);
}
}
/// <summary>
/// Move selected values form 'Columns' list box to 'Selected Columns' list box
/// </summary>
private void MoveFromColumnsToSelectedColumnsAction()
{
for (int i = 0; i < _selectedInColumns.Count;)
{
SelectedColumns.Add(_selectedInColumns.ElementAt(i));
Columns.Remove(_selectedInColumns.ElementAt(i));
}
}
private string BuildSelectClause()
{
return(string.Join(",", SelectedColumns.Select(s =>
{
var tableName = (string.IsNullOrWhiteSpace(s.TableName) || s.TableName == FromTableName) ? FromTableAlias : s.TableName;
return $"[{tableName}].[{s.ColumnName}] AS [{s.AliasName}]";
})));
}
public void MoveSelectedDown()
{
var item1 = SelectedVisibleColumn;
var item2 = SelectedColumns[SelectedColumns.IndexOf(item1) + 1];
SelectedColumns.Swap(item1, item2);
SelectedVisibleColumn = item1;
}
/// <inheritdoc />
public ISelectStringBuilder AddSelect(params string[] columnNames)
{
foreach (var column in columnNames)
{
SelectedColumns.Add(column);
}
return(this);
}
/// <summary>
/// Move all values from 'Selected Columns' list box to 'Columns' list box
/// </summary>
private void MoveAllFromSelectedColumnsToColumnsAction()
{
for (int i = 0; i < SelectedColumns.Count;)
{
Columns.Add(SelectedColumns.ElementAt(i));
SelectedColumns.RemoveAt(i);
}
}
private void OnSelectedColumnsChange(bool invoke = true)
{
SelectedColumns.Clear();
SelectedColumns.AddRange(_columnsSelected.Select(i => i.First));
if (invoke)
{
SelectedColumnsCountChange?.Invoke();
}
}
private void OnSelectedColumnsChange(bool invoke = true)
{
SelectedColumns.RemoveWhere(c => !c.IsMandatory);
SelectedColumns.AddRange(_columnsSelected.Where(c => !c.IsMandatory));
if (invoke)
{
SelectedColumnsCountChange.SafeInvoke();
}
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.KindCount).ToArray()));
p.Add(FilterValue.ToString());
return(p);
}
public void Remove()
{
var selected = SelectedColumns.Where(c => c.IsSelected).ToArray();
foreach (var item in selected)
{
SelectedColumns.Remove(item);
item.IsSelected = false;
AvailableColumns.Add(item);
}
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(ResultColumn.Name.ToUpper());
p.Add(ResultColumn.Rem);
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.KindCount).ToArray()));
p.Add(DataType_ClassMethod.ToString());
return(p);
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
p.Add(jyfield.ToString());
p.Add(jzfield.ToString());
if (IsSelectGroup > 0)
{
p.Add("1");
p.Add(GroupingColumn.Name.ToUpper() + "|" +
string.Join("|", GroupingColumn.GroupingTags.Select(c => GroupingColumn.Name.ToUpper() + "." + c.Index).ToArray()));
//p.Add(GroupingColumn.Name.ToUpper());
p.Add(GroupingColumn.Rem + "|" +
string.Join("|", GroupingColumn.GroupingTags.Select(c => " " + c.Index).ToArray()));
//p.Add(GroupingColumn.Rem.ToUpper());
}
else
{
p.Add("0");
}
//var sbName = new List<string>();
//sbName.Add(GroupingColumn.Name.ToUpper());
//foreach (var item in GroupingTags)
//{
// sbName.Add(GroupingColumn.Name + "." + item.Index);
//}
//var sbLabel = new List<string>();
//sbLabel.Add(GroupingColumn.Rem);
//foreach (var item in GroupingTags)
//{
// sbLabel.Add(" " + item.Name);
//}
//p.Add(string.Join("|", sbName));
//p.Add(string.Join("|", sbLabel));
return(p);
}
public void Reset()
{
while (SelectedColumns.Count > 0)
{
AvailableColumns.Add(SelectedColumns[0]);
SelectedColumns.RemoveAt(0);
}
foreach (var column in DefaultColumns)
{
AvailableColumns.Remove(column);
SelectedColumns.Add(column);
}
}
public void MoveDown()
{
if (SelectedColumns.Count == 0 || SelectedColumns.Last().IsSelected)
{
return;
}
var selected = SelectedColumns.Where(c => c.IsSelected).Reverse().ToArray();
foreach (var item in selected)
{
var index = SelectedColumns.IndexOf(item);
SelectedColumns.RemoveAt(index);
SelectedColumns.Insert(index + 1, item);
}
}
public void HideColumn()
{
var oldIndex = SelectedColumns.IndexOf(SelectedVisibleColumn);
int newIndex = oldIndex;
if (newIndex >= (SelectedColumns.Count - 1))
{
--newIndex;
}
var col = SelectedVisibleColumn;
SelectedVisibleColumn = null;
col.Visible = false;
SelectedVisibleColumn = (newIndex >= 0) ? SelectedColumns[newIndex] : null;
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.KindCount).ToArray()));
foreach (var item in RelativeColumns)
{
p.Add(item.DistroType);
p.Add(item.LinkFunction);
}
p.Add(string.Join(",", RelativeColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", RelativeColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", RelativeColumns.Select(c => c.KindCount).ToArray()));
p.Add(jyField.ToString());
return(p);
}
protected override void OnPropertyChanged(DependencyPropertyChangedEventArgs e)
{
base.OnPropertyChanged(e);
if (e.Property == HeaderHeightProperty)
{
PositionHeaderCells(ActualWidth);
}
if (e.Property == RowHeightProperty)
{
PositionRows(ActualWidth);
}
if (e.Property == ItemsProperty)
{
InvalidateRows();
PositionRows(ActualWidth);
}
if (e.Property == ActualWidthProperty || e.Property == ActualHeightProperty)
{
PositionRows(ActualWidth);
PositionHeaderCells(ActualWidth);
PositionScroll(ActualWidth);
}
if (e.Property == SelectedItemProperty)
{
SetSelection(new[] { SelectedItem }, null, null, null);
}
if (e.Property == SelectedItemsProperty)
{
SetSelection(SelectedItems.ToArray(), null, null, null);
}
if (e.Property == SelectedRowsProperty)
{
SetSelection(null, SelectedRows.ToArray(), null, null);
}
if (e.Property == SelectedColumnsProperty)
{
SetSelection(null, null, SelectedColumns.ToArray(), null);
}
if (e.Property == SelectedCellsProperty)
{
SetSelection(null, null, null, SelectedCells.ToArray());
}
}
private void AddinList_SelectedIndexChanged(object sender, EventArgs e)
{
grid.DataSource = null;
SelectedColumns.Items.Clear();
if (AddinList.SelectedIndex == 0)
{
}
else
{
grid.DataSource = Helper.Instance.GetDataSource((AddinList.SelectedItem as AddinView).Addin.DataControl);
SelectedColumns.Items.Clear();
foreach (DataGridViewColumn column in grid.Columns)
{
SelectedColumns.Items.Add(column.Name);
SelectedColumns.SetItemChecked(SelectedColumns.Items.Count - 1, true);
}
}
}
public ColumnSelectorVM(IEnumerable <GuiGridColumn> columns, OnSaveDelegate onSave)
{
_onSave = onSave;
CloseCommand = new DelegateCommand(
o => true,
o => CloseAction()
);
SaveCommand = new DelegateCommand(
o => true,
o => Save()
);
UpColumnCommand = new DelegateCommand(
o => SelectedSelectedColumn != null && SelectedColumns.IndexOf(SelectedSelectedColumn) > 0,
o => UpColumn(SelectedSelectedColumn)
);
DownColumnCommand = new DelegateCommand(
o => SelectedSelectedColumn != null && SelectedColumns.IndexOf(SelectedSelectedColumn) < SelectedColumns.Count - 1,
o => DownColumn(SelectedSelectedColumn)
);
AddColumnCommand = new DelegateCommand(
o => SelectedAvailableColumn != null,
o => AddColumn(SelectedAvailableColumn)
);
RemoveColumnCommand = new DelegateCommand(
o => SelectedSelectedColumn != null,
o => RemoveColumn(SelectedSelectedColumn)
);
ResetDefaultsCommand = new DelegateCommand(
o => true,
o => ResetDefaults()
);
SetColumns(columns);
}
private void AddinList_SelectedIndexChanged(object sender, EventArgs e)
{
if (AddinList.SelectedIndex == 0) // Open from CSV File
{
DataTable table = SquadronHelper.Instance.GetDataTableFromCSV();
if (table != null)
{
SelectedColumns.Items.Clear();
foreach (DataColumn c in table.Columns)
{
SelectedColumns.Items.Add(c.ColumnName);
}
grid.DataSource = table;
}
}
else
{
OpenFromGrid();
}
for (int i = 0; i < SelectedColumns.Items.Count; i++)
{
SelectedColumns.SetItemChecked(i, true);
}
if (grid.DataSource != null)
{
if (grid.DataSource is DataTable)
{
InfoLabel.Text = (grid.DataSource as DataTable).Rows.Count.ToString() + " rows";
}
else
{
InfoLabel.Text = grid.Rows.Count.ToString() + " rows";
}
}
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
List <string> nameList = new List <string>();
foreach (var item in SelectedColumns)
{
nameList.Add(item.Name.ToUpper() + "|" +
string.Join("|", item.GroupingTags.Select(c => item.Name.ToUpper() + "." + c.Index).ToArray()));
}
p.Add(string.Join("|", nameList.ToArray()));
List <string> remList = new List <string>();
foreach (var item in SelectedColumns)
{
remList.Add(item.Rem + "|" +
string.Join("|", item.GroupingTags.Select(c => " " + c.Index).ToArray()));
}
p.Add(string.Join("|", remList.ToArray()));
//p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
//p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
p.Add(rytxt);
return(p);
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
var sbName = new List <string>();
sbName.Add(GroupingColumn.Name.ToUpper());
foreach (var item in GroupingTags)
{
sbName.Add(GroupingColumn.Name.ToUpper() + "." + item.Index);
}
var sbLabel = new List <string>();
sbLabel.Add(GroupingColumn.Rem);
foreach (var item in GroupingTags)
{
sbLabel.Add(" " + item.Name);
}
p.Add(string.Join("|", sbName));
p.Add(string.Join("|", sbLabel));
p.Add(bzField.ToString());
p.Add(jyField.ToString());
return(p);
}
/// <summary>
/// Build columns list for available and selected boxes
/// </summary>
/// <param name="selectedColumns"></param>
private void SetColumns(IEnumerable <GuiGridColumn> selectedColumns)
{
AvailableColumns.Clear();
foreach (var col in EventDefinition.Instance.Columns)
{
var item = selectedColumns.FirstOrDefault(x => x.ColumnType == col.ColumnType) ??
new GuiGridColumn()
{
ColumnType = col.ColumnType,
Width = 100
};
AvailableColumns.Add(item);
}
// when adding selected column they will be auto-removed from "available" list
SelectedColumns.Clear();
foreach (var item in selectedColumns)
{
AddColumn(item);
}
SelectedSelectedColumn = SelectedAvailableColumn = null;
}
private List <string> GetParameterReady()
{
List <string> p = new List <string>();
p.Add(string.Join(",", SelectedColumns.Select(c => c.Name.ToUpper()).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c => c.Rem).ToArray()));
p.Add(string.Join(",", SelectedColumns.Select(c =>
{
if (c.IsContinuous)
{
return("0");
}
else
{
return(c.KindCount.ToString());
}
}).ToArray()));
p.Add(GroupingColumn.Name.ToUpper());
p.Add(GroupingColumn.Rem);
p.Add(scField.ToString());
p.Add(jqField.ToString());
p.Add(rowGroupSign.ToString());
if (rowGroupSign == 1)
{
p.Add(GroupingRowColumn.Name.ToUpper());
p.Add(GroupingRowColumn.Rem);
}
else
{
p.Add("NA");
p.Add("NA");
}
return(p);
}
