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