private void buttonUpdateEmployee_Click(object sender, EventArgs e)
        {
            if ((textBoxclientname.Text == "") || (textBoxbooktitle.Text == "") || (textBoxOrderQuantity.Text == "") || (textBoxUnitPrice.Text == "") || (textBoxSubtotal.Text == "") || (textBoxGST.Text == "") || (textBoxPST.Text == "") || (textBoxtotal.Text == ""))
            {
                MessageBox.Show("Please full fill all the fields", "Missing Data");

                return;
            }
            else
            {
            }
            {
                Order Us = new Order();
                Us.OrdernUmber  = Convert.ToInt32(textBoxOrderNumber.Text);
                Us.OrderDate    = dateTimePickerOrder.Text;
                Us.ShippingDate = dateTimePickerShipping.Text;
                Us.ClientNumber = textBoxclientname.Text;
                Us.BookName     = textBoxbooktitle.Text;
                Us.Quantity     = Convert.ToSByte(textBoxOrderQuantity.Text);
                Us.unit         = Convert.ToSByte(textBoxUnitPrice.Text);
                Us.Subtotal     = Convert.ToSByte(textBoxSubtotal.Text);
                Us.Gst          = Convert.ToSByte(textBoxGST.Text);
                Us.Pst          = Convert.ToSByte(textBoxPST.Text);
                Us.unit         = Convert.ToSByte(textBoxtotal.Text);
                DialogResult ans = MessageBox.Show("Do you really want to update this User?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                if (ans == DialogResult.Yes)
                {
                    OrdersDA.Update(Us);
                    MessageBox.Show("User record has been updated successfully", "Confirmation");
                }
                textBoxOrderNumber.Enabled = true;
                ClearAll();
            }
        }