public int Update(TnfValueDomain tnfValueDomain) { return(Update(new object[] { tnfValueDomain.Oid, tnfValueDomain.CatalogueOid, tnfValueDomain.ValueDomainType, tnfValueDomain.Name, tnfValueDomain.ShortName, tnfValueDomain.Description, tnfValueDomain.DataType, tnfValueDomain.NrDec, tnfValueDomain.IsUnion, tnfValueDomain.Unit, tnfValueDomain.NrChar })); }
public void Add(TnfValueDomain tnfValueDomain) { Add(new object[] { tnfValueDomain.Oid, tnfValueDomain.CatalogueOid, tnfValueDomain.ValueDomainType, tnfValueDomain.Name, tnfValueDomain.ShortName, tnfValueDomain.Description, tnfValueDomain.DataType, tnfValueDomain.NrDec, tnfValueDomain.IsUnion, tnfValueDomain.Unit, tnfValueDomain.NrChar }); }
private static TnfValueDomain ReadObject(IDataRecord reader) { var tnfValueDomain = new TnfValueDomain(); tnfValueDomain.Oid = reader["oid"].ToInt(); tnfValueDomain.CatalogueOid = reader["catalogue_oid"].ToInt(); tnfValueDomain.ValueDomainType = reader["value_domain_type"].FromDbString(); tnfValueDomain.Name = reader["name"].FromDbString(); tnfValueDomain.ShortName = reader["shortname"].FromDbString(); tnfValueDomain.Description = reader["description"].FromDbString(); tnfValueDomain.DataType = reader["datatype"].FromDbString(); tnfValueDomain.NrDec = reader["nr_dec"].ToInt32(); tnfValueDomain.IsUnion = reader.ReadIfExists("is_union").ToBoolean() ?? false; tnfValueDomain.Unit = reader["unit"].FromDbString(); tnfValueDomain.NrChar = reader["nr_char"].ToInt32(); return(tnfValueDomain); }
private List <TnfValueDomain> GetAll(int catalogueOid, int fromDate, int toDate, bool bTimeInterval) { var valueDomains = new List <TnfValueDomain>(); string commandText = String.Format("SELECT * FROM {0} WHERE catalogue_oid = {1}", TnfValueDomainTableName, catalogueOid); if (bTimeInterval) { commandText += " AND valid_from >= " + fromDate + " AND valid_to <= " + toDate; } using (IDataReader idataReader = Db.ExecuteReader(commandText)) { while (idataReader != null && idataReader.Read()) { TnfValueDomain valueDomain = ReadObject(idataReader); valueDomains.Add(valueDomain); } } return(valueDomains); }