---

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace Wpf_Entity_Examples
{
    public partial class MainWindow : Window
    {
        user312_dbEntities db;

        public MainWindow()
        {
            InitializeComponent();
        }

        // INSERT
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Student15 student = new Student15();

            student.FirstName = txtFirst.Text;
            student.LastName = txtLast.Text;

            db.Student15.Add(student);
            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        // DELETE
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            int num = Convert.ToInt32(txtId.Text);

            var dRow = db.Student15
                .Where(w => w.ID == num)
                .FirstOrDefault();

            db.Student15.Remove(dRow);
            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        // UPDATE
        private void Button_Click_2(object sender, RoutedEventArgs e)
        {
            int num = Convert.ToInt32(txtId.Text);

            var uRow = db.Student15
                .Where(w => w.ID == num)
                .FirstOrDefault();

            uRow.FirstName = txtFirst.Text;
            uRow.LastName = txtLast.Text;

            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        // Загрузка данных при открытии окна
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            db = new user312_dbEntities();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }
    }
}