private void SaveConnectionDefinition()
{
string tempConnectionString = string.Empty;
if (this.ConnectionName.Trim().Length == 0)
{
AppMessages.DisplayErrorMessage("You must specify a connection name.");
return;
}
if (this.ConnectionString.Trim().Length == 0)
{
this.ConnectionString = BuildConnectionString();
if (this.ConnectionString.Trim().Length == 0)
{
AppMessages.DisplayErrorMessage("You must specify connection properties and build a connection string.");
return;
}
}
else
{
tempConnectionString = BuildConnectionString();
if (this.ConnectionString != tempConnectionString)
{
_msg.Length = 0;
_msg.Append("One or more connection properties have changes since connection string was last built.\r\n");
_msg.Append("Do you want to rebuild the connection string before saving it?");
DialogResult res = AppMessages.DisplayMessage(_msg.ToString(), "Connection string save ...", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation);
if (res == DialogResult.Yes)
{
this.ConnectionString = tempConnectionString;
}
else
{
if (res == DialogResult.Cancel)
{
return;
}
else
{
//continue with save operation even though connection string has not been updated with latest connection properties
;
}
}
}
}
PFConnectionDefinition conndef = _csp.BuildConnectionDefinition(this.ConnectionName, this.ConnectionString, this.ConnectionAccessStatus);
string filename = _csp.SaveConnectionDefinition(conndef);
if (filename != string.Empty)
{
_msg.Length = 0;
_msg.Append("Connection definition saved to ");
_msg.Append(filename);
_msg.Append(".");
AppMessages.DisplayInfoMessage(_msg.ToString());
}
}
private void SaveConnectionDefinition()
{
string tempConnectionString = string.Empty;
if (this.ConnectionName.Trim().Length == 0)
{
AppMessages.DisplayErrorMessage("You must specify a connection name.");
return;
}
if (this.ConnectionString.Trim().Length == 0)
{
this.ConnectionString = BuildConnectionString();
if (this.ConnectionString.Trim().Length == 0)
{
AppMessages.DisplayErrorMessage("You must specify connection properties and build a connection string.");
return;
}
}
//DO NOT PROMPT TO REBUILD FOR OLEDB, even if either dsn or driver parameter has changed. User must specifically use Build button. In most cases connection string must be manually input for OLEDB: parameters on from are not enough.
//else
//{
// tempConnectionString = BuildConnectionString();
// if (this.ConnectionString != tempConnectionString)
// {
// _msg.Length = 0;
// _msg.Append("One or more connection properties have changes since connection string was last built.\r\n");
// _msg.Append("Do you want to rebuild the connection string before saving it?");
// DialogResult res = AppMessages.DisplayMessage(_msg.ToString(), "Connection string save ...", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation);
// if (res == DialogResult.Yes)
// {
// this.ConnectionString = tempConnectionString;
// }
// else
// {
// if (res == DialogResult.Cancel)
// return;
// else
// {
// //continue with save operation even though connection string has not been updated with latest connection properties
// ;
// }
// }
// }
//}
PFConnectionDefinition conndef = _csp.BuildConnectionDefinition(this.ConnectionName, this.ConnectionString, this.ConnectionAccessStatus);
string filename = _csp.SaveConnectionDefinition(conndef);
if (filename != string.Empty)
{
_msg.Length = 0;
_msg.Append("Connection definition saved to ");
_msg.Append(filename);
_msg.Append(".");
AppMessages.DisplayInfoMessage(_msg.ToString());
}
}