public void PasteFailsInFilterGrid() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //filter first column tableView.Columns[0].FilterString = "[Name] Like 'Jaap%'"; //setup eventhandler for failed paste checking error message int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { Assert.AreEqual("Cannot paste into filtered tableview.", e.Value); callCount++; }; //action! paste in the first column.. tableView.SelectCells(0, 0, 0, 0); tableViewCopyPasteController.PasteLines(new[] { "kaas" }); //we should have failed Assert.AreEqual(1, callCount); }
public void PasteFailsOnSortedColumn() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //sort on the second column tableView.Columns[1].SortOrder = SortOrder.Ascending; //setup eventhandler for failed paste checking error message int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { Assert.AreEqual("Cannot paste into sorted column", e.Value); callCount++; }; //action! paste in the first column..second column is hit so should fail tableView.SelectCells(0, 0, 0, 0); tableViewCopyPasteController.PasteLines(new[] { "kaas\tmelk" }); //we should have failed Assert.AreEqual(1,callCount); }
public void UseValidatorToIgnorePaste() { var tableView = new TableView(); var tableWithTwoStrings = new DataTable(); tableWithTwoStrings.Columns.Add("Name", typeof(string)); tableWithTwoStrings.Columns.Add("B", typeof(string)); tableWithTwoStrings.Rows.Add("a", "b"); tableView.Data = tableWithTwoStrings; tableView.InputValidator += TableViewEditorValidator; var tableViewCopyPasteController = new TableViewPasteController(tableView); Assert.AreEqual("b", tableWithTwoStrings.Rows[0][1]); //select top right cell tableView.SelectCells(0, 1, 0, 1); // paste "c" and check result tableViewCopyPasteController.PasteLines(new[] { "c" }); Assert.AreEqual("c", tableWithTwoStrings.Rows[0][1]); // check paste of d fails tableViewCopyPasteController.PasteLines(new[] { "d" }); Assert.AreEqual("c", tableWithTwoStrings.Rows[0][1]); }
public void UseValidatorToIgnoreRow() { var tableView = new TableView(); var dataTable = new DataTable(); dataTable.Columns.Add("Alpha", typeof(string)); dataTable.Columns.Add("Numeric", typeof(int)); dataTable.Rows.Add("a", 1); tableView.Data = dataTable; tableView.PasteBehaviour = TableViewPasteBehaviourOptions.SkipRowWhenValueIsInvalid; tableView.InputValidator = (c, v) => { if (c.ColumnIndex == 0 && (v.ToString() == "b")) { return(new Utils.Tuple <string, bool>("b not allowed", false)); } return(new Utils.Tuple <string, bool>("", true)); }; var tableViewCopyPasteController = new TableViewPasteController(tableView); Assert.AreEqual(1, dataTable.Rows[0][1]); //select top left cell tableView.SelectCells(1, 0, 0, 0); // paste "c" and check result tableViewCopyPasteController.PasteLines(new[] { "b\t2", "c\t3" }); Assert.AreEqual(2, dataTable.Rows.Count); Assert.AreEqual("c", dataTable.Rows[1][0]); }
public void PastingIntoReadOnlyCellsDoesNotChangeTheValues() { var tableWithTwoStrings = new DataTable(); tableWithTwoStrings.Columns.Add("A", typeof(string)); tableWithTwoStrings.Columns.Add("B", typeof(string)); tableWithTwoStrings.Rows.Add("a", "b"); var tableView = new TableView { Data = tableWithTwoStrings }; //values in the first column are read only tableView.ReadOnlyCellFilter = delegate(TableViewCell cell) { return(cell.ColumnIndex == 0); }; //select top row tableView.SelectCells(0, 0, 0, 1); var tableViewCopyPasteController = new TableViewPasteController(tableView); //paste some non sense. tableViewCopyPasteController.PasteLines(new[] { "c\td" }); //only column b should have changed Assert.AreEqual("a", tableWithTwoStrings.Rows[0][0]); Assert.AreEqual("d", tableWithTwoStrings.Rows[0][1]); }
public void PasteFailsInFilterGrid() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //filter first column tableView.Columns[0].FilterString = "[Name] Like 'Jaap%'"; //setup eventhandler for failed paste checking error message int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { Assert.AreEqual("Cannot paste into filtered tableview.", e.Value); callCount++; }; //action! paste in the first column.. tableView.SelectCells(0, 0, 0, 0); tableViewCopyPasteController.PasteLines(new[] { "kaas" }); //we should have failed Assert.AreEqual(1, callCount); }
public void PasteTakesInvisibleColumnsIntoAccount() { //if a possible paste is too big it is important to not exceed the visiblecolcount - 1 var list = new BindingList <Person>() { new Person { Name = "jan", Age = 25 }, new Person { Name = "fon", Age = 33 }, new Person { Name = "peer", Age = 25 }, new Person { Name = "fo", Age = 33 } }; var tableView = new TableView { Data = list }; //hide the age column tableView.Columns[1].Visible = false; //select top left tableView.SelectCells(0, 0, 0, 0); var tableViewCopyPasteController = new TableViewPasteController(tableView); //paste some non sense tableViewCopyPasteController.PasteLines(new[] { "kees\tkan\twel" }); //first person should be kees now Assert.AreEqual("kees", list[0].Name); }
public void PasteFailsOnSortedColumn() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //sort on the second column tableView.Columns[1].SortOrder = SortOrder.Ascending; //setup eventhandler for failed paste checking error message int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { Assert.AreEqual("Cannot paste into sorted column", e.Value); callCount++; }; //action! paste in the first column..second column is hit so should fail tableView.SelectCells(0, 0, 0, 0); tableViewCopyPasteController.PasteLines(new[] { "kaas\tmelk" }); //we should have failed Assert.AreEqual(1, callCount); }
public void CopyPasteEnumInBindingList() { var list = new BindingList <ClassWithEnum> { new ClassWithEnum { Type = FruitType.Banaan }, new ClassWithEnum { Type = FruitType.Peer } }; var tableView = new TableView { Data = list }; var editor = DefaultTypeEditorFactory.CreateComboBoxTypeEditor(); editor.Items = Enum.GetValues(typeof(FruitType)); tableView.Columns[0].Editor = editor; var tableViewCopyPasteController = new TableViewPasteController(tableView); //select 2nd row tableView.SelectCells(1, 0, 1, 0); //paste twee bananen en een peer ;) tableViewCopyPasteController.PasteLines(new[] { "Banaan", "Banaan", "Peer" }); //we should have 3 bananas and a pear Assert.AreEqual("Banaan", "Banaan", "Banaan", "Peer", list.Select(c => c.Type).ToArray()); //WindowsFormsTestHelper.ShowModal(tableView); }
public void PasteFillsSelection() { var list = new BindingList <Person>() { new Person { Name = "jan", Age = 25 }, new Person { Name = "fon", Age = 33 }, new Person { Name = "peer", Age = 25 }, new Person { Name = "fo", Age = 33 } }; var tableView = new TableView { Data = list }; //select all cells in first column tableView.SelectCells(0, 0, 3, 0); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //this should set the first column to kees,anton,kees,anton tableViewCopyPasteController.PasteLines(new[] { "kees", "anton" }); //asert the names are now like this Assert.AreEqual(new[] { "kees", "anton", "kees", "anton" }, list.Select(p => p.Name).ToArray()); }
public void CopyPasteEnumInBindingList() { var list = new BindingList <ClassWithEnum> { new ClassWithEnum { Type = FruitType.Banaan }, new ClassWithEnum { Type = FruitType.Peer } }; var tableView = new TableView { Data = list }; tableView.SetEnumComboboxEditor(typeof(FruitType), 0); var tableViewCopyPasteController = new TableViewPasteController(tableView); //select 2nd row tableView.SelectCells(1, 0, 1, 0); //paste twee bananen en een peer ;) tableViewCopyPasteController.PasteLines(new[] { "Banaan", "Banaan", "Peer" }); //we should have 3 bananas and a pear Assert.AreEqual("Banaan", "Banaan", "Banaan", "Peer", list.Select(c => c.Type).ToArray()); }
public void PasteDoesNotAddNewRowsToSortedTableView() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //select the first cell of the second column tableView.SelectCells(0, 1, 0, 1); //sort fist column tableView.Columns[0].SortOrder = SortOrder.Ascending; //action paste a possible 3 lines tableViewCopyPasteController.PasteLines(new[] { "kaas\tmelk", "noot\tmies", "appel\tflap" }); //assert rowcount is still one..no new rows are added on a sorted grid Assert.AreEqual(1, tableView.RowCount); //make sure we did something Assert.AreEqual("kaas", tableView.GetCellValue(0, 1)); }
public void PasteDoesNotAddNewRowsToSortedTableView() { TableView tableView = GetTableViewWithTwoStringColumnsAndOneRow(); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //select the first cell of the second column tableView.SelectCells(0, 1, 0, 1); //sort fist column tableView.Columns[0].SortOrder = SortOrder.Ascending; //action paste a possible 3 lines tableViewCopyPasteController.PasteLines(new[] {"kaas\tmelk","noot\tmies","appel\tflap"}); //assert rowcount is still one..no new rows are added on a sorted grid Assert.AreEqual(1,tableView.RowCount); //make sure we did something Assert.AreEqual("kaas",tableView.GetRowCellValue(0,1)); }
public void PasteFailsIntoNonSquareSelection() { var list = new BindingList <Person>() { new Person { Name = "jan", Age = 25 }, new Person { Name = "fon", Age = 33 }, new Person { Name = "peer", Age = 25 }, new Person { Name = "fo", Age = 33 } }; var tableView = new TableView { Data = list }; //make a diagonal selection tableView.SelectedCells.Add(new TableViewCell(0, 0)); tableView.SelectedCells.Add(new TableViewCell(1, 1)); var tableViewCopyPasteController = new TableViewPasteController(tableView); int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { callCount++; Assert.AreEqual( "Cannot paste into non rectangular selection", e.Value); }; //this should a paste failed event tableViewCopyPasteController.PasteLines(new[] { "kees", "anton" }); Assert.AreEqual(1, callCount); }
public void PasteIntoARowSelection() { var tableWithTwoStrings = new DataTable(); tableWithTwoStrings.Columns.Add("A", typeof(string)); tableWithTwoStrings.Columns.Add("B", typeof(string)); tableWithTwoStrings.Rows.Add("a", "b"); var tableView = new TableView { Data = tableWithTwoStrings }; var tableViewCopyPasteController = new TableViewPasteController(tableView); //select top row tableView.SelectCells(0, 0, 0, 1); //paste some non sense. tableViewCopyPasteController.PasteLines(new[] { "c" }); //first line should now be [c c] Assert.AreEqual("c", tableWithTwoStrings.Rows[0][0]); Assert.AreEqual("c", tableWithTwoStrings.Rows[0][1]); }
public void PasteFillsSelection() { var list = new BindingList<Person>() { new Person {Name = "jan", Age = 25}, new Person {Name = "fon", Age = 33}, new Person {Name = "peer", Age = 25}, new Person {Name = "fo", Age = 33} }; var tableView = new TableView {Data = list}; //select all cells in first column tableView.SelectCells(0, 0, 3, 0); //hook up a copy paste controller var tableViewCopyPasteController = new TableViewPasteController(tableView); //this should set the first column to kees,anton,kees,anton tableViewCopyPasteController.PasteLines(new[] {"kees", "anton"}); //asert the names are now like this Assert.AreEqual(new[] {"kees", "anton", "kees", "anton"}, list.Select(p => p.Name).ToArray()); }
public void PasteIntoARowSelection() { var tableWithTwoStrings = new DataTable(); tableWithTwoStrings.Columns.Add("A", typeof(string)); tableWithTwoStrings.Columns.Add("B", typeof(string)); tableWithTwoStrings.Rows.Add("a", "b"); var tableView = new TableView { Data = tableWithTwoStrings }; var tableViewCopyPasteController = new TableViewPasteController(tableView); //select top row tableView.SelectCells(0, 0, 0, 1); //paste some non sense. tableViewCopyPasteController.PasteLines(new[] { "c" }); //first line should now be [c c] Assert.AreEqual("c", tableWithTwoStrings.Rows[0][0]); Assert.AreEqual("c", tableWithTwoStrings.Rows[0][1]); }
public void PastingIntoReadOnlyCellsDoesNotChangeTheValues() { var tableWithTwoStrings = new DataTable(); tableWithTwoStrings.Columns.Add("A", typeof(string)); tableWithTwoStrings.Columns.Add("B", typeof(string)); tableWithTwoStrings.Rows.Add("a", "b"); var tableView = new TableView { Data = tableWithTwoStrings }; //values in the first column are read only tableView.ReadOnlyCellFilter = delegate (TableViewCell cell) { return cell.ColumnIndex== 0; }; //select top row tableView.SelectCells(0, 0, 0, 1); var tableViewCopyPasteController = new TableViewPasteController(tableView); //paste some non sense. tableViewCopyPasteController.PasteLines(new[] { "c\td" }); //only column b should have changed Assert.AreEqual("a", tableWithTwoStrings.Rows[0][0]); Assert.AreEqual("d", tableWithTwoStrings.Rows[0][1]); }
public void PasteTakesInvisibleColumnsIntoAccount() { //if a possible paste is too big it is important to not exceed the visiblecolcount - 1 var list = new BindingList<Person>() { new Person {Name = "jan", Age = 25}, new Person {Name = "fon", Age = 33}, new Person {Name = "peer", Age = 25}, new Person {Name = "fo", Age = 33} }; var tableView = new TableView {Data = list}; //hide the age column tableView.Columns[1].Visible = false; //select top left tableView.SelectCells(0, 0, 0, 0); var tableViewCopyPasteController = new TableViewPasteController(tableView); //paste some non sense tableViewCopyPasteController.PasteLines(new[] {"kees\tkan\twel"}); //first person should be kees now Assert.AreEqual("kees", list[0].Name); }
public void CopyPasteEnumInBindingList() { var list = new BindingList<ClassWithEnum> { new ClassWithEnum{Type = FruitType.Banaan}, new ClassWithEnum{Type = FruitType.Peer} }; var tableView = new TableView { Data = list }; tableView.SetEnumComboboxEditor(typeof(FruitType),0); var tableViewCopyPasteController = new TableViewPasteController(tableView); //select 2nd row tableView.SelectCells(1,0,1,0); //paste twee bananen en een peer ;) tableViewCopyPasteController.PasteLines(new[]{"Banaan","Banaan","Peer" }); //we should have 3 bananas and a pear Assert.AreEqual("Banaan","Banaan","Banaan","Peer",list.Select(c=>c.Type).ToArray()); }
public void PasteFailsIntoNonSquareSelection() { var list = new BindingList<Person>() { new Person {Name = "jan", Age = 25}, new Person {Name = "fon", Age = 33}, new Person {Name = "peer", Age = 25}, new Person {Name = "fo", Age = 33} }; var tableView = new TableView { Data = list }; //make a diagonal selection tableView.SelectedCells.Add(new TableViewCell(0,0)); tableView.SelectedCells.Add(new TableViewCell(1, 1)); var tableViewCopyPasteController = new TableViewPasteController(tableView); int callCount = 0; tableViewCopyPasteController.PasteFailed += (s, e) => { callCount++; Assert.AreEqual( "Cannot paste into non rectangular selection", e.Value); }; //this should a paste failed event tableViewCopyPasteController.PasteLines(new[] { "kees", "anton" }); Assert.AreEqual(1,callCount); }