private void textBox_MasterCode_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
textBox_MasterCode.Text = "";
textBox_MasterCode.Text = scannedCode.ToString();
scannedCode.Clear();
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
codeCURD = new BarcodeReferenceCode_CRUD(conn);
BarcodeMasterCodeInfo item = new BarcodeMasterCodeInfo();
var id = codeCURD.GetMaxID(BarcodeReferenceCode_CRUD.Table.MASTER_CODE) + 1;
item.ID = id;
item.MasterCode = textBox_MasterCode.Text;
codeCURD.Insert(item);
ds = codeCURD.SelectAll_Dataset(BarcodeReferenceCode_CRUD.Table.MASTER_CODE);
conn.Close();
}
DataGridViewRefreshBinding(BarcodeReferenceCode_CRUD.Table.MASTER_CODE);
}
else
{
textBox_MasterCode.Text = "";
scannedCode.Append(KeyToUni.KeyCodeToUnicode(e.KeyCode).ToUpper());
}
}
private void button_MasterDelete_Click(object sender, EventArgs e)
{
var index = dataGridView.CurrentCell.RowIndex;
var id = dataGridView[0, index];
var code = dataGridView[1, index];
BarcodeMasterCodeInfo item = new BarcodeMasterCodeInfo();
item.ID = (int)id.Value;
item.MasterCode = (string)code.Value;
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
codeCURD = new BarcodeReferenceCode_CRUD(conn);
codeCURD.Delete(item);
ds = codeCURD.SelectAll_Dataset(BarcodeReferenceCode_CRUD.Table.MASTER_CODE);
conn.Close();
}
DataGridViewRefreshBinding(BarcodeReferenceCode_CRUD.Table.MASTER_CODE);
}
