[Fact]

public void CheckPayerFilesTransmittedStatus_FileExists_Returns1()

{

    // Arrange

    var payerRequestDetails = new PayerRequestDetails

    {

        Request_ID = 1,

        External_Location = "C:\\Your\\Path\\To\\Files\\",

        Submitted_Filename = "example.txt"

    };

​

    // Mock IDbConnection (for ProcessAuditLogDA)

    var dbConnectionMock = new Mock<IDbConnection>();

​

    // Mock IDbCommand and IDbDataParameter (for IDbConnection.CreateCommand)

    var dbCommandMock = new Mock<IDbCommand>();

    var dbParameterMock = new Mock<IDbDataParameter>();

​

    // Set up IDbConnection.CreateCommand to return the mock IDbCommand

    dbConnectionMock.Setup(conn => conn.CreateCommand()).Returns(dbCommandMock.Object);

​

    // Mock IDbTransaction (for IDbConnection.BeginTransaction)

    var dbTransactionMock = new Mock<IDbTransaction>();

​

    // Set up IDbConnection.BeginTransaction to return the mock IDbTransaction

    dbConnectionMock.Setup(conn => conn.BeginTransaction()).Returns(dbTransactionMock.Object);

​

    // Mock IDbDataParameterCollection (for IDbCommand.Parameters)

    var dbParameterCollectionMock = new Mock<IDataParameterCollection>();

​

    // Set up IDbCommand.Parameters to return the mock IDbDataParameterCollection

    dbCommandMock.Setup(cmd => cmd.Parameters).Returns(dbParameterCollectionMock.Object);

​

    // Mock SqlConnectionFactory (for new SqlConnection)

    var sqlConnectionFactoryMock = new Mock<ISqlConnectionFactory>();

​

    // Set up SqlConnectionFactory.CreateConnection to return the mock IDbConnection

    sqlConnectionFactoryMock.Setup(factory => factory.CreateConnection(It.IsAny<string>())).Returns(dbConnectionMock.Object);

​

    // Create a mock for BaseDataAccess

    var baseDataAccessMock = new Mock<BaseDataAccess>();

​

    // Set up GetConnectionForTheType to return a connection string

    baseDataAccessMock.Setup(bda => bda.GetConnectionForTheType(It.IsAny<string>()))

                     .Returns("your_connection_string_here");

​

    // Mock ProcessAuditLogDA

    var processAuditLogDAMock = new Mock<ProcessAuditLogDA>();

​

    // Set up LogProcessAuditDetails to do nothing (for testing purposes)

    processAuditLogDAMock.Setup(da => da.LogProcessAuditDetails(It.IsAny<ProcessAuditLog>()));

​

    // Mock ExportAPI (the class under test)

    var exportAPI = new ExportAPI(baseDataAccessMock.Object, processAuditLogDAMock.Object);

​

    // Act

    var result = exportAPI.CheckPayerFilesTransmittedStatus(payerRequestDetails);

​

    // Assert

    Assert.Equal(1, result);

    // Add any additional assertions based on the expected behavior

}

​