/// <summary>
/// Saves a property group
/// </summary>
/// <param name="propertyGroup"></param>
/// <returns>true if successful; false otherwise</returns>
internal bool Save(XPropertyGroup propertyGroup)
{
List <SqlParameter> paramList = new List <SqlParameter>();
if (propertyGroup.IsDirty)
{
paramList.Add(new SqlParameter("@Id", propertyGroup.Id));
paramList.Add(new SqlParameter("@Name", propertyGroup.Name));
paramList.Add(new SqlParameter("@DisplayValue", propertyGroup.DisplayValue));
paramList.Add(new SqlParameter("@AssetTypeId", propertyGroup.AssetTypeId));
paramList.Add(new SqlParameter("@IsInstance", propertyGroup.IsInstance));
paramList.Add(new SqlParameter("@Created", propertyGroup.Created));
paramList.Add(new SqlParameter("@LastModified", propertyGroup.LastModified));
paramList.Add(new SqlParameter("@Deleted", propertyGroup.Deleted));
paramList.Add(new SqlParameter("@CreatedBy", propertyGroup.CreatedBy));
paramList.Add(new SqlParameter("@LastModifiedBy", propertyGroup.LastModifiedBy));
paramList.Add(new SqlParameter("@DeletedBy", propertyGroup.DeletedBy));
if (base.ExecuteSql(spPropertyGroup_Save, paramList))
{
if (new PropertyGroupPropertyRelationDal(this.ConnectionString).PropertyGroupPropertyRelationList_Save(propertyGroup.PropertyMembers))
{
propertyGroup.IsNew = false;
propertyGroup.IsDirty = false;
return(true);
}
}
return(false);
}
return(true);
}
/// <summary>
/// Gets a PropertyGroup instance based on the supplied id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
internal XPropertyGroup Get(Guid id)
{
XPropertyGroup propGroup = null;
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@Id", id));
using (SqlDataReader rdr = base.OpenDataReader(spPropertyGroup_Get, paramList))
{
if ((rdr == null) || (!rdr.HasRows))
{
return(null);
}
propGroup = new XPropertyGroup();
propGroup.Id = id;
rdr.Read();
int name = rdr.GetOrdinal("Name");
int display = rdr.GetOrdinal("DisplayValue");
int atId = rdr.GetOrdinal("AssetTypeId");
int isInstance = rdr.GetOrdinal("IsInstance");
int created = rdr.GetOrdinal("Created");
int lastMod = rdr.GetOrdinal("LastModified");
int deleted = rdr.GetOrdinal("Deleted");
int createdBy = rdr.GetOrdinal("CreatedBy");
int lastModBy = rdr.GetOrdinal("LastModifiedBy");
int deletedBy = rdr.GetOrdinal("DeletedBy");
if (!rdr.IsDBNull(name))
{
propGroup.Name = rdr.GetString(name);
}
if (!rdr.IsDBNull(display))
{
propGroup.DisplayValue = rdr.GetString(display);
}
if (!rdr.IsDBNull(atId))
{
propGroup.AssetTypeId = rdr.GetGuid(atId);
}
if (!rdr.IsDBNull(isInstance))
{
propGroup.IsInstance = (bool)rdr.GetValue(isInstance);
}
if (!rdr.IsDBNull(created))
{
propGroup.Created = rdr.GetDateTime(created);
}
if (!rdr.IsDBNull(lastMod))
{
propGroup.LastModified = rdr.GetDateTime(lastMod);
}
if (!rdr.IsDBNull(deleted))
{
propGroup.Deleted = rdr.GetDateTime(deleted);
}
if (!rdr.IsDBNull(createdBy))
{
propGroup.CreatedBy = rdr.GetGuid(createdBy);
}
if (!rdr.IsDBNull(lastModBy))
{
propGroup.LastModifiedBy = rdr.GetGuid(lastModBy);
}
if (!rdr.IsDBNull(deletedBy))
{
propGroup.DeletedBy = rdr.GetGuid(deletedBy);
}
//PropertyGroupPropertyRelationDal relationDal = new PropertyGroupPropertyRelationDal();
//PropertyDal pDal = new PropertyDal();
//foreach (PropertyGroupPropertyRelation relation in relationDal.PropertyGroupPropertyRelationList_GetByPropertyGroupId(id))
//{
// propGroup.AddPropertyMember(relation);
// Property prop = pDal.Get(relation.PropertyId);
// prop.IsRequired = relation.IsRequired;
// prop.IsReadOnly = relation.IsReadOnly;
// prop.DefaultValue = relation.DefaultValue;
// propGroup.Properties.Add(prop);
//}
//propGroup.Properties.IsNew = false;
//propGroup.Properties.IsDirty = false;
propGroup.IsNew = false;
propGroup.IsDirty = false;
return(propGroup);
}
}
internal List <XPropertyGroup> GetCollectionByViewId(Guid viewId)
{
//PropertyDal propDal = new PropertyDal();
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@ViewId", viewId));
List <XPropertyGroup> values = new List <XPropertyGroup>();
using (SqlDataReader rdr = base.OpenDataReader(spPropertyGroupList_GetByViewId, paramList))
{
if ((rdr == null) || (!rdr.HasRows))
{
return(values);
}
int id = rdr.GetOrdinal("Id");
int name = rdr.GetOrdinal("Name");
int display = rdr.GetOrdinal("DisplayValue");
int atId = rdr.GetOrdinal("AssetTypeId");
int isInstance = rdr.GetOrdinal("IsInstance");
int created = rdr.GetOrdinal("Created");
int lastMod = rdr.GetOrdinal("LastModified");
int createdBy = rdr.GetOrdinal("CreatedBy");
int lastModBy = rdr.GetOrdinal("LastModifiedBy");
while (rdr.Read())
{
XPropertyGroup propGroup = new XPropertyGroup();
propGroup.Id = rdr.GetGuid(id);
if (!rdr.IsDBNull(name))
{
propGroup.Name = rdr.GetString(name);
}
if (!rdr.IsDBNull(display))
{
propGroup.DisplayValue = rdr.GetString(display);
}
propGroup.AssetTypeId = rdr.GetGuid(atId);
if (!rdr.IsDBNull(isInstance))
{
propGroup.IsInstance = (bool)rdr.GetValue(isInstance);
}
propGroup.Created = rdr.GetDateTime(created);
if (!rdr.IsDBNull(lastMod))
{
propGroup.LastModified = rdr.GetDateTime(lastMod);
}
propGroup.CreatedBy = rdr.GetGuid(createdBy);
if (!rdr.IsDBNull(lastModBy))
{
propGroup.LastModifiedBy = rdr.GetGuid(lastModBy);
}
//PropertyGroupPropertyRelationDal relationDal = new PropertyGroupPropertyRelationDal();
//PropertyDal pDal = new PropertyDal();
//foreach (PropertyGroupPropertyRelation relation in relationDal.PropertyGroupPropertyRelationList_GetByPropertyGroupId(propGroup.Id))
//{
// propGroup.AddPropertyMember(relation);
//}
propGroup.IsNew = false;
propGroup.IsDirty = false;
values.Add(propGroup);
}
//foreach (PropertyGroup pg in values)
//{
// pg.Properties = propDal.GetCollectionByPropertyGroupId(pg.Id);
//}
}
return(values);
}
