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");
}
