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