/// <summary> /// This function retrieves the default container tissue mapping. /// </summary> public DataTable GetContainerTissueMapping() { if (_mappingContainerTissue == null) { _mappingContainerTissue = _databaseObject.CreateAndFillDataTable($"SELECT {QRY_CONTAINER_TISSUE_COLUMNS} FROM {QRY_CONTAINER_TISSUE}"); } return(_mappingContainerTissue.Copy()); }
private bool needsConverstion(DAS database, string queryToExecute) { try { database.CreateAndFillDataTable(queryToExecute); return(false); } catch (OleDbException) { return(true); } }
public DASDataTable FullTableFrom(string query) { return(DatabaseObject.CreateAndFillDataTable(query)); }
/// <summary> /// This function retrieves a list of found proteins fulfilling the search criteria. /// </summary> public DataTable GetProteinsByName(string name) { DASDataTable retTable = null; try { _databaseObject.AddParameter(P_NAME, name, DAS.ParameterModes.PARM_IN, DAS.ServerTypes.ST_VARCHAR2); retTable = _databaseObject.CreateAndFillDataTable( $"SELECT {QRY_FIND_PROTEINS_COLUMNS} FROM {QRY_PROTEINS_BY_NAME} WHERE {P_NAME} = @{P_NAME}"); } finally { _databaseObject.RemoveParameter(P_NAME); } return(retTable); }