private void keypressed(Object o, KeyPressEventArgs e)//ENTER key
{
if (e.KeyChar == (char)Keys.Return)
{
e.Handled = true;
if (string.IsNullOrWhiteSpace(txtSearch.Text))
{
}
else
{
string tmp = txtSearch.Text;
cbLengths.SelectedIndex = 0;
cbColour.SelectedIndex = 0;
cbFarm.SelectedIndex = 0;
cbSleeve.SelectedIndex = 0;
radioButtonMix1.Checked = true;
radioButtonFt1.Checked = true;
txtSearch.Text = tmp;
var mySql = new mySql();
string search = "and flowers.plu=" + txtSearch.Text;
CBselect = mySql.selectFlAddOr + search;
mySql.GetData(CBselect, bindingSource1);
mySql.updateAntall(lblAddOrAntalFl, dataGridViewOA);
}
}
}
private void cbSleeve_SelectedIndexChanged(object sender, EventArgs e)
{
var mySql = new mySql();
whSleeve = mySql.findCbValue(cbSleeve, whSleeve, btnRemoveAOS, dataGridView4, "and sleeves.sleeve_id=", txtSearch);
CBselect = mySql.selectFlAddOr + whFarm + whLen + whColour + whSleeve + whMix + whFt;
mySql.GetData(CBselect, bindingSource1);
mySql.updateAntall(lblAddOrAntalFl, dataGridViewOA);
}
private void radioButtonFt3_CheckedChanged(object sender, EventArgs e)
{
var mySql = new mySql();
if (radioButtonFt3.Checked)
{
whFt = "and flowers.fairtrade=0";
}
CBselect = mySql.selectFlAddOr + whFarm + whLen + whColour + whSleeve + whMix + whFt;
mySql.GetData(CBselect, bindingSource1);
txtSearch.Text = "";
mySql.updateAntall(lblAddOrAntalFl, dataGridViewOA);
}
private void btnSearchFl_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtSearch.Text))
{
}
else
{
string tmp = txtSearch.Text;
cbLengths.SelectedIndex = 0;
cbColour.SelectedIndex = 0;
cbFarm.SelectedIndex = 0;
cbSleeve.SelectedIndex = 0;
radioButtonMix1.Checked = true;
radioButtonFt1.Checked = true;
txtSearch.Text = tmp;
var mySql = new mySql();
string search = "and flowers.plu=" + txtSearch.Text;
CBselect = mySql.selectFlAddOr + search;
mySql.GetData(CBselect, bindingSource1);
mySql.updateAntall(lblAddOrAntalFl, dataGridViewOA);
}
}
private void AddOr_Load(object sender, EventArgs e)
{
var mySql = new mySql();
CBselect = mySql.selectFlAddOr + whFarm + whLen + whColour + whSleeve + whMix + whFt;
dataGridViewOA.DataSource = bindingSource1;
mySql.GetData(CBselect, bindingSource1);
dataGridViewOA.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
//fill up dataGridView by Farms
dataGridView1.DataSource = bindingSource5;
mySql.GetData(mySql.selectFarms, bindingSource5);
//fill up dataGridView by Lengths
dataGridView2.DataSource = bindingSource2;
mySql.GetData(mySql.selectLengths, bindingSource2);
////fill up dataGridView by Colours
dataGridView3.DataSource = bindingSource3;
mySql.GetData(mySql.selectColour, bindingSource3);
////fill up dataGridView by Sleeves
dataGridView4.DataSource = bindingSource4;
mySql.GetData(mySql.selectSleeve, bindingSource4);
//fill up combo boxes
mySql.fillUpCb(cbFarm, "SELECT farms.farm_name FROM[MG_inkjop].[dbo].[farms]");
mySql.fillUpCb(cbLengths, "SELECT lengths.length FROM[MG_inkjop].[dbo].[lengths]");
mySql.fillUpCb(cbColour, "SELECT colours.colour FROM[MG_inkjop].[dbo].[colours]");
mySql.fillUpCb(cbSleeve, "SELECT sleeves.sleeve FROM[MG_inkjop].[dbo].[sleeves]");
dataGridViewOA.Columns[0].Visible = true;
dataGridViewOrders.DataSource = bindingSourceOrders;
mySql.GetData("select order_number from [MG_inkjop].[dbo].[orders] group by order_number", bindingSourceOrders);
dataGridViewOrders.AllowUserToAddRows = false;//prevent from create empt row on the end
tabControlAddOrder.Appearance = TabAppearance.Buttons;
tabControlAddOrder.ItemSize = new Size(0, 1);
tabControlAddOrder.SizeMode = TabSizeMode.Fixed;
radioButtonMix1.Checked = true;
radioButtonFt1.Checked = true;
mySql.updateAntall(lblAddOrAntalFl, dataGridViewOA);
}