private void SearchDSPhieuXuat(string search)
        {
            PhieuXuatController phieuXuat = new PhieuXuatController();

            dgvDSPhieuXuat.ItemsSource           = phieuXuat.SearchList(search).DefaultView;
            dgvDSPhieuXuat.Columns[0].Visibility = Visibility.Collapsed;
            dgvDSPhieuXuat.SelectedIndex         = 0;
        }
        private void LoadDSPhieuXuat()
        {
            PhieuXuatController phieuXuat = new PhieuXuatController();

            dgvDSPhieuXuat.ItemsSource           = phieuXuat.GetList().DefaultView;
            dgvDSPhieuXuat.Columns[0].Visibility = Visibility.Collapsed;
            dgvDSPhieuXuat.SelectedIndex         = 0;
        }
        public ucUsedDetails(int id)
        {
            InitializeComponent();
            PhieuXuatController phieuXuat = new PhieuXuatController();

            dgvPhieuNhapDetails.ItemsSource = phieuXuat.GetDetails(id).DefaultView;
            txtGhiChuPX.Text = phieuXuat.GetNote(id);

            btnClose.Click += BtnClose_Click;
        }
        private void UcRawUsed_Loaded(object sender, RoutedEventArgs e)
        {
            NguyenLieuController nguyenLieu = new NguyenLieuController();
            PhieuXuatController  phieuXuat  = new PhieuXuatController();

            cbbTenNguyenLieu.ItemsSource = nguyenLieu.GetName();

            btnLuu.IsEnabled = false;
            btnHuy.IsEnabled = false;

            cbbTenNguyenLieu.IsEnabled = false;
            txtSoLuong.IsEnabled       = false;
            txtGhiChu.IsEnabled        = false;

            LoadDSPhieuXuat();

            dgvPhieuXuat.Columns[0].Header = "Tên nguyên liệu";
            dgvPhieuXuat.Columns[1].Header = "Số lượng";
            dgvPhieuXuat.Columns[2].Header = "Ghi chú";
        }
        private void BtnLuuPhieuXuat_Click(object sender, RoutedEventArgs e)
        {
            if (ctpx.Count > 0)
            {
                PhieuXuatController  phieuXuat  = new PhieuXuatController();
                NguyenLieuController nguyenLieu = new NguyenLieuController();
                DateTime             ngayXuat   = DateTime.Now;

                try
                {
                    phieuXuat.Create(manv, ngayXuat, txtGhiChuPX.Text);

                    int maPX = phieuXuat.GetLastId();

                    foreach (var item in ctpx)
                    {
                        int maNL = nguyenLieu.NameToId(item.TenNL);
                        phieuXuat.CreateDetails(maPX, maNL, item.SoLuongXuat, item.GhiChu);
                    }

                    MessageBox.Show("Lưu phiếu xuất thành công!", "Thông báo!", MessageBoxButton.OK, MessageBoxImage.Information);

                    ctpx.Clear();
                    cbbTenNguyenLieu.IsEnabled     = false;
                    cbbTenNguyenLieu.SelectedIndex = 0;
                    txtSoLuong.IsEnabled           = false;
                    txtSoLuong.Text     = "";
                    txtGhiChu.IsEnabled = false;
                    txtGhiChu.Text      = "";

                    LoadDSPhieuXuat();

                    txtGhiChuPX.Text = "";
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }