private void ListViewItem_Selected(object sender, RoutedEventArgs e) { using (workEntities1 db = new workEntities1()) { //var emp = GlobalDataGrid.ItemsSource = db.Employee.ToList(); } }
private void _renewControl() { using (workEntities1 db = new workEntities1()) { List <string> posName = new List <string>(); foreach (var pos in db.PositionSet) { posName.Add(pos.Name); } comboBox.ItemsSource = posName; dataGrid.ItemsSource = db.Employee.ToList(); } }
private void button_Delete_Click(object sender, RoutedEventArgs e) { using (workEntities1 db = new workEntities1()) { int id = (dataGrid.SelectedItem as Employee).Id; var deleteUser = db.Employee.Where(u => u.Id == id).Single(); if (deleteUser.Name == null) { } db.Employee.Remove(deleteUser); db.SaveChanges(); } _renewControl(); }
private void button_Click(object sender, RoutedEventArgs e) { using (workEntities1 db = new workEntities1()) { db.Employee.Add(new Employee() { SecondName = textBox_SecondName.Text, Name = textBox_Name.Text, Login = textBox_Login.Text, Password = passwordBox.Password, PositionId = comboBox.SelectedIndex + 1 }).ToString(); db.SaveChanges(); } _renewControl(); }
private void search_texbox_TextChanged(object sender, TextChangedEventArgs e) { using (workEntities1 db = new workEntities1()) { if (search_texbox.Text.Equals("")) { _renewControl(); } else { var employees = from emp in db.Employee where emp.Name.ToLower().Contains(search_texbox.Text.ToLower()) || emp.SecondName.ToLower().Contains(search_texbox.Text.ToLower()) select emp; dataGrid.ItemsSource = employees.ToList(); } } }