private void Window_Loaded(object sender, RoutedEventArgs e)
{
ERPEF entity = new ERPEF();
comboBoxStates.ItemsSource = entity.States.ToList();
comboBoxStates.SelectedIndex = 0;
}
private void gridViewData_RowDetailsVisibilityChanged(object sender, DataGridRowDetailsEventArgs e)
{
try
{
if (e.Row.DetailsVisibility == System.Windows.Visibility.Visible)
{
var item = e.Row.Item;
Type type = item.GetType();
int employeeId = (int)type.GetProperty("EmployeeId").GetValue(item, null);
DataGrid dataGrid = e.DetailsElement as DataGrid;
using (ERPEF context = new ERPEF())
{
IQueryable <FamilyRelation> relations = context.FamilyRelations
.Where(n => n.EmployeeId == employeeId);
if (relations.Count() > 0)
{
dataGrid.ItemsSource = relations.ToList();
}
else
{
dataGrid.Visibility = Visibility.Hidden;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonDisplay_Click(object sender, RoutedEventArgs e)
{
try
{
using (ERPEF entity = new ERPEF())
{
IQueryable<Employee> employees =null;
string keyword = textBoxKeyword.Text;
string state = Convert.ToString(comboBoxStates.SelectedValue).Trim() ;
if (keyword != "" || state!= "")
{
employees = entity.Employees.
Where(n => (keyword !="" &&
(n.FirstName.Contains(keyword)
|| n.LastName.Contains(keyword)))
|| keyword == "").
Where (n => state == ""
|| (state != "" &&
n.StateCode.Equals(state )));
}
else
{
employees = entity.Employees;
}
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(employees.ToList());
PropertyGroupDescription group = new PropertyGroupDescription("StateCode");
view.GroupDescriptions.Add(group);
gridViewData.ItemsSource = view;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}