//common form processing routines
public void InitializeForm()
{
EnableFormControls();
this.txtDatabasePlatform.Text = _dbPlatform.ToString();
InitDatabaseObject();
if (this.ConnectionString.Trim().Length > 0)
{
InitPropertiesFromConnectionString();
}
else
{
NewConnectionDefinition();
}
SaveFormFields();
}
private void InitDbDef(DatabasePlatform dbPlatform)
{
int rowInx = 0;
int maxRowInx = _dbNamesAndLocations.GetLength(0) - 1;
_dbPlatform = dbPlatform;
_dbPlatformDesc = dbPlatform.ToString();
string configValue = AppConfig.GetStringValueFromConfigFile(_dbPlatformDesc, string.Empty);
if (configValue.Length > 0)
{
string[] parsedConfig = configValue.Split('|');
_dbNamespace = parsedConfig[0];
_dbClassName = parsedConfig[1];
_dbDllPath = parsedConfig[2];
}
else
{
for (rowInx = 0; rowInx <= maxRowInx; rowInx++)
{
if (_dbNamesAndLocations[rowInx, _dbPlatformDescInx].ToLower() == _dbPlatformDesc.ToLower())
{
_dbNamespace = _dbNamesAndLocations[rowInx, _dbNamespaceInx];
_dbClassName = _dbNamesAndLocations[rowInx, _dbClassNameInx];
_dbDllPath = _dbNamesAndLocations[rowInx, _dbDllPathInx];
}
}
}
}
//common form processing routines
public void InitializeForm()
{
_printer = new FormPrinter(this);
EnableFormControls();
SetHelpFileValues();
this.txtDatabasePlatform.Text = _dbPlatform.ToString();
this.cboEncryptionMode.Text = this.cboEncryptionMode.Items[0].ToString();
InitDatabaseObject();
if (this.ConnectionString.Trim().Length > 0)
{
InitPropertiesFromConnectionString();
}
else
{
NewConnectionDefinition();
}
SaveFormFields();
}
private PFConnectionDefinition BuildConnectionDefinition()
{
_connectionDefinition = new PFConnectionDefinition();
_connectionDefinition.DbPlatform = _dbPlatform;
_connectionDefinition.ConnectionName = _connectionName;
_connectionDefinition.ConnectionString = _connectionString;
_connectionDefinition.ProviderDefinition = _connectionManager.FindProvider(_dbPlatform.ToString());
_connectionDefinition.ConnectionAccessStatus = _connectionAccessStatus;
GetPlatformPropertiesAndKeys();
return(_connectionDefinition);
}
private PFDatabase InitDatabaseObject(DatabasePlatform dbPlat)
{
string connStr = string.Empty;
string nmSpace = string.Empty;
string clsName = string.Empty;
string dllPath = string.Empty;
PFDatabase db = null;
string configValue = AppConfig.GetStringValueFromConfigFile(dbPlat.ToString(), string.Empty);
if (configValue.Length > 0)
{
string[] parsedConfig = configValue.Split('|');
if (parsedConfig.Length != 3)
{
_msg.Length = 0;
_msg.Append("Invalid config entry items for ");
_msg.Append(_dbPlatform.ToString());
_msg.Append(". Number of items after parse: ");
_msg.Append(parsedConfig.Length.ToString());
_msg.Append(".");
throw new System.Exception(_msg.ToString());
}
nmSpace = parsedConfig[0];
clsName = parsedConfig[1];
dllPath = parsedConfig[2];
db = new PFDatabase(dbPlat.ToString(), dllPath, nmSpace + "." + clsName);
}
else
{
db = new PFDatabase(dbPlat);
}
return(db);
}//end method
}//end method
private PFDatabase GetPFDatabaseObject(DatabasePlatform dbPlat)
{
string dbPlatformDesc = DatabasePlatform.Unknown.ToString();
PFDatabase db = null;
string connStr = string.Empty;
string nmSpace = string.Empty;
string clsName = string.Empty;
string dllPath = string.Empty;
dbPlatformDesc = dbPlat.ToString();
string configValue = AppConfig.GetStringValueFromConfigFile(dbPlatformDesc, string.Empty);
if (configValue.Trim() == string.Empty)
{
_msg.Length = 0;
_msg.Append("Unable to find config entry for ");
_msg.Append(dbPlatformDesc);
throw new System.Exception(_msg.ToString());
}
string[] parsedConfig = configValue.Split('|');
if (parsedConfig.Length != 3)
{
_msg.Length = 0;
_msg.Append("Invalid config entry items for ");
_msg.Append(dbPlatformDesc);
_msg.Append(". Number of items after parse: ");
_msg.Append(parsedConfig.Length.ToString());
_msg.Append(".");
throw new System.Exception(_msg.ToString());
}
nmSpace = parsedConfig[0];
clsName = parsedConfig[1];
dllPath = parsedConfig[2];
db = new PFDatabase(dbPlatformDesc, dllPath, nmSpace + "." + clsName);
return(db);
}
private PFDatabase GetDbObject(DatabasePlatform dbPlatform, string dbConnectionString)
{
string dbPlatformDesc = DatabasePlatform.Unknown.ToString();
PFDatabase db = null;
string connStr = string.Empty;
string nmSpace = string.Empty;
string clsName = string.Empty;
string dllPath = string.Empty;
try
{
dbPlatformDesc = dbPlatform.ToString();
connStr = dbConnectionString;
string configValue = AppConfig.GetStringValueFromConfigFile(dbPlatformDesc, string.Empty);
string[] parsedConfig = configValue.Split('|');
nmSpace = parsedConfig[0];
clsName = parsedConfig[1];
dllPath = parsedConfig[2];
db = new PFDatabase(dbPlatformDesc, dllPath, nmSpace + "." + clsName);
db.ConnectionString = connStr;
db.OpenConnection();
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
Program._messageLog.WriteLine(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
}
finally
{
;
}
return(db);
}
private string GetConnectionString(DatabasePlatform dbPlat)
{
string connStr = string.Empty;
string configKey = "DefaultConnection_";
string dbPlatformDesc = DatabasePlatform.Unknown.ToString();
dbPlatformDesc = dbPlat.ToString();
configKey = configKey + dbPlatformDesc;
string configValue = AppConfig.GetStringValueFromConfigFile(configKey, string.Empty);
if (configValue.Trim() == string.Empty)
{
_msg.Length = 0;
_msg.Append("Unable to find config entry for ");
_msg.Append(configKey);
throw new System.Exception(_msg.ToString());
}
connStr = configValue;
return(connStr);
}
/// <summary>
/// Constructor.
/// </summary>
public PFProviderDefinition(DatabasePlatform databasePlatform)
{
_databasePlatform = databasePlatform;
_providerName = _databasePlatform.ToString();
}
/// <summary>
/// Allows deleting of connection definitions from list of saved definitions.
/// </summary>
/// <param name="dbPlat">Database platform for which the connections are defined.</param>
public void DeleteConnectionDefinition(DatabasePlatform dbPlat)
{
PFNameListDeleteListPrompt frm = null;
try
{
frm = new PFNameListDeleteListPrompt();
frm.Caption = "Delete Connection String Definition";
frm.ListBoxLabel = "Select one or more items to delete:";
frm.SourceFolder = Path.Combine(_connectionManager.ConnectionDefintionsLocation, dbPlat.ToString());
frm.ShowDialog();
frm.Close();
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
AppMessages.DisplayErrorMessage(_msg.ToString());
}
finally
{
frm = null;
}
}
/// <summary>
/// Allows renaming of connection definitions from list of saved definitions.
/// </summary>
/// <param name="dbPlat">Database platform for which the connections are defined.</param>
public void RenameConnectionDefinition(DatabasePlatform dbPlat)
{
PFNameListRenamePrompt frm = null;
try
{
frm = new PFNameListRenamePrompt();
frm.Caption = "Rename Connection String Definition";
frm.SourceFolder = Path.Combine(_connectionManager.ConnectionDefintionsLocation, dbPlat.ToString());
frm.ShowDialog();
frm.Close();
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append("FileRename on RandomBooleansForm failed.\r\n");
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
AppMessages.DisplayErrorMessage(_msg.ToString());
}
finally
{
frm = null;
}
}
/// <summary>
/// Retrieves connection definitions defined and saved by current user for the specified database platform.
/// </summary>
/// <param name="dbPlat">DatabasePlatform used in the connection strings to be retrieved.</param>
/// <returns>PFConnectionDefinition object.</returns>
public PFConnectionDefinition GetConnectionDefinition(DatabasePlatform dbPlat)
{
PFConnectionDefinition conndef = default(PFConnectionDefinition);
string pathToDefFiles = Path.Combine(_connectionManager.ConnectionDefintionsLocation, dbPlat.ToString());
PFNameListPrompt nlp = new PFNameListPrompt();
string[] conndefFiles = Directory.GetFiles(pathToDefFiles, "*.xml", SearchOption.AllDirectories);
if (conndefFiles.Length == 0)
{
_msg.Length = 0;
_msg.Append("Unabled to find any saved connection definitions in ");
_msg.Append(pathToDefFiles);
_msg.Append(".");
AppMessages.DisplayAlertMessage(_msg.ToString());
return(conndef);
}
nlp.Text = "Connection Definition Chooser ...";
nlp.lblSelect.Text = "Select connection definition to open from list below:";
foreach (string condefFile in conndefFiles)
{
string conndefName = Path.GetFileNameWithoutExtension(condefFile);
nlp.lstNames.Items.Add(conndefName);
}
DialogResult res = nlp.ShowDialog();
if (res == DialogResult.OK)
{
string selectedConnDefName = nlp.lstNames.SelectedItem.ToString();
conndef = PFConnectionDefinition.LoadFromXmlFile(Path.Combine(pathToDefFiles, selectedConnDefName + ".xml"));
}
return(conndef);
}
public void CopyAdventureWorksDW(DatabasePlatform sourceDbPlatform, string sourceConnection,
DatabasePlatform destinationDbPlatorm, string destinationConnection,
bool replaceExistingTables, int batchSizeForDataWrites, string outputTablesSchema)
{
PFDatabase sourceDb = null;
PFDatabase destinationDb = null;
Stopwatch sw = new Stopwatch();
try
{
_msg.Length = 0;
_msg.Append("CopyAdventureWorksDW started ...\r\n");
Program._messageLog.WriteLine(_msg.ToString());
sw.Start();
sourceDb = GetDbObject(sourceDbPlatform, sourceConnection);
if (sourceDb.IsConnected == false)
{
_msg.Length = 0;
_msg.Append("Unable to connect to source datatabase ");
_msg.Append(sourceDbPlatform.ToString());
_msg.Append(Environment.NewLine);
_msg.Append("Connection String: ");
_msg.Append(Environment.NewLine);
_msg.Append(sourceConnection);
throw new System.Exception(_msg.ToString());
}
destinationDb = GetDbObject(destinationDbPlatorm, destinationConnection);
if (destinationDb.IsConnected == false)
{
_msg.Length = 0;
_msg.Append("Unable to connect to destination datatabase ");
_msg.Append(destinationDbPlatorm.ToString());
_msg.Append(Environment.NewLine);
_msg.Append("Connection String: ");
_msg.Append(Environment.NewLine);
_msg.Append(destinationConnection);
throw new System.Exception(_msg.ToString());
}
_msg.Length = 0;
_msg.Append("Time to connect to databases: ");
_msg.Append(sw.FormattedElapsedTime);
Program._messageLog.WriteLine(_msg.ToString());
CopyTables(sourceDb, destinationDb, replaceExistingTables, batchSizeForDataWrites, outputTablesSchema);
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
Program._messageLog.WriteLine(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
}
finally
{
if (sourceDb.IsConnected)
{
sourceDb.CloseConnection();
}
sourceDb = null;
if (destinationDb.IsConnected)
{
destinationDb.CloseConnection();
}
destinationDb = null;
sw.Stop();
_msg.Length = 0;
_msg.Append("\r\n... CopyAdventureWorksDW finished.");
Program._messageLog.WriteLine(_msg.ToString());
_msg.Length = 0;
_msg.Append(Environment.NewLine);
_msg.Append("Elapsed copy time: ");
_msg.Append(sw.FormattedElapsedTime);
_msg.Append(Environment.NewLine);
Program._messageLog.WriteLine(_msg.ToString());
}
}
