private void transferStockToolStripMenuItem_Click(object sender, EventArgs e)
        {
            TransferStock ts = new TransferStock();

            do
            {
                GetData();
                fillDGV();
                ts.ShowDialog();
            }while (TransferStock.act == "Transfer");
            fillItems();
        }
        private void tvItems_AfterSelect(object sender, TreeViewEventArgs e)
        {
            if (tvItems.SelectedNode.Text == "Add New Item")
            {
                Items it = new Items();
                it.ShowDialog();
                GetData();
                fillItems();
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }

            if (tvItems.SelectedNode.Text == "Order Stock")
            {
                NewPurchaseOrder nps = new NewPurchaseOrder();
                nps.ShowDialog();
                GetData();
                fillItems();
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }
            if (tvItems.SelectedNode.Text == "Receive Stock")
            {
                ReceiveStock rs = new ReceiveStock();
                do
                {
                    rs.ShowDialog();
                    GetData();
                    fillItems();
                }while (ReceiveStock.act == "Receive");
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }
            if (tvItems.SelectedNode.Text == "Sell Stock")
            {
                SellStock ss = new SellStock();
                do
                {
                    ss.ShowDialog();
                    GetData();
                    fillItems();
                }while (SellStock.act == "Sell");
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }
            if (tvItems.SelectedNode.Text == "Transfer Stock")
            {
                TransferStock ts = new TransferStock();
                do
                {
                    GetData();
                    fillDGV();
                    ts.ShowDialog();
                }while (TransferStock.act == "Transfer");

                fillItems();
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }
            if (tvItems.SelectedNode.Text == "Orders List")
            {
                OrdersList ol = new OrdersList();
                ol.ShowDialog();
                GetData();
                fillItems();
                tvItems.CollapseAll();
                tvItems.ExpandAll();
                return;
            }
        }