/// <summary>Tests the connection to the database</summary>
private void TestConnection()
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
SqlConnection conn = MbmSqlConnection.GetSqlConnection();
ConnectionState connState;
using (conn)
{
connState = conn.State;
}
if (connState == ConnectionState.Open)
{
ConnectionLabel.Content = "Connection was successful";
}
else
{
ConnectionLabel.Content = "Failed to connect to database";
}
}
catch (Exception ex)
{
ConnectionLabel.Content = ex.Message.ToString();
LoggingService.Log(ex, "Log.txt");
}
Mouse.OverrideCursor = Cursors.Arrow;
}
public void SqlConnectionTest()
{
ConnectionState actual;
ConnectionState expected = ConnectionState.Open;
SqlConnection conn = MbmSqlConnection.GetSqlConnection();
using (conn)
{
actual = conn.State;
}
Assert.AreEqual(expected, actual);
}
/// <summary>Retrieves connection string settings and binds it to the window</summary>
private void RetrieveConnectionString()
{
MbmSqlConnection DatabaseConnection = new MbmSqlConnection();
this.DataContext = DatabaseConnection;
}
