/// <summary>
/// This function retrieves a list of property strings for a data base record id.
/// </summary>
public string[] GetDataBaseRecProperties(string database, string rec_id)
{
DASDataTable dt = null;
string[] ret;
try
{
_databaseObject.AddParameter(P_DATABASE, database, DAS.ParameterModes.PARM_IN,
DAS.ServerTypes.STRING);
_databaseObject.AddParameter(P_REC_ID, rec_id, DAS.ParameterModes.PARM_IN,
DAS.ServerTypes.STRING);
dt = _databaseObject.CreateAndFillDataTable(
$"SELECT {QRY_DATABASE_REC_PROPERTIES_COLUMNS} FROM {QRY_DATABASE_REC_PROPERTIES_BY_ID} WHERE {P_DATABASE} = @{P_DATABASE} AND {P_REC_ID} = @{P_REC_ID}");
ret = new string[dt.Rows.Count()];
int i = 0;
foreach (DASDataRow dr in dt.Rows)
{
DASColumnValue property = new DASColumnValue(dr, dr.Table.Columns.ItemByName("PROPERTY"));
DASColumnValue propertyValue = new DASColumnValue(dr, dr.Table.Columns.ItemByName("PROPERTY_VALUE"));
ret[i++] += $"{property.GetValueAsString()}: {propertyValue.GetValueAsString()}";
}
}
finally
{
_databaseObject.RemoveParameter(P_DATABASE);
_databaseObject.RemoveParameter(P_REC_ID);
}
return(ret);
}
/// <summary>
/// This function retrieves a list of information strings for a data base record id.
/// </summary>
public string[] GetDataBaseRecInfos(string database, string rec_id)
{
DASDataTable dt = null;
string[] ret;
try
{
_databaseObject.AddParameter(P_DATABASE, database, DAS.ParameterModes.PARM_IN,
DAS.ServerTypes.STRING);
_databaseObject.AddParameter(P_REC_ID, rec_id, DAS.ParameterModes.PARM_IN,
DAS.ServerTypes.STRING);
dt = _databaseObject.CreateAndFillDataTable(
$"SELECT {QRY_DATABASE_REC_INFO_COLUMNS} FROM {QRY_DATABASE_REC_INFO_BY_ID} WHERE {P_DATABASE} = @{P_DATABASE} AND {P_REC_ID} = @{P_REC_ID}");
ret = new string[dt.Columns.Count() - 2];
foreach (DASDataRow dr in dt.Rows)
{
for (int i = 2; i < dt.Columns.Count(); i++)
{
var colval = new DASColumnValue(dr, dt.Columns.ItemByIndex(i));
if (colval.DBNullValue)
{
continue;
}
if (colval.Value is DateTime)
{
ret[i - 2] += $"{dt.Columns.ItemByIndex(i).ColumnName}: {colval.GetValueAsString("yyyy-MM-dd")}";
}
else
{
ret[i - 2] += $"{dt.Columns.ItemByIndex(i).ColumnName}: {colval.GetValueAsString()}";
}
}
}
}
finally
{
_databaseObject.RemoveParameter(P_DATABASE);
_databaseObject.RemoveParameter(P_REC_ID);
}
return(ret);
}
