Ejemplo n.º 1
0
        void addFlowerToOrder()
        {
            //TODO: check if fl_id is not exist in that order
            var mySql = new mySql();

            createSQLSelelct();
            createSQLInsert();
            mySql.GetData(insertFltoOrder, bindingSourceOrders);
            dataGridViewAON.DataSource = bindingSourceOrders;
            mySql.GetData(selectOrder, bindingSourceOrders);
            dataGridViewAON.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            lblAddOrAntallBoxes.Text      = mySql.sumColumn(dataGridViewAON, "boxes");
            lblAddOrAntallStems.Text      = mySql.sumColumn(dataGridViewAON, "stems");
            lblAddOrAntallPrice.Text      = mySql.sumColumn(dataGridViewAON, "price");
            lblAddOrAntallBuckets.Text    = mySql.sumColumn(dataGridViewAON, "buckets");
        }