public void Start(DatabaseDialog databaseDialog, int whichDatabase, TableDialog tableDialog, int whichTable) { //Start the Control() method, and set returned value as option int option = Control(); switch (option) { case 0: //If --Print Table-- is selected print the table TablePrinter.Print(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 1: //If --Search in table-- is selected, print table only with content matching the search TableSearcher.Search(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 2: //If --Edit table-- is selected let user select the cell to edit TableEditor.SelectCell(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 3: //If --Add new row-- is selected start adding new row RowAdder.Add(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 4: //If --Add new column-- is selected start adding new column ColumnAdder.Add(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 5: //If --Delete column-- is selected let user select the column to delete ColumnDeleter.SelectColumn(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 6: //If --Delete row-- is selected let user select the row to delete RowDeleter.SelectRow(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 7: //If --Delete table-- is selected start deleting currently selected table TableDeleter.Delete(ConnectionString, ServerType, databaseDialog, whichDatabase, tableDialog, whichTable, this); break; case 8: //If --Return-- is selected return to the tableDialog tableDialog.Start(databaseDialog, whichDatabase, this); break; } }
public void TestRowDeleter_OneCell() { var operation = new RowDeleter(); operation.ColumnNameToFind = "b"; operation.DeleteRowsWhereValuesMatch = new Regex("^cat$"); using (var dt = new DataTable()) { dt.Columns.Add("a"); dt.Columns.Add("b"); dt.Rows.Add("cat", "cat"); dt.Rows.Add("dog", "dog"); dt.Rows.Add("cat", "dog"); var listener = new ToMemoryDataLoadEventListener(true); var result = operation.ProcessPipelineData(dt, listener, new GracefulCancellationToken()); Assert.AreEqual(2, result.Rows.Count); Assert.AreEqual("dog", result.Rows[0]["a"]); Assert.AreEqual("dog", result.Rows[0]["b"]); Assert.AreEqual("cat", result.Rows[1]["a"]); Assert.AreEqual("dog", result.Rows[1]["b"]); operation.Dispose(listener, null); var msg = listener.EventsReceivedBySender[operation].Single(); Assert.AreEqual(ProgressEventType.Warning, msg.ProgressEventType); Assert.AreEqual("Total RowDeleted operations for ColumnNameToFind 'b' was 1", msg.Message); } }
public void EditPrevOnFirst(int row, Key keyCode, Column colPrev, CellValueContiueEdit prevHandler, RowDeleter delHandler) { if (keyCode == Key.BackSpace) { delHandler(row); return; } if (row > 0) { row--; } EditPrev(row, keyCode, colPrev, prevHandler); }