Window3.xaml.cs 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
  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.Shapes;
  14. namespace AutReg
  15. {
  16. /// <summary>
  17. /// Логика взаимодействия для Window3.xaml
  18. /// </summary>
  19. public partial class Window3 : Window
  20. {
  21. gr683_gddEntities2 db;
  22. public Window3()
  23. {
  24. InitializeComponent();
  25. db = new gr683_gddEntities2();
  26. dgogrenci.ItemsSource = db.Table_1.ToList();
  27. }
  28. private void Button_Click(object sender, RoutedEventArgs e)
  29. {
  30. Table_1 student = new Table_1();
  31. student.FName = txtFirst.Text;
  32. student.LName = txtLast.Text;
  33. db.Table_1.Add(student);
  34. db.SaveChanges();
  35. dgogrenci.ItemsSource = db.Table_1.ToList();
  36. }
  37. private void Button_Click_1(object sender, RoutedEventArgs e)
  38. {
  39. try
  40. {
  41. int num = Convert.ToInt32(txtId.Text);
  42. var dRow = db.Table_1.Where(w => w.id == num).FirstOrDefault();
  43. db.Table_1.Remove(dRow);
  44. db.SaveChanges();
  45. dgogrenci.ItemsSource = db.Table_1.ToList();
  46. }
  47. catch (Exception ex)
  48. {
  49. MessageBox.Show(ex.Message);
  50. }
  51. }
  52. private void Button_Click_2(object sender, RoutedEventArgs e)
  53. {
  54. try
  55. {
  56. int num = Convert.ToInt32(txtId.Text);
  57. var uRow = db.Table_1.Where(w => w.id == num).FirstOrDefault();
  58. uRow.FName = txtFirst.Text;
  59. uRow.LName = txtLast.Text;
  60. db.SaveChanges();
  61. dgogrenci.ItemsSource = db.Table_1.ToList();
  62. }
  63. catch (Exception ex)
  64. {
  65. MessageBox.Show(ex.Message);
  66. }
  67. }
  68. }
  69. }