private void lstDetail_SelectedIndexChanged(object sender, EventArgs e)
{
if (atts.Count > 0)
{
if (lstDetail.SelectedItems.Count > 0)
{
CompExtention.Attribute att = atts.Where(x => x.Name == lstDetail.SelectedItems[0].Text).FirstOrDefault();
if (att != null)
{
SetValue(att);
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstDetail_SelectedIndexChanged(object sender, EventArgs e)
{
if (component.Attributes.Count > 0)
{
if (lstDetail.SelectedItems.Count > 0)
{
var s = component.Attributes.Where(x => x.Name == lstDetail.SelectedItems[0].Text).FirstOrDefault();
SelectedAttribute = s;
InitialAttribute = s.Clone();
{
if (SelectedAttribute != null)
{
SetValue();
}
}
gbField.Text = "Field Attribute - " + SelectedAttribute.DisplayName;
}
}
}
private void SetValue(CompExtention.Attribute att)
{
var item = d.Where(x => x.Value == att.Type.ToString().Replace("_", "")).FirstOrDefault();
// if (item != null) {
cmbAttributeType.SelectedItem = item;
txtLength.Text = att.Length.ToString();
ckKey.Checked = att.IsKey;
ckRequied.Checked = att.IsRequired;
ckNull.Checked = att.IsNullable;
txtDefaultValue.Text = att.DefaultValue;
txtDisplay.Text = att.DisplayName;
txtExtension.Text = att.FileExtension;
if (att.Type == CompExtention.AttributeType._lookup)
{
cmbLookUp.Enabled = true;
bindLookup();
cmbLookUp.SelectedItem = dtLookup.AsEnumerable().Where(x => x["FieldInstanceID"].ToString() == att.LookupInstanceID.ToString()).FirstOrDefault();
}
else
{
cmbLookUp.Enabled = false;
cmbLookUp.SelectedItem = "";
}
if (att.Type == CompExtention.AttributeType._componentlookup)
{
bindComponentCombo();
bindComponentLookupDisplayName(att.ComponentLookup);
cmbCompLookup.Enabled = true;
cmbCompDisplayName.Enabled = true;
cmbCompLookup.SelectedItem = CompList.Where(x => x.ID == att.ComponentLookup).FirstOrDefault();
cmbCompDisplayName.SelectedItem = compDisplayField.Where(x => x.ID == att.ComponentLookupDisplayField).FirstOrDefault();
}
else
{
cmbCompLookup.Enabled = false;
cmbCompDisplayName.Enabled = false;
cmbCompDisplayName.SelectedItem = "";
}
//}
// cmbAttributeType.SelectedItem = cmbAttributeType.Items.IndexOf(att.Type.ToString().Replace("_", ""));//comboBox1.Items.IndexOf("test1")att.Type;
}
private void btnReset_Click(object sender, EventArgs e)
{
if (lstDetail.SelectedItems != null)
{
var s = component.Attributes.Where(x => x.Name == InitialAttribute.Name).FirstOrDefault();
if (s != null)
{
for (int i = 0; i < component.Attributes.Count; i++)
{
if (component.Attributes[i].Name == InitialAttribute.Name)
{
component.Attributes[i] = InitialAttribute.Clone();
SelectedAttribute = InitialAttribute.Clone();
}
SetValue();
bindAttributeList();
}
}
}
}
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");
}
