protected override List <string> GetPendingSubmissionList(SpringBaseDao baseDao) { if (_useSubmissionHistoryTable) { ExceptionUtils.ThrowIfEmptyString(_submissionHistoryTableName, "_submissionHistoryTableName"); ExceptionUtils.ThrowIfEmptyString(_submissionHistoryTableProcessingStatusName, "_submissionHistoryTableProcessingStatusName"); ExceptionUtils.ThrowIfEmptyString(_submissionHistoryTablePkName, "_submissionHistoryTableTransactionIdName"); ExceptionUtils.ThrowIfEmptyString(_submissionHistorySubmissionType, "_submissionHistorySubmissionType"); List <string> recordIdList = null; baseDao.DoSimpleQueryWithRowCallbackDelegate( _submissionHistoryTableName, _submissionHistoryTableProcessingStatusName + ";SUBMISSIONTYPE", new object[] { EnumUtils.ToDescription(CDX_Processing_Status.Pending), _submissionHistorySubmissionType }, _submissionHistoryTablePkName, delegate(IDataReader reader) { if (recordIdList == null) { recordIdList = new List <string>(); } recordIdList.Add(reader.GetString(0)); }); return(recordIdList); } return(null); }
public static SubmissionTrackingDataType GetActiveSubmissionTrackingElement(SpringBaseDao baseDao, string pk) { SubmissionTrackingDataType data = null; baseDao.DoSimpleQueryWithRowCallbackDelegate(TABLE_NAME, PK_COLUMN, pk, LOAD_COLUMNS, delegate(IDataReader reader) { int index = 0; data = new SubmissionTrackingDataType(); data.ETLCompletionDateTime = GetNullableDateTime(reader, ref index, out data.ETLCompletionDateTimeSpecified); data.DETChangeCompletionDateTime = GetNullableDateTime(reader, ref index, out data.DETChangeCompletionDateTimeSpecified); data.SubmissionDateTime = GetNullableDateTime(reader, ref index, out data.SubmissionDateTimeSpecified); data.SubmissionTransactionId = GetNullableString(reader, ref index); data.SubmissionTransactionStatus = GetNullableEnum <TransactionStatusCode>(reader, ref index, out data.SubmissionTransactionStatusSpecified); data.SubmissionStatusDateTime = GetNullableDateTime(reader, ref index, out data.SubmissionStatusDateTimeSpecified); data.ResponseParseDateTime = GetNullableDateTime(reader, ref index, out data.ResponseParseDateTimeSpecified); data.WorkflowStatus = GetEnum <TransactionStatusCode>(reader, ref index); data.WorkflowStatusMessage = GetNullableString(reader, ref index); }); if (data == null) { throw new ArgException("Could not find data in the {0} table with PK {1}", TABLE_NAME, pk); } return(data); }
private void DoSimpleQueryWithRowCallbackDelegate(IDbCommand dbCommand, string semicolonSeparatedTableNames, string semicolonSeparatedWhereColumnNames, IList <object> whereValues, string semicolonSeparatedColumnNames, RowCallbackDelegate callback) { _dao.DoSimpleQueryWithRowCallbackDelegate(semicolonSeparatedTableNames, semicolonSeparatedWhereColumnNames, whereValues, semicolonSeparatedColumnNames, callback); }
public static IList <string> GetActiveSubmissionTrackingElementPKs(SpringBaseDao baseDao) { List <string> pks = null; baseDao.DoSimpleQueryWithRowCallbackDelegate(TABLE_NAME, "WORKFLOW_STAT NOT " + FINISHED_STATUS_IN_CLAUSE, null, null, PK_COLUMN, delegate(IDataReader reader) { string pk = reader.GetString(0); CollectionUtils.Add(pk, ref pks); }); return(pks); }
protected SubmittedDocumentList GetSubmittedDocumentList() { SubmittedDocumentList list = new SubmittedDocumentList(); List <SubmittedDocument> documents = new List <SubmittedDocument>(); string triFlowId = _flowManager.GetDataFlowIdByName("TRI"); string queryString; object[] queryParams; if (_transactionStatus == CommonTransactionStatusCode.Unknown) { queryString = "FlowId;WebMethod;ModifiedOn >="; queryParams = new object[] { triFlowId, NodeMethod.Submit.ToString(), _submissionDate }; } else { queryString = "FlowId;WebMethod;Status;ModifiedOn >="; queryParams = new object[] { triFlowId, NodeMethod.Submit.ToString(), _transactionStatus.ToString(), _submissionDate }; } _baseDao.DoSimpleQueryWithRowCallbackDelegate( "NTransaction", queryString, queryParams, "ModifiedOn DESC", "Id;ModifiedOn", delegate(IDataReader reader) { SubmittedDocument doc = new SubmittedDocument(); doc.TransactionID = reader.GetString(0); doc.ReceivedDate = reader.GetDateTime(1); documents.Add(doc); }); TrimListToRequestSize(_dataRequest, documents); list.SubmittedDocuments = documents.ToArray(); return(list); }