using System.Text;
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;
using Microsoft.EntityFrameworkCore;
using ontapcuoiky.Models;


namespace ontapcuoiky
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            hienthidulieu();
            hienthucb();
        }
        QlbanHangContext db = new QlbanHangContext();
        private void hienthidulieu()
        {
            var query = from sp in db.SanPhams.AsNoTracking()
                        orderby sp.TenSp 
                        select new
                        {
                            sp.MaSp,
                            sp.TenSp,
                            sp.MaLoai,
                            sp.SoLuong,
                            sp.DonGia,
                            ThanhTien = sp.SoLuong * sp.DonGia
                        };
            dtg.ItemsSource = query.ToList();
        }

        private void hienthucb()
        {
            var query = db.LoaiSanPhams.AsNoTracking().ToList();
            cb.ItemsSource = query.ToList();
            cb.DisplayMemberPath = "TenLoai";
            cb.SelectedValuePath = "MaLoai";
            cb.SelectedIndex = 0;
        }

        private void Them_Click(object sender, RoutedEventArgs e)
        {
            var query = db.SanPhams.SingleOrDefault(t => t.MaSp.Equals(txtma.Text));
            if(query != null)
            {
                MessageBox.Show("ma san pham da ton tai", "thong bao");
                return;
            }
            
            if(!int.TryParse(txtsoluong.Text, out var n) || n <= 0)
            {
                MessageBox.Show("so luong phai lon hon 0", "thong bao");
                return;
            }

            SanPham moi = new SanPham();
            moi.MaSp = txtma.Text;
            moi.TenSp = txtten.Text;
            LoaiSanPham a = (LoaiSanPham)cb.SelectedItem;
            moi.MaLoai = a.MaLoai;
            moi.DonGia = int.Parse(txtdongia.Text);
            moi.SoLuong = int.Parse(txtsoluong.Text); 
            db.SanPhams.Add(moi);
            db.SaveChanges();
            hienthidulieu();
            MessageBox.Show("them thanh cong", "thong bao");
        }

        private void sua(object sender, RoutedEventArgs e)
        {
            var query = db.SanPhams.SingleOrDefault(t => t.MaSp.Equals(txtma.Text));
            if (query == null)
            {
                MessageBox.Show("ma san pham khong ton tai", "thong bao");
                return;
            }
            if (!int.TryParse(txtsoluong.Text, out var n) || n <= 0)
            {
                MessageBox.Show("so luong phai lon hon 0", "thong bao");
                return;
            }

            query.TenSp = txtten.Text;
            query.DonGia = int.Parse(txtdongia.Text);
            query.SoLuong = int.Parse(txtsoluong.Text);
            LoaiSanPham a = (LoaiSanPham)cb.SelectedItem;
            query.MaLoai = a.MaLoai;
            db.SaveChanges();
            hienthidulieu();
            MessageBox.Show("sua thanh cong", "thong bao");
        }

        private void xoa(object sender, RoutedEventArgs e)
        {
            var query = db.SanPhams.SingleOrDefault(t => t.MaSp.Equals(txtma.Text));
            if (query == null)
            {
                MessageBox.Show("ma san pham khong ton tai", "thong bao");
                return;
            }
            MessageBoxResult kq = MessageBox.Show("ban co chac chan muon xoa khong", "thong bao", MessageBoxButton.YesNo);
            if(kq == MessageBoxResult.Yes)
            {
                db.SanPhams.Remove(query);
                db.SaveChanges();
                hienthidulieu();
                MessageBox.Show("xoa thanh cong", "thong bao");
            }
        }

        private void tim(object sender, RoutedEventArgs e)
        {
            var query = db.SanPhams.SingleOrDefault(t => t.MaSp.Equals(txtma.Text));
            if (query == null)
            {
                MessageBox.Show("ma san pham khong ton tai", "thong bao");
                return;
            }

            var x = from sp in db.SanPhams.AsNoTracking()
                    where sp.MaSp.Equals(txtma.Text) select new
                    {
                        sp.MaSp,
                        sp.TenSp,
                        sp.MaLoai,
                        sp.DonGia,
                        sp.SoLuong,
                        ThanhTien = sp.DonGia * sp.SoLuong
                    };
            dtg.ItemsSource = x.ToList();
        }

        private void thongke(object sender, RoutedEventArgs e)
        {
            Window1 x = new Window1();
            x.Show();
        }

        private void dtg_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            dynamic sp = dtg.SelectedItem;
            txtma.Text = sp.MaSp;
            txtten.Text = sp.TenSp;
            txtdongia.Text = sp.DonGia.ToString();
            txtsoluong.Text = sp.SoLuong.ToString();
            cb.SelectedValue = sp.MaLoai;
        }
    }
}