private void btnAddFilter_Click(object sender, RoutedEventArgs e)
{
using (EFContext context = new EFContext())
{
string text = txtFilterName.Text;
var find = context.FilterName.SingleOrDefault(f => f.Name == text);
if (find == null)
{
FilterName filterName = new FilterName
{
Name = text
};
context.FilterName.Add(filterName);
context.SaveChanges();
MyTreeViewItem viewItem = new MyTreeViewItem()
{
Id = filterName.Id.ToString(),
Name = filterName.Name
};
TreeViewItem item = new TreeViewItem();
item.Header = viewItem;
TreeViewFilterName.Items.Add(item);
}
else
{
MessageBox.Show($"Find {find.Id}");
}
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
var item = TreeViewFilterName.SelectedItem as TreeViewItem;
using (EFContext context = new EFContext())
{
if (item != null)
{
ItemsControl parent = GetSelectedTreeViewItemParent(item as TreeViewItem);
if (parent != null)
{
MyTreeViewItem myItem = item.Header as MyTreeViewItem;
MyTreeViewItem parentItem = (parent as TreeViewItem).Header as MyTreeViewItem;
var deletevalue = context.FilterValue.SingleOrDefault(x => x.Id.ToString() == myItem.Id);
var delgroup = context.FilterNameGroups.SingleOrDefault
(
x => x.FilterNameId.ToString() == parentItem.Id &&
x.FilterValueId == deletevalue.Id
);
if (deletevalue != null)
{
context.FilterNameGroups.Remove(delgroup);
context.FilterValue.Remove(deletevalue);
context.SaveChanges();
RefreshTreeView();
}
}
}
}
}
private void btnAddValue_Click(object sender, RoutedEventArgs e)
{
string text = txtFilterValue.Text;
if (TreeViewFilterName.SelectedItem is TreeViewItem && !string.IsNullOrEmpty(text))
{
TreeViewItem newChild = new TreeViewItem()
{
Header = text
};
TreeViewItem it = TreeViewFilterName.SelectedItem as TreeViewItem;
ItemsControl parent = GetSelectedTreeViewItemParent(it);
MyTreeViewItem MyHeader = new MyTreeViewItem();
if (parent is TreeViewItem)
{
TreeViewItem par = parent as TreeViewItem;
MyHeader = par.Header as MyTreeViewItem;
par.Items.Add(newChild);
}
else
{
it.Items.Add(newChild);
MyHeader = it.Header as MyTreeViewItem;
}
using (EFContext context = new EFContext())
{
FilterValue filtervalue = new FilterValue()
{
Name = newChild.Header.ToString()
};
context.FilterValue.Add(filtervalue);
context.SaveChanges();
FilterNameGroups group = new FilterNameGroups()
{
FilterNameId = int.Parse(MyHeader.Id.ToString()),
FilterValueId = filtervalue.Id
};
context.FilterNameGroups.Add(group);
context.SaveChanges();
}
RefreshTreeView();
}
}
private void RefreshTreeView()
{
TreeViewFilterName.Items.Clear();
TreeViewFilterName.DisplayMemberPath = "Name";
TreeViewFilterName.SelectedValuePath = "Id";
using (EFContext context = new EFContext())
{
var query = (from f in context.vFilterNameGroup
select new
{
FNameId = f.FilterNameId,
FName = f.FilterName,
FvalueId = f.FilterValueId,
Fvalue = f.FilterValue
}).ToList();
var group = (from f in query
group f by new
{
Id = f.FNameId,
Name = f.FName
} into g
orderby g.Key.Name
select g).ToList();
foreach (var filterName in group)
{
var Fname = new MyTreeViewItem
{
Id = filterName.Key.Id.ToString(),
Name = filterName.Key.Name
};
TreeViewItem parent = new TreeViewItem();
parent.Header = Fname;/* = filterName.Key.Name;*/
TreeViewFilterName.Items.Add(parent);
// item.DisplayMemberPath = "name";
var fValues = from v in filterName
group v by new MyTreeViewItem
{
Id = v.FvalueId.ToString(),
Name = v.Fvalue
};
foreach (var filterValue in fValues)
{
if (string.IsNullOrEmpty(filterValue.Key.Name))
{
continue;
}
var FVAL = new MyTreeViewItem
{
Id = filterValue.Key.Id,
Name = filterValue.Key.Name
};
TreeViewItem child = new TreeViewItem()
{
Header = FVAL
};
parent.Items.Add(child);
}
}
}
}
