예제 #1
0
        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);
            }
        }