private void button1_Click(object sender, EventArgs e)
        {
            Database_Class db = new Database_Class();

            int drug_num;
            int clinic_number    = 0;
            int quantity_stock   = 0;
            int reorder_lvl      = 0;
            int reorder_quantity = 0;


            string drug_name, drug_description, method_admin;
            double dosage, drug_cost;

            drug_name        = txtDrugName.Text;
            drug_description = txtDrugDescription.Text;
            method_admin     = txtMethodAdministration.Text;

            drug_num = Convert.ToInt32(txtDrugNum.Text);

            if (cmbQuantity_In_Stock.SelectedItem != null)
            {
                quantity_stock = int.Parse(cmbQuantity_In_Stock.SelectedItem.ToString());
            }

            if (cmbReorder_lvl.SelectedItem != null)
            {
                reorder_lvl = int.Parse(cmbReorder_lvl.SelectedItem.ToString());
            }

            if (cmb_Drug_Quantity.SelectedItem != null)
            {
                reorder_quantity = int.Parse(cmb_Drug_Quantity.SelectedItem.ToString());
            }

            if (cmbClinicNumber.SelectedValue != null)
            {
                clinic_number = int.Parse(cmbClinicNumber.SelectedValue.ToString());
            }


            dosage    = Convert.ToDouble(txtDosage.Text);
            drug_cost = Convert.ToDouble(txtDrugCost.Text);


            if (!txtDrugName.Text.Equals(null) || !txtDrugDescription.Text.Equals(null) || !txtMethodAdministration.Text.Equals(null) || cmbQuantity_In_Stock.SelectedItem != null || cmbReorder_lvl.SelectedItem != null || cmbClinicNumber.SelectedValue != null || cmb_Drug_Quantity != null || !txtDosage.Text.Equals(null) || !txtDrugCost.Text.Equals(null))
            {
                db.insert_pharma_supplies(drug_num, clinic_number, drug_name, drug_description, dosage, method_admin, quantity_stock, reorder_lvl, reorder_quantity, drug_cost);
                clear();
            }
            else
            {
                MessageBox.Show("Please enter all required information", "Pharmacutical Supplies", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
예제 #2
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);
            }
        }
예제 #3
0
        private void button7_Click(object sender, EventArgs e)
        {
            Database_Class db = new Database_Class();

            string vetname, petName, petType, desctiption;
            string examNum;
            string staff_number = "TestValue";
            int    pet_number = 0;
            string examDate, examTime;

            Random ran = new Random();

            vetname     = txtVetFName.Text;
            petName     = lblPetName.Text;
            petType     = lblTypeOfPet.Text;
            examTime    = txtTime.Text;
            desctiption = richTextBox1.Text;



            examDate = dateTimePicker1.Value.ToString();
            examDate = examDate.Substring(0, 10).Replace('/', '-');

            if (cmbStaffNum.SelectedItem != null)
            {
                try
                {
                    staff_number = cmbStaffNum.SelectedValue.ToString();
                }
                catch (Exception exc)
                {
                    MessageBox.Show(exc.ToString());
                }
                finally
                {
                    cmbStaffNum.SelectedIndex = -1;
                }
            }

            if (cmbPetNum.SelectedItem != null)
            {
                try
                {
                    pet_number = Convert.ToInt32(cmbPetNum.SelectedValue);
                }
                catch (Exception exc)
                {
                    MessageBox.Show(exc.ToString());
                }
                finally
                {
                    cmbPetNum.SelectedIndex = -1;
                }
            }

            examNum = staff_number + pet_number + ran.Next(1111, 9999);



            db.insert_examination(examNum, examDate, examTime, vetname, pet_number,
                                  petName, petType, desctiption, staff_number);



            TreatmentReportForm treatmentForm = new TreatmentReportForm();

            treatmentForm.ShowDialog();
            this.Close();
        }