public async Task SubtractRoomOccupantsShouldSetGenderAsync()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("SubtractRoomOccupantsShouldSetGenderAsync")
.Options;
using var testContext = new RoomServiceContext(options);
testContext.Database.EnsureCreated();
var room = PresetEntityRoom(testContext);
room.Gender = null;
room.NumberOfOccupants = 1;
testContext.Room.Add(room);
await testContext.SaveChangesAsync();
var mapper = new DbMapper();
var repo = new Repository(testContext, mapper);
await repo.SubtractRoomOccupantsAsync(_newRoomId);
var result = await testContext.Room.Where(r => r.RoomId == _newRoomId).Include(r => r.Gender).FirstAsync();
Assert.True(result.Gender == null);
}
public async Task RepoGetVacantShouldReturnAvailableRoomsBasedOnFilter()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("RepoGetVacantShouldReturnAvailableRoomsBasedOnFilter")
.Options;
using var assembleContext = new RoomServiceContext(options);
assembleContext.Database.EnsureCreated();
var mapper = new DbMapper();
var newRoom = PresetEntityRoom(assembleContext);
var newRoom2 = PresetEntityRoom2(assembleContext);
assembleContext.Add(newRoom);
assembleContext.Add(newRoom2);
assembleContext.SaveChanges();
var endDate = new DateTime(2001, 3, 15);
using var actContext = new RoomServiceContext(options);
var repo = new Repository(actContext, mapper);
var filterRoom = await repo.GetVacantFilteredRoomsByGenderandEndDateAsync("Female", endDate);
var assertContext = new RoomServiceContext(options);
Assert.NotNull(filterRoom);
Assert.Equal(_newRoomId.ToString(), filterRoom.FirstOrDefault(r => r.Item1 == _newRoomId).Item1.ToString());
}
public async Task RepoDeleteOneOfTwo()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("RepoDeleteOneOfTwo")
.Options;
using var testContext = new RoomServiceContext(options);
var mapper = new DbMapper();
var newRoom1 = PresetEntityRoom(testContext);
var newRoom2 = PresetEntityRoom2(testContext);
testContext.Add(newRoom1);
testContext.Add(newRoom2);
testContext.SaveChanges();
using var assertContext = new RoomServiceContext(options);
var repo = new Repository(assertContext, mapper);
await repo.DeleteRoomAsync(_newRoomId2);
assertContext.SaveChanges();
Assert.Null(assertContext.Room.Find(_newRoomId2));
}
public async Task UpdateRoomShouldUpdateLeaseAsync()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("UpdateRoomShouldUpdateLease")
.Options;
using var testContext = new RoomServiceContext(options);
var mapper = new DbMapper();
var repo = new Repository(testContext, mapper);
testContext.Database.EnsureCreated();
testContext.Room.Add(PresetEntityRoom(testContext));
await testContext.SaveChangesAsync();
var room = PresetEntityRoom(testContext);
var updateRoom = PresetBLRoom();
updateRoom.SetLease(_newLeaseStart.AddDays(3), _newLeaseEnd.AddYears(2));
updateRoom.RoomId = room.RoomId;
await repo.UpdateRoomAsync(updateRoom);
await testContext.SaveChangesAsync();
var result = await testContext.Room.FirstAsync(r => r.RoomId == _newRoomId);
Assert.True(result.LeaseStart == _newLeaseStart.AddDays(3));
}
private DataAccess.Entities.Room PresetEntityRoom3(RoomServiceContext context)
{
return(new DataAccess.Entities.Room
{
RoomId = _newRoomId3,
ComplexId = _newComplexId,
Gender = context.Gender.FirstOrDefault(g => g.Type == "Male"),
RoomNumber = "2004",
RoomType = context.RoomType.FirstOrDefault(g => g.Type == "TownHouse"),
NumberOfBeds = _newNumOfBeds,
NumberOfOccupants = _newNumOfOccupants3,
LeaseStart = _newLeaseStart,
LeaseEnd = _newLeaseEnd
});
}
// Use to set up a valid entity Room
private DataAccess.Entities.Room PresetEntityRoom(RoomServiceContext context)
{
return(new DataAccess.Entities.Room
{
RoomId = _newRoomId,
ComplexId = _newComplexId,
Gender = context.Gender.FirstOrDefault(g => g.Type == _newGender),
RoomNumber = _newRoomNumber,
RoomType = context.RoomType.FirstOrDefault(g => g.Type == _newRoomType),
NumberOfBeds = _newNumOfBeds,
NumberOfOccupants = _newNumOfOccupants,
LeaseStart = _newLeaseStart,
LeaseEnd = _newLeaseEnd
});
}
public async Task SubtractRoomOccupantsShouldUpdateAsync()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("SubtractRoomOccupantsShouldUpdate")
.Options;
using var testContext = new RoomServiceContext(options);
testContext.Database.EnsureCreated();
testContext.Room.Add(PresetEntityRoom(testContext));
await testContext.SaveChangesAsync();
var mapper = new DbMapper();
var repo = new Repository(testContext, mapper);
await repo.SubtractRoomOccupantsAsync(_newRoomId);
var result = await testContext.Room.FirstAsync(r => r.RoomId == _newRoomId);
Assert.True(result.NumberOfOccupants == _newNumOfOccupants - 1);
}
public async Task RepoReadCheckGenderTest()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("RepoReadCheckGenderTest")
.Options;
using var testContext = new RoomServiceContext(options);
testContext.Database.EnsureCreated();
var mapper = new DbMapper();
var newRoom = PresetEntityRoom2(testContext);
testContext.Add(newRoom);
testContext.SaveChanges();
using var actContext = new RoomServiceContext(options);
var repo = new Repository(actContext, mapper);
var resultRoom = await repo.ReadRoomAsync(newRoom.RoomId);
Assert.Equal("Male", resultRoom.Gender);
}
public async Task CreateRoomShouldCreateAsync()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("CreateRoomShouldCreateAsync")
.Options;
using var assembleContext = new RoomServiceContext(options);
var mapper = new DbMapper();
assembleContext.Database.EnsureCreated();
var assembleRoom = PresetBLRoom();
var actRepo = new Repository(assembleContext, mapper);
await actRepo.CreateRoomAsync(assembleRoom);
await assembleContext.SaveChangesAsync();
using var assertContext = new RoomServiceContext(options);
Assert.NotNull(assertContext.Room.Find(_newRoomId));
}
public async Task RepoDeleteComplexRoomShouldDeleteAllRoomsInComplex()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("RepoDeleteComplexRoomShouldDeleteAllRoomsInComplex")
.Options;
using var assembleContext = new RoomServiceContext(options);
assembleContext.Database.EnsureCreated();
//var mapper = new DBMapper(assembleContext);
var mapper = new DbMapper();
var newRoom = PresetEntityRoom(assembleContext);
var newRoom2 = PresetEntityRoom2(assembleContext);
var newRoom3 = PresetEntityRoom3(assembleContext);
assembleContext.Add(newRoom);
assembleContext.Add(newRoom2);
assembleContext.Add(newRoom3);
assembleContext.SaveChanges();
using var actContext = new RoomServiceContext(options);
var repo = new Repository(actContext, mapper);
var deleteComplexRooms = await repo.DeleteComplexRoomAsync(_newComplexId);
await actContext.SaveChangesAsync();
var assertContext = new RoomServiceContext(options);
//The DeleteComplexRoomAsync method deletes all rooms based on the complex, it works
//But we have 3 seeded room in our database that aren't in the same complex
//so even after delete all the created rooms
//we still have our seeded data.
Assert.Equal(3, assertContext.Room.Count());
}
public async Task ReadRoomShouldReturnRoom()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("ReadRoomShouldReturnRoom")
.Options;
using var testContext = new RoomServiceContext(options);
var mapper = new DbMapper();
testContext.Database.EnsureCreated();
var newRoomEntity = PresetEntityRoom(testContext);
testContext.Add(newRoomEntity);
await testContext.SaveChangesAsync();
using var assertContext = new RoomServiceContext(options);
var repo = new Repository(assertContext, mapper);
var resultRoom = await repo.ReadRoomAsync(_newRoomId);
Assert.NotNull(resultRoom);
Assert.Equal(_newRoomId, resultRoom.RoomId);
}
public RoomRequestsController(RoomServiceContext context, IHubContext <RoomHub, IRoomHubClient> roomHub)
{
_context = context;
_roomHub = roomHub;
}
public Repository(RoomServiceContext context, IMapper mapper)
{
_context = context;
_map = mapper;
}
public async Task RepoGetFilterRoomShouldFilterBasedOnWhatYouGiveIt()
{
var options = new DbContextOptionsBuilder <RoomServiceContext>()
.UseInMemoryDatabase("RepoGetFilterRoomShouldFilterBasedOnWhatYouGiveIt")
.Options;
using var assembleContext = new RoomServiceContext(options);
assembleContext.Database.EnsureCreated();
var mapper = new DbMapper();
var newRoom = PresetEntityRoom(assembleContext);
var newRoom2 = PresetEntityRoom2(assembleContext);
var newRoom3 = PresetEntityRoom3(assembleContext);
assembleContext.Add(newRoom);
assembleContext.Add(newRoom2);
assembleContext.Add(newRoom3);
assembleContext.SaveChanges();
var endDate = new DateTime(2001, 3, 15);
using var actContext = new RoomServiceContext(options);
var repo = new Repository(actContext, mapper);
//Returns 1 room because there is only 1 room that matches that room number
var filterRoom1 = await repo.GetFilteredRoomsAsync(_newComplexId, _newRoomNumber, null, null, null, null, null);
//Returns 2 rooms because there are 2 rooms that are labeld as "Male" gender
var filterRoom2 = await repo.GetFilteredRoomsAsync(_newComplexId, null, _newNumOfBeds, null, "Male", null, null);
//Returns 1 room because there is only one room labeled as room type TownHouse
var filterRoom3 = await repo.GetFilteredRoomsAsync(_newComplexId, null, _newNumOfBeds, "TownHouse", null, null, null);
//Returns 3 rooms because that is all the rooms witht that complex Id
var filterRoom4 = await repo.GetFilteredRoomsAsync(_newComplexId, null, null, null, null, null, null);
//Returns 3 rooms because there are 3 rooms with that many number of beds
var filterRoom5 = await repo.GetFilteredRoomsAsync(_newComplexId, null, _newNumOfBeds, null, null, null, null);
//Returns 0 rooms because there are no rooms whose lease are greater than the end date
var filterRoom6 = await repo.GetFilteredRoomsAsync(_newComplexId, null, null, null, null, DateTime.Now, null);
//Returns 1 room
var filterRoom7 = await repo.GetFilteredRoomsAsync(_newComplexId, null, null, null, null, null, _newRoomId);
Assert.Equal(_newRoomNumber, filterRoom1.FirstOrDefault(r => r.RoomNumber == _newRoomNumber).RoomNumber);
Assert.Equal(2, filterRoom2.Count(r => r.Gender == "Male"));
//Assert.Equal("TownHouse", filterRoom3.FirstOrDefault(r => r.RoomType == "TownHouse").RoomType);
Assert.Equal(1, filterRoom3.Count(r => r.RoomType == "TownHouse"));
//Assert.Equal(newComplexId, filterRoom4.FirstOrDefault(r => r.ComplexId == newComplexId).ComplexId);
Assert.Equal(3, filterRoom4.Count(r => r.ComplexId == _newComplexId));
Assert.Equal(3, filterRoom5.Count(r => r.NumberOfBeds == _newNumOfBeds));
Assert.True(filterRoom6.Count() == 0);
Assert.True(filterRoom7.Count() == 1);
}
