How to Get Closed Check Details in Simphony / Micros extensibility using C#

using System.Data;
using Contracts.Factories;
using SimphonyUtilities.Settings;

namespace Factories.DatabaseConnection
{
    public class SimphonyDbConnectionFactory : IDbConnectionFactory
    {
        private readonly DatabaseSettings _databaseSettings;

        public SimphonyDbConnectionFactory()
        {
            _databaseSettings = DatabaseSettings.GetDbSettingsSafe(DatabaseSettings.DatabaseAlias.Master);
        }

        public string DataStore => DatabaseSettings.GetDbSettingsSafe(DatabaseSettings.DatabaseAlias.LocalDb).DBCatalog;

        public string CheckPostingDB => DatabaseSettings.GetDbSettingsSafe(DatabaseSettings.DatabaseAlias.CPServiceDb).DBCatalog;

        public bool CheckPostingDbExists => DatabaseSettings.CheckDbSettingsExist(DatabaseSettings.DatabaseAlias.CPServiceDb);

        public IDbConnection CreateConnection() => new EMC.Data.Sql.DatabaseConnection(_databaseSettings).Connection as System.Data.Common.DbConnection;
    }
}