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