/// <summary>
/// Set-up for changing to a new table
/// </summary>
private void Setup()
{
tableName = cmbTable.SelectedItem.ToString();
editingSidebar = null;
columns = DBMethods.MetaRequests.GetColumnDataFromTable(tableName);
// Allow the user to search through all columns or a specific column for the table
List <string> colSearch = new List <string> {
"All Columns"
};
colSearch.AddRange(columns.Select(c => c.Name));
if (editingSidebar != null)
{
editingSidebar.Close();
}
editingSidebar = new DataEditingSidebar(columns, tableName, this);
lblSidebar.Content = editingSidebar.Content;
if (!(filterableDataGrid is null))
{
filterableDataGrid.Close();
}
filterableDataGrid = new FilterableDataGrid(columns, this);
filterableDataGrid.SetMaxHeight(700);
lblSearchData.Content = filterableDataGrid.Content;
}
private void UpdateEditingSidebar(string[] newData)
{
if (mode == contactString)
{
if (contactEditing is null)
{
contactEditing = new DataEditingSidebar(contactsColumns, "Contact", this);
}
if (contactAdding is null)
{
contactAdding = new DataEditingSidebar(contactsColumns, "Contact", this);
}
contactEditing.ChangeSelectedData(newData);
contactAdding.StartAddNew(GetClientID());
dtgDogs.UpdateSelectedIndex(-1);
dtgClients.UpdateSelectedIndex(-1);
}
else if (mode == dogString)
{
if (dogsEditing is null)
{
dogsEditing = new DataEditingSidebar(dogsColumns, "Dog", this);
}
if (dogsAdding is null)
{
dogsAdding = new DataEditingSidebar(dogsColumns, "Dog", this);
}
dogsEditing.ChangeSelectedData(newData);
dogsAdding.StartAddNew(GetClientID());
dtgContacts.UpdateSelectedIndex(-1);
dtgClients.UpdateSelectedIndex(-1);
}
else if (mode == clientString)
{
if (clientsEditing is null)
{
clientsEditing = new DataEditingSidebar(clientsColumns, "Client", this);
}
if (clientsAdding is null)
{
clientsAdding = new DataEditingSidebar(clientsColumns, "Client", this);
}
clientsEditing.ChangeSelectedData(newData);
clientsAdding.StartAddNew(GetClientID());
dtgDogs.UpdateSelectedIndex(-1);
dtgContacts.UpdateSelectedIndex(-1);
}
UpdateClientEditor();
}