private bool TestConnection(out string errorMessage)
{
DatabaseTester tester = new DatabaseTester(
GetConnectionString(),
ConfigurationManager.ConnectionStrings[StoreContext.ConnectionStringsTagName].ProviderName);
return(tester.TestConnection(out errorMessage));
}
public async void Test(string sqlServerInstance, string databaseName, string login, string password)
{
ApplicationData.Current.LocalSettings.Values["canConnect"] = "Cannot establish connection";
DatabaseTester databaseTester = new DatabaseTester(GetConnectionString());
string message = string.Empty;
try
{
await databaseTester.CanEstablishConnection();
System.Threading.Thread.Sleep(2000);
var canConnect = ApplicationData.Current.LocalSettings.Values["canConnect"] as string;
if (canConnect == "true")
{
message = "Connected, ";
await databaseTester.IsDbNotOccupied();
System.Threading.Thread.Sleep(2000);
var IsTheOnlyConnection = ApplicationData.Current.LocalSettings.Values["isTheOnlyConnection"] as string;
if (IsTheOnlyConnection == "true")
{
message += "no other connections detected.";
}
else
{
message += "multiple database connections detected.";
}
}
else
{
message = canConnect.ToString();
}
}
catch (SqlException e)
{
message = e.Message;
}
var dialog = new MessageDialog(message);
await dialog.ShowAsync();
}
protected void uxTestReadButton_Click(object sender, EventArgs e)
{
try
{
DatabaseTester dbTest = CreateConnectionString();
string message;
if (dbTest.TestSelectCommand("LanguageText", out message))
{
uxResultLiteral.Text = AlertMessage("Test Read Permission Successful");
}
else
{
uxResultLiteral.Text = DisplayErrorMessage(message);
}
}
catch (Exception ex)
{
uxResultLiteral.Text = DisplayErrorMessage(ex.Message);
}
}
public void ShouldResolveAndExecuteAHandler()
{
new DatabaseTester().Clean();
var report = new ExpenseReport
{
Title = "TestExpens",
Description = "This is an ",
Number = "123",
Status = ExpenseReportStatus.Cancelled
};
using (var context = new StubbedDataContextFactory().GetContext())
{
context.AddRange(report);
context.SaveChanges();
}
var container = new DatabaseTester().GetContainer();
var bus = container.GetInstance <Bus>();
var reports = bus.Send(new ListExpenseReportsCommand());;
reports.Length.ShouldBe(1);
}
private bool TestConnection(string connectionString, string providerName, out string errMessage)
{
DatabaseTester dbTest = new DatabaseTester(connectionString, providerName);
return(dbTest.TestConnection(out errMessage));
}
