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