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