//Application routines
private void BuildConnectionString()
{
PFConnectionManager connMgr = null;
DatabasePlatform dbPlat = DatabasePlatform.Unknown;
ConnectionStringPrompt cp = null;
try
{
dbPlat = (DatabasePlatform)Enum.Parse(typeof(DatabasePlatform), this.cboDatabaseTypeForOutputTable.Text);
connMgr = new PFConnectionManager();
cp = new ConnectionStringPrompt(dbPlat, connMgr);
cp.ConnectionString = this.txtConnectionStringForOutputTable.Text;
System.Windows.Forms.DialogResult res = cp.ShowConnectionPrompt();
if (res == DialogResult.OK)
{
this.txtConnectionStringForOutputTable.Text = cp.ConnectionString;
}
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
WriteLogMessage(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
}
finally
{
;
}
}
private void DefineConnectionString(ComboBox cboDatabaseType, TextBox txtConnectionString)
{
PFConnectionManager connMgr = null;
DatabasePlatform dbPlat = DatabasePlatform.Unknown;
ConnectionStringPrompt cp = null;
if (cboDatabaseType.Text.Trim().Length == 0)
{
_msg.Length = 0;
_msg.Append("You must specify a database type before defining a connection string.");
AppMessages.DisplayWarningMessage(_msg.ToString());
return;
}
try
{
dbPlat = (DatabasePlatform)Enum.Parse(typeof(DatabasePlatform), cboDatabaseType.Text);
connMgr = new PFConnectionManager();
cp = new ConnectionStringPrompt(dbPlat, connMgr);
cp.ConnectionString = txtConnectionString.Text;
System.Windows.Forms.DialogResult res = cp.ShowConnectionPrompt();
if (res == DialogResult.OK)
{
txtConnectionString.Text = cp.ConnectionString;
}
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
Program._messageLog.WriteLine(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToErrorLog);
}
finally
{
;
}
}
public static void ShowConnectionPromptForm(MainForm frm)
{
PFConnectionManager connMgr = null;
DatabasePlatform dbPlat = DatabasePlatform.MSSQLServer;
bool runTests = false;
try
{
_msg.Length = 0;
_msg.Append("ShowConnectionPromptForm started ...\r\n");
Program._messageLog.WriteLine(_msg.ToString());
connMgr = new PFConnectionManager();
ConnectionStringPrompt cp = new ConnectionStringPrompt(dbPlat, connMgr);
System.Windows.Forms.DialogResult res = cp.ShowConnectionPrompt();
if (res == System.Windows.Forms.DialogResult.OK)
{
runTests = true;
_msg.Length = 0;
_msg.Append("Connection name: ");
_msg.Append(cp.ConnectionName);
_msg.Append(Environment.NewLine);
_msg.Append("Connection string: ");
_msg.Append(cp.ConnectionString);
_msg.Append(Environment.NewLine);
_msg.Append("Connection Definition: ");
_msg.Append(Environment.NewLine);
if (cp.ConnectionDefinition != null)
{
_msg.Append(cp.ConnectionDefinition.ToString());
_msg.Append(Environment.NewLine);
}
Program._messageLog.WriteLine(_msg.ToString());
}
else
{
_msg.Length = 0;
_msg.Append("User cancelled connection string request: ");
_msg.Append(res.ToString());
Program._messageLog.WriteLine(_msg.ToString());
}
if (runTests)
{
//cp.ConnectionDefinition.SaveToXmlFile(@"c:\temp\TestConnectionDefinition.xml");
//PFConnectionDefinition newCP = PFConnectionDefinition.LoadFromXmlFile(@"c:\temp\TestConnectionDefinition.xml");
//cp.ConnectionDefinition.ConnectionKeyElements.SaveToXmlFile(@"c:\temp\ConnectionKeyElements.xml");
//PFList<stKeyValuePair<string, string>> elementsList = cp.ConnectionDefinition.ConnectionKeyElements.ConvertThisToPFKeyValueListEx();
//elementsList.SaveToXmlFile(@"c:\temp\ConnectionKeyElements_PFList.xml");
//Program._messageLog.WriteLine(Environment.NewLine + "newCP TO STRING:" + Environment.NewLine + newCP.ToString() + Environment.NewLine + "END newCP TO STRING" + Environment.NewLine);
//PFKeyValueList<string, string> testlist = PFKeyValueList<string, string>.LoadFromXmlString(cp.ConnectionDefinition.DbPlatformConnectionStringProperties[15].Value);
//Program._messageLog.WriteLine(testlist.ToXmlString());
//cp.ConnectionDefinition.DbPlatformConnectionStringProperties.SaveToXmlFile(@"c:\temp\DbPlatformConnectionStringProperties.xml");
//Program._messageLog.WriteLine(Environment.NewLine + "-----------");
//string dumpOutput = PFObjectDumper.Write(cp, 0);
//Program._messageLog.WriteLine(dumpOutput);
//Program._messageLog.WriteLine(Environment.NewLine + "-----------");
//cp = null;
//newCP = null;
}
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
Program._messageLog.WriteLine(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
}
finally
{
_msg.Length = 0;
_msg.Append("\r\n... ShowConnectionPromptForm finished.");
Program._messageLog.WriteLine(_msg.ToString());
}
}
