private void button1_Click(object sender, EventArgs e) { Database_Class db = new Database_Class(); string item_name, item_description; int item_num = 0; int clinic_number = 0; int quantity = 0; int reorder_level = 0; int reorder_quantity = 0; double item_cost = 0; item_name = txtItemName.Text; item_description = txtItemDescription.Text; item_num = Convert.ToInt32(txtItem_num.Text); if (cmbQuantity.SelectedItem != null) { quantity = int.Parse(cmbQuantity.SelectedItem.ToString()); } if (cmbReorderLevel.SelectedItem != null) { reorder_level = int.Parse(cmbReorderLevel.SelectedItem.ToString()); } if (cmbReorderQuantity.SelectedItem != null) { reorder_quantity = int.Parse(cmbReorderQuantity.SelectedItem.ToString()); } if (cmbClinicNum.SelectedValue != null) { clinic_number = int.Parse(cmbClinicNum.SelectedValue.ToString()); } item_cost = Convert.ToDouble(txtItemCost.Text); if (!txtItemName.Text.Equals(null) || !txtItemDescription.Equals(null) || !txtItem_num.Equals(null) || !txtItemCost.Equals(null) || cmbQuantity.SelectedItem != null || cmbReorderLevel.SelectedItem != null || cmbReorderQuantity.SelectedItem != null || cmbClinicNum.SelectedValue != null) { db.insert_non_surgical_supplies(item_num, item_name, item_description, quantity, reorder_level, reorder_quantity, item_cost, clinic_number); clear(); } else { MessageBox.Show("Please enter all required information", "Non-Surgical Supplies", MessageBoxButtons.OK, MessageBoxIcon.Information); } }