public async Task GetSampleValuesAsyncTest()
{
using (var dt = UnitTestStatic.GetDataTable(1000))
{
using (var dummy = new CustomProcessDisplay(UnitTestInitializeCsv.Token))
{
var reader = new DataTableWrapper(dt);
foreach (DataColumn col in dt.Columns)
{
var res = await DetermineColumnFormat.GetSampleValuesAsync(reader, 10,
new[] { col.Ordinal }, 10, "null",
dummy.CancellationToken);
if (col.ColumnName != "AllEmpty")
{
Assert.AreNotEqual(0, res[col.Ordinal].Values.Count, col.ColumnName);
}
else
{
Assert.AreEqual(0, res[col.Ordinal].Values.Count, col.ColumnName);
}
}
}
}
}
public void ApplyFiltersFilteredDataGridViewTest()
{
using (var fdgv = new FilteredDataGridView())
{
fdgv.ApplyFilters();
}
using (var fdgv = new FilteredDataGridView())
{
using (var comboBoxColumn = new DataGridViewComboBoxColumn())
{
comboBoxColumn.Items.AddRange(Color.Red, Color.Yellow, Color.Green);
comboBoxColumn.ValueType = typeof(Color);
}
var boolColumn = new DataGridViewCheckBoxColumn();
fdgv.Columns.Add(boolColumn);
fdgv.ApplyFilters();
}
using (var dt = UnitTestStatic.GetDataTable())
using (var filteredDataGridView = new FilteredDataGridView())
{
filteredDataGridView.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(filteredDataGridView);
frm.Show();
filteredDataGridView.ApplyFilters();
}
}
}
public void CopySelectedColumnsIntoClipboard()
{
Extensions.RunSTAThread(() =>
{
using (var dgv = new DataGridView())
{
dgv.AutoGenerateColumns = true;
using (var dt = UnitTestStatic.GetDataTable())
{
dgv.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(dgv);
frm.Show();
dgv.Columns[1].Selected = true;
dgv.Columns[2].Selected = true;
try
{
Clipboard.Clear();
var cp = new DataGridViewCopyPaste(UnitTestInitializeWin.HTMLStyle);
cp.SelectedDataIntoClipboard(dgv, true, false, UnitTestInitializeCsv.Token);
var dataObject = Clipboard.GetDataObject();
Assert.IsNotNull(dataObject);
Assert.IsNotNull(dataObject.GetData(DataFormats.Text));
}
catch (ExternalException e)
{
Console.WriteLine(e);
Assert.Inconclusive(e.Message);
}
}
}
}
});
}
public async Task GetSourceColumnInformationTestAsync2()
{
using (var dt = UnitTestStatic.GetDataTable())
{
using (var reader = new DataTableWrapper(dt))
{
var fillGuessSettings = new FillGuessSettings
{
DetectNumbers = true,
DetectDateTime = true,
DetectPercentage = true,
DetectBoolean = true,
DetectGUID = true,
IgnoreIdColumns = true
};
//await reader.OpenAsync(processDisplay.CancellationToken);
var(information, columns) = await reader.FillGuessColumnFormatReaderAsyncReader(fillGuessSettings,
new ColumnCollection(), false, true, "<NULL>", UnitTestInitializeCsv.Token);
Assert.AreEqual(7, columns.Count(), "Recognized columns");
Assert.AreEqual(8, information.Count, "Information Lines");
var(information2, columns2) = await reader.FillGuessColumnFormatReaderAsyncReader(fillGuessSettings,
new ColumnCollection(), true, true, "<NULL>", UnitTestInitializeCsv.Token);
Assert.AreEqual(11, columns2.Count());
// Added 4 text columns,
Assert.AreEqual(11, information2.Count);
}
}
}
public async System.Threading.Tasks.Task ReStoreViewSettingDetailControlAsync()
{
using (var dt = UnitTestStatic.GetDataTable())
{
using (var dc = new DetailControl())
{
dc.HTMLStyle = UnitTestInitializeWin.HTMLStyle;
dc.DataTable = dt;
await dc.RefreshDisplayAsync(FilterType.All, UnitTestInitializeCsv.Token);
var columnFilters = new List <ToolStripDataGridViewColumnFilter>
{
new ToolStripDataGridViewColumnFilter(dc.FilteredDataGridView.Columns[0])
};
columnFilters[0].ColumnFilterLogic.Operator = "=";
columnFilters[0].ColumnFilterLogic.ValueText = "Halloween";
columnFilters[0].ColumnFilterLogic.Active = true;
var text = ViewSetting.StoreViewSetting(dc.FilteredDataGridView, columnFilters);
var fn = System.IO.Path.Combine(FileSystemUtils.ExecutableDirectoryName(), "test.delete");
FileSystemUtils.FileDelete(fn);
FileSystemUtils.WriteAllText(fn, text);
dc.ReStoreViewSetting(fn);
FileSystemUtils.FileDelete(fn);
}
}
}
public void HideEmptyColumnsTest()
{
using (var filteredDataGridView = new FilteredDataGridView())
{
var dt = UnitTestStatic.GetDataTable(100);
filteredDataGridView.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(filteredDataGridView);
frm.Show();
var numCol = 0;
foreach (DataGridViewColumn col in filteredDataGridView.Columns)
{
if (col.Visible)
{
numCol++;
}
}
Assert.AreEqual(numCol, dt.Columns.Count);
filteredDataGridView.HideEmptyColumns();
numCol = 0;
foreach (DataGridViewColumn col in filteredDataGridView.Columns)
{
if (col.Visible)
{
numCol++;
}
}
Assert.AreEqual(numCol + 1, dt.Columns.Count);
}
}
}
public void FormShowMaxLength()
{
using (var dataTable = UnitTestStatic.GetDataTable(60))
using (var form = new FormShowMaxLength(dataTable, dataTable.Select(), new List <string>(), UnitTestInitializeWin.HTMLStyle))
{
UnitTestWinFormHelper.ShowFormAndClose(form);
}
}
public void FormUniqueDisplay()
{
using (var dataTable = UnitTestStatic.GetDataTable(60))
using (var form = new FormUniqueDisplay(dataTable, dataTable.Select(), dataTable.Columns[0].ColumnName, UnitTestInitializeWin.HTMLStyle))
{
UnitTestWinFormHelper.ShowFormAndClose(form);
}
}
public void FrozenColumns()
{
using (var dt = UnitTestStatic.GetDataTable())
using (var filteredDataGridView = new FilteredDataGridView())
{
filteredDataGridView.DataSource = dt;
filteredDataGridView.FrozenColumns = 2;
UnitTestWinFormHelper.WaitSomeTime(.2, UnitTestInitializeCsv.Token);
}
}
public void HighlightText()
{
using (var dt = UnitTestStatic.GetDataTable())
using (var filteredDataGridView = new FilteredDataGridView())
{
filteredDataGridView.DataSource = dt;
filteredDataGridView.HighlightText = "ag";
UnitTestWinFormHelper.WaitSomeTime(.2, UnitTestInitializeCsv.Token);
Assert.AreEqual("", filteredDataGridView.CurrentFilter);
}
}
public void DynamicStorageSize()
{
Assert.AreEqual("500 Bytes",
UnitTestStatic.ExecuteWithCulture(() => StringConversion.DynamicStorageSize(500), "de-DE"));
Assert.AreEqual("1.95 kB",
UnitTestStatic.ExecuteWithCulture(() => StringConversion.DynamicStorageSize(2000), "en-US"));
Assert.AreEqual("9,77 kB",
UnitTestStatic.ExecuteWithCulture(() => StringConversion.DynamicStorageSize(10000), "de-DE"));
Assert.AreEqual("195,31 kB",
UnitTestStatic.ExecuteWithCulture(() => StringConversion.DynamicStorageSize(200000), "de-DE"));
Assert.AreEqual("1,91 MB",
UnitTestStatic.ExecuteWithCulture(() => StringConversion.DynamicStorageSize(2000000), "de-DE"));
}
public void SetRowHeightTest()
{
using (var filteredDataGridView = new FilteredDataGridView())
{
filteredDataGridView.DataSource = UnitTestStatic.GetDataTable(100);
using (var frm = new Form())
{
frm.Controls.Add(filteredDataGridView);
frm.Show();
filteredDataGridView.SetRowHeight();
}
}
}
public void DataGridViewColumnFilterControl()
{
using (var dataTable = UnitTestStatic.GetDataTable(60))
{
var col = new DataGridViewTextBoxColumn
{
ValueType = dataTable.Columns[0].DataType,
Name = dataTable.Columns[0].ColumnName,
DataPropertyName = dataTable.Columns[0].ColumnName
};
UnitTestWinFormHelper.ShowControl(new DataGridViewColumnFilterControl(col));
}
}
public void ToolStripDataGridViewColumnFilterTest()
{
var data = UnitTestStatic.GetDataTable(200);
var dataview = new DataView(data, null, null, DataViewRowState.CurrentRows);
var col = new DataGridViewTextBoxColumn()
{
ValueType = typeof(int),
Name = "int",
DataPropertyName = "int"
};
var test = new ToolStripDataGridViewColumnFilter(typeof(int), col);
Assert.AreEqual(true, test.ColumnFilterLogic.Active);
}
public void SelectedDataIntoClipboardTest()
{
using (var dgv = new DataGridView())
{
dgv.AutoGenerateColumns = true;
dgv.DataSource = UnitTestStatic.GetDataTable(100);
using (var frm = new Form())
{
frm.Controls.Add(dgv);
frm.Show();
dgv.SelectedDataIntoClipboard(true, false, CancellationToken.None);
}
}
}
public void GetActiveValueClusterTest()
{
var data = UnitTestStatic.GetDataTable(200);
var dataview = new DataView(data, null, null, DataViewRowState.CurrentRows);
var test0a = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test0a.BuildValueClusters(dataview, typeof(string), 0, 200));
Assert.AreEqual(0, test0a.GetActiveValueCluster().Count());
foreach (var iten in test0a.ValueClusters)
{
iten.Active = true;
}
Assert.AreEqual(test0a.ValueClusters.Count(), test0a.GetActiveValueCluster().Count());
}
public async Task GetSampleValuesAsync()
{
using (var dataTable = UnitTestStatic.GetDataTable(150, false))
{
using (var processDisplay = new CustomProcessDisplay(UnitTestInitializeCsv.Token))
{
using (var reader = new DataTableWrapper(dataTable))
{
var res = await DetermineColumnFormat
.GetSampleValuesAsync(reader, 100, new[] { 0, 1 }, 20, null, processDisplay.CancellationToken)
.ConfigureAwait(false);
Assert.AreEqual(20, res[0].Values.Count);
}
}
}
}
public void ToolStripDataGridViewColumnFilterTest()
{
using (var data = UnitTestStatic.GetDataTable(200))
using (new DataView(data, null, null, DataViewRowState.CurrentRows))
{
var col = new DataGridViewTextBoxColumn { ValueType = typeof(int), Name = "int", DataPropertyName = "int" };
var test = new ToolStripDataGridViewColumnFilter(col);
Assert.AreEqual(false, test.ColumnFilterLogic.Active);
test.ColumnFilterLogic.Active = true;
Assert.AreEqual(false, test.ColumnFilterLogic.Active);
test.ColumnFilterLogic.Operator = "=";
test.ColumnFilterLogic.ValueText = "2";
test.ColumnFilterLogic.Active = true;
Assert.AreEqual(true, test.ColumnFilterLogic.Active);
Assert.IsNotNull(test.ValueClusterCollection);
}
}
public void HideEmptyColumnsTest()
{
using (var filteredDataGridView = new FilteredDataGridView())
{
var dt = UnitTestStatic.GetDataTable();
filteredDataGridView.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(filteredDataGridView);
frm.Show();
var numCol = filteredDataGridView.Columns.Cast <DataGridViewColumn>().Count(col => col.Visible);
Assert.AreEqual(numCol, dt.Columns.Count);
filteredDataGridView.HideEmptyColumns();
numCol = filteredDataGridView.Columns.Cast <DataGridViewColumn>().Count(col => col.Visible);
Assert.AreEqual(numCol + 1, dt.Columns.Count);
}
}
}
public void FilteredDataGridViewVarious_SetFilterMenu()
{
using (var data = UnitTestStatic.GetDataTable(200))
using (var ctrl = new FilteredDataGridView())
{
UnitTestWinFormHelper.ShowControl(new FilteredDataGridView(), 0.5d,
(control, form) =>
{
if (!(control is FilteredDataGridView ctrl2))
{
return;
}
ctrl2.DataSource = data;
// Refresh all columns filters
for (int col = 0; col < data.Columns.Count; col++)
{
ctrl2.SetFilterMenu(col);
}
});
public void SelectedDataIntoClipboardAllTest()
{
Extensions.RunSTAThread(() =>
{
using (var dgv = new DataGridView())
{
dgv.AutoGenerateColumns = true;
using (var dt = UnitTestStatic.GetDataTable())
{
dgv.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(dgv);
frm.Show();
dgv.SelectAll();
var cp = new DataGridViewCopyPaste(UnitTestInitializeWin.HTMLStyle);
cp.SelectedDataIntoClipboard(dgv, true, false, UnitTestInitializeCsv.Token);
}
}
}
});
}
public void BuildValueClustersTest()
{
var data = UnitTestStatic.GetDataTable(200);
var dataview = new DataView(data, null, null, DataViewRowState.CurrentRows);
var test0a = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test0a.BuildValueClusters(dataview, typeof(string), 0, 200));
Assert.IsNotNull(test0a.ValueClusters);
var test0b = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.TooManyValues, test0b.BuildValueClusters(dataview, typeof(string), 0, 1));
Assert.AreEqual(0, test0b.ValueClusters.Count());
var test1 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test1.BuildValueClusters(dataview, typeof(int), 1, 200));
var test2 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test2.BuildValueClusters(dataview, typeof(DateTime), 2, 200));
var test3 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test3.BuildValueClusters(dataview, typeof(bool), 3, 2));
var test4 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test4.BuildValueClusters(dataview, typeof(double), 4, 200));
var test5 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test5.BuildValueClusters(dataview, typeof(decimal), 5, 200));
var test7 = new ValueClusterCollection();
Assert.AreEqual(BuildValueClustersResult.ListFilled, test7.BuildValueClusters(dataview, typeof(string), 7, 200));
}
public void ValueClusterCollection()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(int), "intCol");
using (var data = UnitTestStatic.GetDataTable(200))
{
using (var dataView = new DataView(data, null, null, DataViewRowState.CurrentRows))
{
columnFilterLogic.ValueClusterCollection.BuildValueClusters(dataView, typeof(int), 1);
var i = 0;
foreach (var cluster in columnFilterLogic.ValueClusterCollection.ValueClusters)
{
cluster.Active = true;
if (i++ > 2)
{
break;
}
}
columnFilterLogic.Active = true;
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
}
public void SelectedDataIntoClipboardTest()
{
Extensions.RunSTAThread(() =>
{
using (var dgv = new DataGridView())
{
dgv.AutoGenerateColumns = true;
using (var dt = UnitTestStatic.GetDataTable())
{
dgv.DataSource = dt;
using (var frm = new Form())
{
frm.Controls.Add(dgv);
frm.Show();
try
{
Clipboard.Clear();
var cp = new DataGridViewCopyPaste(UnitTestInitializeWin.HTMLStyle);
cp.SelectedDataIntoClipboard(dgv, true, false, UnitTestInitializeCsv.Token);
var dataObject = Clipboard.GetDataObject();
Assert.IsNotNull(dataObject);
Assert.IsNotNull(dataObject.GetData(DataFormats.Text));
}
catch (ExternalException)
{
Assert.Inconclusive("Exception thrown but this can happen");
}
catch (Exception ex)
{
Assert.Fail($"Wrong exception {ex.Message}");
}
}
}
}
});
}
public static void ClassInitialize(TestContext context)
{
m_Data = UnitTestStatic.GetDataTable(200);
m_DataView = new DataView(m_Data, null, null, DataViewRowState.CurrentRows);
}