/// <summary>
///
/// </summary>
private void LoadModal()
{
DataTable dt = new DataTable();
DataTable dtModal = new DataTable();
DataTable dtItem = new DataTable();
DataTable dtRelation = new DataTable();
dt = dataComponentModal.GetModal(this.ClientID, ComponentModalID);
dtModal = dt.DefaultView.ToTable(true, "Name", "Catgory", "ParentComponent");
dtItem = dt.DefaultView.ToTable(true, "ComponentID", "ChildComponentID", "ComponentModalItemID", "ParentName", "ChildName");
dtRelation = dt.DefaultView.ToTable(true, "ComponentModalItemID", "ParentField", "ComponentModalID",
"RelatedField", "ComponentModalRelationID", "Parent", "Child", "ParentFieldName", "ChildFieldName");
foreach (DataRow dr in dtModal.Rows)
{
ModalName = dr.IsNull("Name") ? "" : dr["Name"].ToString();
Category = dr.IsNull("Catgory") ? "" : dr["Catgory"].ToString();
ParentComponent = dr.IsNull("ParentComponent") ? "" : dr["ParentComponent"].ToString();
}
foreach (DataRow dr in dtItem.Rows)
{
var componentID = dr.IsNull("ComponentID") ? "" : dr["ComponentID"].ToString();
var ccomponentid = dr.IsNull("ChildComponentID") ? "" : dr["ChildComponentID"].ToString();
var cmodalitemid = dr.IsNull("ComponentModalItemID") ? "" : dr["ComponentModalItemID"].ToString();
var pname = dr.IsNull("ParentName") ? "" : dr["ParentName"].ToString();
var cname = dr.IsNull("ChildName") ? "" : dr["ChildName"].ToString();
ComponentNode cn = new ComponentNode(this.ClientID, componentID, ccomponentid, cmodalitemid);
cn.ParentName = pname;
cn.ChildName = cname;
dtRelation.DefaultView.RowFilter = "ComponentModalItemID ='" + cmodalitemid + "'";
var dtr = dtRelation.DefaultView.ToTable(true);
dtRelation.DefaultView.RowFilter = "";
foreach (DataRow dRow in dtr.Rows)
{
var mrid = dRow.IsNull("ComponentModalRelationID") ? "" : dRow["ComponentModalRelationID"].ToString();
var pf = dRow.IsNull("ParentField") ? "" : dRow["ParentField"].ToString();
var rf = dRow.IsNull("RelatedField") ? "" : dRow["RelatedField"].ToString();
var p = dRow.IsNull("Parent") ? "" : dRow["Parent"].ToString();
var c = dRow.IsNull("Child") ? "" : dRow["Child"].ToString();
var pfield = dRow.IsNull("ParentFieldName") ? "" : dRow["ParentFieldName"].ToString();
var cfield = dRow.IsNull("ChildFieldName") ? "" : dRow["ChildFieldName"].ToString();
cn.AddRelation(new LinkComponentField()
{
ModalItemRelationID = mrid,
Child = c,
Parent = p,
ParentFieldName = pfield,
RelatedFieldName = cfield,
ParentField = pf,
RelatedField = rf
});
}
this.ComponentModalRoot.Add(cn);
}
}
/// <summary>
/// /
/// </summary>
/// <param name="componentID"></param>
/// <param name="childComponent"></param>
/// <param name="lf"></param>
/// <returns></returns>
public bool AddNode(string componentID, string childComponent, List <LinkComponentField> lf)
{
ComponentNode cn = new ComponentNode(this.ClientID);
cn.ComponentModalID = this.ComponentModalID;
cn.ComponentID = componentID;
cn.ChildComponentID = childComponent;
foreach (LinkComponentField f in lf)
{
cn.AddRelation(f.ParentField, f.RelatedField, f.ModalItemRelationID, f.Parent, f.Child);
}
if (this.ComponentModalID != "")
{
return(cn.SaveModalItem(conn));
}
else
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="clientid"></param>
/// <returns></returns>
public static List <ComponentModal> GetModalList(string clientid)
{
DataTable dt = new DataTable();
DataTable dtModal = new DataTable();
DataTable dtItem = new DataTable();
DataTable dtRelation = new DataTable();
List <ComponentModal> ModalList = new List <ComponentModal>();
var c = new ClientServer(clientid);
var dataComponentModal = new Data.Component.ComponentModal(c.GetServer().Connection());
dt = dataComponentModal.GetAllModal(clientid);
dtModal = dt.DefaultView.ToTable(true, "Name", "Catgory", "ParentComponent", "ComponentModalID");
dtItem = dt.DefaultView.ToTable(true, "ComponentID", "ChildComponentID", "ComponentModalItemID", "ParentName", "ChildName");
dtRelation = dt.DefaultView.ToTable(true, "ComponentModalItemID", "ParentField", "ComponentModalID",
"RelatedField", "ComponentModalRelationID", "Parent", "Child", "ParentFieldName", "ChildFieldName");
foreach (DataRow dr in dtModal.Rows)
{
var comp = new ComponentModal(clientid);
comp.ModalName = dr.IsNull("Name") ? "" : dr["Name"].ToString();
comp.Category = dr.IsNull("Catgory") ? "" : dr["Catgory"].ToString();
comp.ParentComponent = dr.IsNull("ParentComponent") ? "" : dr["ParentComponent"].ToString();
comp.ComponentModalID = dr.IsNull("ComponentModalID") ? "" : dr["ComponentModalID"].ToString();
dt.DefaultView.RowFilter = "ComponentModalID ='" + comp.ComponentModalID + "'";
dt.DefaultView.RowFilter = "";
dtItem = dt.DefaultView.ToTable(true);
foreach (DataRow dRow in dtItem.Rows)
{
var componentID = dRow.IsNull("ComponentID") ? "" : dRow["ComponentID"].ToString();
var ccomponentid = dRow.IsNull("ChildComponentID") ? "" : dRow["ChildComponentID"].ToString();
var cmodalitemid = dRow.IsNull("ComponentModalItemID") ? "" : dRow["ComponentModalItemID"].ToString();
var pname = dRow.IsNull("ParentName") ? "" : dRow["ParentName"].ToString();
var cname = dRow.IsNull("ChildName") ? "" : dRow["ChildName"].ToString();
ComponentNode cn = new ComponentNode(clientid, componentID, ccomponentid, cmodalitemid);
cn.ParentName = pname;
cn.ChildName = cname;
dtRelation.DefaultView.RowFilter = "ComponentModalItemID ='" + cmodalitemid + "'";
var dtr = dtRelation.DefaultView.ToTable(true);
dtRelation.DefaultView.RowFilter = "";
foreach (DataRow drNodeRe in dtr.Rows)
{
var mrid = drNodeRe.IsNull("ComponentModalRelationID") ? "" : drNodeRe["ComponentModalRelationID"].ToString();
var pf = drNodeRe.IsNull("ParentField") ? "" : drNodeRe["ParentField"].ToString();
var rf = drNodeRe.IsNull("RelatedField") ? "" : drNodeRe["RelatedField"].ToString();
var p = drNodeRe.IsNull("Parent") ? "" : drNodeRe["Parent"].ToString();
var ch = drNodeRe.IsNull("Child") ? "" : drNodeRe["Child"].ToString();
var pfield = drNodeRe.IsNull("ParentFieldName") ? "" : drNodeRe["ParentFieldName"].ToString();
var cfield = drNodeRe.IsNull("ChildFieldName") ? "" : drNodeRe["ChildFieldName"].ToString();
cn.AddRelation(new LinkComponentField()
{
ModalItemRelationID = mrid,
Child = ch,
Parent = p,
ParentFieldName = pfield,
RelatedFieldName = cfield,
ParentField = pf,
RelatedField = rf
});
}
comp.ComponentModalRoot.Add(cn);
}
ModalList.Add(comp);
}
return(ModalList);
}