public void UpdateSpecificDatabaseNodeTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
//modify the dbInfo start time
dbInfo.StartTime = new TimeSpan(22, 59, 0);
dbHandler.UpdateDatabaseNode(dbInfo);
dbInfo = dbHandler.GetDatabaseNode(dbInfo.ID)
;
Assert.AreEqual("22:59:00", dbInfo.StartTime.ToString());
dbHandler.RemoveDatabaseNode(dbInfo.ID);
}
/// <summary>
/// Called when navigation to a content fragment begins: Loads the info for the selected database.
/// </summary>
/// <param name="e">An object that contains the navigation data.</param>
public void OnFragmentNavigation(FirstFloor.ModernUI.Windows.Navigation.FragmentNavigationEventArgs e)
{
Guid databaseId;
if (Guid.TryParse(e.Fragment, out databaseId))
{
DatabaseInfo dbInfo = dbHandler.GetDatabaseNode(databaseId);
if (dbInfo == null)
{
FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage("The database requested was not found!", "Not Found", MessageBoxButton.OK);
NavigationCommands.GoToPage.Execute(new Uri("/Pages/DatabasesPage.xaml", UriKind.Relative), FirstFloor.ModernUI.Windows.Navigation.NavigationHelper.FindFrame(null, this));
}
CurrentDbInfo = dbInfo;
this.DataContext = CurrentDbInfo;
}
}
public void RetrieveSpecificDatabaseNodeTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
DatabaseInfo dbInfo2 = dbHandler.GetDatabaseNode(dbInfo.ID);
Assert.AreEqual("TestDatabase", dbInfo2.DatabaseName);
dbHandler.RemoveDatabaseNode(dbInfo.ID);
}