public void ShouldGetAll()
{
// Arrange
var options = new DbContextOptionsBuilder <DeskBookerContext>()
.UseInMemoryDatabase(databaseName: "ShouldGetAll")
.Options;
var storedList = new List <Desk>
{
new Desk(),
new Desk(),
new Desk()
};
using (var context = new DeskBookerContext(options))
{
foreach (var desk in storedList)
{
context.Add(desk);
context.SaveChanges();
}
}
// Act
List <Desk> actualList;
using (var context = new DeskBookerContext(options))
{
var repository = new DeskRepository(context);
actualList = repository.GetAll().ToList();
}
// Assert
Assert.Equal(storedList.Count(), actualList.Count());
}
public void ShouldReturnTheAvailableDesks()
{
// Arrange
var date = new DateTime(2020, 1, 25);
var options = new DbContextOptionsBuilder <DeskBookerContext>()
.UseInMemoryDatabase(databaseName: "ShouldReturnTheAvailableDesks")
.Options;
using (var context = new DeskBookerContext(options))
{
context.Desk.Add(new Desk {
Id = 1
});
context.Desk.Add(new Desk {
Id = 2
});
context.Desk.Add(new Desk {
Id = 3
});
context.DeskBooking.Add(new DeskBooking {
DeskId = 1, Date = date
});
context.DeskBooking.Add(new DeskBooking {
DeskId = 2, Date = date.AddDays(1)
});
context.SaveChanges();
}
using (var context = new DeskBookerContext(options))
{
var repository = new DeskRepository(context);
// Act
var desks = repository.GetAvailableDesks(date);
// Assert
Assert.Equal(2, desks.Count());
Assert.Contains(desks, d => d.Id == 2);
Assert.Contains(desks, d => d.Id == 3);
Assert.DoesNotContain(desks, d => d.Id == 1);
}
}
