/// <summary>
/// writes/updates/saves the users score to the database
/// </summary>
public void SaveScoreToDatabase()
{
IUserAdministration admin = new UserAdministration();
for (int i = 0; i < database.RetrieveNumberOfRowsInTable(); i++)
{
string tableRow = database.RetrieveTableRow(database.TableName, i);
string[] split = tableRow.Split(separator: '\n');
if (user.UserName.Equals(split[0]))
{
admin.DeleteUser(i);
admin.AddUser(user.UserName, user.Email, user.Password, user.Password, user.Score);
}
}
}
public void MethodForDeletingAUserShouldFirstRetrieveARowFromDatabaseThenAccessOnlyTheUserColumnStringInOrderToEnterItAsTheArgumentForMethodDeleteRowFromTable()
{
// Arrange
string query = null;
Mock <IUserTable> mockDatabase = new Mock <IUserTable>();
mockDatabase.Setup(r => r.TableName).Returns("Table Name");
mockDatabase.Setup(r => r.RetrieveTableRow("Table Name", 1)).Returns("Huey \n [email protected]\nred\n35");
mockDatabase.Setup(r => r.DeleteRowFromTable(It.IsAny <string>())).Callback <string>((s1) =>
{
query = s1;
});
IUserAdministration sut = new UserAdministration(user, mockDatabase.Object);
// Act
sut.DeleteUser(1);
//Assert
Assert.AreEqual("Huey ", query);
}