private void button1_Click(object sender, EventArgs e)
        {
            DialogResult result;

            result = MessageBox.Show("Are you sure want to update Transmission details?", "Update File Details", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                if (new ShipmentDetailMng(conn).ProductionDoneIsExist(int.Parse(lblTLbl.Text), lblShipment.Text) == true)
                {
                    if (new ShipmentDetailMng(conn).QRDoneIsExist(int.Parse(lblTLbl.Text), lblShipment.Text) == true)
                    {
                        ShipmetDetail mShilmpent = new ShipmetDetail();

                        mShilmpent.ShpID              = (int.Parse(lblTLbl.Text));
                        mShilmpent.ShipmentID         = lblShipment.Text;
                        mShilmpent.DollerFileName     = txtDollarFileName.Text;
                        mShilmpent.DollerUploadedDate = dateTimePickerDollarDate.Value;
                        mShilmpent.FinalPrice         = float.Parse(numericFinalPrice.Value.ToString());
                        mShilmpent.XmittedDate        = dateTimePickerXmittedDate.Value;
                        mShilmpent.TransmissionDone   = 1;


                        ShipmentDetailMng ShipDetailMng = new ShipmentDetailMng(conn);


                        if (ShipDetailMng.UpdateTransmissioInShipment(mShilmpent) > 0)
                        {
                            MessageBox.Show("File details successfully updated..!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                    else
                    {
                        MessageBox.Show("File is not QR done yet", "Cannot Update Trasmission", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }

                else
                {
                    MessageBox.Show("File is not Production done yet", "Cannot Update Trasmission", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }