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; } } }
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; } } }
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(); } } }
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"); } } }