/// <summary>
/// Creates DataTable containing the custom values specified in the RandomCustomValuesDataRequest definition.
/// </summary>
/// <param name="numRows">Number of output rows to generate.</param>
/// <param name="rdr">RandomCustomValuesDataRequest object contains the definition for the custom values.</param>
/// <param name="summaryDataTable">DataTable that will contain the summary values (i.e. how many times each value appears in the result table).</param>
/// <param name="showInstalledDatabaseProvidersOnly">Instructs custom values routines to only allow connections from the list installed database providers.</param>
/// <param name="defaultOutputDatabaseType">Default database type to show if user is prompted for connection information.</param>
/// <param name="defaultOutputDatabaseConnectionString">Default connection string to use if user is prompted for connection information.</param>
/// <param name="defaultDataGridExportFolder">Default folder for storing any output requested by user from the result grids that are displayed.</param>
/// <returns>ADO.NET DataTable containing the custom values.</returns>
/// <remarks>New set of values are generated and stored by this routine.</remarks>
public DataTable CreateRandomCustomValuesDataTable(int numRows,
RandomCustomValuesDataRequest rdr,
out DataTable summaryDataTable,
bool showInstalledDatabaseProvidersOnly,
string defaultOutputDatabaseType,
string defaultOutputDatabaseConnectionString,
string defaultDataGridExportFolder)
{
DataTable summaryTable = new DataTable();
DataListProcessor _appProcessor = new DataListProcessor();
DataTable listTable = null;
try
{
_appProcessor.ShowInstalledDatabaseProvidersOnly = showInstalledDatabaseProvidersOnly;
_appProcessor.DefaultOutputDatabaseType = defaultOutputDatabaseType;
_appProcessor.DefaultOutputDatabaseConnectionString = defaultOutputDatabaseConnectionString;
_appProcessor.GridExportFolder = defaultDataGridExportFolder;
summaryTable = _appProcessor.GetCustomRandomDataFile(rdr, numRows, false, false);
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append("Error in CreateRandomCustomValuesDataTable routine.\r\n");
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
throw new System.Exception(_msg.ToString());
}
finally
{
;
}
summaryDataTable = summaryTable;
listTable = CreateCustomValuesListTable(summaryTable);
return(listTable);
}
/// <summary>
/// Generates set of random names and associated locations. This routine allows the randomizer routines to display a grid with the output before returning with the result.
/// </summary>
/// <param name="numRows">Number of names to generate.</param>
/// <param name="rdr">RandomNamesAndLocationsDataRequest object containing the definition to use for the name and location generation.</param>
/// <param name="showInstalledDatabaseProvidersOnly">Show list of installed data providers only if the user is shown an output grid and wants to manually export the list to external storage.</param>
/// <param name="defaultOutputDatabaseType">Default database to show if user is prompted for connection information.</param>
/// <param name="defaultOutputDatabaseConnectionString">Default connection string to show if user is prompted for connection information.</param>
/// <param name="defaultDataGridExportFolder">Default export file folder to use if user is exporting data from a grid displaying the random names/locations output.</param>
/// <returns>ADO.NET DataTable containing the set of random names and locations.</returns>
public DataTable CreateRandomNamesAndLocationsDataTable(int numRows,
RandomNamesAndLocationsDataRequest rdr,
bool showInstalledDatabaseProvidersOnly,
string defaultOutputDatabaseType,
string defaultOutputDatabaseConnectionString,
string defaultDataGridExportFolder)
{
DataTable dt = new DataTable();
DataListProcessor _appProcessor = new DataListProcessor();
try
{
_appProcessor.ShowInstalledDatabaseProvidersOnly = showInstalledDatabaseProvidersOnly;
_appProcessor.DefaultOutputDatabaseType = defaultOutputDatabaseType;
_appProcessor.DefaultOutputDatabaseConnectionString = defaultOutputDatabaseConnectionString;
_appProcessor.GridExportFolder = defaultDataGridExportFolder;
dt = _appProcessor.GetRandomNamesList(rdr,
numRows,
false, //no output to xml file
rdr.RandomDataXmlFilesFolder,
rdr.ListName,
false); //no output to preview grid
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append("Error in CreateRandomNamesAndLocationsDataTable routine.\r\n");
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
throw new System.Exception(_msg.ToString());
}
finally
{
;
}
return(dt);
}
