Initializes a new instance of the SpecimenManagerDa class

Concatenates two strings that are already in SQL VALUES IN format

Takes an array of strings and puts every element in one string in 'str1','str2','str3' format ready to be used for SQL VALUES IN()

Determines whether the specified Object is equal to the current Object.

Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

Get all Accession records by PatientId

Get all Accession records by PatientId

Get all specimens records. Order by Boxname, then PositionId

Gets all the collections that are available for (transfer) requests (status "Available").

Gets all the collections that are available for putting specimens in (status "Available" or "Pending Transfer").

Returns a DataSet (array of DataTables) which traces back the path to a SiteId. This returns the an array of sibling

Gets all boxes (id and name) that are part of the collection If there are specimens in the collection, with no box associated, it also adds a new "Other" box with id 0

Get specimens based on breast cancer clinical/research data

Same as GetBreastResearchSpecimens but takes a range of record to be returned and allows option of just returning the record count ONLY SQL SERVER 2005 Compatible

Get the collection with the passed in collection name

Get the Id of the collection by its name

Get the list of collections that match the parameters passed in.

Get all Collections of each specimen passing SpecimenId

Get contacts by ContactType=Specimen for specimens

Gets the distribution associated with the request Id.

Serves as a hash function for a particular type.

Get Identifier by type (from Web.config) and specimenId

Get Identifier by type (from Web.config), patientId and dataset

Get Parentkey by SpeciemnId

Same as GetProstateResearchByHistologyData but takes a range of record to be returned and allows option of just returning the record count ONLY SQL SERVER 2005 Compatible

Same as GetProstateResearchByReferenceNumberData but takes a range of record to be returned and allows option of just returning the record count ONLY SQL SERVER 2005 Compatible

Get details of all the specimens and boxes in the collections part of this request.

Get a Specimen Request by name (RequestIdentifier).

Returns a list of specimens based on Protocol patients. Optionally filtered by search params.

Returns dataset comprised of DISTINCT PtProtocolStudyId, DISTINCT SpecimenStatus

Get Specimens by AccessionId.

Gets all specimens in the box. Adds a custom column "Transferable" with values "yes" if the specimen is part of the collection "no" otherwise

used to get the Specimens having Children this is used to validate deletion of specimens in SpecimenAccession record Specimens grid

Get all specimens in the collection with the passed in Id.

Gets the Type of the current instance.

Gets all specimens that are part of a collection but are not in a box

Creates a shallow copy of the current Object.

Returns a String that represents the current Object.