private void TXT_ITEMNAME_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Down)
{
if (LST_ITEM_LIST.Items.Count > 0)
{
LST_ITEM_LIST.Focus();
LST_ITEM_LIST.Items[0].Selected = true;
}
}
}
private void hyflexTextbox5_TextChanged(object sender, EventArgs e)
{
if (TXT_ITEMNAME.Text.Length > 1)
{
LOAD_ITEMS_TO_LISTVIEW();
}
else
{
LST_ITEM_LIST.Hide();
}
}
private void LOAD_ITEMS_TO_LISTVIEW()
{
try
{
using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT i.item_id,i.barcode,i.item_category,i.item_name FROM item AS i WHERE (i.barcode LIKE @barcode OR i.item_name LIKE @item_name)", CONNECTION.CON))
{
DA.SelectCommand.Parameters.Clear();
DA.SelectCommand.Parameters.AddWithValue("@barcode", "%" + TXT_ITEMNAME.Text + "%");
DA.SelectCommand.Parameters.AddWithValue("@item_name", "%" + TXT_ITEMNAME.Text + "%");
DataTable DT = new DataTable();
DA.Fill(DT);
if (DT.Rows.Count > 0)
{
LST_ITEM_LIST.Items.Clear();
foreach (DataRow DR in DT.Rows)
{
ListViewItem LST = new ListViewItem(DR.Field <int>(0).ToString());
{
LST.SubItems.Add(DR.Field <string>(1));
LST.SubItems.Add(DR.Field <string>(3));
}
LST_ITEM_LIST.Items.Add(LST);
}
if (LST_ITEM_LIST.Items.Count > 0)
{
LST_ITEM_LIST.Visible = true;
LST_ITEM_LIST.Size = new Size(687, 335);
}
else
{
LST_ITEM_LIST.Hide();
}
}
else
{
LST_ITEM_LIST.Items.Clear();
}
}
}
catch (Exception EX)
{
MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
mdg.ShowDialog();
}
}
private void LST_ITEM_LIST_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Up)
{
if (LST_ITEM_LIST.Items[0].Selected == true)
{
TXT_ITEMNAME.Focus();
}
}
if (e.KeyCode == Keys.Enter)
{
ITEM_CODE = LST_ITEM_LIST.SelectedItems[0].SubItems[0].Text;
ITEM_NAME = LST_ITEM_LIST.SelectedItems[0].SubItems[2].Text;
BARCODE = LST_ITEM_LIST.SelectedItems[0].SubItems[1].Text;
TXT_ITEMNAME.Text = ITEM_NAME;
LST_ITEM_LIST.Hide();
TXT_QTY.Focus();
}
}
