public void SaveEndCode_WhenDatabaseThrowsError_ShouldThrowException()
        {
            //Arrange
            mockDataAccess
            .Setup(x => x.ExecuteNonQuery(
                       It.IsAny <string>(),
                       "prc_ISISEndCodeSave",
                       It.IsAny <CommandType>(),
                       It.IsAny <SqlParameter[]>(),
                       ref It.Ref <List <SqlParameter> > .IsAny))
            .Throws <Exception>();

            //Act and Assert
            Assert.Throws <Exception>(() => codeTables.SaveEndCode("endCode", 10, "desc", "lngdesc", 10));

            mockExceptionHandling.VerifyAll();
        }