public void TestAddRemove()
{
UserDatabase userDb = new UserDatabase(_settingsLookup[ConnectionKey]);
GetTestUser(out var name, out User user);
// Test User is not there
Assert.IsNotNull(userDb.LoadedItems);
int numberInitialItems = userDb.LoadedItems.Count;
List <string> userNames = userDb.LoadedItems.ToList().Select(x => x.Name).ToList();
Assert.IsFalse(userNames.Contains(name));
// Add new User
userDb.AddNewItemToDatabase(user);
userDb.ConnectToDatabase();
Assert.AreNotEqual(numberInitialItems, userDb.LoadedItems.Count);
Assert.AreEqual(1, userDb.LoadedItems.Count - numberInitialItems);
List <string> userNames2 = userDb.LoadedItems.ToList().Select(x => x.Name).ToList();
Assert.IsTrue(userNames2.Contains(name));
// Remove the new user
userDb.RemoveItemFromDatabase(user);
userDb.ConnectToDatabase();
Assert.AreEqual(userDb.LoadedItems.Count, numberInitialItems);
List <string> userNames3 = userDb.LoadedItems.ToList().Select(x => x.Name).ToList();
Assert.IsFalse(userNames3.Contains(name));
}
public async Task SetupRemoteCollections()
{
string connection = SettingsVm.LocalConnectionString;
try
{
RemoteDatabaseCollections.Clear();
_remoteBooksReadDatabase = new BooksReadDatabase(connection, true);
_remoteBooksReadDatabase.MongoClientFunc = GetRemoteConnection;
//_remoteBooksReadDatabase.ResetLoadedItems();
_remoteBooksReadDatabase.ConnectToDatabase();
RemoteDatabaseCollections.Add(new DataCollectionSettings(_remoteBooksReadDatabase));
_remoteNationDatabase = new NationDatabase(connection, true);
_remoteNationDatabase.MongoClientFunc = GetRemoteConnection;
//_remoteNationDatabase.ResetLoadedItems();
_remoteNationDatabase.ConnectToDatabase();
RemoteDatabaseCollections.Add(new DataCollectionSettings(_remoteNationDatabase));
_remoteUserDatabase = new UserDatabase(connection, true);
_remoteUserDatabase.MongoClientFunc = GetRemoteConnection;
//_remoteUserDatabase.ResetLoadedItems();
_remoteUserDatabase.ConnectToDatabase();
RemoteDatabaseCollections.Add(new DataCollectionSettings(_remoteUserDatabase));
NotifyOfPropertyChange(() => RemoteDatabaseCollections);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
/// <summary>
/// The get users from database command action.
/// </summary>
public void GetUsersCommandAction()
{
_usersReadDatabase.ConnectToDatabase();
if (_usersReadDatabase.ReadFromDatabase)
{
_usersReadFromDatabase = _usersReadDatabase.LoadedItems;
OnPropertyChanged(() => Users);
}
}
public UserLoginControllerUtilities(MongoDbSettings mongoDbSettings) : base(mongoDbSettings)
{
if (!mongoDbSettings.UseRemoteHost)
{
_userDatabase = new UserDatabase(mongoDbSettings.DatabaseConnectionString);
}
else
{
_userDatabase =
new UserDatabase(string.Empty, false)
{
MongoClientFunc = GetRemoteConnection
};
_userDatabase.ConnectToDatabase();
}
}
public async Task SetupLocalCollections()
{
string connection = SettingsVm.LocalConnectionString;
LocalDatabaseCollections.Clear();
_localBooksReadDatabase = new BooksReadDatabase(connection);
_localBooksReadDatabase.ConnectToDatabase();
LocalDatabaseCollections.Add(new DataCollectionSettings(_localBooksReadDatabase));
_localNationDatabase = new NationDatabase(LocalConnectionString);
_localNationDatabase.ConnectToDatabase();
LocalDatabaseCollections.Add(new DataCollectionSettings(_localNationDatabase));
_localUserDatabase = new UserDatabase(LocalConnectionString);
_localUserDatabase.ConnectToDatabase();
LocalDatabaseCollections.Add(new DataCollectionSettings(_localUserDatabase));
NotifyOfPropertyChange(() => LocalDatabaseCollections);
}
public BooksDataControllerUtilities(MongoDbSettings dbSettings, SmtpConfig mailConfig) : base(dbSettings)
{
_smtpConfig = mailConfig;
DatabaseConnectionString = dbSettings.DatabaseConnectionString;
ExportDirectory = dbSettings.ExportDirectory;
_books = new ObservableCollection <Book>();
_booksReadFromDatabase = new ObservableCollection <BookRead>();
_nationsReadFromDatabase = new ObservableCollection <Nation>();
_usersReadFromDatabase = new ObservableCollection <User>();
if (!dbSettings.UseRemoteHost)
{
_booksReadDatabase = new BooksReadDatabase(DatabaseConnectionString);
_nationsReadDatabase = new NationDatabase(DatabaseConnectionString);
_userDatabase = new UserDatabase(DatabaseConnectionString);
}
else
{
_booksReadDatabase =
new BooksReadDatabase(string.Empty, false)
{
MongoClientFunc = GetRemoteConnection
};
_booksReadDatabase.ConnectToDatabase();
_nationsReadDatabase =
new NationDatabase(string.Empty, false)
{
MongoClientFunc = GetRemoteConnection
};
_nationsReadDatabase.ConnectToDatabase();
_userDatabase =
new UserDatabase(string.Empty, false)
{
MongoClientFunc = GetRemoteConnection
};
_userDatabase.ConnectToDatabase();
}
}
