public IList <IXObjectTypeProperty> GetByAssetTypeId(Guid assetTypeId) { IList <IXObjectTypeProperty> list = new List <IXObjectTypeProperty>(); using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.AssetTypePropertyRelations_Get, new List <SqlParameter>() { new SqlParameter("@AssetTypeId", assetTypeId) })) { if ((rdr == null) || (!rdr.HasRows)) { return(list); } int Id = rdr.GetOrdinal("Id"); int AssetTypeId = rdr.GetOrdinal("AssetTypeId"); int PropertyId = rdr.GetOrdinal("PropertyId"); int IsInstance = rdr.GetOrdinal("IsInstance"); int IsInherited = rdr.GetOrdinal("IsInherited"); int IsInheritedValue = rdr.GetOrdinal("IsInheritedValue"); int Created = rdr.GetOrdinal("Created"); int CreatedBy = rdr.GetOrdinal("CreatedBy"); while (rdr.Read()) { XObjectTypeProperty relation = new XObjectTypeProperty(); if (!rdr.IsDBNull(Id)) { relation.Id = rdr.GetGuid(Id); } if (!rdr.IsDBNull(AssetTypeId)) { relation.AssetTypeId = rdr.GetGuid(AssetTypeId); } if (!rdr.IsDBNull(PropertyId)) { relation.PropertyId = rdr.GetGuid(PropertyId); } if (!rdr.IsDBNull(IsInstance)) { relation.IsInstance = (bool)rdr.GetValue(IsInstance); } if (!rdr.IsDBNull(IsInherited)) { relation.IsInherited = (bool)rdr.GetValue(IsInherited); } if (!rdr.IsDBNull(IsInheritedValue)) { relation.IsInheritedValue = (bool)rdr.GetValue(IsInheritedValue); } if (!rdr.IsDBNull(Created)) { relation.Created = rdr.GetDateTime(Created); } if (!rdr.IsDBNull(CreatedBy)) { relation.CreatedBy = rdr.GetGuid(CreatedBy); } relation.IsNew = false; relation.IsDirty = false; list.Add(relation); } } return(list); }
public IXObjectTypeProperty Get(Guid id) { using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.AssetTypePropertyRelation_Get, new List <SqlParameter>() { new SqlParameter("@Id", id) })) { if ((rdr == null) || (!rdr.HasRows)) { return(null); } rdr.Read(); XObjectTypeProperty relation = new XObjectTypeProperty(); if (!rdr.IsDBNull(rdr.GetOrdinal("AssetTypeId"))) { relation.AssetTypeId = (Guid)rdr[rdr.GetOrdinal("AssetTypeId")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("PropertyId"))) { relation.PropertyId = (Guid)rdr[rdr.GetOrdinal("PropertyId")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("IsInstance"))) { relation.IsInstance = (bool)rdr[rdr.GetOrdinal("IsInstance")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("IsInheritedValue"))) { relation.IsInheritedValue = (bool)rdr[rdr.GetOrdinal("IsInheritedValue")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Created"))) { relation.Created = (DateTime)rdr[rdr.GetOrdinal("Created")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedBy"))) { relation.CreatedBy = (Guid)rdr[rdr.GetOrdinal("CreatedBy")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Deleted"))) { relation.Deleted = (DateTime)rdr[rdr.GetOrdinal("Deleted")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("DeletedBy"))) { relation.DeletedBy = (Guid)rdr[rdr.GetOrdinal("DeletedBy")]; } relation.Id = id; relation.IsNew = false; relation.IsDirty = false; return(relation); } }
private IList <IXObjectTypeProperty> GetCollectionFromReader(string spName, List <SqlParameter> paramList) { IList <IXObjectTypeProperty> list = new List <IXObjectTypeProperty>(); using (SqlDataReader rdr = base.OpenDataReader(spName, paramList)) { if ((rdr != null) && (rdr.HasRows)) { int Id = rdr.GetOrdinal("Id"); int AssetTypeId = rdr.GetOrdinal("AssetTypeId"); int PropertyId = rdr.GetOrdinal("PropertyId"); int IsInstance = rdr.GetOrdinal("IsInstance"); int IsInheritedValue = rdr.GetOrdinal("IsInheritedValue"); int Created = rdr.GetOrdinal("Created"); int CreatedBy = rdr.GetOrdinal("CreatedBy"); while (rdr.Read()) { XObjectTypeProperty relation = new XObjectTypeProperty(); if (!rdr.IsDBNull(Id)) { relation.Id = rdr.GetGuid(Id); } if (!rdr.IsDBNull(AssetTypeId)) { relation.AssetTypeId = rdr.GetGuid(AssetTypeId); } if (!rdr.IsDBNull(PropertyId)) { relation.PropertyId = rdr.GetGuid(PropertyId); } if (!rdr.IsDBNull(IsInstance)) { relation.IsInstance = (bool)rdr.GetValue(IsInstance); } if (!rdr.IsDBNull(IsInheritedValue)) { relation.IsInheritedValue = (bool)rdr.GetValue(IsInheritedValue); } if (!rdr.IsDBNull(Created)) { relation.Created = rdr.GetDateTime(Created); } if (!rdr.IsDBNull(CreatedBy)) { relation.CreatedBy = rdr.GetGuid(CreatedBy); } relation.IsNew = false; relation.IsDirty = false; list.Add(relation); } } } return(list); }