private void btnSaveView_Click(object sender, EventArgs e)
{
CompExtention.ComponentViewManager cvm = new CompExtention.ComponentViewManager(new CompExtention.DataAccess.ComponentViewHandler(connection, 2));
var view = cvm.NewView(txtView.Text);
int Index = 0;
var cm = new CompExtention.ComponentManager(2, txtCoreComponent.Text, new CompExtention.DataAccess.ComponentDataHandler(connection));
view.CoreComponent = ((CompExtention.Component)cm.GetComponent()).ID;
foreach (Control c in grContainer.Controls)
{
if (c.GetType().Name == "Button")
{
continue;
}
var vr = ((ViewRelation)c);
if (vr.Component.ComponentID != "" && ((ViewRelation)c).Component.ChildComponentID != "")
{
var comp = vr.GetComponentRelation();
//if (Index == 0) {
// view.CoreComponent = comp.ComponentID;
//}
Index = Index + 1;
view.ComponentRelations.Add(comp);
}
}
if (MessageBox.Show("Ensure all the component and its relationship assigned to this view. Are you sure want to proceed?", "Confirm Save", MessageBoxButtons.YesNoCancel) == DialogResult.Yes)
{
cvm.Save(view);
}
MessageBox.Show("View Created Successfully");
}
private void textBox2_DragDrop(object sender, DragEventArgs e)
{
if (e.Data.GetDataPresent(typeof(ListView.SelectedListViewItemCollection).ToString(), false))
{
ListView.SelectedListViewItemCollection lstViewColl = (ListView.SelectedListViewItemCollection)e.Data.GetData(typeof(ListView.SelectedListViewItemCollection));
textBox2.Text = lstViewColl[0].Text;
var cm = new CompExtention.ComponentManager(2, lstViewColl[0].Text, new CompExtention.DataAccess.ComponentDataHandler(Connection));
ChildComponent = (CompExtention.Component)cm.GetComponent();
cm.LoadAttributes();
SetComponentChildFields();
Component.ChildComponentID = ChildComponent.ID;
}
}
private void btnImportComponent_Click(object sender, EventArgs e)
{
// TZ.CompExtention.Component
//TZComponents
DataTable dtLookUpComponent = new DataTable();
List <CompExtention.Builder.FieldElement> TalentozComponentFields = new List <CompExtention.Builder.FieldElement>();
List <int> LookUpComponent = new List <int>();
List <CompExtention.Builder.FieldElement> LookupComponentDisplayField = new List <CompExtention.Builder.FieldElement>();
TZ.CompExtention.ComponentManager cm = new CompExtention.ComponentManager();
cm.Set(new TZ.CompExtention.DataAccess.ComponentDataHandler(connection));
foreach (DataRow dr in dtComponentInstance.Rows)
{
CompExtention.Builder.FieldElement f = new CompExtention.Builder.FieldElement();
f = Newtonsoft.Json.JsonConvert.DeserializeObject <CompExtention.Builder.FieldElement>(dr["FieldAttribute"].ToString());
f.FieldInstanceID = Convert.ToInt32(dr["FieldInstanceID"].ToString());
f.FieldDescription = (dr["FieldDescription"].ToString());
f.ComponentID = Convert.ToInt32(dr["CompType"].ToString());
f.FieldTypeID = Convert.ToInt32(dr["FieldTypeID"].ToString());
if (f.FieldTypeID == 22)
{
if (f.FieldComponent != "")
{
LookUpComponent.Add(Convert.ToInt32(f.ComponentID));
var fComponent = TZComponents.Where(x => x.ComponentID == Convert.ToInt32(f.FieldComponent)).FirstOrDefault();
f.FieldHelp = fComponent.TitleField;
LookupComponentDisplayField.Add(f);
}
}
TalentozComponentFields.Add(f);
}
LookUpComponent = LookUpComponent.Distinct().ToList();
Dictionary <int, string> tzComponentWithImportComp = new Dictionary <int, string>();
foreach (CompExtention.Builder.TalentozComponent comp in TZComponents)
{
TZ.CompExtention.Component Comp = new CompExtention.Component(comp.ComponentName, Global.GetType(comp.ComponentType));
if (comp != null)
{
Comp.TableName = comp.TableName;
dtComponentInstance.DefaultView.RowFilter = "FieldTypeID = " + comp.ComponentID;
DataTable dtAtt = dtComponentInstance.DefaultView.ToTable(true);
dtComponentInstance.DefaultView.RowFilter = "";
//CompExtention.Builder.FieldElement f = new CompExtention.Builder.FieldElement();
CompExtention.Attribute _att_id1 = Comp.NewAttribute(ClientID);
_att_id1.IsKey = true;
_att_id1.Name = comp.IDField1Name;
_att_id1.DisplayName = comp.IDField1Name;
_att_id1.Type = CompExtention.AttributeType._number;
_att_id1.IsNullable = false;
Comp.AddAttribute(_att_id1);
Comp.Keys.Add(_att_id1);
CompExtention.Attribute _att_id2 = Comp.NewAttribute(ClientID);
_att_id2.IsKey = true;
_att_id2.Name = comp.IDField2Name;
_att_id2.DisplayName = comp.IDField2Name;
_att_id2.Type = CompExtention.AttributeType._number;
_att_id2.IsNullable = false;
Comp.AddAttribute(_att_id2);
Comp.Keys.Add(_att_id2);
if (comp.IDField3Name != "")
{
CompExtention.Attribute _att_id3 = Comp.NewAttribute(ClientID);
_att_id3.IsKey = true;
_att_id3.Name = comp.IDField3Name;
_att_id3.DisplayName = comp.IDField3Name;
_att_id3.Type = CompExtention.AttributeType._number;
_att_id3.IsNullable = false;
Comp.AddAttribute(_att_id3);
Comp.Keys.Add(_att_id3);
}
if (comp.IDField4Name != "")
{
CompExtention.Attribute _att_id4 = Comp.NewAttribute(ClientID);
_att_id4.IsKey = true;
_att_id4.Name = comp.IDField4Name;
_att_id4.DisplayName = comp.IDField4Name;
_att_id4.Type = CompExtention.AttributeType._number;
_att_id4.IsNullable = false;
Comp.AddAttribute(_att_id4);
Comp.Keys.Add(_att_id4);
}
var flist = TalentozComponentFields.Where(x => x.ComponentID == comp.ComponentID).ToList();
foreach (CompExtention.Builder.FieldElement f in flist)
{
CompExtention.Attribute _att = Comp.NewAttribute(ClientID);
_att.Name = "F_" + f.FieldInstanceID;
_att.DisplayName = f.FieldDescription;
_att.DefaultValue = f.DefaultValue;
_att.FileExtension = f.FileExtension;
_att.LookupInstanceID = f.FieldInstanceLookUpID.ToString();
_att.Length = f.MaxLength;
_att.IsUnique = f.isUnique;
_att.IsRequired = f.isRequired;
_att.IsNullable = true;
_att.Type = Global.GetAttributeType(f.FieldTypeID);
_att.IsCore = f.isCore;
if (f.FieldTypeID == 22)
{
}
_att.IsAuto = false;
_att.IsSecured = false;
Comp.AddAttribute(_att);
}
cm.Save(Comp);
tzComponentWithImportComp.Add(comp.ComponentID, cm.Component.ID); // mapping talentoz component to import component ids.
var compLookup_imp = Comp.Attributes.Where(x => x.Type == CompExtention.AttributeType._componentlookup);
foreach (CompExtention.Attribute a in compLookup_imp)
{
// LookupComponentDisplayField.Add(Convert.ToInt32(f.FieldComponent), f);
var cdfield = LookupComponentDisplayField.Where(x => x.FieldDescription == a.DisplayName && x.ComponentID == comp.ComponentID).FirstOrDefault();
cdfield.FieldValue = a.ID;
// cdfield.Value.FileExtension = a.ComponentID;
}
foreach (CompExtention.Builder.FieldElement a in LookupComponentDisplayField)
{
var atc = Comp.Attributes.Where(x => x.Name == a.FieldHelp).FirstOrDefault();
if (atc != null)
{
a.FieldExpression = atc.ID;
}
}
}
}
foreach (CompExtention.Builder.FieldElement a in LookupComponentDisplayField)
{
var k = tzComponentWithImportComp.Where(x => x.Key == Convert.ToInt32(a.FieldComponent)).FirstOrDefault();
cm.UpdateComponentLookup(ClientID, "", a.FieldValue, k.Value, a.FieldExpression);
}
MessageBox.Show("done");
}
