public void Check_If_Responds_To_Query()
{
var options = new DbContextOptionsBuilder <TRDBContext>().UseInMemoryDatabase(databaseName: "database_super_cazzuto").Options;
using (var context = new TRDBContext(options))
{
context.TReservations.Add(new TennisReservation()
{
CourtId = 1, ReservationTime = DateTime.Now, MatchType = "Singolo"
});
context.TReservations.Add(new TennisReservation()
{
CourtId = 2, ReservationTime = DateTime.Now, MatchType = "Doppio"
});
context.TReservations.Add(new TennisReservation()
{
CourtId = 2, ReservationTime = DateTime.Now, MatchType = "Singolo"
});
context.TReservations.Add(new TennisReservation()
{
CourtId = 1, ReservationTime = DateTime.Now, MatchType = "Doppio"
});
context.SaveChanges();
}
using (var context = new TRDBContext(options))
{
var repo = new Repository(context);
var result = repo.FindByMatchType("Doppio");
Assert.Equal(2, result.Count());
}
}
public void Check_If_Add_To_Database_Works()
{
//Arrange
var testReservation = new TennisReservation();
testReservation.CourtId = 1;
testReservation.ReservationTime = DateTime.Now;
testReservation.MatchType = "Doppio";
//{ CourtId = 1, ReservationTime = DateTime.Now, MatchType = "Doppio" };
var options = new DbContextOptionsBuilder <TRDBContext>().UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Initial Catalog=TennisReservations;Integrated Security=True; MultipleActiveResultSets=true").Options;
using (var context = new TRDBContext(options))
{
Repository repo = new Repository(context);
var count = repo.Reservations.Count();
//Act
repo.AddReservation(testReservation);
//Assert
Assert.Equal(count + 1, repo.Reservations.Count());
Assert.Equal(testReservation, repo.Reservations.Last());
}
using (var context = new TRDBContext(options))
{
var count = context.TReservations.Count();
//Act
context.TReservations.Remove(testReservation);
context.SaveChanges();
//Assert
Assert.Equal(count - 1, context.TReservations.Count());
Assert.NotEqual(testReservation, context.TReservations.Last());
}
}