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); }