예제 #1
0
        private void buttonAddDevice_Click(object sender, EventArgs e)
        {
            // Bring up the Add Device form
            this.Visible = false;

            AddDevice form = new AddDevice();

            form.Show();

            this.Dispose();
        }
예제 #2
0
        private void buttonAddDevice_Click(object sender, EventArgs e)
        {
            // Check for blank fields and verify the device is not already added
            SQLiteConnection connectCheck = new SQLiteConnection(Login.connection);

            connectCheck.Open();
            String        queryCheckDevice = "SELECT Device, SerialNumber FROM Device WHERE Device = '" + textBoxDevice.Text + "' OR SerialNumber = '" + textBoxSerial.Text + "';";
            SQLiteCommand cmdCheck         = new SQLiteCommand(queryCheckDevice, connectCheck);
            object        checkDevice      = cmdCheck.ExecuteScalar();

            connectCheck.Close();

            if (checkDevice != null)
            {
                MessageBox.Show("This Device and/or Serial Number is already in the database.");
            }


            else if (string.IsNullOrWhiteSpace(textBoxDevice.Text) || string.IsNullOrWhiteSpace(textBoxSerial.Text))
            {
                MessageBox.Show("Please enter all information for the device.");
            }

            else if (MessageBox.Show("Are you sure you want to add this device?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                SQLiteConnection connect = new SQLiteConnection(Login.connection);

                // Adds the new Serial Number and Device Name to the Devices table in the database
                try
                {
                    String        query = "INSERT INTO Device (SerialNumber, Device) VALUES (@SerialNumber, @Device);";
                    SQLiteCommand cmd   = new SQLiteCommand(query, connect);
                    connect.Open();

                    cmd.Parameters.AddWithValue("@SerialNumber", textBoxSerial.Text);
                    cmd.Parameters.AddWithValue("@Device", textBoxDevice.Text);
                    cmd.ExecuteNonQuery();
                    connect.Close();
                }
                catch (SQLiteException exp)
                {
                    MessageBox.Show(exp.Message.ToString());
                }
                finally
                {
                    if (connect.State == ConnectionState.Open)
                    {
                        connect.Close();
                    }
                }

                // Refresh after the device has been added
                this.Visible = false;

                AddDevice form = new AddDevice();
                form.Show();

                this.Dispose();
            }
            else
            {
                // Discard changes
            }
        }