public async void DeleteConfirmed_ValidDeleteNoGameProduct()
{
Game aGame = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>()
};
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { aGame }.AsQueryable());
gameDbSetStub.
Setup(g => g.FindAsync(aGame.Id)).
ReturnsAsync(aGame);
dbStub.
Setup(db => db.Games).
Returns(gameDbSetStub.Object);
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
var result = await controller.DeleteGameConfirmed(aGame.Id) as RedirectToRouteResult;
Assert.That(result != null);
Assert.That(result.RouteValues["Action"], Is.EqualTo("Index"));
}
public void DeleteConfirmed_IdNotInDb()
{
Game aGame = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>()
};
Guid nonMatch = Guid.Empty;
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { aGame }.AsQueryable());
gameDbSetStub.
Setup(g => g.FindAsync(aGame.Id)).
ReturnsAsync(aGame);
dbStub.
Setup(db => db.Games).
Returns(gameDbSetStub.Object);
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
Assert.That(async () => await controller.DeleteGameConfirmed(nonMatch), Throws.InstanceOf<HttpException>().And.Matches<HttpException>(e => e.GetHttpCode() == 404));
}
public void DeleteConfirmed_SaveAsyncThrowingForeignKeyViolationException_HandlesException()
{
Game game = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>()
};
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
StubEmptyProductLocationInventories(dbStub);
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { game }.AsQueryable());
gameDbSetStub.
Setup(gdb => gdb.FindAsync(It.IsAny<Guid>())).
ReturnsAsync(game);
dbStub.
Setup(db => db.Games).
Returns(gameDbSetStub.Object);
DbUpdateException orderConstraintException = new DbUpdateException("See inner",
SqlExceptionCreator.Create( // This message was copied verbatim from the actual exception being thrown
"The DELETE statement conflicted with the REFERENCE constraint " +
"\"FK_dbo.ProductLocationInventory_dbo.Product_ProductId\"." +
"The conflict occurred in database \"prog3050\", table " +
"\"dbo.ProductLocationInventory\", column 'ProductId'." +
"The statement has been terminated.",
(int)SqlErrorNumbers.ConstraintViolation));
dbStub.
Setup(db => db.SaveChangesAsync()).
ThrowsAsync(orderConstraintException);
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
Assert.That(async () => await controller.DeleteGameConfirmed(game.Id), Throws.Nothing);
}
public async void DeleteConfirmed_CatchesOnSaveDelete()
{
Game aGame = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>()
};
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { aGame }.AsQueryable());
gameDbSetStub.Setup(g => g.FindAsync(aGame.Id)).ReturnsAsync(aGame);
dbStub.Setup(db => db.Games).Returns(gameDbSetStub.Object);
dbStub.Setup(db => db.SaveChangesAsync()).Throws<DbUpdateException>();
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
var result = await controller.DeleteGameConfirmed(aGame.Id) as RedirectToRouteResult;
Assert.That(result != null);
}
public async void DeleteConfirmed_WithSKUs_RemovesAllSKUs()
{
Game game = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>
{
availableSKU,
discontinuedSKU
}
};
List<GameProduct> deletedProducts = new List<GameProduct>();
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { game }.AsQueryable());
gameDbSetStub.SetupForInclude();
gameDbSetStub.
Setup(gdb => gdb.FindAsync(It.IsAny<Guid>())).
ReturnsAsync(game);
Mock<DbSet<GameProduct>> gameProductDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<GameProduct>().AsQueryable());
gameProductDbSetStub.Setup(gdb => gdb.RemoveRange(It.IsAny<IEnumerable<GameProduct>>())).
Returns<IEnumerable<GameProduct>>(val => val).
Callback<IEnumerable<GameProduct>>(val => deletedProducts = val.ToList());
Mock<DbSet<ProductLocationInventory>> inventoriesDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<ProductLocationInventory>().AsQueryable());
dbStub.
Setup(db => db.GameProducts).
Returns(gameProductDbSetStub.Object);
dbStub.
Setup(db => db.ProductLocationInventories).
Returns(inventoriesDbSetStub.Object);
dbStub.
Setup(db => db.Games).
Returns(gameDbSetStub.Object);
dbStub.
Setup(db => db.SaveChangesAsync()).
ReturnsAsync(1);
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
await controller.DeleteGameConfirmed(game.Id);
Assert.That(deletedProducts, Has.Count.EqualTo(2));
Assert.That(deletedProducts, Has.Member(availableSKU).And.Member(discontinuedSKU));
}
public async void DeleteConfirmed_NonZeroInventories_OnlyRemovesEmptyProductLocationInventories()
{
Game game = new Game
{
Id = gameId,
GameSKUs = new List<GameProduct>
{
new PhysicalGameProduct
{
Id = gameSKUId,
GameId = gameId
}
}
};
var matchingEmptyInventory = new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("B5055382-1AC6-4306-8830-CF3225D55E36"),
NewOnHand = 0,
UsedOnHand = 0,
NewOnOrder = 0
};
var inventories = new List<ProductLocationInventory>
{
matchingEmptyInventory,
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("26226470-8CB5-4408-B9FF-20CD35DAF7B9"),
NewOnHand = 1,
UsedOnHand = 0,
NewOnOrder = 0
},
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("3817326F-77F1-46E9-93DB-6C8F13FAB135"),
NewOnHand = 0,
UsedOnHand = 1,
NewOnOrder = 0
},
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("7625893A-CA94-42CB-9DF0-3D8CA1380405"),
NewOnHand = 0,
UsedOnHand = 0,
NewOnOrder = 1
},
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("F341600E-EA96-4CDB-9EEE-62E42B8007D4"),
NewOnHand = -1,
UsedOnHand = 0,
NewOnOrder = 0
},
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("964A866D-E6D1-43C6-A473-2C3AF6693473"),
NewOnHand = 0,
UsedOnHand = -1,
NewOnOrder = 0
},
new ProductLocationInventory
{
ProductId = gameSKUId,
LocationId = new Guid("548DD025-F261-4BE3-AC5B-F59C08E5B033"),
NewOnHand = 0,
UsedOnHand = 0,
NewOnOrder = -1
}
};
var deletedInventories = new List<ProductLocationInventory>();
Mock<IVeilDataAccess> dbStub = TestHelpers.GetVeilDataAccessFake();
Mock<DbSet<Game>> gameDbSetStub = TestHelpers.GetFakeAsyncDbSet(new List<Game> { game }.AsQueryable());
gameDbSetStub.SetupForInclude();
gameDbSetStub.
Setup(gdb => gdb.FindAsync(It.IsAny<Guid>())).
ReturnsAsync(game);
Mock<DbSet<ProductLocationInventory>> inventoriesDbSetStub = TestHelpers.GetFakeAsyncDbSet(inventories.AsQueryable());
inventoriesDbSetStub.
Setup(idb => idb.RemoveRange(It.IsAny<IEnumerable<ProductLocationInventory>>())).
Returns<IEnumerable<ProductLocationInventory>>(val => val).
Callback<IEnumerable<ProductLocationInventory>>(val => deletedInventories = val.ToList());
Mock<DbSet<GameProduct>> gameProductDbSetStub =
TestHelpers.GetFakeAsyncDbSet(new List<GameProduct>().AsQueryable());
dbStub.
Setup(db => db.GameProducts).
Returns(gameProductDbSetStub.Object);
dbStub.
Setup(db => db.ProductLocationInventories).
Returns(inventoriesDbSetStub.Object);
dbStub.
Setup(db => db.Games).
Returns(gameDbSetStub.Object);
dbStub.
Setup(db => db.SaveChangesAsync()).
ReturnsAsync(1);
GamesController controller = new GamesController(dbStub.Object, idGetter: null);
await controller.DeleteGameConfirmed(game.Id);
Assert.That(deletedInventories, Has.Count.EqualTo(1));
Assert.That(deletedInventories, Has.Member(matchingEmptyInventory));
}