/// <summary>
        /// used to display all for final barcode
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ViewAll_Click(object sender, EventArgs e)
        {
            var view = (from barcode in _Database.Barcodes
                        where barcode.Batch == _Batch &&
                        barcode.PrintBatch != null &&
                        barcode.FinalBarcode == "success"
                        select new
            {
                barcode.SequenceNumber,
                barcode.Barcodes
            }).ToList();

            FinalBarcodeView.DataSource = view;
            FinalBarcodeView.Refresh();
        }
        /// <summary>
        /// used to refresh and view data
        /// </summary>
        private void ViewData()
        {
            var finalBarcode = (from barcode in _Database.Barcodes
                                where barcode.FinalBarcode != null &&
                                barcode.PrintBatch != null &&
                                barcode.FinalBarcode == "success" &&
                                barcode.Batch == _Batch
                                select new
            {
                barcode.SequenceNumber,
                barcode.Barcodes
            }).ToList();

            FinalBarcodeView.DataSource = finalBarcode;
            FinalBarcodeView.Refresh();
        }
        /// <summary>
        /// used to refresh data from database to final barcode view
        /// </summary>
        private void RefreshData()
        {
            var view = (from barcode in _Database.Barcodes
                        where barcode.Batch == _Batch &&
                        barcode.PrintBatch != null &&
                        barcode.FinalBarcode == "success"

                        select new
            {
                barcode.SequenceNumber,
                barcode.Barcodes
            }).ToList();

            ScannedCount.Text           = view.Count().ToString();
            FinalBarcodeView.DataSource = view;
            FinalBarcodeView.Refresh();
        }