/// <summary> /// Will remove a distribution from distribution list /// </summary> /// <param name="inDist"></param> public void RemoveSelectedDistribution(object inDist) { Themes.ComboBoxItem oldDist = inDist as Themes.ComboBoxItem; _mineralAltDistValues.Remove(oldDist); RaisePropertyChanged("MineralAltDistValues"); }
/// <summary> /// Will add to the list of purposes a selected purpose by the user. /// </summary> public void AddADistribution(string distToAdd) { Themes.ComboBoxItem newDist = new Themes.ComboBoxItem(); newDist.itemValue = distToAdd; foreach (Themes.ComboBoxItem cb in MineralAltDist) { if (cb.itemValue == distToAdd) { newDist.itemName = cb.itemName; break; } } if (newDist.itemName != null && newDist.itemValue != string.Empty) { bool foundValue = false; foreach (Themes.ComboBoxItem existingItems in _mineralAltDistValues) { if (distToAdd == existingItems.itemName) { foundValue = true; } } if (!foundValue) { _mineralAltDistValues.Add(newDist); } } RaisePropertyChanged("MineralAltDistValues"); }
/// <summary> /// Will add to the list of purposes a selected purpose by the user. /// </summary> public void AddAPurpose(string purposeToAdd) { #region NEW METHOD Themes.ComboBoxItem newPurp = new Themes.ComboBoxItem(); newPurp.itemValue = purposeToAdd; foreach (Themes.ComboBoxItem cb in SamplePurpose) { if (cb.itemValue == purposeToAdd) { newPurp.itemName = cb.itemName; break; } } if (newPurp.itemName != null && newPurp.itemValue != string.Empty) { bool foundValue = false; foreach (Themes.ComboBoxItem existingItems in _purposeValues) { if (purposeToAdd == existingItems.itemName) { foundValue = true; } } if (!foundValue) { _purposeValues.Add(newPurp); } } #endregion RaisePropertyChanged("PurposeValues"); }
/// <summary> /// Will remove a purpose from purpose list /// </summary> /// <param name="inPurpose"></param> public void RemoveSelectedPurpose(object inPurpose) { Themes.ComboBoxItem oldPurp = inPurpose as Themes.ComboBoxItem; _purposeValues.Remove(oldPurp); RaisePropertyChanged("PurposeValues"); }
public void MineralModeBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { ComboBox senderBox = sender as ComboBox; if (senderBox.SelectedIndex != -1) { Themes.ComboBoxItem senderItem = senderBox.SelectedItem as Themes.ComboBoxItem; CalculateResidual(senderItem.itemValue); } }
/// <summary> /// Will fill the list box with items coming from user selected picklist to edit /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void picklistSelector_SelectionChangedAsync(object sender, SelectionChangedEventArgs e) { //Save current list if needed await picklistVM.SaveDialogInfo(); //Cast ComboBox senderBox = sender as ComboBox; Themes.ComboBoxItem selectedVocab = senderBox.SelectedItem as Themes.ComboBoxItem; //Fill the list box with selected value picklistVM.FillListBoxPicklistValues(selectedVocab.itemValue); }
/// <summary> /// Will fill the combobox that shows available picklist for selected theme /// </summary> private void FillPicklistCombobox() { //Get the current project type string fieldworkType = string.Empty; if (localSettings.GetSettingValue(Dictionaries.DatabaseLiterals.FieldUserInfoFWorkType) != null) { fieldworkType = localSettings.GetSettingValue(Dictionaries.DatabaseLiterals.FieldUserInfoFWorkType).ToString(); } //Retrieve list of picklist from user selected theme VocabularyManager vocManager = new VocabularyManager(); List <object> vocabManagerRaw = accessData.ReadTable(vocManager.GetType(), null); IEnumerable <VocabularyManager> vocManagerTable = vocabManagerRaw.Cast <VocabularyManager>(); //Cast to proper list type IEnumerable <VocabularyManager> vocThemeID = from vm in vocManagerTable where vm.ThemeTable.ToLower().Contains(picklistTheme) && vm.ThemeEditable == Dictionaries.DatabaseLiterals.boolYes && (vm.ThemeProjectType == fieldworkType || vm.ThemeProjectType == "") select vm; //Special case for mineral table if (picklistTheme == Dictionaries.DatabaseLiterals.KeywordMineral) { vocThemeID = from vm in vocManagerTable where vm.ThemeTable.ToLower().Contains(picklistTheme) && !vm.ThemeTable.ToLower().Contains(Dictionaries.DatabaseLiterals.KeywordMA) && vm.ThemeEditable == Dictionaries.DatabaseLiterals.boolYes && (vm.ThemeProjectType == fieldworkType || vm.ThemeProjectType == "") select vm; } //Add theme list to dialog or a default NA value if nothing is available yet if (vocThemeID.Count() > 0) { foreach (VocabularyManager themeID in vocThemeID) { Themes.ComboBoxItem picklistTheme = new Themes.ComboBoxItem(); picklistTheme.itemName = themeID.ThemeNameDesc; picklistTheme.itemValue = themeID.ThemeName; _picklists.Add(picklistTheme); } } else { ResourceLoader appResources = ResourceLoader.GetForCurrentView(); string emptyTheme = appResources.GetString("PicklistDialogEmptyList/Text"); Themes.ComboBoxItem emptyPicklist = new Themes.ComboBoxItem(); emptyPicklist.itemName = emptyTheme; emptyPicklist.itemValue = string.Empty; _picklists.Add(emptyPicklist); } RaisePropertyChanged("Picklists"); }
/// <summary> /// Will fill the parent combobox if any parent is found inside a list of terms. /// </summary> /// <param name="selectedChildID"></param> public void FillParentCombobox(string selectedChildID) { //Build query to retrieve unique parents //select * from M_DICTIONARY m WHERE m.CODETHEME in string querySelect_1 = "select * from " + Dictionaries.DatabaseLiterals.TableDictionary + " m "; string queryWhere_1 = " WHERE m." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " in "; //(select m.CODETHEME from M_DICTIONARY m join M_DICTIONARY_MANAGER mdm on m.CODETHEME = mdm.CODETHEME WHERE m.CODE in string querySelect_2 = "(select m." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " from " + Dictionaries.DatabaseLiterals.TableDictionary + " m "; string querySelect_2_join = "join " + Dictionaries.DatabaseLiterals.TableDictionaryManager + " mdm on m." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " = mdm." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " "; string queryWhere_2 = " WHERE m." + Dictionaries.DatabaseLiterals.FieldDictionaryCode + " in "; //(select distinct(m.RELATEDTO) from M_DICTIONARY m WHERE m.CODETHEME = 'MODTEXTURE' ORDER BY m.RELATEDTO ) and mdm.ASSIGNTABLE in string querySelect_3 = "(select distinct(m." + Dictionaries.DatabaseLiterals.FieldDictionaryRelatedTo + ") from " + Dictionaries.DatabaseLiterals.TableDictionary + " m "; string queryWhere_3 = " WHERE m." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " = '" + selectedChildID + "'"; string queryOrderBy_3 = " ORDER BY m." + Dictionaries.DatabaseLiterals.FieldDictionaryRelatedTo + " ) and mdm." + Dictionaries.DatabaseLiterals.FieldDictionaryManagerAssignTable + " in "; //(select mdm2.ASSIGNTABLE from M_DICTIONARY_MANAGER mdm2 where mdm2.CODETHEME = 'MODTEXTURE')) AND m.VISIBLE = 'Y' ORDER BY m.DESCRIPTIONEN ASC string queryWhere_1_2 = "(select mdm2." + Dictionaries.DatabaseLiterals.FieldDictionaryManagerAssignTable + " from " + Dictionaries.DatabaseLiterals.TableDictionaryManager + " mdm2 where mdm2." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " = '" + selectedChildID + "'))"; string queryWhere_1_3 = " AND m." + Dictionaries.DatabaseLiterals.FieldDictionaryVisible + " = '" + Dictionaries.DatabaseLiterals.boolYes + "'"; string queryOrderby_1 = " ORDER BY m." + Dictionaries.DatabaseLiterals.FieldDictionaryDescription + " ASC"; string queryFinal = querySelect_1 + queryWhere_1 + querySelect_2 + querySelect_2_join + queryWhere_2 + querySelect_3 + queryWhere_3 + queryOrderBy_3 + queryWhere_1_2 + queryWhere_1_3 + queryOrderby_1; //Get a unique list of all parents List <object> parentRaw = accessData.ReadTable(voc.GetType(), queryFinal); IEnumerable <Vocabularies> parentTable = parentRaw.Cast <Vocabularies>(); //Add theme list to dialog or a default NA value if nothing is available yet _parentPicklist.Clear(); foreach (Vocabularies parents in parentTable) { Themes.ComboBoxItem picklistParents = new Themes.ComboBoxItem(); picklistParents.itemName = parents.Description; picklistParents.itemValue = parents.Code; _parentPicklist.Add(picklistParents); } RaisePropertyChanged("PicklistParents"); }
/// <summary> /// Will fill the related combobox with a list f all structures from the database. /// </summary> public void FillStructureRelated(string lithoClass = "") { //Init. if (lithoClass != string.Empty) { _structRel.Clear(); RaisePropertyChanged("StructRelated"); } string querySelect = "SELECT * FROM " + Dictionaries.DatabaseLiterals.TableStructure; string queryWhere = " WHERE " + Dictionaries.DatabaseLiterals.FieldStructureParentID; //For new structures or editing existing structures if (existingDataDetailStructure.GenericTableName == Dictionaries.DatabaseLiterals.TableEarthMat) { queryWhere = queryWhere + " = '" + existingDataDetailStructure.GenericID + "'"; } else if (existingDataDetailStructure.GenericTableName == Dictionaries.DatabaseLiterals.TableStructure) { queryWhere = queryWhere + " = '" + existingDataDetailStructure.ParentID + "'"; } //Extra where clause to select only counterpart and not same structure types if (existingDataDetailStructure.structure.StructureClass != null && existingDataDetailStructure.structure.StructureClass != string.Empty && existingDataDetailStructure.structure.StructureClass.Contains(DatabaseLiterals.KeywordPlanar)) { queryWhere = queryWhere + " AND " + DatabaseLiterals.FieldStructureClass + " LIKE '%" + DatabaseLiterals.KeywordLinear + "%'"; } else { queryWhere = queryWhere + " AND " + DatabaseLiterals.FieldStructureClass + " LIKE '%" + DatabaseLiterals.KeywordPlanar + "%'"; } string finalQuery = querySelect + queryWhere; List <object> allStructures = accessData.ReadTable(structureModel.GetType(), finalQuery); IEnumerable <Structure> strucTable = allStructures.Cast <Structure>(); if (strucTable.Count() != 0) { foreach (Structure st in strucTable) { if (st.StructureID != _structID && st.StructureID != _structParentID) { Themes.ComboBoxItem structItem = new Themes.ComboBoxItem(); structItem.itemName = st.StructureName; structItem.itemValue = st.StructureID; _structRel.Add(structItem); } } } //Add a dumb value if nothing is found if (_structRel.Count == 0) { Themes.ComboBoxItem structItem = new Themes.ComboBoxItem(); structItem.itemName = Dictionaries.DatabaseLiterals.picklistNADescription; structItem.itemValue = Dictionaries.DatabaseLiterals.picklistNACode; _structRel.Add(structItem); } else { //Add default emtpy so user can unselect Themes.ComboBoxItem structItem = new Themes.ComboBoxItem(); structItem.itemName = string.Empty; structItem.itemValue = string.Empty; _structRel.Insert(0, structItem); //Reselect user value _selectedStructRel = existingDataDetailStructure.structure.StructureRelated; RaisePropertyChanged("SelectedStructRelated"); } //Update UI RaisePropertyChanged("StructRelated"); }