private void button1_Click(object sender, EventArgs e)
        {
            var isNumeric = int.TryParse(txtSearch.Text, out int n);

            if (isNumeric == true)
            {
                foreach (object o in cmdOp.Items)
                {
                    updateAll(o.ToString());
                }


                //NEEDS TO MARK THE DOOR AS COMPLETE
                SqlStatements sqlUpdate = new SqlStatements();

                frmLooseItems fli = new frmLooseItems(int.Parse(this.txtSearch.Text));

                fli.ShowDialog();



                sqlUpdate.CompleteDoor(Int32.Parse(txtSearch.Text), -1);
                RefreshDoorData();
            }
        }
        private void button1_Click_1(object sender, EventArgs e)
        {
            var isNumeric = int.TryParse(txtSearch.Text, out int n);

            if (isNumeric == true)
            {
                SqlStatements sqlUpdate = new SqlStatements();
                sqlUpdate.CompleteDoor(Int32.Parse(txtSearch.Text), 0);
                RefreshDoorData();
            }
        }