private void btnCreateNew_Click(object sender, EventArgs e)
{
FormProduct frm = new FormProduct(this);
frm.LoadCatagory();
frm.LoadBrand();
frm.LoadVendor();
frm.Show();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
String colname = dataGridView1.Columns[e.ColumnIndex].Name;
if (colname == "Edit")
{
FormProduct frm = new FormProduct(this);
frm.btnSave.Enabled = false;
frm.btnUpdate.Enabled = true;
frm.textBoxBarcode.Enabled = false;
frm.textBoxPcode.Enabled = false;
LoadRecords();
frm.LoadBrand();
frm.LoadCatagory();
frm.LoadVendor();
frm.textBoxPcode.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
frm.textBoxBarcode.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
frm.cboCatagory.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
frm.cboBrand.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
frm.textBoxPDescription.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
frm.textBoxQty.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
frm.textBoxBuying_price.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
frm.textBoxSelling_price.Text = dataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString();
frm.textBoxDiscount.Text = dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString();
frm.textBoxRe_order.Text = dataGridView1.Rows[e.RowIndex].Cells[10].Value.ToString();
frm.cboVendor.Text = dataGridView1.Rows[e.RowIndex].Cells[11].Value.ToString();
frm.textBoxExpiry_date.CustomFormat = dataGridView1.Rows[e.RowIndex].Cells[12].Value.ToString();
frm.ShowDialog();
}
else if (colname == "Delete")
{
if (MessageBox.Show("You want to remove this product?", "Remove", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
cn.Open();
cm = new SqlCommand("delete from tableProduct where pcode like '" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "'", cn);
cm.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Product removed sucessfully.", "Removed", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadRecords();
}
}
}
