public List <MscMcomPool> GetPool()
        {
            SWDbObjectQuery query = new SWDbObjectQuery();

            query.AddSearchCriteria("ProcessStatus", "S");
            query.AddSearchCriteria("IsAsynchronous", true);
            return(new MscMcomPool().find <MscMcomPool>(query));
        }
        public MscMcomClaim GetClaim(Int64 provGuid)
        {
            SWDbObjectQuery query = new SWDbObjectQuery();

            query.AddSearchCriteria("AuthKey", provGuid);
            foreach (var item in new MscMcomClaim().find <MscMcomClaim>(query))
            {
                return(item);
            }
            return(null);
        }
        public MscMcomPool GetMscMcomPoolClearingNo(long clearingNo, String actionType)
        {
            SWDbObjectQuery query = new SWDbObjectQuery();

            query.AddSearchCriteria("ClearingRefKey", clearingNo);
            query.AddSearchCriteria("ActionType", actionType);
            foreach (var item in new MscMcomPool().find <MscMcomPool>(query))
            {
                return(item);
            }
            return(null);
        }