public AddProduct()
{
InitializeComponent();
db = new PrjDAO();
dataGridView1.DataSource = db.getProductsandCategory();
cbxCate.DataSource = db.getCategory();
cbxCate.DisplayMember = "name";
cbxCate.ValueMember = "id";
dataGridView1.AutoGenerateColumns = false;
DataTable tb = db.getProductsandCategory();
t = new List <int>();
for (int i = 0; i < tb.Rows.Count; i++)
{
t.Add(Convert.ToInt32(tb.Rows[i][0]));
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim().Equals(""))
{
MessageBox.Show("Category name can't be blank");
}
else if (txtUnit.Text.Trim().Equals(""))
{
MessageBox.Show("Unit can not be blank");
}
else
{
int parsedValue;
if (txtID.Text.Trim().Equals(""))
{
MessageBox.Show("ID can not be blank");
return;
}
else if (!int.TryParse(txtID.Text, out parsedValue))
{
MessageBox.Show("This is a number only field");
return;
}
else
{
int r = Convert.ToInt32(txtID.Text);
foreach (int i in t)
{
if (r == i)
{
MessageBox.Show("ID can not duplicate");
return;
}
}
db.insertProduct(Convert.ToInt32(txtID.Text), txtName.Text, txtUnit.Text, Convert.ToInt32(cbxCate.SelectedValue));
MessageBox.Show("Add successfully");
dataGridView1.DataSource = db.getProductsandCategory();
dataGridView1.Refresh();
}
}
}
