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);
}