CopyCenter/CopyCenter/OrdersWindow.xaml.cs

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.Shapes;

namespace CopyCenter
{
    /// <summary>
    /// Логика взаимодействия для OrdersWindow.xaml
    /// </summary>
    public partial class OrdersWindow : Window
    {
        gr672_liiEntities db;

        public OrdersWindow()
        {
            InitializeComponent();
            db = new gr672_liiEntities();
            comboBox1.ItemsSource = db.Services.ToList();
            comboBox1.DisplayMemberPath = "NameService";
            comboBox1.SelectedValuePath = "idService";

            comboBox2.ItemsSource = db.Clients.ToList();
            comboBox2.DisplayMemberPath = "NameClient";
            comboBox2.SelectedValuePath = "idClient";

            comboBox4.ItemsSource = db.Users.ToList();
            comboBox4.DisplayMemberPath = "Login";
            comboBox4.SelectedValuePath = "idUser";

            comboBox3.ItemsSource = db.Payments.ToList();
            comboBox3.DisplayMemberPath = "NumberPayment";
            comboBox3.SelectedValuePath = "idPayment";
        } 
    
        private void Exit_Click(object sender, RoutedEventArgs e)
        {
            MenuWindow mw = new MenuWindow();
            mw.Show();
            this.Close();
        }

        private void Add(object sender, RoutedEventArgs e)
        {
            Order order = new Order();
            order.NumberOrder = Convert.ToInt32(Number.Text);
            order.ViewOrder = View.Text;
            order.OrderDate = Convert.ToDateTime(Date.Text);
            order.CostOrder = Convert.ToInt32(Price.Text);
            order.idClient = Convert.ToInt32(comboBox2.SelectedValue.ToString());
            order.idService = Convert.ToInt32(comboBox1.SelectedValue.ToString());
            order.idUser = Convert.ToInt32(comboBox4.SelectedValue.ToString());
            order.idPayment = Convert.ToInt32(comboBox3.SelectedValue.ToString());
            db.Orders.Add(order);
            db.SaveChanges();
            OrdersList.ItemsSource = db.Orders.ToList();

        }

        private void Delete(object sender, RoutedEventArgs e)
        {
            Order dRow = new Order();
            int num = Convert.ToInt32(Number.Text);
            dRow = db.Orders.Where(w => w.NumberOrder == num).FirstOrDefault();
            db.Orders.Remove(dRow);
            db.SaveChanges();
            OrdersList.ItemsSource = db.Clients.ToList();
        }

        private void Update(object sender, RoutedEventArgs e)
        {
            Order uRow = new Order();
            int num = Convert.ToInt32(Number.Text);
            uRow = db.Orders.Where(w => w.NumberOrder == num).FirstOrDefault();
            uRow.NumberOrder = Convert.ToInt32(Number.Text);
            uRow.ViewOrder = View.Text;
            uRow.OrderDate = Convert.ToDateTime(Date.Text);
            uRow.CostOrder = Convert.ToInt32(Price.Text);
            uRow.idClient = Convert.ToInt32(comboBox2.SelectedValue.ToString());
            uRow.idService = Convert.ToInt32(comboBox1.SelectedValue.ToString());
            uRow.idUser = Convert.ToInt32(comboBox4.SelectedValue.ToString());
            uRow.idPayment = Convert.ToInt32(comboBox3.SelectedValue.ToString());
            db.SaveChanges();
            OrdersList.ItemsSource = db.Orders.ToList();
        }

    }
}