MainWindow.xaml.cs 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Windows;
  7. using System.Windows.Controls;
  8. using System.Windows.Data;
  9. using System.Windows.Documents;
  10. using System.Windows.Input;
  11. using System.Windows.Media;
  12. using System.Windows.Media.Imaging;
  13. using System.Windows.Navigation;
  14. using System.Windows.Shapes;
  15. namespace WPF_Entity_Examole
  16. {
  17. /// <summary>
  18. /// Логика взаимодействия для MainWindow.xaml
  19. /// </summary>
  20. public partial class MainWindow : Window
  21. {
  22. dbSchool db;
  23. public MainWindow()
  24. {
  25. InitializeComponent();
  26. }
  27. private void InsertClick_Click(object sender, RoutedEventArgs e)
  28. {
  29. Student student = new Student();
  30. student.Firstname = txtFist.Text;
  31. student.LastName = txtLast.Text;
  32. db.Student.Add(student);
  33. db.SaveChanges();
  34. dgogrenci.ItemsSource = db.Student.ToList();
  35. }
  36. private void DeleteClick_Click(object sender, RoutedEventArgs e)
  37. {
  38. int num = Convert.ToInt32(txtId.Text);
  39. var dRow = db.Student.Where(w => w.IdStudent == num).FirstOrDefault();
  40. db.Student.Remove(dRow);
  41. db.SaveChanges();
  42. dgogrenci.ItemsSource = db.Student.ToList();
  43. }
  44. private void UpdateClick_Click(object sender, RoutedEventArgs e)
  45. {
  46. int num = Convert.ToInt32(txtId.Text);
  47. var uRow = db.Student.Where(w => w.IdStudent == num).FirstOrDefault();
  48. uRow.Firstname = txtFist.Text;
  49. uRow.LastName = txtLast.Text;
  50. db.SaveChanges();
  51. dgogrenci.ItemsSource = db.Student.ToList();
  52. }
  53. private void Dgogrenci_Loaded(object sender, RoutedEventArgs e)
  54. {
  55. db = new dbSchool();
  56. dgogrenci.ItemsSource = db.Student.ToList();
  57. }
  58. }
  59. }