public void LoadView(int clientID)
{
ComponentViewManager cvm = new ComponentViewManager(this.ViewID, clientID, new TZ.CompExtention.DataAccess.ComponentViewHandler(this.Connection, clientID));
cvm.LoadViewComponents();
this.View = (ComponentView)cvm.View;
if (this.Type == TemplateType.PIVOT)
{
Attribute PivotCol = new Attribute();
var cField = this.TemplateFields.Where(x => x.IsColumn == true).FirstOrDefault();
if (cField != null)
{
foreach (Component c in this.View.Components)
{
int attCount = c.Attributes.Count;
for (int i = 0; i < attCount; i++)
{
var att = c.Attributes[i];
if (att.ID == cField.ID)
{
PivotCol = att;
if (PivotCol.Type == AttributeType._lookup)
{
var dm = new DataManager();
dm.tableName("sys_fieldinstancelookup");
dm.SelectFields("fieldinstanceid", "sys_FieldInstanceLookup", FieldType._string);
dm.SelectFields("LookUpID", "sys_FieldInstanceLookup", FieldType._string);
dm.SelectFields("LookUpDescription", "sys_FieldInstanceLookup", FieldType._string);
dm.SelectFields("LookUpCode", "sys_FieldInstanceLookup", FieldType._string);
dm.Where("sys_FieldInstanceLookup", "clientid", "=", Convert.ToString(clientID));
dm.Where("sys_FieldInstanceLookup", "fieldinstanceid", "=", Convert.ToString(PivotCol.LookupInstanceID));
var dt = dm.GetData(Connection);
int index = 0;
foreach (DataRow dr in dt.Rows)
{
bool isRequired = false;
if (index == 0)
{
isRequired = true;
}
c.AddAttribute(new Attribute()
{
ID = PivotCol.ID + "_" + dr["LookUpID"].ToString(),
Name = dr["LookUpDescription"].ToString(),
DisplayName = dr["LookUpDescription"].ToString(),
Type = AttributeType._string,
IsKey = false,
IsRequired = isRequired,
ClientID = clientID,
ComponentID = c.ID,
LookupInstanceID = PivotCol.LookupInstanceID,
});
index = index + 1;
this.TemplateFields.Add(new TemplateField()
{
ID = PivotCol.ID + "_" + dr["LookUpID"].ToString(),
IsColumn = true,
IsKey = false,
IsDefault = true,
IsRequired = isRequired,
});
}
}
}
}
c.Attributes.Remove(PivotCol);
var pField = this.TemplateFields.Where(x => x.IsPivot == true).FirstOrDefault();
if (pField != null)
{
c.Attributes.Remove(c.Attributes.Where(x => x.ID == pField.ID).FirstOrDefault());
this.TemplateFields.Remove(pField);
}
}
}
}
}
