private void DeleteFilter(ListViewItem item)
{
MetadataSimpleFilter filter = null;
if (tcFilters.SelectedTab == tpInclude)
{
filter = _connection.ConnectionDescriptor.MetadataLoadingOptions.IncludeFilter;
}
else if (tcFilters.SelectedTab == tpExclude)
{
filter = _connection.ConnectionDescriptor.MetadataLoadingOptions.ExcludeFilter;
}
if (filter != null)
{
filter.Objects.Remove(item.Tag as string);
filter.Schemas.Remove(item.Tag as string);
}
if (tcFilters.SelectedTab == tpInclude)
{
lvInclude.Items.Remove(item);
}
else if (tcFilters.SelectedTab == tpExclude)
{
lvExclude.Items.Remove(item);
}
UpdateTabFiltersCaption();
}
private void LoadFilterTo(MetadataSimpleFilter filter, ListView listBox)
{
foreach (var filterObject in filter.Objects)
{
var item = FindItemByName(filterObject);
listBox.Items.Add(filterObject, filterObject, GetImageKeyByItem(item));
}
foreach (var filterSchema in filter.Schemas)
{
var item = FindItemByName(filterSchema);
listBox.Items.Add(filterSchema, filterSchema, GetImageKeyByItem(item));
}
}
private void LoadFilterTo(MetadataSimpleFilter filter, ListView listBox)
{
foreach (var filterObject in filter.Objects)
{
var item = FindItemByName(filterObject);
listBox.Items.Add(new ListViewItem {
Name = filterObject, Icon = GetImage(item)
});
}
foreach (var filterSchema in filter.Schemas)
{
var item = FindItemByName(filterSchema);
listBox.Items.Add(new ListViewItem {
Name = filterSchema, Icon = GetImage(item)
});
}
}
private void LoadFilterTo(MetadataSimpleFilter filter, ListView listBox)
{
var sqlContext = databaseSchemaView1.SQLContext;
foreach (var filterObject in filter.Objects)
{
using (var parsedName = GetNameForSearch(sqlContext, filterObject))
{
var item = FindItemByName(parsedName);
if (item != null)
{
var listItem = listBox.Items.Add(item.NameFull, GetImageKeyByItem(item));
listItem.Tag = filterObject;
}
else
{
var listItem = listBox.Items.Add(parsedName.GetQualifiedName(), GetImageKeyByItem(null));
listItem.Tag = filterObject;
}
}
}
foreach (var filterSchema in filter.Schemas)
{
using (var parsedName = GetNameForSearch(sqlContext, filterSchema))
{
var item = FindItemByName(parsedName);
if (item != null)
{
var listItem = listBox.Items.Add(item.NameFull, GetImageKeyByItem(item));
listItem.Tag = filterSchema;
}
else
{
var listItem = listBox.Items.Add(parsedName.GetQualifiedName(), GetImageKeyByItem(null));
listItem.Tag = filterSchema;
}
}
}
}
private void DeleteFilter(string itemName)
{
MetadataSimpleFilter filter = null;
if (tcFilter.SelectedItem == tpInclude)
{
filter = _connection.MetadataLoadingOptions.IncludeFilter;
}
else if (tcFilter.SelectedItem == tpExclude)
{
filter = _connection.MetadataLoadingOptions.ExcludeFilter;
}
if (filter != null)
{
filter.Objects.Remove(itemName);
filter.Schemas.Remove(itemName);
}
if (tcFilter.SelectedItem == tpInclude)
{
var item = lvInclude.Items.Cast <ListViewItem>().FirstOrDefault(x => x.Name == itemName);
if (item != null)
{
lvInclude.Items.Remove(item);
}
}
else if (tcFilter.SelectedItem == tpExclude)
{
var item = lvExclude.Items.Cast <ListViewItem>().FirstOrDefault(x => x.Name == itemName);
if (item != null)
{
lvExclude.Items.Remove(item);
}
}
}
private void DeleteFilter(string itemName)
{
MetadataSimpleFilter filter = null;
if (tcFilters.SelectedTab == tpInclude)
{
filter = _connection.MetadataLoadingOptions.IncludeFilter;
}
else if (tcFilters.SelectedTab == tpExclude)
{
filter = _connection.MetadataLoadingOptions.ExcludeFilter;
}
if (filter != null)
{
filter.Objects.Remove(itemName);
filter.Schemas.Remove(itemName);
}
if (tcFilters.SelectedTab == tpInclude)
{
var items = lvInclude.Items.Find(itemName, false);
if (items.Length != 0)
{
lvInclude.Items.Remove(items[0]);
}
}
else if (tcFilters.SelectedTab == tpExclude)
{
var items = lvExclude.Items.Find(itemName, false);
if (items.Length != 0)
{
lvExclude.Items.Remove(items[0]);
}
}
}
