} // getPropsNotInLayout()
public Collection <CswNbtObjClassDesignNodeTypeProp> getPropNodesInLayout(Int32 NodeTypeId, Int32 TabId, CswEnumNbtLayoutType LayoutType, bool NumberedOnly = false, CswDateTime Date = null)
{
Collection <CswNbtObjClassDesignNodeTypeProp> ret = new Collection <CswNbtObjClassDesignNodeTypeProp>();
CswTableSelect LayoutSelect = _CswNbtMetaDataResources.CswNbtResources.makeCswTableSelect("getPropNodesInLayout_select", "nodetype_layout");
string WhereClause = "where nodetypeid = " + NodeTypeId.ToString() +
" and nodetypetabsetid = " + TabId.ToString() +
" and layouttype = '" + LayoutType.ToString() + "'";
if (NumberedOnly)
{
WhereClause += " and nodetypepropid in (select nodetypepropid " +
" from nodetype_props " +
" where " + CswEnumNbtNodeTypePropAttributes.usenumbering + " = '" + CswConvert.ToDbVal(true) + "')";
}
Collection <OrderByClause> orderBy = new Collection <OrderByClause>()
{
new OrderByClause("display_row", CswEnumOrderByType.Ascending),
new OrderByClause("display_column", CswEnumOrderByType.Descending)
};
DataTable LayoutTable = LayoutSelect.getTable(WhereClause, orderBy);
foreach (DataRow Row in LayoutTable.Rows)
{
Int32 PropId = CswConvert.ToInt32(Row["nodetypepropid"]);
CswNbtObjClassDesignNodeTypeProp PropNode = _CswNbtMetaDataResources.CswNbtResources.Nodes.getNodeByRelationalId(new CswPrimaryKey("nodetype_props", PropId));
ret.Add(PropNode);
}
return(ret);
} // getPropNodesInLayout()
public IEnumerable<CswNbtMetaDataNodeTypeProp> getLayoutProps( Int32 NodeTypeId, Int32 TabId, CswEnumNbtLayoutType LayoutType, CswDateTime Date, bool PropsInLayout = true )
{
string NodeTypeIdStr = NodeTypeId.ToString();
string WhereClause = "where nodetypeid = '" + NodeTypeIdStr + "' ";
WhereClause += " and nodetypepropid ";
if( PropsInLayout )
{
WhereClause += " in ";
}
else
{
WhereClause += " not in ";
}
WhereClause += " (select nodetypepropid ";
if( null == Date || Date.ToDateTime() == DateTime.MinValue )
{
WhereClause += " from nodetype_layout ";
}
else
{
WhereClause += " from " + CswNbtAuditTableAbbreviation.getAuditTableSql( _CswNbtMetaDataResources.CswNbtResources, "nodetype_layout", Date );
}
WhereClause += " where layouttype = '" + LayoutType.ToString() + "'" +
" and nodetypeid = " + NodeTypeIdStr + @" ";
if( LayoutType == CswEnumNbtLayoutType.Edit && TabId != Int32.MinValue )
{
WhereClause += "and nodetypetabsetid = " + TabId.ToString();
}
WhereClause += ")";
return _CollImpl.getWhere( WhereClause, Date ).Cast<CswNbtMetaDataNodeTypeProp>();
} // getPropsInLayout()
} // getLayout()
/// <summary>
/// Returns a layout for a property on a tab.
/// If edit, be sure to supply a valid TabId.
/// </summary>
public NodeTypeLayout getLayout(CswEnumNbtLayoutType LayoutType, Int32 NodeTypeId, Int32 PropId, Int32 TabId, CswDateTime Date)
{
NodeTypeLayout ret = null;
if (false == CswTools.IsDate(Date))
{
_CacheLayout(NodeTypeId);
ret = _Cache[NodeTypeId].FirstOrDefault(Layout => Layout.LayoutType == LayoutType &&
Layout.PropId == PropId &&
(LayoutType != CswEnumNbtLayoutType.Edit || Layout.TabId == TabId));
}
else
{
string Sql = @"select * from " + CswNbtAuditTableAbbreviation.getAuditTableSql(_CswNbtMetaDataResources.CswNbtResources, "nodetype_layout", Date) +
" where nodetypeid = " + NodeTypeId + " " +
" and layouttype = '" + LayoutType.ToString() + "' " +
" and nodetypepropid = " + PropId + " ";
if (LayoutType == CswEnumNbtLayoutType.Edit)
{
Sql += " and nodetypetabsetid = " + TabId;
}
CswArbitrarySelect LayoutSelect = _CswNbtMetaDataResources.CswNbtResources.makeCswArbitrarySelect("getLayout_Audit_Select", Sql);
DataTable LayoutTable = LayoutSelect.getTable();
if (LayoutTable.Rows.Count > 0)
{
ret = new NodeTypeLayout(LayoutTable.Rows[0]);
}
}
return(ret);
} // getLayout()
/// <summary>
/// Returns a dictionary of layout by tab
/// </summary>
public Dictionary <Int32, NodeTypeLayout> getLayout(CswEnumNbtLayoutType LayoutType, Int32 NodeTypeId, Int32 PropId, CswDateTime Date)
{
Dictionary <Int32, NodeTypeLayout> LayoutByTab = new Dictionary <Int32, NodeTypeLayout>();
if (false == CswTools.IsDate(Date))
{
_CacheLayout(NodeTypeId);
foreach (NodeTypeLayout Layout in _Cache[NodeTypeId].Where(Layout => Layout.LayoutType == LayoutType &&
Layout.PropId == PropId))
{
LayoutByTab[Layout.TabId] = Layout;
}
}
else
{
string Sql = @"select * from " + CswNbtAuditTableAbbreviation.getAuditTableSql(_CswNbtMetaDataResources.CswNbtResources, "nodetype_layout", Date) +
" where nodetypeid = " + NodeTypeId + " " +
" and layouttype = '" + LayoutType.ToString() + "' " +
" and nodetypepropid = " + PropId;
CswArbitrarySelect LayoutSelect = _CswNbtMetaDataResources.CswNbtResources.makeCswArbitrarySelect("getLayout_Audit_Select", Sql);
DataTable LayoutTable = LayoutSelect.getTable();
foreach (DataRow LayoutRow in LayoutTable.Rows)
{
NodeTypeLayout Layout = new NodeTypeLayout(LayoutRow);
LayoutByTab.Add(Layout.TabId, Layout);
}
}
return(LayoutByTab);
} // getLayout()
} // updatePropLayout()
public void updatePropLayout(CswEnumNbtLayoutType LayoutType, CswNbtMetaDataNodeTypeProp Prop, CswNbtMetaDataNodeTypeProp InsertAfterProp, bool DoMove)
{
bool Added = false;
if (DoMove)
{
removePropFromLayout(LayoutType, Prop, Int32.MinValue);
}
if (InsertAfterProp != null)
{
Dictionary <Int32, NodeTypeLayout> InsertAfterPropLayouts = getLayout(LayoutType, InsertAfterProp, null);
if (InsertAfterPropLayouts.Values.Count > 0)
{
foreach (Int32 TabId in InsertAfterPropLayouts.Keys)
{
NodeTypeLayout InsertAfterPropLayout = InsertAfterPropLayouts[TabId];
// Make space for the new prop
CswTableUpdate LayoutUpdate = _CswNbtMetaDataResources.CswNbtResources.makeCswTableUpdate("makeSpaceForProp_Update", "nodetype_layout");
string WhereClause = "where layouttype = '" + LayoutType.ToString() + "' and nodetypeid = " + InsertAfterProp.NodeTypeId.ToString();
if (TabId != Int32.MinValue && LayoutType == CswEnumNbtLayoutType.Edit)
{
WhereClause += " and nodetypetabsetid = " + TabId.ToString();
}
DataTable LayoutTable = LayoutUpdate.getTable(WhereClause);
foreach (DataRow Row in LayoutTable.Rows)
{
if (CswConvert.ToInt32(Row["display_column"]) == InsertAfterPropLayout.DisplayColumn &&
CswConvert.ToInt32(Row["display_row"]) > InsertAfterPropLayout.DisplayRow)
{
Row["display_row"] = CswConvert.ToDbVal(CswConvert.ToInt32(Row["display_row"]) + 1);
}
}
LayoutUpdate.update(LayoutTable);
// Add new prop to the layout
updatePropLayout(LayoutType, Prop.NodeTypeId, Prop, false, TabId, InsertAfterPropLayout.DisplayRow + 1, InsertAfterPropLayout.DisplayColumn, InsertAfterPropLayout.TabGroup);
Added = true;
} // foreach( Int32 TabId in InsertAfterPropLayouts.Keys )
} // if( InsertAfterPropLayouts.Values.Count > 0 )
} // if( InsertAfterProp != null )
if (false == Added)
{
// Just add it somewhere
updatePropLayout(LayoutType, Prop.NodeTypeId, Prop, false, Prop.getNodeType().getFirstNodeTypeTab().TabId);
}
if (_Cache.ContainsKey(Prop.NodeTypeId))
{
_Cache.Remove(Prop.NodeTypeId);
}
} // updatePropLayout()
/// <summary>
/// Clear all properties from a layout
/// </summary>
public void clearLayout(CswEnumNbtLayoutType LayoutType, Int32 NodeTypeId)
{
CswTableUpdate LayoutUpdate = _CswNbtMetaDataResources.CswNbtResources.makeCswTableUpdate("clearLayout_Update", "nodetype_layout");
string WhereClause = "where layouttype = '" + LayoutType.ToString() + "' and nodetypeid = " + NodeTypeId.ToString();
DataTable LayoutTable = LayoutUpdate.getTable(WhereClause);
foreach (DataRow Row in LayoutTable.Rows)
{
Row.Delete();
}
LayoutUpdate.update(LayoutTable);
if (_Cache.ContainsKey(NodeTypeId))
{
_Cache.Remove(NodeTypeId);
}
} // clearLayout()
} // updatePropLayout()
public void removePropFromLayout(CswEnumNbtLayoutType LayoutType, CswNbtMetaDataNodeTypeProp Prop, Int32 TabId)
{
if (LayoutType != CswEnumNbtLayoutType.Unknown && Prop != null)
{
CswTableUpdate LayoutUpdate = _CswNbtMetaDataResources.CswNbtResources.makeCswTableUpdate("removePropFromLayout_Update", "nodetype_layout");
string WhereClause = "where layouttype = '" + LayoutType.ToString() + "' and nodetypepropid = " + Prop.PropId.ToString();
if (TabId != Int32.MinValue && LayoutType == CswEnumNbtLayoutType.Edit)
{
WhereClause += " and nodetypetabsetid = " + TabId.ToString();
}
DataTable LayoutTable = LayoutUpdate.getTable(WhereClause);
foreach (DataRow Row in LayoutTable.Rows)
{
Row.Delete();
}
LayoutUpdate.update(LayoutTable);
} // if( Type != CswEnumNbtLayoutType.Unknown && Prop != null )
if (_Cache.ContainsKey(Prop.NodeTypeId))
{
_Cache.Remove(Prop.NodeTypeId);
}
} // removePropFromLayout()
} // getPropNodesInLayout()
public IEnumerable <CswNbtObjClassDesignNodeTypeProp> getPropNodesNotInLayout(CswNbtMetaDataNodeType NodeType, Int32 TabId, CswEnumNbtLayoutType LayoutType, CswDateTime Date = null)
{
Collection <CswNbtObjClassDesignNodeTypeProp> ret = new Collection <CswNbtObjClassDesignNodeTypeProp>();
CswTableSelect PropsSelect = _CswNbtMetaDataResources.CswNbtResources.makeCswTableSelect("getPropNodesNotInLayout_select", "nodetype_props");
string WhereClause = "where nodetypepropid not in (select nodetypepropid " +
" from nodetype_layout " +
" where nodetypeid = " + NodeType.NodeTypeId.ToString() +
" and nodetypetabsetid = " + TabId.ToString() +
" and layouttype = '" + LayoutType.ToString() + "')";
DataTable LayoutTable = PropsSelect.getTable(WhereClause);
foreach (DataRow Row in LayoutTable.Rows)
{
Int32 PropId = CswConvert.ToInt32(Row["nodetypepropid"]);
CswNbtObjClassDesignNodeTypeProp PropNode = _CswNbtMetaDataResources.CswNbtResources.Nodes.getNodeByRelationalId(new CswPrimaryKey("nodetype_props", PropId));
ret.Add(PropNode);
}
return(ret);
} // getPropNodesNotInLayout()
} // getLayout()
/// <summary>
/// Updates the given layout by placing the given property in the specified locaiton (or at the bottom)
/// </summary>
/// <param name="LayoutType">Add, Edit, Preview, or Table (Search)</param>
/// <param name="NodeTypeId">NodetypeId of the NodeType to which the prop belongs</param>
/// <param name="NtProp">Prop to move</param>
/// <param name="DoMove">If true, remove the prop from other tab(s) before moving to the new one (Edit Layout only)</param>
/// <param name="TabId">TabId to which the prop should be added (Edit Layout Only)</param>
/// <param name="DisplayRow">Row number to place the property. If the cell is taken, it will be placed beneath the pre-existing prop</param>
/// <param name="DisplayColumn">Column number to place the property. If the cell is taken, it will be placed beneath the pre-existing prop</param>
/// <param name="TabGroup">(Optional) specify the name of the TabGroup with which to place the prop (if it doesn't exist, one will be created)</param>
public void updatePropLayout(CswEnumNbtLayoutType LayoutType, Int32 NodeTypeId, CswNbtMetaDataNodeTypeProp NtProp, bool DoMove, Int32 TabId = Int32.MinValue, Int32 DisplayRow = Int32.MinValue, Int32 DisplayColumn = Int32.MinValue, string TabGroup = "")
{
if (LayoutType != CswEnumNbtLayoutType.Unknown &&
null != NtProp)
{
if (DoMove)
{
removePropFromLayout(LayoutType, NtProp, Int32.MinValue);
}
CswTableUpdate LayoutUpdate = _CswNbtMetaDataResources.CswNbtResources.makeCswTableUpdate("updatePropLayout_Update", "nodetype_layout");
string WhereClause = "where layouttype = '" + LayoutType.ToString() + "' and nodetypepropid = " + NtProp.PropId.ToString();
if (TabId != Int32.MinValue && LayoutType == CswEnumNbtLayoutType.Edit)
{
WhereClause += " and nodetypetabsetid = " + TabId.ToString();
}
DataTable LayoutTable = LayoutUpdate.getTable(WhereClause);
DataRow Row = null;
if (LayoutTable.Rows.Count > 0)
{
Row = LayoutTable.Rows[0];
}
else
{
Row = LayoutTable.NewRow();
LayoutTable.Rows.Add(Row);
}
Row["layouttype"] = LayoutType.ToString();
Row["nodetypeid"] = CswConvert.ToDbVal(NodeTypeId);
Row["nodetypepropid"] = CswConvert.ToDbVal(NtProp.PropId);
Row["auditlevel"] = NtProp.AuditLevel.ToString(); // layout audit goes with property audit
if (LayoutType == CswEnumNbtLayoutType.Edit)
{
if (TabId != Int32.MinValue)
{
Row["nodetypetabsetid"] = CswConvert.ToDbVal(TabId);
}
else
{
throw new CswDniException(CswEnumErrorType.Error, "Tab is required", "CswNbtMetaDataNodeTypeLayoutMgr.updatePropLayout() requires a valid TabId for Edit layouts");
}
}
Int32 FinalDisplayRow = DisplayRow;
Int32 FinalDisplayCol = DisplayColumn;
//Very special case for 'Save'--it is always last
if (FinalDisplayRow == Int32.MaxValue)
{
CswNbtMetaDataObjectClassProp Ocp = NtProp.getObjectClassProp();
if (null == Ocp || Ocp.PropName != CswNbtObjClass.PropertyName.Save)
{
FinalDisplayRow = Int32.MaxValue - 1;
}
}
else
{
if (FinalDisplayRow <= 0)
{
FinalDisplayRow = getCurrentMaxDisplayRow(NodeTypeId, TabId, LayoutType) + 1;
}
if (FinalDisplayCol <= 0)
{
FinalDisplayCol = 1;
}
}
Row["display_row"] = CswConvert.ToDbVal(FinalDisplayRow);
Row["display_column"] = CswConvert.ToDbVal(FinalDisplayCol);
Row["tabgroup"] = TabGroup;
LayoutUpdate.update(LayoutTable);
} // if( Type != CswEnumNbtLayoutType.Unknown && Prop != null )
if (_Cache.ContainsKey(NodeTypeId))
{
_Cache.Remove(NodeTypeId);
}
} // updatePropLayout()