/// <summary>
/// Will update list box in dialog
/// </summary>
/// <param name="inSelectedItem">The combobox item user has selected</param>
public void FillListBoxPicklistValues(string selectedItemID)
{
//Variables
bool hasParent = false;
//Retrieve list of values
string picklistQuerySelectFrom = "SELECT * FROM " + Dictionaries.DatabaseLiterals.TableDictionary;
string picklistQueryWhere = " WHERE " + Dictionaries.DatabaseLiterals.TableDictionary + "." + Dictionaries.DatabaseLiterals.FieldDictionaryCodedTheme + " = '" + selectedItemID + "'";
string picklistQueryOrder = " ORDER BY " + Dictionaries.DatabaseLiterals.TableDictionary + "." + Dictionaries.DatabaseLiterals.FieldDictionaryOrder + " ASC";
string picklistQueryFinal = picklistQuerySelectFrom + picklistQueryWhere + picklistQueryOrder;
List <object> vocRaw = accessData.ReadTable(voc.GetType(), picklistQueryFinal);
IEnumerable <Vocabularies> vocTable = vocRaw.Cast <Vocabularies>();
//Add theme list to dialog or a default NA value if nothing is available yet
_picklistValues.Clear();
_picklistValueCodes.Clear();
foreach (Vocabularies termIDs in vocTable)
{
_picklistValues.Add(termIDs);
_picklistValueCodes.Add(termIDs.Code);
if (termIDs.RelatedTo != string.Empty && termIDs.RelatedTo != null)
{
hasParent = true;
}
}
RaisePropertyChanged("PicklistValues");
if (hasParent)
{
_parentVisibility = Visibility.Visible;
RaisePropertyChanged("ParentVisibility");
FillParentCombobox(selectedItemID);
}
else
{
_parentVisibility = Visibility.Collapsed;
RaisePropertyChanged("ParentVisibility");
//Empty list
_parentPicklist.Clear();
RaisePropertyChanged("PicklistParents");
}
}
private List <string> CreateSuggestionList()
{
Vocabularies vocabularyModel = new Vocabularies();
string vocQuerySelect = "SELECT * FROM " + Dictionaries.DatabaseLiterals.TableDictionary;
string vocQueryWhere = " WHERE CODETHEME = 'LITHDETAIL'";
string vocQueryVisibility = " AND " + Dictionaries.DatabaseLiterals.TableDictionary + "." + Dictionaries.DatabaseLiterals.FieldDictionaryVisible + " = '" + Dictionaries.DatabaseLiterals.boolYes + "'";
string vocFinalQuery = vocQuerySelect + vocQueryWhere + vocQueryVisibility;
List <object> vocResults = accessData.ReadTable(vocabularyModel.GetType(), vocFinalQuery);
var outResults = new List <string>();
foreach (Vocabularies tmp in vocResults)
{
outResults.Add(tmp.RelatedTo.ToString() + " ; " + tmp.Code.ToString());
}
return(outResults);
}
