//Click Confirm button for insert data into database
private void btnConfirm_Click(object sender, EventArgs e)
{
try
{
if (CheckBarcode() && CheckEmpty() && checkcustomer() && checkcodeasset() && checkdatecode() && checklinecode())
{
string recDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dt.Clear();
cmd.Clear();
cmd.Append("insert into t_barcode_rec(barcode, model, line, lot, rec_date) ");
cmd.Append("values('").Append(txtBarcode.Text).Append("','");
cmd.Append(txtModel.Text).Append("','").Append(txtLine.Text).Append("','");
cmd.Append(txtLot.Text).Append("','").Append(recDate).Append("')");
switch (SQL.sqlExecuteNonQueryState(cmd.ToString(), false))
{
case 0:
StatusState("Fail", 2);
break;
case 1:
counter++;
GetTable(false);
StatusState("OK", 0);
lbCounter.Text = counter.ToString();
break;
case 2:
StatusState("Duplicate", 1);
MessageBox.Show("Barcode Duplicate", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Warning);
break;
}
}
}
catch (Exception ex)
{
StatusState(ex.Message, 2);
MessageBox.Show(ex.Message, "Warring");
}
txtBarcode.Clear();
txtBarcode.Focus();
}
