示例#1
0
        private void equipmentForm_Load(object sender, EventArgs e)
        {
            if (Scanning.InitReader())
            {
                readerEventHandler = new EventHandler(myReader_OnRead);

                Scanning.MyEventHandler = readerEventHandler;

                populateTreeView();
                populateMFRComboBox();
            }
        }
示例#2
0
        private void myReader_OnRead(object sender, EventArgs e)
        {
            Symbol.Barcode.ReaderData TheReaderData = Scanning.MyReaderData;

            // If it is a successful read (as opposed to a failed one)
            if (TheReaderData.Result == Symbol.Results.SUCCESS)
            {
                if (TheReaderData.Type == Symbol.Barcode.DecoderTypes.PDF417)
                {
                    util.CAC_PDF417 CAC_PDF417 = new util.CAC_PDF417(TheReaderData.Text);

                    lastNameTextBox.Text         = CAC_PDF417.LastName;
                    firstNameTextBox.Text        = CAC_PDF417.FirstName;
                    middleInitialTextBox.Text    = CAC_PDF417.MiddleInitial;
                    ediTextBox.Text              = CAC_PDF417.EDI;
                    rankTextBox.Text             = CAC_PDF417.Rank;
                    branchComboBox.SelectedValue = CAC_PDF417.BranchCode;

                    if (TheReaderData.MultiPart)
                    {
                        MessageBox.Show(TheReaderData.AuxData.Text);
                    }
                }

                // Start the next read
                Scanning.StartRead();
            }
            else
            {
                string sMsg = "Read Failed\n"
                              + "Result = "
                              + (TheReaderData.Result).ToString();

                MessageBox.Show(sMsg, "ReadNotify");

                if (TheReaderData.Result == Symbol.Results.E_SCN_READINCOMPATIBLE)
                {
                    // If the failure is E_SCN_READINCOMPATIBLE, exit the application.
                    MessageBox.Show("The application will now exit.");
                    this.Close();
                    return;
                }
            }
        }
示例#3
0
        private void myReader_OnRead(object sender, EventArgs e)
        {
            Symbol.Barcode.ReaderData TheReaderData = Scanning.MyReaderData;

            // If it is a successful read (as opposed to a failed one)
            if (TheReaderData.Result == Symbol.Results.SUCCESS)
            {
                if (TheReaderData.Type == Symbol.Barcode.DecoderTypes.DATAMATRIX)
                {
                    //Symbol.Barcode.DecoderTypes.DATAMATRIX
                    util.Equip_DataMatrix scannedDataMatrix = new util.Equip_DataMatrix(TheReaderData.Text);

                    serialNumberTextBox.Text  = scannedDataMatrix.SerialNumber;
                    mfrComboBox.SelectedValue = scannedDataMatrix.MFR;
                    populateProductComboBox(mfrComboBox.SelectedValue.ToString());
                    productComboBox.SelectedValue = scannedDataMatrix.PartNumber;

                    if (TheReaderData.MultiPart)
                    {
                        MessageBox.Show(TheReaderData.AuxData.Text);
                    }
                }

                // Start the next read
                Scanning.StartRead();
            }
            else
            {
                string sMsg = "Read Failed\n"
                              + "Result = "
                              + (TheReaderData.Result).ToString();

                MessageBox.Show(sMsg, "ReadNotify");

                if (TheReaderData.Result == Symbol.Results.E_SCN_READINCOMPATIBLE)
                {
                    // If the failure is E_SCN_READINCOMPATIBLE, exit the application.
                    MessageBox.Show("The application will now exit.");
                    this.Close();
                    return;
                }
            }
        }
示例#4
0
        private void personnelForm_Load(object sender, EventArgs e)
        {
            SQLiteDataAdapter etDBDataAdapter = new SQLiteDataAdapter("SELECT Branch, BranchCode FROM Branch", etDBConnection);
            DataSet           etDBDataSet     = new DataSet("Personnel");

            etDBConnection.Open();
            etDBDataAdapter.Fill(etDBDataSet);
            etDBConnection.Close();

            branchComboBox.DataSource    = etDBDataSet.Tables[0];
            branchComboBox.DisplayMember = "Branch";
            branchComboBox.ValueMember   = "BranchCode";

            refreshPersonnelListbox();
            if (Scanning.InitReader())
            {
                readerEventHandler = new EventHandler(myReader_OnRead);

                Scanning.MyEventHandler = readerEventHandler;
            }
        }
