cdac.medinfo.sdk.dcm30_04.services.ups.dbhelper

Class UPS_DBQuery

java.lang.Object

cdac.medinfo.sdk.dcm30_04.services.ups.dbhelper.UPS_DBQuery

public class UPS_DBQuery
extends java.lang.Object

This class interacts with database and performs queries fired.

Constructor Summary

Constructors

Constructor and Description
UPS_DBQuery() This id default constructor for UPS_DBQuery

Method Summary

Methods

Modifier and Type	Method and Description
boolean	checkForSubscription(java.lang.String strSOPInstance) Check for subscription for specified SOP .
java.lang.String	getDATASETUUID(java.lang.String strUID) Checks whether provided transaction UID is created or not.
boolean	isTransactionUIDExist(java.lang.String strUID) Checks whether provided transaction UID is exist or not.
IDataSet	retrieveInstanceInfo(ISingleCollection<ITag> objTagCollection, java.lang.String strSOPInstance) Retrieves the information of a given SOP Instance UID and populates the Dataset.
IDataSet	retrieveInstanceInfoForTwo(ISingleCollection<ITag> objTagCollection, java.lang.String strSOPInstance) This function gets the Status for N-Event Report Service.
IDataSet	retrieveUPSInstanceInfoForThree(ISingleCollection<ITag> objTagCollection, java.lang.String strSOPInstance) This function gets the Status for N-Event Report Service.
boolean	storeInstanceInfoForSubscription(IDataSet objIDataSet) Updates the SOPInstance information for Subscription.
boolean	storeInstanceInfoForUnSubscribe(IDataSet objIDataSet) Updates the SOPInstance information for UnSubscribe It updates the information of all DataElements of provided Dataset
boolean	updateUPSInstanceInfo(IDataSet objIDataSet, java.lang.String strSOPInstance) Updates the SOPInstance information.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

UPS_DBQuery

public UPS_DBQuery()

This id default constructor for UPS_DBQuery

Method Detail

isTransactionUIDExist

public boolean isTransactionUIDExist(java.lang.String strUID)
                              throws java.sql.SQLException

Checks whether provided transaction UID is exist or not.

Parameters:

strSOPInstance - value of transaction UID

Returns:

boolean shows status as success or failure

Throws:

java.sql.SQLException - if sql operation fails

updateUPSInstanceInfo

public boolean updateUPSInstanceInfo(IDataSet objIDataSet,
                            java.lang.String strSOPInstance)
                              throws java.sql.SQLException

Updates the SOPInstance information. It updates the information of all DataElements of provided Dataset

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOPInstance UID

Returns:

boolean status as true or false

Throws:

java.sql.SQLException - if SQL Operation fails

getDATASETUUID

public java.lang.String getDATASETUUID(java.lang.String strUID)
                                throws java.sql.SQLException

Checks whether provided transaction UID is created or not.

Parameters:

strSOPInstance - value of transaction UID

Returns:

boolean shows status as success or failure

Throws:

java.sql.SQLException - if sql operation fails

retrieveInstanceInfo

public IDataSet retrieveInstanceInfo(ISingleCollection<ITag> objTagCollection,
                            java.lang.String strSOPInstance)
                              throws java.sql.SQLException

Retrieves the information of a given SOP Instance UID and populates the Dataset.

Parameters:

objIDataSet - instance of input Dataset

strSOPInstanceUID - value of SOPInstance UID

Returns:

objIDataSet instance of resultant Dataset

Throws:

java.sql.SQLException - if SQL operation fails

storeInstanceInfoForSubscription

public boolean storeInstanceInfoForSubscription(IDataSet objIDataSet)
                                         throws java.sql.SQLException

Updates the SOPInstance information for Subscription. It updates the information of all DataElements of provided Dataset

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOPInstance UID

Returns:

boolean status as true or false

Throws:

java.sql.SQLException - if SQL Operation fails

storeInstanceInfoForUnSubscribe

public boolean storeInstanceInfoForUnSubscribe(IDataSet objIDataSet)
                                        throws java.sql.SQLException

Updates the SOPInstance information for UnSubscribe It updates the information of all DataElements of provided Dataset

Parameters:

objIDataSet - instance of Dataset

strSOPInstanceUID - value of SOPInstance UID

Returns:

boolean status as true or false

Throws:

java.sql.SQLException - if SQL Operation fails

retrieveInstanceInfoForTwo

public IDataSet retrieveInstanceInfoForTwo(ISingleCollection<ITag> objTagCollection,
                                  java.lang.String strSOPInstance)
                                    throws java.sql.SQLException

This function gets the Status for N-Event Report Service.

Throws:

java.sql.SQLException

retrieveUPSInstanceInfoForThree

public IDataSet retrieveUPSInstanceInfoForThree(ISingleCollection<ITag> objTagCollection,
                                       java.lang.String strSOPInstance)
                                         throws java.sql.SQLException

This function gets the Status for N-Event Report Service.

Throws:

java.sql.SQLException

checkForSubscription

public boolean checkForSubscription(java.lang.String strSOPInstance)
                             throws java.sql.SQLException

Check for subscription for specified SOP .

Parameters:

strSOPInstance -

Returns:

true if Success, otherwise false

Throws:

java.sql.SQLException