private void btnDatHang_Click(object sender, EventArgs e)
        {
            int           soluong   = 0;
            int           dongia    = 0;
            List <string> mahanghoa = new List <string>();

            foreach (DataGridViewRow c in dgvHangHoa.Rows)
            {
                try
                {
                    if (c.Cells[0].Value.ToString() == "True")
                    {
                        soluong           = Int32.Parse(c.Cells[1].Value.ToString());
                        dongia            = Int32.Parse(c.Cells[5].Value.ToString());
                        this.tongsoluong += soluong;
                        this.tongtien    += soluong * dongia;
                        mahanghoa.Add(c.Cells[2].Value.ToString() + "," + soluong + "," + soluong * dongia);
                    }
                }
                catch
                {
                }
            }
            int       d           = (int)System.DateTime.Now.DayOfWeek;
            string    madonhang   = $"DH{d}-{DateTime.Now.ToString("HHmmss")}";
            string    maphieugiao = $"PG{d}-{DateTime.Now.ToString("HHmmss")}";
            HoaDon    hoadon      = new HoaDon(madonhang, txtMaKH.Text, "Xac Nhan", cbMaNV.Text, this.tongtien);
            PhieuGiao phieugiao   = new PhieuGiao(maphieugiao, madonhang, cbMaNV.Text, txtDiaChi.Text);

            XacNhan xacnhan = new XacNhan(hoadon, phieugiao, this.tongsoluong, txtMaKH.Text, mahanghoa);

            xacnhan.Owner = this;
            xacnhan.Show();
        }
        public bool taoDonHang(PhieuGiao phieuGiao)
        {
            DataProvider provider = new DataProvider();

            provider.getConnect();
            try
            {
                SqlCommand cmd = new SqlCommand(phieuGiao.queryInsert(), provider.Connect);
                provider.Connect.Open();
                cmd.ExecuteNonQuery();

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
            finally
            {
                provider.disConnect();
            }
        }