private void btnSaveUpd_Click(object sender, EventArgs e)
        {
            DBcon.connect();
            Pesticides pes = new Pesticides();

            pes.PesticideType     = comboBoxUpdType.Text;
            pes.PesticideQuantity = Decimal.Parse(numericUpDownUpdateQ.Value.ToString());

            PesticideHandler pesHandlr = new PesticideHandler();

            pesHandlr.updateQuantity(DBcon.getConn(), pes);

            MessageBox.Show("Fertiliser added");

            this.Hide();
        }
        private void btnSaveP_Click(object sender, EventArgs e)
        {
            DBcon.connect();
            Pesticides pes = new Pesticides();

            pes.PesticideType     = comboBoxPesType.Text;
            pes.PesticideQuantity = Decimal.Parse(numericUpDownPesQauntity.Value.ToString());
            pes.Company           = textBoxPesComp.Text;

            PesticideHandler pesHandlr = new PesticideHandler();

            pesHandlr.addNewPesticide(DBcon.getConn(), pes);

            MessageBox.Show("Fertiliser added");

            this.Hide();
        }