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

            //Act and Assert
            Assert.Throws <Exception>(() => codeTables.SaveService(
                                          1, "wcode", "modifier", "serviceName", "serviceDescription", 1, 1, "strTier", 10));

            mockExceptionHandling.VerifyAll();
        }