private void BtnConnectionForm_Click(object sender, RoutedEventArgs e)
{
var connectionParams = new MsConnectionParams();
var connectionForm = new msConnectionFormWpf();
if (connectionForm.showDialog("wpf test", ref connectionParams))
{
MessageBox.Show(connectionParams.ToString());
MessageBox.Show(connectionParams.GetConnectionString());
}
}
private void btnTestMsConnectionForms_Click(object sender, EventArgs e)
{
var connectionForm = new msConnectionForm();
var connectionParams = new MsConnectionParams();
if (connectionForm.showDialog("msUtilities Test App", ref connectionParams))
{
MessageBox.Show(connectionParams.ToString());
MessageBox.Show(connectionParams.GetConnectionString());
}
}
private void btnTestMsConnectionFormsSqlServer_Click(object sender, EventArgs e)
{
var connectionForm = new msConnectionForm();
var connectionParams = new MsConnectionParams();
connectionParams.DatabaseType = MsDatabaseType.SqlServer;
connectionParams.Database = "database";
if (connectionForm.showDialog("msUtilities Test App", ref connectionParams))
{
MessageBox.Show(connectionParams.ToString());
MessageBox.Show(connectionParams.GetConnectionString());
}
}
public void TestConnectionStringGenerationFirebirdEmpty()
{
var conn = new MsConnectionParams
{
DatabaseType = MsDatabaseType.Firebird,
Username = User,
Password = Password,
Host = Host,
Database = DatabaseName
};
var test = $"User={User};Password={Password};Database={DatabaseName};DataSource={Host};";
var result = conn.GetConnectionString();
Assert.AreEqual(test, result);
}
public void TestConnectionStringGenerationSqlServer()
{
var conn = new MsConnectionParams(
MsDatabaseType.SqlServer,
User,
Password,
Host,
DatabaseName
);
var test = $"User Id={User};Password={Password};Database={DatabaseName};Server={Host};";
var result = conn.GetConnectionString();
Assert.AreEqual(test, result);
}
public void TestConnectionStringGenerationOther()
{
var conn = new MsConnectionParams(
MsDatabaseType.Other,
User,
Password,
Host,
DatabaseName
);
const string test = "";
var result = conn.GetConnectionString();
Assert.AreEqual(test, result);
}
public static DbConnection GetConnection(out string error, MsConnectionParams connectionParams)
{
error = "";
try
{
switch (connectionParams.DatabaseType)
{
case MsDatabaseType.Firebird:
#if !NET20
return new FbConnection(connectionParams.GetConnectionString());
#else
error = Messages.databaseNotSupported;
return null;
#endif
case MsDatabaseType.SqlServer:
return new SqlConnection(connectionParams.GetConnectionString());
case MsDatabaseType.None:
error = Messages.databaseTypeNotSelected;
return null;
case MsDatabaseType.Other:
error = Messages.databaseNotSupported;
return null;
default:
error = Messages.databaseNotSupported;
return null;
}
}
catch (Exception err)
{
error = err.Message;
return null;
}
}
