private void PopulateLov(bool overwrite) { // determine location Attribute attribute = SchemaInfo.Attribute; TaxonomyInfo taxonomy = SchemaInfo.TaxonomyInfo; Guid waitkey = FrmWaitScreen.ShowMessage(string.Format("Populating LOVs - {0} - {1}", taxonomy.NodeName, attribute.AttributeName)); // get values from database var listOfValues = GetLovs(attribute, taxonomy); SchemaInfo schemaInfo = taxonomy.SchemaInfos.FirstOrDefault(si => si.Attribute.Equals(attribute)); if (schemaInfo != null) { if (overwrite) { // assign database values to list of values schemaInfo.ActiveListOfValues = listOfValues; } else { // compare current list of values to database and add // missing database values to list of values var currentLov = schemaInfo.ActiveListOfValues.ToList(); foreach (var lov in listOfValues) { if (!currentLov.Contains(lov)) { currentLov.Add(lov); } } schemaInfo.ActiveListOfValues = currentLov; } } // save new list of values AryaTools.Instance.SaveChangesIfNecessary(false, false); FrmWaitScreen.HideMessage(waitkey); // refresh list of values form AryaTools.Instance.Forms.ListofValuesForm.SchemaInfo = schemaInfo; }
private void dataGridView1_CellValuePushed(object sender, DataGridViewCellValueEventArgs e) { if (_schemaInfo == null) { return; } if (e.RowIndex < _lovs.Count) { // this code is called when an existing value is modified (this includes value deletions) // first, figure out the relevant property of the LOV, based on the column. string header = dgv.Columns[e.ColumnIndex].HeaderText; string fname = _columns[header].FieldName; Type lovType = _lovs[e.RowIndex].GetType(); PropertyInfo lovProperty = lovType.GetProperty(fname); // get the string representation of the new value string newValue = e.Value == null ? string.Empty : e.Value.ToString().Trim(); if (lovProperty.PropertyType == typeof(string)) { // get the old value for this cell/property var currentValue = lovProperty.GetValue(_lovs[e.RowIndex]); // if the current value is null or it doesn't match the new value, // assign the new value to the property (this fires the corresponding setter) if (currentValue == null || currentValue.ToString() != newValue) { lovProperty.SetValue(_lovs[e.RowIndex], newValue); } } else if (lovProperty.PropertyType == typeof(int?)) { int numValue; if (int.TryParse(newValue, out numValue)) { lovProperty.SetValue(_lovs[e.RowIndex], numValue); } else { lovProperty.SetValue(_lovs[e.RowIndex], null); } } if (!_lovs[e.RowIndex].Active) { _lovs.RemoveAt(e.RowIndex); } } else { // this code runs if the focus is on the new row - we're adding a value. // note that the setter is never called string value = e.Value == null ? string.Empty : e.Value.ToString().Trim(); if (dgv.Columns[e.ColumnIndex].Name == ValueColumn && !String.IsNullOrEmpty(value)) { var lov = SchemaInfo.AddLov(value); if (lov != null) { _lovs.Add(new ListofValueWrapper(lov)); } } } AryaTools.Instance.SaveChangesIfNecessary(false, false); // match the number of rows in the grid to the number of LOVs dgv.RowCount = _lovs.Count + 1; }
public static string SetValue(TaxonomyInfo taxonomy, Attribute attribute, bool autoMapSchema, SchemaAttribute schematus, object value, bool suppressAutoMapMessage = false) { var schemaInfo = taxonomy.SchemaInfos.FirstOrDefault(si => si.Attribute.Equals(attribute)); var newSchemaInfo = false; if (schemaInfo == null) { if (suppressAutoMapMessage) { return(null); } if (!autoMapSchema && MessageBox.Show( String.Format("Attribute [{0}] is not mapped in Node [{1}]. Do you want to map it?", attribute, taxonomy.TaxonomyData.NodeName), @"Add to Schema", MessageBoxButtons.YesNo) == DialogResult.No) { return(null); } schemaInfo = new SchemaInfo { Attribute = attribute }; taxonomy.SchemaInfos.Add(schemaInfo); newSchemaInfo = true; } if (schematus == null) { //Create/Update Schema Info only var currentSchemaData = schemaInfo.SchemaData; var newSchemaData = new SchemaData(); if (value != null && value is SchemaData) { var fromSchemaData = (SchemaData)value; if (currentSchemaData != null && currentSchemaData.Equals(fromSchemaData)) { return(null); } newSchemaData.DataType = fromSchemaData.DataType; newSchemaData.DisplayOrder = fromSchemaData.DisplayOrder; newSchemaData.NavigationOrder = fromSchemaData.NavigationOrder; newSchemaData.InSchema = fromSchemaData.InSchema; } if (currentSchemaData != null) { currentSchemaData.Active = false; } schemaInfo.SchemaDatas.Add(newSchemaData); return(null); } var activeSd = schemaInfo.SchemaData; switch (schematus.AttributeType) { case SchemaAttributeType.Primary: var reallyNewSd = false; var reorderRanks = false; SchemaData newSchemaData; if (activeSd == null) { reallyNewSd = true; newSchemaData = new SchemaData(); } else { //activeSd.DeletedBy = AryaTools.Instance.InstanceData.CurrentUser.ID; activeSd.DeletedByUser = AryaTools.Instance.InstanceData.CurrentUser; //fixes Object not found error activeSd.DeletedOn = DateTime.Now; newSchemaData = new SchemaData { DataType = activeSd.DataType, InSchema = activeSd.InSchema, NavigationOrder = activeSd.NavigationOrder, DisplayOrder = activeSd.DisplayOrder }; } var propertyName = schematus.PrimarySchemaAttribute.Replace(" ", String.Empty); var valueProperty = newSchemaData.GetType().GetProperty(propertyName); var propertyType = valueProperty.PropertyType; if (propertyType == typeof(string)) { var stringValue = value ?? String.Empty; if (propertyName == "DataType") { stringValue = ValidateDataType(stringValue); } if (!(valueProperty.GetValue(newSchemaData, null) ?? String.Empty).Equals(stringValue)) { reallyNewSd = true; valueProperty.SetValue(newSchemaData, stringValue.ToString(), null); } } else if (propertyType == typeof(bool)) { var boolValue = value ?? false; string firstCharacter; try { firstCharacter = boolValue.ToString().Substring(0, 1).ToLower(); } catch (Exception) { firstCharacter = "f"; } var newValue = firstCharacter.Equals("t") || firstCharacter.Equals("y") || firstCharacter.Equals("1"); if (!((bool)valueProperty.GetValue(newSchemaData, null)).Equals(newValue)) { reallyNewSd = true; valueProperty.SetValue(newSchemaData, newValue, null); } } else if (propertyType == typeof(decimal)) { var decimalValue = value ?? 0.0; decimal newDecimalValue; if (Decimal.TryParse(decimalValue.ToString(), out newDecimalValue)) { if (!((decimal)valueProperty.GetValue(newSchemaData, null)).Equals(newDecimalValue)) { reallyNewSd = true; valueProperty.SetValue(newSchemaData, newDecimalValue, null); reorderRanks = SchemaDataGridView.AutoOrderRanks; } } else { return(String.Format("Invalid value [{0}] for [{1}] - [{2}].{3}Expected a decimal value.", decimalValue, taxonomy.NodeName, attribute, Environment.NewLine)); } } else { return(String.Format("Unknown data type for value [{0}] for [{1}] - [{2}]", value ?? String.Empty, taxonomy.NodeName, attribute)); } if (reallyNewSd) { if (activeSd != null) { activeSd.Active = false; } schemaInfo.SchemaDatas.Add(newSchemaData); if (reorderRanks) { AutoOrderRanks(newSchemaData.SchemaInfo.TaxonomyInfo, newSchemaData); } } return(null); case SchemaAttributeType.Meta: var reallyNewSmd = false; if (schematus.DataType == typeof(bool)) { value = value.ToString().StartsWith("y", StringComparison.OrdinalIgnoreCase) ? "Yes" : "No"; } //First check if there is an active SchemaData if (activeSd == null) { if (suppressAutoMapMessage) { return(null); } if (!newSchemaInfo && !autoMapSchema && MessageBox.Show( String.Format("Attribute [{0}] is not mapped in Node [{1}]. Do you want to map it?", attribute, taxonomy.TaxonomyData.NodeName), "Add to Schema", MessageBoxButtons.YesNo) == DialogResult.No) { return(null); } schemaInfo.SchemaDatas.Add(new SchemaData()); reallyNewSmd = true; } var activeSmi = (from mi in schemaInfo.SchemaMetaInfos where mi.Attribute.Equals(schematus.MetaSchemaAttribute) select mi).FirstOrDefault(); if (activeSmi == null) { activeSmi = new SchemaMetaInfo { Attribute = schematus.MetaSchemaAttribute }; schemaInfo.SchemaMetaInfos.Add(activeSmi); reallyNewSmd = true; } var activeSmd = activeSmi.SchemaMetaData; if (activeSmd == null) { reallyNewSmd = true; } else if (value == null || !activeSmd.Value.Equals(value)) { reallyNewSmd = true; activeSmd.Active = false; } if (reallyNewSmd && value != null && !String.IsNullOrEmpty(value.ToString())) { activeSmi.SchemaMetaDatas.Add(new SchemaMetaData { Value = value.ToString() }); SchemaDataGridView.UpdateAutoCompleteSource(schematus.MetaSchemaAttribute, value.ToString()); } return(null); default: return("Unknown Meta-attribute Type! Weird!!!"); } }