public void GetEndCodebyID_WhenDbErrorsOut_ShouldThrowException()
        {
            //Arrange
            mockDataAccess
            .Setup(x => x.GetDataTable(
                       It.IsAny <string>(),
                       "prc_ISISEndCodeByIDGet",
                       System.Data.CommandType.StoredProcedure,
                       It.IsAny <SqlParameter[]>()))
            .Throws <Exception>();

            //Act and Assert
            Assert.Throws <Exception>(() => codeTables.GetEndCodebyID(1));

            mockExceptionHandling.Verify();
        }