private void InitializeComboBox()
{
// Load machine list data and assign to combobox
List <string> machineData = SqliteDataAcces.LoadListData("Machine", "Tools");
machineData = machineData.OrderBy(q => q).Distinct().ToList();
machineComboBox.ItemsSource = machineData;
// Load type list data and assign to combobox
List <string> typeData = SqliteDataAcces.LoadComboBoxData("Type", "Machine", machineComboBox.Text);
typeData = typeData.OrderBy(q => q).Distinct().ToList();
typeComboBox.ItemsSource = typeData;
// Load type list data and assign to combobox
List <string> functionData = SqliteDataAcces.LoadComboBoxData("Function", "Type", typeComboBox.Text);
functionData = functionData.OrderBy(q => q).Distinct().ToList();
functionComboBox.ItemsSource = functionData;
}
private void InitializeVendorComboBox()
{
// Load function list data and assign to combobox
List <string> holderVendorData = SqliteDataAcces.LoadListData("HolderVendor", "Tools");
List <string> extensionVendorData = SqliteDataAcces.LoadListData("ExtensionVendor", "Tools");
List <string> toolVendorData = SqliteDataAcces.LoadListData("ToolVendor", "Tools");
// Combine vendorData
var vendorData = holderVendorData.Concat(extensionVendorData)
.Concat(toolVendorData)
.ToList();
// Sort data and Remove duplicates
vendorData = vendorData.OrderBy(q => q).Distinct().ToList();
// Assign data to vendor comboboxes
HolderVendorComboBox.ItemsSource = vendorData;
ExtensionVendorComboBox.ItemsSource = vendorData;
ToolVendorComboBox.ItemsSource = vendorData;
}
//
// ---Handle Comboboxes---
//
private void InitializeComboBox()
{
// Load Type list data and assign to combobox
List <string> typeData = SqliteDataAcces.LoadListData("ToolType", "ToolTypes");
typeData = typeData.OrderBy(q => q).Distinct().ToList();
TypeComboBox.ItemsSource = typeData;
// Load Holder list data and assign to combobox
List <string> holderData = SqliteDataAcces.LoadListData("HolderName", "Holders");
holderData = holderData.OrderBy(q => q).Distinct().ToList();
HolderComboBox.ItemsSource = holderData;
// Load machine list data and assign to combobox
List <string> machineData = SqliteDataAcces.LoadListData("MachineName", "Machines");
machineData = machineData.OrderBy(q => q).Distinct().ToList();
MachineComboBox.ItemsSource = machineData;
// Load function list data and assign to combobox
List <string> holderVendorData = SqliteDataAcces.LoadListData("HolderVendor", "Tools");
List <string> extensionVendorData = SqliteDataAcces.LoadListData("ExtensionVendor", "Tools");
List <string> toolVendorData = SqliteDataAcces.LoadListData("ToolVendor", "Tools");
// Combine vendorData
var vendorData = holderVendorData.Concat(extensionVendorData)
.Concat(toolVendorData)
.ToList();
// Sort data and Remove duplicates
vendorData = vendorData.OrderBy(q => q).Distinct().ToList();
// Assign data to vendor comboboxes
HolderVendorComboBox.ItemsSource = vendorData;
ExtensionVendorComboBox.ItemsSource = vendorData;
ToolVendorComboBox.ItemsSource = vendorData;
}