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);
}
