private List <Association> GetAssociations(List <StoredQueryParameter> lstStoredQueryParameter) { List <Association> lstAssociations = null; RegistryStoredQueryDataAccess objStoredQueryDAL = null; string paramValue = null; string entryUUID = null; string uniqueID = null; //Prepare SQL IN Param Value paramValue = PrepareForSqlInStatement(lstStoredQueryParameter[0].ParameterValue); if (lstStoredQueryParameter[0].ParameterName == "$XDSDocumentEntryEntryUUID") { entryUUID = paramValue; } else { uniqueID = paramValue; } objStoredQueryDAL = new RegistryStoredQueryDataAccess(); lstAssociations = objStoredQueryDAL.GetAssociations(entryUUID, uniqueID); return(lstAssociations); }
public override System.Xml.XmlDocument ProcessQuery(StoredQuery objStoredQueryRequest) { XmlDocument xmlDocResponse = null; XmlDocument xmlDocAdHocQueryResponse; List <SubmissionSet> lstSubmissionSet = null; List <DocumentEntry> lstDocumentEntry = null; List <Folder> lstFolder = null; List <Association> lstAssociation = null; string patientUID = null; string submissionSetStatus = null; string documentEntryStatus = null; string folderStatus = null; string documentEntryUUIDs = null; RegistryStoredQueryDataAccess objStoredQueryDAL = new RegistryStoredQueryDataAccess(); patientUID = base.RemoveSingleQuotes(GetParameterValue(objStoredQueryRequest.ParameterList, "$patientId")); submissionSetStatus = base.PrepareForSqlInStatement(GetParameterValue(objStoredQueryRequest.ParameterList, "$XDSSubmissionSetStatus")); documentEntryStatus = base.PrepareForSqlInStatement(GetParameterValue(objStoredQueryRequest.ParameterList, "$XDSDocumentEntryStatus")); folderStatus = base.PrepareForSqlInStatement(GetParameterValue(objStoredQueryRequest.ParameterList, "$XDSFolderStatus")); //SubmissionSet lstSubmissionSet = objStoredQueryDAL.GetSubmissionSets(submissionSetStatus, patientUID); //DocumentEntry lstDocumentEntry = objStoredQueryDAL.GetDocumentEntries(documentEntryStatus, patientUID); lstDocumentEntry = GetDocumentEntries(lstDocumentEntry, objStoredQueryRequest); documentEntryUUIDs = GetDocumentEntryUUIDs(lstDocumentEntry); //Folders lstFolder = objStoredQueryDAL.GetFolders(folderStatus, patientUID); //Associations lstAssociation = objStoredQueryDAL.GetAssociations(documentEntryUUIDs, null); //Construct AdHocQueryResponse Element xmlDocAdHocQueryResponse = StoredQueryBase.ConstructAdHocQueryResponseElement(GlobalValues.CONST_RESPONSE_STATUS_TYPE_SUCCESS); xmlDocResponse = ConstructRegistryObjectList(xmlDocAdHocQueryResponse, lstSubmissionSet, lstDocumentEntry, lstFolder, lstAssociation); return(xmlDocResponse); }
protected List <SubmissionSetDocumentFolder> GetAssociationsBySourceObjectOrTargetObject(List <StoredQueryParameter> lstStoredQueryParams) { List <SubmissionSetDocumentFolder> lstAssociations = null; RegistryStoredQueryDataAccess objRegistryStoredQueryDAL = null; string uuids = null; for (int count = 0; count < lstStoredQueryParams.Count; count++) { if (lstStoredQueryParams[count].ParameterName == "$uuid") { uuids = PrepareForSqlInStatement(lstStoredQueryParams[count].ParameterValue); } } objRegistryStoredQueryDAL = new RegistryStoredQueryDataAccess(); lstAssociations = objRegistryStoredQueryDAL.GetAssociations(uuids); objRegistryStoredQueryDAL = null; return(lstAssociations); }