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

            result = MessageBox.Show("Are you sure want to update Audit 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.AuditName       = txtAuditName.Text;
                        mShilmpent.AuditLoadedDate = dateTimePickerAuditLoadedDate.Value;
                        mShilmpent.AuditCount      = int.Parse(numericAuditCount.Value.ToString());
                        mShilmpent.AuditStatus     = cmbAuditStatus.Text;


                        ShipmentDetailMng ShipDetailMng = new ShipmentDetailMng(conn);


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