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;
}
}
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 TestConnectionParamsFromXmlOld()
{
var xml = new XmlDocument();
var xmlElement = xml.CreateElement("connection");
xmlElement.SetAttribute("databaseType", "dtFirebird");
xmlElement.SetAttribute("databaseTypeCustom", "");
xmlElement.SetAttribute("host", Host);
xmlElement.SetAttribute("DatabaseName", DatabaseName);
xmlElement.SetAttribute("username", User);
xmlElement.SetAttribute("password", MsStringCipher.Encrypt(Password, EncryptionKey));
var conn = new MsConnectionParams(xmlElement, EncryptionKey);
Assert.AreEqual(MsDatabaseType.Firebird, conn.DatabaseType);
Assert.AreEqual(Password, conn.Password);
}
public void TestConnectionParamsToXml()
{
var conn = new MsConnectionParams(
MsDatabaseType.Firebird,
User,
Password,
Host,
DatabaseName
);
var xml = new XmlDocument();
var xmlElement = xml.CreateElement("connection");
conn.ToXml(xmlElement, EncryptionKey);
Assert.AreEqual("user", xmlElement.GetAttribute("username"));
Assert.AreNotEqual("password", xmlElement.GetAttribute("password"));
Assert.AreEqual("password", MsStringCipher.Decrypt(xmlElement.GetAttribute("password"), EncryptionKey));
}
public static DbCommand GetCommand(MsConnectionParams connectionParams, DbConnection dbConn, string commandText)
{
switch (connectionParams.DatabaseType)
{
case MsDatabaseType.Firebird:
#if !NET20
return new FbCommand(commandText, (FbConnection)dbConn);
#else
return null;
#endif
case MsDatabaseType.SqlServer:
return new SqlCommand(commandText, (SqlConnection)dbConn);
case MsDatabaseType.None:
return null;
case MsDatabaseType.Other:
return null;
default:
return null;
}
}
public static string DatabaseConnectionTest(MsConnectionParams connectionParams)
{
string error;
var dbConn = GetConnection(out error, connectionParams);
if (dbConn == null)
{
return string.Format(Messages.databaseNotConfigured, error);
}
else
{
try
{
dbConn.Open();
dbConn.Close();
return string.Format(Messages.databaseConnectionTestResult, connectionParams.Host, connectionParams.Database);
}
catch (Exception err)
{
return string.Format(Messages.databaseConnectionError, connectionParams.Host, connectionParams.Database, err.Message);
}
}
}
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 DbParameter GetParameter(MsConnectionParams connectionParams, string paramName, object paramValue)
{
switch (connectionParams.DatabaseType)
{
case MsDatabaseType.Firebird:
#if !NET20
return new FbParameter(paramName, paramValue);
#else
return null;
#endif
case MsDatabaseType.SqlServer:
return new SqlParameter(paramName, paramValue);
case MsDatabaseType.None:
return null;
case MsDatabaseType.Other:
return null;
default:
return null;
}
}