public List <TnfPropertyObjectTypeValidForTypeOfTransport> GetAllForType(int catalogueOid, int propertyObjectTypeOid)
{
if (!Db.TableExists(ValidForTypeOfTransportTableName))
{
return(new List <TnfPropertyObjectTypeValidForTypeOfTransport>());
}
List <TnfPropertyObjectTypeValidForTypeOfTransport> ret = new List <TnfPropertyObjectTypeValidForTypeOfTransport>();
string commandText = string.Format(@"select * from {0} where {1}='{2}' and {3}='{4}'",
ValidForTypeOfTransportTableName,
CatalogueOidColumnName,
catalogueOid,
PropertyObjectTypeOidColumnName,
propertyObjectTypeOid);
using (IDataReader idataReader = Db.ExecuteReader(commandText))
{
while (idataReader.Read())
{
TnfPropertyObjectTypeValidForTypeOfTransport validForTypeOfTransport = ReadValidForTypeOfTransport(idataReader);
ret.Add(validForTypeOfTransport);
}
}
return(ret);
}
public void Add(TnfPropertyObjectTypeValidForTypeOfTransport typeOfTransport)
{
Add(new object[]
{
typeOfTransport.PropertyObjectTypeOid,
typeOfTransport.CatalogueOid,
typeOfTransport.TypeOfTransport
});
}
