/// <summary>
/// Get all valid values for a certain value domain
/// </summary>
/// <param name="catalogueOid">OID for the data catalogue</param>
/// <param name="valueDomainOid">OID for the value domain</param>
/// <returns></returns>
public List <TnfValidValue> GetAll(int catalogueOid, int valueDomainOid)
{
var validValues = new List <TnfValidValue>();
string commandText = String.Format("SELECT * FROM {0} WHERE catalogue_oid = '{1}' AND value_domain_oid = '{2}'",
TnfValidValueTableName, catalogueOid, valueDomainOid);
using (IDataReader idataReader = Db.ExecuteReader(commandText))
{
while (idataReader != null && idataReader.Read())
{
TnfValidValue validValue = ReadObject(idataReader);
validValues.Add(validValue);
}
}
return(validValues);
}
private List <TnfValidValue> GetAll(int catalogueOid, int fromDate, int toDate, bool bTimeInterval)
{
var validValues = new List <TnfValidValue>();
string commandText = String.Format("SELECT * FROM {0} WHERE catalogue_oid = {1}", TnfValidValueTableName, catalogueOid);
if (bTimeInterval)
{
commandText += " AND from_date >= " + fromDate + " AND to_date <= " + toDate;
}
using (IDataReader idataReader = Db.ExecuteReader(commandText))
{
while (idataReader != null && idataReader.Read())
{
TnfValidValue validValue = ReadObject(idataReader);
validValues.Add(validValue);
}
}
return(validValues);
}
public int Update(TnfValidValue tnfValidValue)
{
return(Update(new object[]
{
tnfValidValue.ValueDomainOid,
tnfValidValue.CatalogueOid,
tnfValidValue.Description,
tnfValidValue.SeqNo,
tnfValidValue.ValidFrom?.Date,
tnfValidValue.ValidTo?.Date,
tnfValidValue.MinValueDouble,
tnfValidValue.MaxValueDouble,
tnfValidValue.MinValueInteger,
tnfValidValue.MaxValueInteger,
tnfValidValue.ValueString,
tnfValidValue.MinValueDateTime?.ToUniversalTime(),
tnfValidValue.MaxValueDateTime?.ToUniversalTime(),
tnfValidValue.EnumCode,
tnfValidValue.Rank
}));
}
private static TnfValidValue ReadObject(IDataRecord reader)
{
var validValue = new TnfValidValue();
validValue.ValueDomainOid = reader["value_domain_oid"].ToInt();
validValue.CatalogueOid = reader["catalogue_oid"].ToInt();
validValue.Description = reader["description"].FromDbString();
validValue.SeqNo = reader["seq_no"].ToInt();
validValue.ValidFrom = reader["valid_from"].ToDateTime();
validValue.ValidTo = reader["valid_to"].ToDateTime();
validValue.MinValueDouble = reader["min_value_double"].ToDouble();
validValue.MaxValueDouble = reader["max_value_double"].ToDouble();
validValue.MinValueInteger = reader["min_value_integer"].ToInt32();
validValue.MaxValueInteger = reader["max_value_integer"].ToInt32();
validValue.ValueString = reader["value_string"].FromDbString();
validValue.MinValueDateTime = reader["min_value_datetime"].ToDateTime();
validValue.MaxValueDateTime = reader["max_value_datetime"].ToDateTime();
validValue.EnumCode = reader["enum_code"].ToInt32();
validValue.Rank = reader["rank"].ToInt32();
return(validValue);
}
