public void TestInsertingAnStaffRecord()
        {
            // Arrange
            var commandMock = new Mock <IDbCommand>();

            commandMock.Setup(m => m.ExecuteNonQuery()).Verifiable();

            var connectionMock = new Mock <IDbConnection>();

            connectionMock.Setup(m => m.CreateCommand()).Returns(commandMock.Object);

            var connectionFactoryMock = new Mock <IDbConnectionFactory>();

            connectionFactoryMock.Setup(m => m.CreateConnection(connectionMock.Object.ToString()));

            var mockUserFunction = new UserFunctions();

            Staff newStaff = new Staff();

            newStaff.Forename    = "Charlotte";
            newStaff.Surname     = "Harrison";
            newStaff.DateOfBirth = DateAndTime.DateValue("11/12/1997");

            // Act
            var result = mockUserFunction.AddStaffRecordToDB(newStaff);

            //Assert
            //commandMock.Setup(m => m.ExecuteNonQuery()).Equals(1);

            NUnit.Framework.Assert.IsTrue(result == "Staff has been successfully saved in database");
        }