示例#5
0
 private void insertEquipmentMenuItem_Click(object sender, EventArgs e)
 {
     if (insertEquipmentMenuItem.Text == "New")
     {
         Scanning.StartRead();
         cancelActionEquipmentMenuItem.Enabled = true;
         insertEquipmentMenuItem.Text          = "Insert";
     }
     else
     {
         try
         {
             SQLiteCommand addEquipmentCommand = new SQLiteCommand(kumpotDBConnection);
             addEquipmentCommand.CommandText = "INSERT INTO EquipInventory (SerialNumber, PartNumber) VALUES ('" +
                                               serialNumberTextBox.Text.Trim() + "', '" + productComboBox.SelectedValue.ToString().Trim() + "')";
             kumpotDBConnection.Open();
             addEquipmentCommand.ExecuteScalar();
             kumpotDBConnection.Close();
             MessageBox.Show("Equipment Added");
             insertEquipmentMenuItem.Text          = "New";
             cancelActionEquipmentMenuItem.Enabled = false;
             populateTreeView();
             Scanning.StopRead();
         }
         catch (SQLiteException ex)
         {
             MessageBox.Show(ex.Message);
             //switch (ex.ErrorCode)
             //{
             //    case SQLiteErrorCode.Constraint:
             //        MessageBox.Show("Serial number is already added.", "Invalid Serial", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
             //        break;
             //}
         }
         finally
         {
             kumpotDBConnection.Close();
         }
     }
 }
示例#6
0
 private void cancelMenuItem_Click(object sender, EventArgs e)
 {
     if (insertPersonnelMenuItem.Text == "Insert")
     {
         insertPersonnelMenuItem.Text = "New";
         Scanning.StopRead();
         togglePersonnelForm(false);
         clearPersonnelForm();
         refreshPersonnelDetails(personnelListBox.SelectedValue.ToString());
         editPersonnelMenuItem.Enabled = true;
     }
     else if (editPersonnelMenuItem.Text == "Update")
     {
         editPersonnelMenuItem.Text = "Edit";
         togglePersonnelForm(false);
         clearPersonnelForm();
         refreshPersonnelDetails(personnelListBox.SelectedValue.ToString());
         insertPersonnelMenuItem.Enabled = true;
         ediTextBox.Enabled = true;
     }
     personnelListBox.Enabled        = true;
     cancelMenuItem.Enabled          = false;
     deletePersonnelMenuItem.Enabled = true;
 }
示例#7
0
 private void cancelActionEquipmentMenuItem_Click(object sender, EventArgs e)
 {
     insertEquipmentMenuItem.Text          = "New";
     cancelActionEquipmentMenuItem.Enabled = false;
     Scanning.StopRead();
 }
示例#8
0
 private void equipmentForm_Closed(object sender, EventArgs e)
 {
     Scanning.TermReader();
 }
示例#9
0
        private void insertPersonnelMenuItem_Click(object sender, EventArgs e)
        {
            if (insertPersonnelMenuItem.Text == "New")
            {
                togglePersonnelForm(true);
                personnelListBox.Enabled        = false;
                insertPersonnelMenuItem.Text    = "Insert";
                deletePersonnelMenuItem.Enabled = false;
                cancelMenuItem.Enabled          = true;
                editPersonnelMenuItem.Enabled   = false;
                clearPersonnelForm();
                Scanning.StartRead();
            }
            else if (MessageBox.Show("Are you sure you want to commit this information to the database?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                if (lastNameTextBox.Text != "" && firstNameTextBox.Text != "" && ediTextBox.Text != "" && rankTextBox.Text != "")
                {
                    try
                    {
                        SQLiteCommand addPersonnelCommand = new SQLiteCommand(etDBConnection);
                        addPersonnelCommand.CommandText = "INSERT INTO Personnel (PersonnelEDI, FirstName, LastName, Rank, Branch, MiddleInitial) " +
                                                          "VALUES ($EDI,$FirstName,$LastName,$Rank,$Branch,$MiddleInitial)";


                        addPersonnelCommand.Parameters.AddWithValue("$EDI", ediTextBox.Text.Trim());
                        addPersonnelCommand.Parameters.AddWithValue("$FirstName", firstNameTextBox.Text.Trim());
                        addPersonnelCommand.Parameters.AddWithValue("$LastName", lastNameTextBox.Text.Trim());
                        addPersonnelCommand.Parameters.AddWithValue("$Rank", rankTextBox.Text.Trim());
                        addPersonnelCommand.Parameters.AddWithValue("$Branch", branchComboBox.SelectedValue.ToString());
                        addPersonnelCommand.Parameters.AddWithValue("$MiddleInitial", middleInitialTextBox.Text.Trim());

                        //Open database and execute command
                        etDBConnection.Open();
                        addPersonnelCommand.ExecuteNonQuery();
                        etDBConnection.Close();
                        MessageBox.Show("Personnel Added");

                        insertPersonnelMenuItem.Text    = "New";
                        cancelMenuItem.Enabled          = false;
                        deletePersonnelMenuItem.Enabled = true;
                        editPersonnelMenuItem.Enabled   = true;
                        personnelListBox.Enabled        = true;

                        togglePersonnelForm(false);
                        clearPersonnelForm();
                        refreshPersonnelListbox();
                        Scanning.StopRead();
                    }
                    catch (SQLiteException sqliteException)
                    {
                        MessageBox.Show(sqliteException.Message);
                        //if (sqliteException.ErrorCode == SQLiteErrorCode.Constraint)
                        //{
                        //    MessageBox.Show("Entered EDI number is not unique and already added.  User is possibly already added.", "Invalid EDI", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
                        //}
                    }
                    finally
                    {
                        etDBConnection.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Missing required information");
                }
            }
        }
示例#10
0
 private void personnelForm_Closed(object sender, EventArgs e)
 {
     Scanning.TermReader();
 }