private void btnDone_Click(object sender, EventArgs e)
        {
            ShipmentDetailFormats mShFormats = new ShipmentDetailFormats();

            DialogResult result;

            result = MessageBox.Show("Are you sure want to update file details?", "Update File Details", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                ShipmetDetail            mShilmpent = new ShipmetDetail();
                ShipmentDetailFormatsMng ShFormats  = new ShipmentDetailFormatsMng(conn);



                mShilmpent.ShpID       = (int.Parse(lblTLbl.Text));
                mShilmpent.ShipmentID  = lblShipment.Text;
                mShilmpent.ISBN        = txtISBN.Text;
                mShilmpent.DISBN       = txtdISBN.Text;
                mShilmpent.Title       = txtBookTitle.Text;
                mShilmpent.Author      = txtAuthor.Text;
                mShilmpent.Author1     = txtAuthor2.Text;
                mShilmpent.PageCount   = int.Parse(txtPageCount.Text);
                mShilmpent.PCPCode     = txtPCPCode.Text;
                mShilmpent.Complexcity = cmbComplexcity.Text;
                mShilmpent.PubDate     = dateTimePickerPubDate.Value;
                mShilmpent.Publisher   = cmbPublisher.Text;
                mShilmpent.Language    = cmbLanguage.Text;
                mShilmpent.Team        = cmbTeamName.Text;
                mShilmpent.Comment     = txtComment.Text;

                ShipmentDetailMng ShipDetailMng = new ShipmentDetailMng(conn);


                if (ShipDetailMng.UpdateShipment(mShilmpent) > 0)
                {
                    MessageBox.Show("File details successfully updated..!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    ShipDetailMng.GetAllShipmentByName();
                }
            }
        }
        private void button3_Click(object sender, EventArgs e)
        {
            try{
                DialogResult result;
                result = MessageBox.Show("Do you really want to register this shipment?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                if (cmbShipmentName.Text != "")
                {
                    if (cmbPDTeam.Text != "")
                    {
                        if (result == DialogResult.Yes)
                        {
                            if (dataGridViewDCDImport.DataSource != null)
                            {
                                //Create Object From User Object
                                ShipmetDetail         mShDetail  = new ShipmetDetail();
                                ShipmentHeader        mShHeader  = new ShipmentHeader();
                                ShipmentDetailFormats mShFormats = new ShipmentDetailFormats();

                                ShipmentHeaderMng        ShHeader  = new ShipmentHeaderMng(conn);
                                ShipmentDetailMng        ShDetail  = new ShipmentDetailMng(conn);
                                ShipmentDetailFormatsMng ShFormats = new ShipmentDetailFormatsMng(conn);

                                mShHeader.ShipmentID     = cmbShipmentName.Text;
                                mShHeader.DownloadedDate = dateTimePickerDCDImport.Value;
                                mShHeader.FileCount      = int.Parse(lblFileCount.Text.ToString());

                                if (ShHeader.AddShipmentHeader(mShHeader) > 0)
                                {
                                    //Loop until total Shipment File Count Registerd into the ShipmentDetails Tabele
                                    for (int i = 0; i < dataGridViewDCDImport.Rows.Count; i++)
                                    {
                                        //Load Selected Grid Row to frm_EditImportedFile for Edit
                                        // int rowIndex = dataGridViewDCDImport.CurrentRow.Index;

                                        string   sISBN         = dataGridViewDCDImport.Rows[i].Cells[0].Value.ToString();
                                        string   sdISBN        = dataGridViewDCDImport.Rows[i].Cells[1].Value.ToString();
                                        string   stxtBookTitle = dataGridViewDCDImport.Rows[i].Cells[2].Value.ToString();
                                        string   stxtAuthor    = dataGridViewDCDImport.Rows[i].Cells[3].Value.ToString();
                                        string   stxtAuthor1   = dataGridViewDCDImport.Rows[i].Cells[4].Value.ToString();
                                        int      sPageCount    = int.Parse(dataGridViewDCDImport.Rows[i].Cells[5].Value.ToString());
                                        DateTime sPubDate      = DateTime.Parse(dataGridViewDCDImport.Rows[i].Cells[6].Value.ToString());
                                        string   sPublisher    = dataGridViewDCDImport.Rows[i].Cells[7].Value.ToString();
                                        string   sLanguage     = dataGridViewDCDImport.Rows[i].Cells[8].Value.ToString();
                                        string   sFormat       = dataGridViewDCDImport.Rows[i].Cells[9].Value.ToString();
                                        string   sComment      = dataGridViewDCDImport.Rows[i].Cells[10].Value.ToString();
                                        string   sTeam         = cmbPDTeam.Text;



                                        // Assign User Interface data to User Object
                                        mShDetail.DownloadedDate   = dateTimePickerDCDImport.Value;
                                        mShDetail.ID               = cmbShipmentName.Text;
                                        mShDetail.Publisher        = sPublisher;
                                        mShDetail.ISBN             = sISBN;
                                        mShDetail.DISBN            = sdISBN;
                                        mShDetail.Title            = stxtBookTitle;
                                        mShDetail.Author           = stxtAuthor;
                                        mShDetail.Author1          = stxtAuthor1;
                                        mShDetail.PageCount        = sPageCount;
                                        mShDetail.PubDate          = sPubDate;
                                        mShDetail.Language         = sLanguage;
                                        mShDetail.Format           = sFormat;
                                        mShDetail.Comment          = sComment;
                                        mShDetail.DateOfAllocation = dateTimePickerAllocatedDate.Value;
                                        mShDetail.Team             = sTeam;
                                        mShDetail.TATDelivery      = 0;
                                        mShDetail.ProductionDone   = 0;
                                        mShDetail.QRDone           = 0;
                                        mShDetail.TransmissionDone = 0;
                                        mShDetail.ClientFeedback   = 0;


                                        if (ShDetail.AddSipmentFile(mShDetail) > 0)
                                        {
                                            // For each uutput formats dedicate a column
                                            //string fePub
                                            //string fMobi
                                            //string fWEB
                                            //string fDoc
                                            //string fAFF For Apple Fixed Book
                                            //string fKF8 For Kindle Fixed Book
                                            //string fKCC For Kindle Comic Book
                                            //string fePib For B&N Fixed Book

                                            mShFormats.ShipmentID = cmbShipmentName.Text;
                                            mShFormats.ShpID      = ShDetail.GetLastID();
                                            List <String> LFormat = ShFormats.GetAllFormats();
                                            mShFormats.ProductionStatus = "Not Assigned";


                                            var s1 = sFormat.Split('/');
                                            for (int x = 0; x < s1.Length; x++)
                                            {
                                                for (int y = 0; y < LFormat.Count(); y++)
                                                {
                                                    if (s1[x].ToString() == LFormat[y])
                                                    {
                                                        mShFormats.FormatName = LFormat[y].ToString();
                                                    }
                                                }

                                                ShFormats.AddShimpentFormats(mShFormats);
                                            }
                                        }
                                    }

                                    MessageBox.Show("New Shipment been registered..!\n\nShipment Name: " + mShDetail.ID + "\nTotal File(s): " + (dataGridViewDCDImport.Rows.Count), "Shipment Registerd", MessageBoxButtons.OK, MessageBoxIcon.Information);

                                    //Clear Header Details registered after shipment
                                    dataGridViewDCDImport.DataSource = null;
                                    lblFileCount.Text  = "";
                                    lblImportPath.Text = "";
                                    dataGridViewDCDInventory.Focus();
                                    RefreshData();
                                    cmbShipmentName.Text = "";
                                    btnImport.Enabled    = false;
                                }
                            }
                            else
                            {
                                MessageBox.Show("There is no new Shipment to import! \nPlease import provided excel file.", "Empty Shipment", MessageBoxButtons.OK, MessageBoxIcon.Error);
                                btnImport.Focus();
                            }
                        }
                        else
                        {
                        }
                    }
                    else
                    {
                        MessageBox.Show("Please select a Team to allocate shipment!", "Empty Team", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        cmbPDTeam.Focus();
                    }
                }
                else
                {
                    MessageBox.Show("There is no Shipment to import!.", "Empty Shipment", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbShipmentName.Focus();
                }
            }
            catch (Exception ex) {
                if (ex.HResult == -2146232060)
                {
                    MessageBox.Show("This shipment is already imported..!\n Please check shipment name again.", "Cannot Import", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("Error" + ex.Message);
                }
            }
        }
示例#3
0
        private void btnAssignUID_Click(object sender, EventArgs e)
        {
            //validate User ID
            if (cmbUserID.Text != "")
            {
                try
                {
                    DialogResult result;
                    result = MessageBox.Show("Do You want to assign User " + cmbUserID.Text + " to this file?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    //Confirm by user
                    if (result == DialogResult.Yes)
                    {
                        //validate Production ID
                        if (cmbPID.Text != "")
                        {
                            int rowIndex = dataGridBeforeAssignedUID.CurrentRow.Index;

                            ProductionManagementHeader mProductionHdr = new ProductionManagementHeader();
                            ProductionManagementDetail mProductionDtl = new ProductionManagementDetail();
                            ShipmentDetailFormats      mShipmetDetail = new ShipmentDetailFormats();
                            ProductionStatus           mLog           = new ProductionStatus();

                            //Production Management Header Value
                            mProductionHdr.ShpID      = int.Parse(cmbPID.Text);
                            mProductionHdr.ShipmentID = cmbShipment.Text;
                            mProductionHdr.FormatName = cmbFormat.Text;

                            //Production Management Detail Value
                            mProductionDtl.ShpID            = int.Parse(cmbPID.Text);
                            mProductionDtl.ShipmentID       = cmbShipment.Text;
                            mProductionDtl.Format           = cmbFormat.Text;
                            mProductionDtl.ISBN             = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString();
                            mProductionDtl.UserID           = cmbUserID.Text;
                            mProductionDtl.PageCount        = int.Parse(dataGridBeforeAssignedUID.Rows[rowIndex].Cells[8].Value.ToString());
                            mProductionDtl.StartDate        = dateTimePickerStartDate.Value;
                            mProductionDtl.ProductionStatus = "Process By User";

                            //Shipment Detail Formats Value
                            mShipmetDetail.ShpID            = int.Parse(cmbPID.Text);
                            mShipmetDetail.ShipmentID       = cmbShipment.Text;
                            mShipmetDetail.FormatName       = cmbFormat.Text;
                            mShipmetDetail.ProductionStatus = "Process By User";

                            //Production Status Log Value
                            mLog.ProductID  = int.Parse(cmbPID.Text);
                            mLog.ShipmentID = cmbShipment.Text;
                            mLog.ISBN       = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString();
                            mLog.StartDate  = DateTime.Now;
                            mLog.FormatName = cmbFormat.Text;
                            mLog.UserID     = lblCUID.Text;
                            mLog.Status     = "Production assign to User " + cmbUserID.Text + " by Access User " + lblCUID.Text;

                            ProductionManagementDetailMng mProductionDtlMng  = new ProductionManagementDetailMng(conn);
                            ShipmentDetailFormatsMng      mShipmentDetailMng = new ShipmentDetailFormatsMng(conn);

                            //Add Prodution Management Header table
                            if (new ProductionManagementHeaderMng(this.conn).AddProductionManagementHeader(mProductionHdr) > 0)
                            {
                                //Update Shipment Format table
                                mShipmentDetailMng.UpdateProductionOnSipmentFormatFile(mShipmetDetail);

                                //Add Prodution Management Detail table
                                mProductionDtlMng.AddProductionManagementDetail(mProductionDtl);
                                MessageBox.Show("File has been assigned.\n\n ISBN: " + mProductionDtl.ISBN + "\n User ID: " + cmbUserID.Text + "\n Start Date: " + dateTimePickerStartDate.Value.ToString("dd/MMM/yyyy"), "File Assigned", MessageBoxButtons.OK, MessageBoxIcon.Information);

                                //Production Log table
                                new ProductionStatusLogMng(this.conn).AddProdustionStatus(mLog);
                                RefreshData();
                            }
                        }
                        else
                        {
                            MessageBox.Show("Production ID cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            cmbPID.Focus();
                        }
                    }
                }
                catch (Exception ex)
                {
                    if (ex.HResult == -2146232060)
                    {
                        MessageBox.Show("This Format is already assigned to a User.\n Please check Format & User ID again.", "Cannot Assign", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        MessageBox.Show("Error" + ex.Message);
                    }
                }
            }
            else
            {
                MessageBox.Show("Plese select User ID to assign file.", "Cannot Assign", MessageBoxButtons.OK, MessageBoxIcon.Error);
                cmbUserID.Focus();
            }
        }
示例#4
0
        private void btnRemove_Click(object sender, EventArgs e)
        {
            try{
                //Message for Error when Shipment Fied is empty
                if (cmbShipment.Text.ToString() == "")
                {
                    MessageBox.Show("Please select a Shipment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                else
                {
                    if (cbmSAllFiles.Checked == true && cmbShipment.Text.ToString() != "")
                    {
                        //Initialize Message Result
                        DialogResult result;
                        result = MessageBox.Show("Do you really want to delete \"" + cmbShipment.Text + "\"?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);


                        if (result == System.Windows.Forms.DialogResult.Yes)
                        {
                            //Create Object From ShipmetDetail Object
                            ShipmetDetail              mShipment                   = new ShipmetDetail();
                            ShipmentHeader             mShipmentHeader             = new ShipmentHeader();
                            ShipmentDetailFormats      mShipmentDetailFormats      = new ShipmentDetailFormats();
                            TATDelivery                mTATDelivery                = new TATDelivery();
                            ProductionManagementDetail mProductionManagementDetail = new ProductionManagementDetail();
                            ProductionManagementHeader mProductionManagementHeader = new ProductionManagementHeader();


                            // Assign Shipment Delete Interface data to mShipmentID
                            String mShipmentID = cmbShipment.Text.ToString();


                            //Create Services
                            ShipmentDetailMng             mShipmentMng                   = new ShipmentDetailMng(conn);
                            ShipmentHeaderMng             mShipmentHeaderMng             = new ShipmentHeaderMng(conn);
                            ShipmentDetailFormatsMng      mShipmentDetailFormatsMng      = new ShipmentDetailFormatsMng(conn);
                            TATDeliveryMng                mTATDeliveryMng                = new TATDeliveryMng(conn);
                            ProductionManagementDetailMng mProductionManagementDetailMng = new ProductionManagementDetailMng(conn);
                            ProductionManagementHeaderMng mProductionManagementHeaderMng = new ProductionManagementHeaderMng(conn);

                            mShipmentDetailFormatsMng.DeleteShimpentFormats(mShipmentID);
                            mShipmentMng.DeleteShipment(mShipmentID);
                            mShipmentHeaderMng.DeleteShipmentHeader(mShipmentID);



                            MessageBox.Show("\"" + cmbShipment.Text + "\" successfully deleted..!", " Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            frm_DCDImport DCDFrm = new frm_DCDImport();
                            RefreshData();
                            this.Dispose();
                        }
                        else
                        {
                            this.Dispose();
                        }
                    }

                    else if (cmbISBN.Text != "" && cmbShipment.Text.ToString() != "")
                    {
                        //Initialize Message Result
                        DialogResult result;
                        result = MessageBox.Show("Do you really want to delete ISBN " + cmbISBN.Text + "?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                        if (result == System.Windows.Forms.DialogResult.Yes)
                        {
                            //Create Object From ShipmetDetail Object
                            ShipmetDetail         mShipmentISBN          = new ShipmetDetail();
                            ShipmetDetail         mShipment              = new ShipmetDetail();
                            ShipmentDetailFormats mShipmentDetailFormats = new ShipmentDetailFormats();



                            // Assign Shipment Delete Interface data to mShipmentwithISBN Object
                            mShipment.ID       = cmbShipment.Text;
                            mShipmentISBN.ISBN = cmbISBN.Text;


                            ShipmentDetailMng        mShipmentMng              = new ShipmentDetailMng(conn);
                            ShipmentDetailMng        mShipmentMngShpID         = new ShipmentDetailMng(conn);
                            ShipmentDetailFormatsMng mShipmentDetailFormatsMng = new ShipmentDetailFormatsMng(conn);

                            if (mShipmentMng.DeleteShipmentFromID(mShipmentISBN, mShipment) > 0)
                            {
                                MessageBox.Show("ISBN " + mShipmentISBN.ISBN + " successfully deleted..!", "ISBN Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                RefreshData();
                                this.Dispose();
                            }
                        }
                        else if (result == DialogResult.No)
                        {
                            this.Close();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.HResult == -2146232060)
                {
                    MessageBox.Show("This shipment is already in production!", "Cannot Delete", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("Error" + ex.Message);
                }
            }
        }
示例#5
0
        private void btnRemoveUID_Click(object sender, EventArgs e)
        {
            try
            {
                DialogResult result;
                int          rowIndex = dataGridAfterAssignedUID.CurrentRow.Index;

                if (dataGridAfterAssignedUID.Rows[rowIndex].Cells[7].Value.ToString() == "Process By User")
                {
                    String ISBN = dataGridAfterAssignedUID.Rows[rowIndex].Cells[2].Value.ToString();

                    result = MessageBox.Show("Do you really want to remove User ID from ISBN: " + ISBN + "?", "Remove User from Assign File", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (result == DialogResult.Yes)
                    {
                        QRDetail                   mQRD                   = new QRDetail();
                        QRHeader                   mQRH                   = new QRHeader();
                        EmployeeProduction         mEMP                   = new EmployeeProduction();
                        ProductionManagementDetail mProductionDtl         = new ProductionManagementDetail();
                        ProductionManagementHeader mProductionHdr         = new ProductionManagementHeader();
                        ShipmentDetailFormats      mShipmentDetailFormats = new ShipmentDetailFormats();
                        ProductionStatus           mLog                   = new ProductionStatus();

                        //initilize values for QR Detail to delete
                        mQRD.ProductID  = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mQRD.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mQRD.ISBN       = ISBN;
                        mQRD.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();

                        //initilize values for QR Header to delete
                        mQRH.ProductID  = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mQRH.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mQRH.ISBN       = ISBN;
                        mQRH.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();

                        //initilize values for Employee Production to delete
                        mEMP.ProductID  = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mEMP.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mEMP.ISBN       = ISBN;
                        mEMP.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();
                        mEMP.Status     = "Complete By User";

                        //initilize values for Production Detail to delete
                        mProductionDtl.ShpID      = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mProductionDtl.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mProductionDtl.ISBN       = ISBN;
                        mProductionDtl.Format     = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();

                        //initilize values for Production Detail Header to delete
                        mProductionHdr.ShpID      = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mProductionHdr.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mProductionHdr.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();

                        //initilize values for Detail Format to delete
                        mShipmentDetailFormats.ShpID      = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mShipmentDetailFormats.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mShipmentDetailFormats.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();

                        //Production Status Log Value
                        mLog.ProductID  = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString());
                        mLog.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString();
                        mLog.ISBN       = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString();
                        mLog.StartDate  = DateTime.Now;
                        mLog.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString();
                        mLog.UserID     = lblCUID.Text;
                        String aUID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[4].Value.ToString();
                        mLog.Status = "Removed assigned User " + aUID + " from Assgned Production by System Access User " + lblCUID.Text;

                        QRDetailMng                   mQRDMng                   = new QRDetailMng(conn);
                        QRHeaderMng                   mQRHMng                   = new QRHeaderMng(conn);
                        EmployeeProductionMng         mEPMMng                   = new EmployeeProductionMng(conn);
                        ProductionManagementDetailMng mShipmentDetailMng        = new ProductionManagementDetailMng(conn);
                        ProductionManagementHeaderMng mProductionHdrMng         = new ProductionManagementHeaderMng(conn);
                        ShipmentDetailFormatsMng      mShipmentDetailFormatsMng = new ShipmentDetailFormatsMng(conn);

                        // Delete Production Manegement Detail
                        if (mShipmentDetailMng.DeleteAssignedProductionManagementDetail(mProductionDtl) > 0)
                        {
                            // Delete Production Manegement Header
                            mProductionHdrMng.DeleteProductionManagementHeader(mProductionHdr);

                            // Delete QR Detail
                            if (mQRDMng.DeleteQRDetail(mQRD) > 0)
                            {
                                // Delete QR Header
                                mQRHMng.DeleteQRHeader(mQRH);
                            }
                            // Delete Employee Production
                            mEPMMng.DeleteUserProdcutionDone(mEMP);

                            // Update Employee Shipment Detail Formats to Not Assign
                            mShipmentDetailFormatsMng.UpdateProductionOnToBeAssignFormatFile(mShipmentDetailFormats);

                            MessageBox.Show("Selected assigned User successfully cleared from File..!", "Assigned File Clear", MessageBoxButtons.OK, MessageBoxIcon.Information);

                            //Production Log table
                            new ProductionStatusLogMng(this.conn).AddProdustionStatus(mLog);

                            RefreshData();
                        }
                    }
                }
                else
                {
                    MessageBox.Show("This file is already in process by User. \nFirst modify status before remove User ID.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    btnModifyUID.Focus();
                }
            }
            catch (Exception ex)
            {
                if (ex.HResult == -2147467261)
                {
                    MessageBox.Show("First select a file to remove User ID.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbShipment.Focus();
                }
                else
                {
                    MessageBox.Show("Error" + ex.Message);
                }
            }
        }