private void InitializeDatabase()
{
using (SpendingContext spendingContext = new SpendingContext())
{
spendingContext.Database.EnsureDeleted();
spendingContext.Database.EnsureCreated();
spendingContext.SaveChanges();
}
}
public void AddSpendingMissingUser_Fails()
{
int missingUserId = 42;
// Arrange
using (SpendingContext spendingContext = new SpendingContext())
{
SpendingRepository spendingRepository = new SpendingRepository(spendingContext);
SpendingController sut = new SpendingController(spendingRepository);
// Act
BadRequestResult actionResult = sut.AddSpending(missingUserId, DateTime.UtcNow.AddDays(-1), 100, "USD", "Misc", "Armor") as BadRequestResult;
// Assert
Assert.Equal(400, actionResult.StatusCode);
}
}
public void ListOrderedByUserId()
{
// Arrange
using (SpendingContext spendingContext = new SpendingContext())
{
SpendingRepository spendingRepository = new SpendingRepository(spendingContext);
SpendingController sut = new SpendingController(spendingRepository);
// Act
ObjectResult actionResult = sut.ListByUserId(1, "Date") as ObjectResult;
// Assert
IEnumerable <SpendingDto> spendings = (IEnumerable <SpendingDto>)actionResult.Value;
Assert.Empty(spendings);
}
}
public void ListOrderedWithWrongOrderBy_Fails()
{
string wrongOrderBy = "loki";
// Arrange
using (SpendingContext spendingContext = new SpendingContext())
{
SpendingRepository spendingRepository = new SpendingRepository(spendingContext);
SpendingController sut = new SpendingController(spendingRepository);
// Act
BadRequestResult actionResult = sut.ListByUserId(1, wrongOrderBy) as BadRequestResult;
// Assert
Assert.Equal(400, actionResult.StatusCode);
}
}
public void AddSpendingAndListIt()
{
// Arrange
using (SpendingContext spendingContext = new SpendingContext())
{
SpendingRepository spendingRepository = new SpendingRepository(spendingContext);
SpendingController sut = new SpendingController(spendingRepository);
// Act
IStatusCodeActionResult actionResult = sut.AddSpending(1, DateTime.UtcNow.AddDays(-1), 100, "USD", "Misc", "Armor") as IStatusCodeActionResult;
// Assert
Assert.Equal(200, actionResult.StatusCode);
ObjectResult listResult = sut.ListByUserId(1, "Date") as ObjectResult;
IEnumerable <SpendingDto> spendings = (IEnumerable <SpendingDto>)listResult.Value;
Assert.Single(spendings);
}
}
// For dev purpose only
private void DatabaseSetup()
{
IConfigurationSection databaseSetupSection = this.Configuration.GetSection("DatabaseSetup");
using (SpendingContext db = new SpendingContext())
{
if (databaseSetupSection["EnsureDeleted"].ToUpperInvariant() == "TRUE")
{
db.Database.EnsureDeleted();
}
if (databaseSetupSection["EnsureCreated"].ToUpperInvariant() == "TRUE")
{
db.Database.EnsureCreated();
}
db.SaveChanges();
}
}
